{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["READ ME","INPUT_Pre-check","INPUT_Weight setting"," INPUT_Geophysical Parameters","INPUT_Business Conditions","OUTPUT_Result","Calculations","Lists","Lists 2"],"not_rendered":{"charts":9,"images":51,"macros":0,"external_links":1,"defined_names":20,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Read Me Sheet"]
[]
[]
[]
[]
[null,null,"MARKET – Market Assessment Tool"]
[]
[null,null,"Introduction"]
[null,null,"This tool complements the module MARKET in the SPIS Toolbox. The tool serves to determine geophysical parameters highlighted as make or break. If any of the parameters scores a 0, the area is considered to have very poor potential for SPIS. A ‘yes’ from this evaluation allows consideration of other parameters."]
[]
[null,null,"Tips & Tricks"]
{"$rows_empty":8}
[null,null,"Overview"]
[null,null,"This tool comprises the following sheets:"]
[null,null,"Input_Pre-check: Allows a first check for SPIS suitability to proceed with the assessment"]
[null,null,"Input_Weight setting: Provides a description of parameters and allows for adjusting weights"]
[null,null,"Input_Geophysical Conditions: For defining geophysical parameters in the target area"]
[null,null,"Input_Business Conditions: For defining business relevant parameters relevant to the target area"]
[null,null,"Output_Results: Shows graphic overview of the market potential of SPIS within an area"]
[]
[null,null,"About"]
[null,null,"Published by: GIZ & FAO"]
[null,null,"Responsible: GIZ project Sustainable Energy for Food - Powering Agriculture\n                      Rebecca Navarro"]
[null,null,"Contact: Powering.Agriculture@giz.de"]
[null,null,"Download link: https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,"About: Powering Agriculture: An Energy Grand Challenge for Development. Available at:  https://poweringag.org"]
[null,null,"Version: 1.0 (July 2018)"]
[null,null,"The Toolbox on Solar Powered Irrigation Systems is made possible through the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Cooperation (OPIC) combined resources to create the PAEGC initiative. The objective of PAEGC is to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity and/or value for farmers and agribusinesses in developing countries and emerging regions that lack access to reliable, affordable clean energy."]
[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."]
[null,null,"GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given."]
[null,null,"© GIZ and FAO, 2018"]

{"sheet":"INPUT_Pre-check","index":1,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[13,19,16,19],[15,17,16,17],[15,18,16,18],[3,0,3,15],[7,3,7,11],[8,3,8,11],[15,0,19,0],[16,6,17,6],[16,7,17,7],[16,8,17,8],[16,9,17,9],[16,10,17,10],[1,4,1,10],[2,4,2,12],[18,14,19,14],[15,15,19,15],[9,1,9,8],[5,3,5,11],[6,3,6,11],[14,2,14,7],[14,8,14,13],[15,1,17,1],[16,13,17,13],[16,11,17,11],[16,12,17,12],[16,5,17,5],[21,1,22,15],[12,2,12,13],[13,2,13,13],[10,0,11,0],[10,1,11,13],[16,2,17,2],[16,3,17,3],[16,4,17,4],[15,2,15,7],[15,8,15,13],[16,14,17,14]]}
[]
[{"$nulls":4},"INPUT - First Pre-Check"]
[]
[]
[]
[null,"Country:",null," Zambia"]
[null,"Specific area of interest:"]
[null,"Assessment date:"]
[null,"Assessor name:"]
[]
[1,"Critical Geophysical Parameters",{"$nulls":12},"Highest Possible Score","Attained Score"]
[{"$nulls":14},9,{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":8}]
[null,"Questions","Sample Data Sources",{"$nulls":11},"Answer","Suitability",null,"Parameter","Score","Raw Score"]
["a)",{"$f":"\"What is the major land cover found in the area?\"","v":"What is the major land cover found in the area?"},"Global Land Cover\n",{"$nulls":11},"Light forest open (tree cover up to 40%)",{"$f":"VLOOKUP(O14,'Lists 2'!A:B,2,0)","v":"Moderately Suitable"},null,"Land Cover",{"$f":"IF(P14=\"Highly Suitable\", \"3\", IF(P14=\"Moderately Suitable\", \"2\", IF(P14=\"Marginally Suitable\", \"1\", \"0\")))","v":"2"},{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":8}]
["b)",{"$f":"\"What is the average annual solar irradiation in the area? (kWh/kW peak - PVOUT value)\"","v":"What is the average annual solar irradiation in the area? (kWh/kW peak - PVOUT value)"},"World Bank Solar map",{"$nulls":5},"IRENA global atlas for renewable energy ",{"$nulls":5},"Above 1460",{"$f":"IF(O15=\"0 - 948\", \"Not Suitable\", IF(O15=\"949 - 1094\", \"Marginally Suitable\", IF(O15=\"1095 - 1460\", \"Moderately Suitable\", \"Highly Suitable\")))","v":"Highly Suitable"},null,"Solar Irradiation",{"$f":"IF(O15=\"Above 1460\", \"3\", IF(O15=\"1095 - 1460\", \"2\", IF(O15=\"949 - 1094\", \"1\", \"0\")))","v":"3"}]
["c)",{"$f":"\"What are the average monthly temperature and precipitation values in \"&'INPUT_Pre-check'!D6&\"?\"","v":"What are the average monthly temperature and precipitation values in  Zambia?"},"\nWorld Bank Global Precipitation Data",{"$nulls":5},"World Climate.com",{"$nulls":6},{"$f":"IF(O19=0, \"Low Irrigation Requirement\",IF(O19=1,\"Marginally Suitable\",IF(O19=2,\"Moderately Suitable\",\"Highly Suitable\")))","v":"Highly Suitable"},null,"Precipitation",{"$f":"IF(P16=\"Moderately Suitable\",2,IF(P16=\"Marginally Suitable\",1,3))","v":3}]
[null,null,"J","F","M","A","M","J","J","A","S","O","N","D","Amount of arid months:"]
[]
[null,"Monthly average temperature (°C)",23,23,23,22,25,18,17,19.5,22.9,24.9,24.4,23.3,{"$f":"COUNTIF(C21:N21,\">0\")","v":5},null,null,"Tavg",{"$f":"AVERAGE(C19:N19)","v":22.166666666666668},"TSD",{"$f":"STDEV(C19:N19)","v":2.6213575016611501}]
[null,"Monthly average precipitation (mm)",221,195,157,43,6,0,0,0,3.6,27.4,107.6,214.8,null,null,null,"Pavg",{"$f":"AVERAGE(C20:N20)","v":81.283333333333346},"PSD",{"$f":"STDEV(C20:N20)","v":91.749043426604572}]
[null,"Aridity Index (Harouna & Carlson 1994)",{"$f":"((C19-S19)/U19)-((C20-S20)/U20)","v":-1.2049118901511016},{"$f":"((D19-S19)/U19)-((D20-S20)/U20)","v":-0.92153018905686723},{"$f":"((E19-S19)/U19)-((E20-S20)/U20)","v":-0.50735693361144751},{"$f":"((F19-S19)/U19)-((F20-S20)/U20)","v":0.35368110069615788},{"$f":"((G19-S19)/U19)-((G20-S20)/U20)","v":1.9014002560316068},{"$f":"((H19-S19)/U19)-((H20-S20)/U20)","v":-0.70357609099337681},{"$f":"((I19-S19)/U19)-((I20-S20)/U20)","v":-1.0850578230220305},{"$f":"((J19-S19)/U19)-((J20-S20)/U20)","v":-0.13135349295039633},{"$f":"((K19-S19)/U19)-((K20-S20)/U20)","v":1.1264469296416704},{"$f":"((L19-S19)/U19)-((L20-S20)/U20)","v":1.6300071442357935},{"$f":"((M19-S19)/U19)-((M20-S20)/U20)","v":0.56514272330771287},{"$f":"((N19-S19)/U19)-((N20-S20)/U20)","v":-1.0228917341277264}]
[null,{"$f":"IF(P12=0,\"Critical Geophysical Parameters NOT IDEAL for SPIS\",\"Proceed to INPUT_Weight Setting\")","v":"Proceed to INPUT_Weight Setting"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Not Suitable"]
[{"$nulls":5},"Marginally Suitable"]
[{"$nulls":5},"Moderately Suitable"]
[{"$nulls":5},"Highly Suitable"]

{"sheet":"INPUT_Weight setting","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[11,1,11,5],[10,1,10,5],[4,5,6,5],[3,0,3,5]]}
[]
[null,null,null,"INPUT - Weight Setting"]
[]
[]
[]
[null,"Geophysical  Parameters:"]
[null,"Non-critical Geophysical Parameters"]
[null,"Additional parameters that are key to the market assessment for SPIS. These do not affect the general viability of SPIS; they affect the success of SPIS adoption in a region as per prevailing geophysical conditions (e.g. groundwater table, frost occurence, topography, agricultural production farming system, etc.). "]
[null,"Inconsequential"]
[null,{"$f":"H40","v":9.0909090909090912E-2}]
[]
[null,"Business Conditions:"]
[null,"1. Government Interventions",null,"2. Development Organizations Interventions",null,"3. Financing"]
[null,"Evaluation of government interventions as a business environment parameter for SPIS, looking at policies, rules and regulations that govern the irrigation and solar sectors. ",null,"This section evaluates  interventions by development organizations that can present a significant influence on the adoption of SPIS within a country or region. ",null,"The parameter looks at the ability of end users to meet the high capital cost for SPIS including financial support from government, development agencies and private sector."]
[null,"Slightly important",null,"Inconsequential",null,"Inconsequential"]
[null,{"$f":"H31","v":0.18181818181818182},null,{"$f":"H32","v":9.0909090909090912E-2},null,{"$f":"H33","v":9.0909090909090912E-2}]
[]
[null,"4. Availability and Cost of Alternatives",null,"5. Technical Capacity",null,"6. Awareness of SPIS Technologies"]
[null,"Criterion considers the availability and cost of competing sources of power for irrigation systems. ",null,"This section evaluates the in country capacity of personnel to design, implememt and maintain SPIS systems.",null,"Parameter assesses the general awareness of solar technologies such as solar lighting and heating systems, and irrigation systems such as pumps in the country."]
[null,"Inconsequential",null,"Inconsequential",null,"Inconsequential"]
[null,{"$f":"H34","v":9.0909090909090912E-2},null,{"$f":"H35","v":9.0909090909090912E-2},null,{"$f":"H36","v":9.0909090909090912E-2}]
[]
[null,"7. Significance of Agriculture to Local Economy",null,"8. Land Tenure",null,"9. Transport and Communication Infrastructure"]
[null,"This section evaluates the importance of agriculture to the target area's economy by assessing its contribution to GDP and employment along with the proportion of arable land used for agriculture.",null,"This parameter seeks an understanding of land tenure rights  which can hinder or promote adoption of SPIS. Not only do tenure rights inform investment security, but may also serve as collateral for loans.",null,"This section evaluates the availability of infrastructure and communication systems such as roads and mobile networks in enabling supply chains and easing movement of people and goods."]
[null,"Inconsequential",null,"Inconsequential",null,"Inconsequential"]
[null,{"$f":"H37","v":9.0909090909090912E-2},null,{"$f":"H38","v":9.0909090909090912E-2},null,{"$f":"H39","v":9.0909090909090912E-2}]
[]
[]
[]
[{"$nulls":5},"Parameter","Weight setting","Percentage","Score"]
[{"$nulls":5},"Government Interventions",{"$f":"B15","v":"Slightly important"},{"$f":"I31/$I$41","v":0.18181818181818182},{"$f":"IF(B15=\"Inconsequential\",2,IF(B15=\"Slightly important\",4,IF(B15=\"Important\",6,IF(B15=\"Very Important\",8,IF(B15=\"Critical\",10)))))","v":4}]
[{"$nulls":5},"Development Organizations Interventions",{"$f":"D15","v":"Inconsequential"},{"$f":"I32/$I$41","v":9.0909090909090912E-2},{"$f":"IF(D15=\"Inconsequential\",2,IF(D15=\"Slightly important\",4,IF(D15=\"Important\",6,IF(D15=\"Very Important\",8,IF(D15=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Financing",{"$f":"F15","v":"Inconsequential"},{"$f":"I33/$I$41","v":9.0909090909090912E-2},{"$f":"IF(F15=\"Inconsequential\",2,IF(F15=\"Slightly important\",4,IF(F15=\"Important\",6,IF(F15=\"Very Important\",8,IF(F15=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Availability and Cost of Alternatives",{"$f":"B20","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(B20=\"Inconsequential\",2,IF(B20=\"Slightly important\",4,IF(B20=\"Important\",6,IF(B20=\"Very Important\",8,IF(B20=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Technical Capacity",{"$f":"D20","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(D20=\"Inconsequential\",2,IF(D20=\"Slightly important\",4,IF(D20=\"Important\",6,IF(D20=\"Very Important\",8,IF(D20=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Awareness of Solar PV and Irrigation Tecnologies",{"$f":"F20","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(F20=\"Inconsequential\",2,IF(F20=\"Slightly important\",4,IF(F20=\"Important\",6,IF(F20=\"Very Important\",8,IF(F20=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Significance of Agriculture to the Local Economy",{"$f":"B25","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(B25=\"Inconsequential\",2,IF(B25=\"Slightly important\",4,IF(B25=\"Important\",6,IF(B25=\"Very Important\",8,IF(B25=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Land Tenure",{"$f":"D25","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(D25=\"Inconsequential\",2,IF(D25=\"Slightly important\",4,IF(D25=\"Important\",6,IF(D25=\"Very Important\",8,IF(D25=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Transport and Communication Infrastructure",{"$f":"F25","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(F25=\"Inconsequential\",2,IF(F25=\"Slightly important\",4,IF(F25=\"Important\",6,IF(F25=\"Very Important\",8,IF(F25=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Additional Geophysical Parameters ",{"$f":"B9","v":"Inconsequential"},9.0909090909090912E-2,{"$f":"IF(B9=\"Inconsequential\",2,IF(B9=\"Slightly important\",4,IF(B9=\"Important\",6,IF(B9=\"Very Important\",8,IF(B9=\"Critical\",10)))))","v":2}]
[{"$nulls":5},"Total",{"$f":"SUM(G31:G40)","v":0},{"$f":"SUM(H31:H40)","v":1.0000000000000002},{"$f":"SUM(I31:I40)","v":22}]

{"sheet":" INPUT_Geophysical Parameters","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,2,1,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[4,0,5,0],[6,2,6,3],[4,1,5,3],[3,0,3,5],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[11,1,11,5]]}
[]
[null,null,"INPUT - Geophysical Parameters"]
[]
[]
[2,"Additional Geophysical Parameters",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!B10","v":9.0909090909090912E-2},{"$f":"SUM(I8:I11)","v":7.2727272727272738E-2}]
[null,"Questions","Sample Data Sources",null,"Answer","Relevance",null,"Weight","Attained Score","Raw Score"]
["a)",{"$f":"\"What is the average ground water table in \"&'INPUT_Pre-check'!D6&\" earmarked for SPIS?\"","v":"What is the average ground water table in  Zambia earmarked for SPIS?"},"Estimated depth of groundwater resources",null,"25m - 50m","Inconsequential",null,{"$f":"E6/COUNTA(B8,B9,B10,B11)","v":2.2727272727272728E-2},{"$f":"(J8*H8)","v":1.3636363636363636E-2},{"$f":"IF(E8=\"Up to 7m\",1,IF(E8=\"7m - 25m\",0.8,IF(E8=\"25m - 50m\",0.6,IF(E8=\"50m - 100m\",0.1,IF(E8=\"Beyond 100m\",0,IF(E8=\"Unknown\",0))))))*IF(F8=\"Inconsequential\",6,IF(F8=\"Slightly important\",5,IF(F8=\"Important\",4,IF(F8=\"Very important\",3,IF(F8=\"Critical\",2)))))/6","v":0.6}]
["b)",{"$f":"\"What is \"&'INPUT_Pre-check'!D6&\"'s minimum annual ambient temperature in terms of frost occurences?\"","v":"What is  Zambia's minimum annual ambient temperature in terms of frost occurences?"},"World Bank Global Temperature Data",null,"1C to 30C","Inconsequential",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":2.2727272727272728E-2},{"$f":"(J9*H9)","v":2.2727272727272728E-2},{"$f":"IF(E9=\"1C to 30C\",(IF(F9=\"Inconsequential\",6,IF(F9=\"Slightly important\",5,IF(F9=\"Important\",4,IF(F9=\"Very important\",3,IF(F9=\"Critical\",2)))))),(IF(F9=\"Inconsequential\",6,IF(F9=\"Slightly important\",4,IF(F9=\"Important\",2,IF(F9=\"Very important\",1,IF(F9=\"Critical\",0)))))))/6","v":1}]
["c)",{"$f":"\"What is \"&'INPUT_Pre-check'!D6&\"'s general topography regarded as?\"","v":"What is  Zambia's general topography regarded as?"},"What is the slope of the area?",null,"Moderate","Inconsequential",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":2.2727272727272728E-2},{"$f":"(J10*H10)","v":1.8181818181818184E-2},{"$f":"IF(E10=\"Flat\",1,IF(E10=\"Moderate\",0.8,IF(E10=\"Steep\",0.6)))*IF(F10=\"Inconsequential\",6,IF(F10=\"Slightly important\",5,IF(F10=\"Important\",4,IF(F10=\"Very important\",3,IF(F10=\"Critical\",2)))))/6","v":0.80000000000000016}]
["d)",{"$f":"\"What is the main type of agricultural production in \"&'INPUT_Pre-check'!D6&\"'s farming system?\"","v":"What is the main type of agricultural production in  Zambia's farming system?"},"Global Agro-Ecological Zones","Farming Systems Maps FAO","Perennial Crops","Inconsequential",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":2.2727272727272728E-2},{"$f":"(J11*H11)","v":1.8181818181818184E-2},{"$f":"IF(E11=\"Seasonal Crops\",0.6,IF(E11=\"Perennial Crops\",0.8,IF(E11=\"Small Livestock\",0.95,IF(E11=\"Large Livestock\",0.9,IF(E11=\"Seasonal and Perennial Crops\",0.7,IF(E11=\"Livestock and crops\",0.7))))))*IF(F11=\"Inconsequential\",6,IF(F11=\"Slightly important\",5,IF(F11=\"Important\",4,IF(F11=\"Very important\",3,IF(F11=\"Critical\",2)))))/6","v":0.80000000000000016}]
[null,{"$f":"IF((Calculations!G4)<(50 %), \"Your score is below 50 % of your initial values for Geophysical Parameters! Please revise your weight setting!\", \"\")","v":""}]
[]
[null,null,"Got more recent data sources? "]
[null,null,"PLEASE SHARE "]
[null,null," and help us to improve our tools."]
[null,null,"Thank you."]

{"sheet":"INPUT_Business Conditions","index":4,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":false,"merged":[[83,9,85,9],[39,7,43,7],[39,8,43,8],[39,9,43,9],[7,7,9,7],[7,8,9,8],[7,9,9,9],[1,2,1,3],[13,0,14,0],[13,1,14,3],[14,7,14,9],[4,0,5,0],[4,1,5,3],[5,7,5,9],[6,2,6,3],[10,2,10,3],[7,1,9,1],[7,5,9,5],[7,0,9,0],[7,2,9,2],[7,4,9,4],[3,0,3,5],[63,2,65,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[15,2,15,3],[17,1,18,1],[17,4,19,4],[66,1,66,5],[62,1,62,5],[61,2,61,3],[59,1,60,3],[57,2,57,3],[99,2,101,3],[81,2,81,3],[82,2,82,3],[84,5,85,5],[84,4,85,4],[86,4,87,4],[21,1,22,3],[17,5,19,5],[28,3,29,3],[97,2,97,3],[59,0,60,0],[17,8,19,8],[17,9,19,9],[19,2,19,3],[21,0,22,0],[17,7,19,7],[17,0,18,0],[52,0,53,0],[34,0,35,0],[23,2,23,3],[39,0,43,0],[39,5,43,5],[38,2,38,3],[39,1,43,1],[43,2,43,3],[39,3,40,3],[39,4,43,4],[28,2,29,2],[86,7,87,7],[86,8,87,8],[86,9,87,9],[83,7,85,7],[83,8,85,8],[98,1,98,5],[84,1,85,1],[84,0,85,0],[84,3,87,3],[85,2,86,2],[86,1,87,1],[86,0,87,0],[79,0,80,0],[70,0,71,0],[70,1,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[79,1,80,3],[86,5,87,5],[89,1,90,3],[91,2,91,3],[83,3,83,5],[89,0,90,0],[92,1,92,5],[93,2,96,3],[102,1,102,5],[88,1,88,5],[69,1,69,5],[58,1,58,5],[51,1,51,5],[33,1,33,5],[20,1,20,5],[12,1,12,5],[78,1,78,5],[45,1,45,5],[24,1,24,5],[25,2,25,3],[26,2,26,3],[27,1,27,5],[30,1,30,5],[31,2,31,3],[32,2,32,3],[56,2,56,3],[55,2,55,3],[54,2,54,3],[52,1,53,3],[48,1,48,5],[37,1,37,5],[34,1,35,3]]}
[]
[null,null,"INPUT - Business Conditions Parameters"]
[]
[]
[1,"Government interventions",null,null,"Highest Possible Score ","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!B16","v":0.18181818181818182},{"$f":" IF(OR(AND(E8=\"No\",F8=\"Critical\"),AND(E11=\"No\",F11=\"Critical\"),AND(E12=\"No\",F12=\"Critical\")),0,SUM(I8:I12))","v":7.0707070707070704E-2}]
[null,"Questions","Sample Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":" \"Are there government, national and local policies and laws promoting solar and irrigation equipmen in\" &'INPUT_Pre-check'!D6&\" ?\"","v":"Are there government, national and local policies and laws promoting solar and irrigation equipmen in Zambia ?"},"• Government irrigation and or solar policies, laws, bills, acts, sector development plans\n• Licensing of solar technicians, suppliers and  or contractor companies\n• Government tax regulation such as duty and VAT exemptions\n","Clean energy development policies","No","Important",null,{"$f":"E6/COUNTA(B8:B12)","v":6.0606060606060608E-2},{"$f":"(J8*H8)","v":1.01010101010101E-2},{"$f":"(IF(E8=\"Yes\",(IF(F8=\"Inconsequential\",3,IF(F8=\"Slightly important\",4,IF(F8=\"Important\",4,IF(F8=\"Very important\",5,IF(F8=\"Critical\",6)))))),(IF(F8=\"Inconsequential\",3,IF(F8=\"Slightly important\",2,IF(F8=\"Important\",1,IF(F8=\"Very important\",1,IF(F8=\"Critical\",0))))))))/6","v":0.16666666666666666}]
[null,null,null,"Renewable energy support policies in developing countries: Table 4, Pg. 121 "]
[null,null,null,"Asia pacific countries policy documents"]
["b)",{"$f":"\"Are there in\"&'INPUT_Pre-check'!D6&\" government programs promoting SPIS devices?\"","v":"Are there in Zambia government programs promoting SPIS devices?"},"• Irrigation and solar programs supported by government resources",null,"Unknown","Inconsequential",null,{"$f":"E6/COUNTA(B8:B12)","v":6.0606060606060608E-2},{"$f":"(J11*H11)","v":3.0303030303030304E-2},{"$f":"(IF(E11=\"Yes\",(IF(F11=\"Inconsequential\",3,IF(F11=\"Slightly important\",4,IF(F11=\"Important\",4,IF(F11=\"Very important\",5,IF(F11=\"Critical\",6)))))),(IF(F11=\"Inconsequential\",3,IF(F11=\"Slightly important\",2,IF(F11=\"Important\",1,IF(F11=\"Very important\",1,IF(F11=\"Critical\",0))))))))/6","v":0.5}]
["c)",{"$f":"\"Are there relevant government ministries and/bodies providing support to the sector in \"&'INPUT_Pre-check'!D6&\"?\"","v":"Are there relevant government ministries and/bodies providing support to the sector in  Zambia?"},"• Agriculture and energy ministries with engagement in SPIS sector\n• Government irrigation organizations, boards, groups\n• Government organizations providing SPIS related information\n• Government quality and standards regulation and enforcement","Stand alone systems regulations and incentives","Unknown","Inconsequential",null,{"$f":"E6/COUNTA(B8:B12)","v":6.0606060606060608E-2},{"$f":"(J12*H12)","v":3.0303030303030304E-2},{"$f":"(IF(E12=\"Yes\",(IF(F12=\"Inconsequential\",3,IF(F12=\"Slightly important\",4,IF(F12=\"Important\",4,IF(F12=\"Very important\",5,IF(F12=\"Critical\",6)))))),(IF(F12=\"Inconsequential\",3,IF(F12=\"Slightly important\",2,IF(F12=\"Important\",1,IF(F12=\"Very important\",1,IF(F12=\"Critical\",0))))))))/6","v":0.5}]
[]
[2,"Development Organizations Interventions",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!D16","v":9.0909090909090912E-2},{"$f":" IF(OR(AND(E17=\"No\",F17=\"Critical\"),AND(E18=\"No\",F18=\"Critical\")),0,SUM(I17:I20))","v":9.0909090909090912E-2}]
[null,"Questions","Sample Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"Are there national programs provided in\"&'INPUT_Pre-check'!D6&\" by non - government institutions that promote adoption of irrigation?\"","v":"Are there national programs provided in Zambia by non - government institutions that promote adoption of irrigation?"},"• List of possible* development agencies and multilateral organizations: ","GIZ (Deutsche Gesellschaft für Internationale Zusammenarbeit GmbH)","Yes","Critical",null,{"$f":"E15/(COUNTA(B17:B20))","v":4.5454545454545456E-2},{"$f":"(J17*H17)","v":4.5454545454545456E-2},{"$f":"(IF(E17=\"Yes\",(IF(F17=\"Inconsequential\",3,IF(F17=\"Slightly important\",4,IF(F17=\"Important\",4,IF(F17=\"Very important\",5,IF(F17=\"Critical\",6)))))),(IF(F17=\"Inconsequential\",3,IF(F17=\"Slightly important\",2,IF(F17=\"Important\",1,IF(F17=\"Very important\",1,IF(F17=\"Critical\",0))))))))/6","v":1}]
["b)",{"$f":"\"Are there national programs provided in\"&'INPUT_Pre-check'!D6&\" by non-government institutions specifically promoting adoption of SPIS devices?\"","v":"Are there national programs provided in Zambia by non-government institutions specifically promoting adoption of SPIS devices?"},"• List of possible* facilities and funds:","GEF (Global Environment Facility)","Yes","Critical",null,{"$f":"E15/COUNTA(B17:B20)","v":4.5454545454545456E-2},{"$f":"(J18*H18)","v":4.5454545454545456E-2},{"$f":"(IF(E18=\"Yes\",(IF(F18=\"Inconsequential\",3,IF(F18=\"Slightly important\",4,IF(F18=\"Important\",4,IF(F18=\"Very important\",5,IF(F18=\"Critical\",6)))))),(IF(F18=\"Inconsequential\",3,IF(F18=\"Slightly important\",2,IF(F18=\"Important\",1,IF(F18=\"Very important\",1,IF(F18=\"Critical\",0))))))))/6","v":1}]
[null,null,"• List of possible* research centers and other NGOs:","AGRA"]
[null,null,"* List is not exhaustive"]
[]
[3,"Financing",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!F16","v":9.0909090909090912E-2},{"$f":"IF(OR(AND(E26=1,F26=\"Critical\"),AND(E33=\"No\",F33=\"Critical\"), AND(E29=0,F29=\"Critical\"), AND(E30=0,F30=\"Critical\")),0,SUM(I25,I28,I33))","v":4.5454545454545456E-2}]
[null,"Questions","Sample National Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)","End users' financial ability",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":3.0303030303030304E-2},{"$f":"I26+I27","v":1.5151515151515152E-2}]
["i)",{"$f":"\"What proportion of the rural population in\"&'INPUT_Pre-check'!D6&\" is poor according to the multi-dimentional poverty index?\"","v":"What proportion of the rural population in Zambia is poor according to the multi-dimentional poverty index?"},"OPHI Global MPI Interactive Databank: Population in multidimensional poverty (H) (%), Rural MPI Poor",null,null,"Inconsequential",null,{"$f":"H25/COUNTA(B26:B27)","v":1.5151515151515152E-2},{"$f":"(H26*J26)","v":7.575757575757576E-3},{"$f":"IF(F26=\"Inconsequential\",0.5,(1-E26))","v":0.5}]
["ii)",{"$f":"\"What is the GNI per capita value of\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the GNI per capita value of Zambia?"}," World Bank data: GNI per capita, Atlas method (current US$) 2016",null,"Lower Middle Income ($1,006 to $3,955)","Inconsequential",null,{"$f":"H25/COUNTA(B26:B27)","v":1.5151515151515152E-2},{"$f":"(H27*J27)","v":7.575757575757576E-3},{"$f":"(IF(F27=\"Inconsequential\",2.5,IF(E27=\"Low income ($1,005 or less)\",1,IF(E27=\"Lower Middle Income ($1,006 to $3,955)\",2,IF(E27=\"Upper Middle Income ($3,956 to $12,235)\",4,IF(E27=\"High Income ($12.236 or more)\",5,))))))/(5)","v":0.5}]
["b)","Availability of financial institution support",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":3.0303030303030304E-2},{"$f":"I29+I30+I32","v":1.5151515151515152E-2}]
["i)",{"$f":"\"What proportion of the population above the age of 15 in \"&'INPUT_Pre-check'!D6&\" own a financial account?\"","v":"What proportion of the population above the age of 15 in  Zambia own a financial account?"},"i) Account  (% age 15+) based on country\nii) Formal borrowing  (% age 15+) based on country","World Bank, Financial Inclusion Data",null,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.0101010101010102E-2},{"$f":"H29*J29","v":5.0505050505050509E-3},{"$f":"IF(F29=\"Inconsequential\",0.5,E29)","v":0.5}]
["ii)",{"$f":"\"What is the proportion of the population above the age of 15 in\"&'INPUT_Pre-check'!D6&\" which borrowed from a financial institution in the given year*?\"","v":"What is the proportion of the population above the age of 15 in Zambia which borrowed from a financial institution in the given year*?"},null,null,null,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.0101010101010102E-2},{"$f":"H30*J30","v":5.0505050505050509E-3},{"$f":"IF(F30=\"Inconsequential\",0.5,E30)","v":0.5}]
[null,"* given year is the most recent year Data is available"]
["iii)",{"$f":"\"What is\"&'INPUT_Pre-check'!D6&\"'s ease of getting credit ranking?\"","v":"What is Zambia's ease of getting credit ranking?"},"World Bank Ease of doing Business 2017",null,null,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.0101010101010102E-2},{"$f":"(H32*J32)","v":5.0505050505050509E-3},{"$f":"(IF(F32=\"Inconsequential\",93,(186-E32)))/186","v":0.5}]
["c)",{"$f":"\"Are there any government economic incentives affecting the adoption of SPIS devices in\"&'INPUT_Pre-check'!D6&\"?\"","v":"Are there any government economic incentives affecting the adoption of SPIS devices in Zambia?"},"• Government tax exemptions, subsidies, rebates, credits etc. given to customers of SPIS products, suppliers or other intermediaries such as financiers",null,"Unknown","Inconsequential",null,{"$f":"E23/COUNTA(B25,B28,B33)","v":3.0303030303030304E-2},{"$f":"H33*J33","v":1.5151515151515152E-2},{"$f":"(IF(E33=\"Yes\",(IF(F33=\"Inconsequential\",3,IF(F33=\"Slightly important\",4,IF(F33=\"Important\",4,IF(F33=\"Very important\",5,IF(F33=\"Critical\",6)))))),(IF(F33=\"Inconsequential\",3,IF(F33=\"Slightly important\",2,IF(F33=\"Important\",1,IF(F33=\"Very important\",1,IF(F33=\"Critical\",0))))))))/6","v":0.5}]
[]
[4,"Availability  and cost of alternative sources of power for pumping",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!B21","v":9.0909090909090912E-2},{"$f":"IF(OR(AND(E39=\"Yes\",F39=\"Critical\"),AND(E40=\"Yes\",F40=\"Critical\"),AND(E47=\"Yes\",F47=\"Critical\"),AND(E48=\"Yes\",F48=\"Critical\")),0,SUM(I38,I46,I49))","v":5.6818181818181823E-2}]
[null,"Questions","Sample Local Data Sources","Sample National Data Sources","Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)","Availability of competitive alternative power sources",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I39+I40+I45","v":2.6515151515151516E-2}]
["i)",{"$f":"\"Does\"&'INPUT_Pre-check'!D6&\" have fossil fuel resources that it exploits?\"","v":"Does Zambia have fossil fuel resources that it exploits?"},"National fossil fuel reserves",null,"Unknown","Inconsequential",null,{"$f":"H38/(COUNTA(B39:B45)-1)","v":1.5151515151515152E-2},{"$f":"H39*J39","v":1.5151515151515152E-2},{"$f":"(6-(IF(E39=\"Yes\",(IF(F39=\"Inconsequential\",3,IF(F39=\"Slightly important\",4,IF(F39=\"Important\",4,IF(F39=\"Very important\",5,IF(F39=\"Critical\",6)))))),0)))/6","v":1}]
["ii)",{"$f":"\"Is the area of interest in close proximity (within 5km of a grid access point) to the grid or is the rural electrification rate of \"&'INPUT_Pre-check'!D6&\" greater than 80%?\"","v":"Is the area of interest in close proximity (within 5km of a grid access point) to the grid or is the rural electrification rate of  Zambia greater than 80%?"},"African grid","Access to electricity, rural electrification rate","Unknown","Inconsequential",null,{"$f":"H38/((COUNTA(B39:B45)-1)*2)","v":7.575757575757576E-3},{"$f":"H40*J40","v":7.575757575757576E-3},{"$f":"(6-(IF(E40=\"Yes\",(IF(F40=\"Inconsequential\",3,IF(F40=\"Slightly important\",4,IF(F40=\"Important\",4,IF(F40=\"Very important\",5,IF(F40=\"Critical\",6)))))),0)))/6","v":1}]
[null,null,"European grid"]
[null,null,"USA grid","Tracking SDG 7 "]
[null,null,"Australian grid ","Grid maps"]
[null,null,"\nFor better accuracy use country specific grid data"]
["iii)",{"$f":"\"What is the frequency of power outages in the area of interest or in\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the frequency of power outages in the area of interest or in Zambia?"},"• Area of interest local electricity supply reliability","Power outages frequency ","Low","Inconsequential",null,{"$f":"H38/((COUNTA(B39:B45)-1)*2)","v":7.575757575757576E-3},{"$f":"H45*J45","v":3.787878787878788E-3},{"$f":"(IF(F45=\"Inconsequential\",2.5,IF(E45=\"Low\",1,IF(E45=\"Regular\",2,IF(E45=\"High\",4,IF(E45=\"Very high\",5,))))))/5","v":0.5}]
["b)","Subsidies",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I47+I48","v":3.0303030303030304E-2}]
["i)",{"$f":"\"Is there a grid subsidy in \"&'INPUT_Pre-check'!D6&\" or in the area of interest including for the cost of electricity and or connection fee to the grid?\"","v":"Is there a grid subsidy in  Zambia or in the area of interest including for the cost of electricity and or connection fee to the grid?"},"• Area of interest local electricity supply regulation","Presence of national electricity subsidy ","Unknown","Inconsequential",null,{"$f":"H38/COUNTA(B47:B48)","v":1.5151515151515152E-2},{"$f":"H47*J47","v":1.5151515151515152E-2},{"$f":"(6-(IF(E47=\"Yes\",(IF(F47=\"Inconsequential\",3,IF(F47=\"Slightly important\",4,IF(F47=\"Important\",4,IF(F47=\"Fairly important\",5,IF(F47=\"Critical\",6)))))),0)))/6","v":1}]
["ii)",{"$f":"\"Is there a fuel subsidy in \"&'INPUT_Pre-check'!D6&\" or in the area of interest?\"","v":"Is there a fuel subsidy in  Zambia or in the area of interest?"},"• Area of interest local fuel supply regulation","Presence of national fuel subsidy e.g. of diesel and kerosene","Unknown","Inconsequential",null,{"$f":"H38/COUNTA(B47:B48)","v":1.5151515151515152E-2},{"$f":"H48*J48","v":1.5151515151515152E-2},{"$f":"(6-(IF(E48=\"Yes\",(IF(F48=\"Inconsequential\",3,IF(F48=\"Slightly important\",4,IF(F48=\"Important\",4,IF(F48=\"Fairly important\",5,IF(F48=\"Critical\",6)))))),0)))/6","v":1}]
["c)","Cost comparison",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I50+I51","v":0}]
["i)",{"$f":"\"What is the average electricity retail tariff in USD per kWh for all end users in\"&'INPUT_Pre-check'!D6&\" or in the area of interest?\"","v":"What is the average electricity retail tariff in USD per kWh for all end users in Zambia or in the area of interest?"},"• Area of interest local electricity supply cost in USD per kWh","Retail electricity tariff (average of all end-users) in USD/kWh",null,"Reference for least penalty will be 1USD/kWh, with the most expensive power, rounded up to the next whole number (0.61)",null,{"$f":"H49/COUNTA(B50:B51)","v":1.5151515151515152E-2},{"$f":"H50*J50","v":0},{"$f":"E50","v":0}]
["ii)",{"$f":"\"What is the average retail price for diesel in USD per litre in\"&'INPUT_Pre-check'!D6&\" or in the area of interest?\"","v":"What is the average retail price for diesel in USD per litre in Zambia or in the area of interest?"},"• Area of interest local average diesel cost in USD/Liter"," Diesel prices in USD/Liter\n",null,"Reference for least penalty will be 3 USD/L the price of Iceland, with the most expensive diesel, rounded up to the next whole number (2.03)",null,{"$f":"H49/COUNTA(B50:B51)","v":1.5151515151515152E-2},{"$f":"H51*J51","v":0},{"$f":"E51/3","v":0}]
[]
[5,"Technical capacity for SPIS",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!D21","v":9.0909090909090912E-2},{"$f":" IF(OR(AND(E56=\"No\",F56=\"Critical\"),AND(E57=\"No\",F57=\"Critical\"),AND(E58=\"No\",F58=\"Critical\")),0,SUM(I56:I58))","v":4.5454545454545456E-2}]
[null,"Questions","Sample National Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"Are there training sessions on solar technologies and application (Design, O&M and repairs) available in\"&'INPUT_Pre-check'!D6&\"?\"","v":"Are there training sessions on solar technologies and application (Design, O&M and repairs) available in Zambia?"},{"$f":"\"• Solar systems and technologies courses in educational institutions in\" & 'INPUT_Pre-check'!D6& \".\"","v":"• Solar systems and technologies courses in educational institutions in Zambia."},null,"Unknown","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":3.0303030303030304E-2},{"$f":"(J56*H56)","v":1.5151515151515152E-2},{"$f":"(IF(E56=\"Yes\",(IF(F56=\"Inconsequential\",3,IF(F56=\"Slightly important\",4,IF(F56=\"Important\",4,IF(F56=\"Very important\",5,IF(F56=\"Critical\",6)))))),(IF(F56=\"Inconsequential\",3,IF(F56=\"Slightly important\",2,IF(F56=\"Important\",1,IF(F56=\"Very important\",1,IF(F56=\"Critical\",0))))))))/6","v":0.5}]
["b)",{"$f":"\"Are solar technicians in\"&'INPUT_Pre-check'!D6&\" licensed to carry out their work by the government?\"","v":"Are solar technicians in Zambia licensed to carry out their work by the government?"},"• Government regulation on licensing of solar technicians",null,"Unknown","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":3.0303030303030304E-2},{"$f":"(J57*H57)","v":1.5151515151515152E-2},{"$f":"(IF(E57=\"Yes\",(IF(F57=\"Inconsequential\",3,IF(F57=\"Slightly important\",4,IF(F57=\"Important\",4,IF(F57=\"Very important\",5,IF(F57=\"Critical\",6)))))),(IF(F57=\"Inconsequential\",3,IF(F57=\"Slightly important\",2,IF(F57=\"Important\",1,IF(F57=\"Very important\",1,IF(F57=\"Critical\",0))))))))/6","v":0.5}]
["c)","Is solar technology part of the curriculum in agricultural courses or programs in agricultural training institutions?",{"$f":"\"• Solar systems and technologies courses in educational institutions in\" & 'INPUT_Pre-check'!D6& \".\"","v":"• Solar systems and technologies courses in educational institutions in Zambia."},null,"Unknown","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":3.0303030303030304E-2},{"$f":"(J58*H58)","v":1.5151515151515152E-2},{"$f":"(IF(E58=\"Yes\",(IF(F58=\"Inconsequential\",3,IF(F58=\"Slightly important\",4,IF(F58=\"Important\",4,IF(F58=\"Very important\",5,IF(F58=\"Critical\",6)))))),(IF(F58=\"Inconsequential\",3,IF(F58=\"Slightly important\",2,IF(F58=\"Important\",1,IF(F58=\"Very important\",1,IF(F58=\"Critical\",0))))))))/6","v":0.5}]
[]
[6,"Awareness of solar PV and irrigation technologies ",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!F21","v":9.0909090909090912E-2},{"$f":" IF(OR(AND(E64=\"No\",F64=\"Critical\"),AND(E68=\"No\",F68=\"Critical\"),AND(E65=\"No\",F65=\"Critical\"),AND(E69=0,F69=\"Critical\")),0,SUM(I63,I67,))","v":4.5454545454545456E-2}]
[null,"Questions","Sample National Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)","Solar",{"$nulls":5},{"$f":"E61/COUNTA(B63,B67)","v":4.5454545454545456E-2},{"$f":"I64+I65+I66","v":2.2727272727272728E-2}]
["i)",{"$f":"\"Is there a cumulative increase in the installed capacity of solar energy between the years 2012 - 2016 in \" &'INPUT_Pre-check'!D6&\"?\"","v":"Is there a cumulative increase in the installed capacity of solar energy between the years 2012 - 2016 in  Zambia?"},"IRENA dashboard: Trends in Renewable Energy",null,"Unknown","Inconsequential",null,{"$f":"H63/COUNTA(B64:B66)","v":1.5151515151515152E-2},{"$f":"(J64*H64)","v":7.575757575757576E-3},{"$f":"(IF(E64=\"Yes\",(IF(F64=\"Inconsequential\",3,IF(F64=\"Slightly important\",4,IF(F64=\"Important\",4,IF(F64=\"Very important\",5,IF(F64=\"Critical\",6)))))),(IF(F64=\"Inconsequential\",3,IF(F64=\"Slightly important\",2,IF(F64=\"Important\",1,IF(F64=\"Very important\",1,IF(F64=\"Critical\",0))))))))/6","v":0.5}]
["ii)",{"$f":"\"Is there a general increase in the annual net additional installed solar energy between the years 2012 - 2016 in \" &'INPUT_Pre-check'!D6&\"?\"","v":"Is there a general increase in the annual net additional installed solar energy between the years 2012 - 2016 in  Zambia?"},null,null,"Unknown","Inconsequential",null,{"$f":"H63/COUNTA(B64:B66)","v":1.5151515151515152E-2},{"$f":"(J65*H65)","v":7.575757575757576E-3},{"$f":"(IF(E65=\"Yes\",(IF(F65=\"Inconsequential\",3,IF(F65=\"Slightly important\",4,IF(F65=\"Important\",4,IF(F65=\"Very important\",5,IF(F65=\"Critical\",6)))))),(IF(F65=\"Inconsequential\",3,IF(F65=\"Slightly important\",2,IF(F65=\"Important\",1,IF(F65=\"Very important\",1,IF(F65=\"Critical\",0))))))))/6","v":0.5}]
["iii)"," What is the solar energy proportion of the total installed energy capacity?",null,null,null,"Inconsequential",null,{"$f":"H63/COUNTA(B64:B66)","v":1.5151515151515152E-2},{"$f":"(J66*H66)","v":7.575757575757576E-3},{"$f":"IF(F66=\"Inconsequential\",0.5,E66)","v":0.5}]
["b)","Distribution networks for solar and irrigation systems",{"$nulls":5},{"$f":"E61/COUNTA(B63,B67)","v":4.5454545454545456E-2},{"$f":"I68+I69","v":2.2727272727272728E-2}]
["i)",{"$f":"\"Is there a presence of suppliers and or distributors of water pump products from global pump manufactures in the market in\"&'INPUT_Pre-check'!D6&\"? \"","v":"Is there a presence of suppliers and or distributors of water pump products from global pump manufactures in the market in Zambia? "},"• List of major water pump products and suppliers","Ebara","Unknown","Inconsequential",null,{"$f":"H67/COUNTA(B68:B69)","v":2.2727272727272728E-2},{"$f":"(J68*H68)","v":1.1363636363636364E-2},{"$f":"(IF(E68=\"Yes\",(IF(F68=\"Inconsequential\",3,IF(F68=\"Slightly important\",4,IF(F68=\"Important\",4,IF(F68=\"Very important\",5,IF(F68=\"Critical\",6)))))),(IF(F68=\"Inconsequential\",3,IF(F68=\"Slightly important\",2,IF(F68=\"Important\",1,IF(F68=\"Very important\",1,IF(F68=\"Critical\",0))))))))/6","v":0.5}]
["ii)",{"$f":"\"Is there a presence of suppliers and/or distributors of solar PV systems from global manufacturers in the market in\"&'INPUT_Pre-check'!D6&\" ? \"","v":"Is there a presence of suppliers and/or distributors of solar PV systems from global manufacturers in the market in Zambia ? "},"• List of major solar PV products and suppliers","Ebara","Unknown","Inconsequential",null,{"$f":"H67/COUNTA(B68:B69)","v":2.2727272727272728E-2},{"$f":"(J69*H69)","v":1.1363636363636364E-2},{"$f":"(IF(E69=\"Yes\",(IF(F69=\"Inconsequential\",3,IF(F69=\"Slightly important\",4,IF(F69=\"Important\",4,IF(F69=\"Very important\",5,IF(F69=\"Critical\",6)))))),(IF(F69=\"Inconsequential\",3,IF(F69=\"Slightly important\",2,IF(F69=\"Important\",1,IF(F69=\"Very important\",1,IF(F69=\"Critical\",0))))))))/6","v":0.5}]
[]
[7,"Significance of agriculture in the local economy",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!B26","v":9.0909090909090912E-2},{"$f":" IF(OR(AND(E74=0,F74=\"Critical\"),AND(E76=0,F76=\"Critical\"),AND(E77=0,F77=\"Critical\")),0,SUM(I74:I78))","v":4.5454545454545456E-2}]
[null,"Questions","Sample National data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"What proportion of the employed population in \"&'INPUT_Pre-check'!D6& \" are employed in the agricultural sector?\"","v":"What proportion of the employed population in  Zambia are employed in the agricultural sector?"},"World Bank; Indicators per country in 2017 (most recent year); Employment in agriculture (% of total employment)",null,null,"Inconsequential",null,{"$f":"E72/COUNTA(B74:B78)","v":1.8181818181818181E-2},{"$f":"(J74*H74)","v":9.0909090909090905E-3},{"$f":"IF(F74=\"Inconsequential\",0.5,E74)","v":0.5}]
["b)",{"$f":"\"What proportion of the population is rural?\"","v":"What proportion of the population is rural?"}," World Bank; Rural population (% of total population) in 2016; ",null,null,"Inconsequential",null,{"$f":"E72/COUNTA(B74:B78)","v":1.8181818181818181E-2},{"$f":"(J75*H75)","v":9.0909090909090905E-3},{"$f":"IF(F75=\"Inconsequential\",0.5,E75)","v":0.5}]
["c)",{"$f":"\"What proportion of \"&'INPUT_Pre-check'!D6& \"'s GDP is contributed by its agricultural output?\"","v":"What proportion of  Zambia's GDP is contributed by its agricultural output?"},"World Bank; Indicators per country in 2016  (most recent year); Agriculture, value added (% of GDP)\n",null,null,"Inconsequential",null,{"$f":"E72/COUNTA(B74:B78)","v":1.8181818181818181E-2},{"$f":"(J76*H76)","v":9.0909090909090905E-3},{"$f":"IF(F76=\"Inconsequential\",0.5,E76)","v":0.5}]
["e)",{"$f":"\"What  proportion of \"&'INPUT_Pre-check'!D6&\"'s total land is agricultural land?\"","v":"What  proportion of  Zambia's total land is agricultural land?"},"World Bank; Indicators per country in 2015  (most recent year); Agricultural land (% of land area)",null,null,"Inconsequential",null,{"$f":"E72/COUNTA(B74:B78)","v":1.8181818181818181E-2},{"$f":"(J77*H77)","v":9.0909090909090905E-3},{"$f":"IF(F77=\"Inconsequential\",0.5,E77)","v":0.5}]
["d)",{"$f":"\"What percentage of cultivated land area in\"&'INPUT_Pre-check'!D6&\" is already under irrigation?\"","v":"What percentage of cultivated land area in Zambia is already under irrigation?"},"FAO, Aquastat map, Part of cultivated area under irrigation (%)",null,null,"Inconsequential",null,{"$f":"E72/COUNTA(B74:B78)","v":1.8181818181818181E-2},{"$f":"(J78*H78)","v":9.0909090909090905E-3},{"$f":"IF(F78=\"Inconsequential\",0.5,E78)+IF(E78>E77,\"0,25\",\"0\")","v":0.5}]
[]
[8,"Land use rights, ownership and tenure ",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!D26","v":9.0909090909090912E-2},{"$f":"SUM(I83:I87)","v":4.5454545454545456E-2}]
[null,"Questions","Sample National Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"What proportion of\" &'INPUT_Pre-check'!D6&\"'s total land area is indigenous and community lands?\"","v":"What proportion of Zambia's total land area is indigenous and community lands?"}," Landmark: Global platform of indigenous and community lands",null,0.6,"Inconsequential",null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":3.0303030303030304E-2},{"$f":"(J83*H83)","v":1.5151515151515152E-2},{"$f":"IF(F83=\"Inconsequential\",0.5,(1-E83))","v":0.5}]
[null,"Impact of population density on SPIS","Data Sources for Population Density","Population Density",null,null,null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":3.0303030303030304E-2},{"$f":"(J84*H84)","v":1.5151515151515152E-2},{"$f":"IF(E85=\"Positive\",(IF(F85=\"Inconsequential\",3,IF(F85=\"Slightly important\",4,IF(F85=\"Important\",4,IF(F85=\"Very important\",5,IF(F85=\"Critical\",6)))))),(IF(F85=\"Inconsequential\",3,IF(F85=\"Slightly important\",2,IF(F85=\"Important\",1,IF(F85=\"Very important\",1,IF(F85=\"Critical\",0)))))))/6","v":0.5}]
["b)","Does the population density positively or negatively affect the market for SPIS?","Country level  World Bank Population Density Data","<1","Unknown","Inconsequential"]
[null,null,"Regional Level Gridded Population of the world version 4"]
["c)","Does the population density have a positive or negative effect on land availability for agriculture?",null,null,"Unknown","Inconsequential",null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":3.0303030303030304E-2},{"$f":"(J87*H87)","v":1.5151515151515152E-2},{"$f":"IF(E87=\"Positive\",(IF(F87=\"Inconsequential\",3,IF(F87=\"Slightly important\",4,IF(F87=\"Important\",4,IF(F87=\"Very important\",5,IF(F87=\"Critical\",6)))))),(IF(F87=\"Inconsequential\",3,IF(F87=\"Slightly important\",2,IF(F87=\"Important\",1,IF(F87=\"Very important\",1,IF(F87=\"Critical\",0)))))))/6","v":0.5}]
[null,null,"World Population Density Data Index Mundi"]
[]
[9,"Transportation and communication infrastructure ",null,null,"Highest Possible Score","Attained Score"]
[{"$nulls":4},{"$f":"'INPUT_Weight setting'!F26","v":9.0909090909090912E-2},{"$f":"I93+I99","v":4.5454545454545456E-2}]
[null,"Questions","Sample National Data Sources",null,"Answer","Relevance",null,"Weight","Attained score","Raw Score"]
["a)","Transport",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":4.5454545454545456E-2},{"$f":"I94+I95+I97+I98+I96","v":2.2727272727272728E-2}]
["i)",{"$f":"\"What is the quality of air transport infrastructure score of\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the quality of air transport infrastructure score of Zambia?"},"Global mobility data, Country snapshot \n",null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":9.0909090909090905E-3},{"$f":"(J94*H94)","v":4.5454545454545452E-3},{"$f":"(IF(F94=\"Inconsequential\",3.5,E94))/7","v":0.5}]
["ii)",{"$f":"\"What is the quality of port infrastructure score of\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the quality of port infrastructure score of Zambia?"},null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":9.0909090909090905E-3},{"$f":"(J95*H95)","v":4.5454545454545452E-3},{"$f":"(IF(F95=\"Inconsequential\",3.5,E95))/7","v":0.5}]
["iii)",{"$f":"\"What is the quality of road infrastructure score of\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the quality of road infrastructure score of Zambia?"},null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":9.0909090909090905E-3},{"$f":"(J96*H96)","v":4.5454545454545452E-3},{"$f":"(IF(F96=\"Inconsequential\",3.5,E96))/7","v":0.5}]
["iv)",{"$f":"\"What is the quality of railroad infrastructure score of\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the quality of railroad infrastructure score of Zambia?"},null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":9.0909090909090905E-3},{"$f":"(J97*H97)","v":4.5454545454545452E-3},{"$f":"(IF(F97=\"Inconsequential\",3.5,E97))/7","v":0.5}]
["v)",{"$f":"\"What is the overall logistics performance index score of\"&'INPUT_Pre-check'!D6&\" in 2016?\"","v":"What is the overall logistics performance index score of Zambia in 2016?"},"Logistics performance index: Quality of trade and transport-related infrastructure (1=low to 5=high)",null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":9.0909090909090905E-3},{"$f":"(J98*H98)","v":4.5454545454545452E-3},{"$f":"(IF(F98=\"Inconsequential\",2.5,E98))/5","v":0.5}]
["b)","Communication",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":4.5454545454545456E-2},{"$f":"I100+I101+I102","v":2.2727272727272728E-2}]
["i)",{"$f":"\"What is the mobile-cellular telephone subscriptions per 100 inhabitants value in\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the mobile-cellular telephone subscriptions per 100 inhabitants value in Zambia?"},"International Telecommunications Union, global ICT Development Index (IDI) statistics",null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":1.5151515151515152E-2},{"$f":"(J100*H100)","v":7.575757575757576E-3},{"$f":"(IF(F100=\"Inconsequential\",50,E100))/100","v":0.5}]
["i)",{"$f":"\"What is the active mobile-broadband subscriptions per 100 inhabitants value in\"&'INPUT_Pre-check'!D6&\"?\"","v":"What is the active mobile-broadband subscriptions per 100 inhabitants value in Zambia?"},null,null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":1.5151515151515152E-2},{"$f":"(J101*H101)","v":7.575757575757576E-3},{"$f":"(IF(F101=\"Inconsequential\",50,E101))/100","v":0.5}]
["iii)",{"$f":"\"What is the overall ICT Development Index value - IDI - of\"&'INPUT_Pre-check'!D6&\" in 2017?\"","v":"What is the overall ICT Development Index value - IDI - of Zambia in 2017?"},null,null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":1.5151515151515152E-2},{"$f":"(J102*H102)","v":7.575757575757576E-3},{"$f":"(IF(F102=\"Inconsequential\",5,E102))/10","v":0.5}]
[]
[]
[null,null,"Got more recent data sources? "]
[null,null,"PLEASE SHARE "]
[null,null," and help us to improve our tools."]
[null,null,"Thank you."]

{"sheet":"OUTPUT_Result","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,3,1,8],[18,1,18,11],[3,2,3,3],[4,2,4,3],[3,6,3,7],[3,8,3,9],[4,6,4,7],[4,8,4,10],[5,1,5,4],[5,7,5,11]]}
[]
[null,null,null,"OUTPUT - Results"]
[]
[null,"Country:",{"$f":"'INPUT_Pre-check'!D6","v":" Zambia"},null,null,null,"Assessment date:",null,{"$f":"'INPUT_Pre-check'!D8","v":"00:00:00"}]
[null,"Specific area of interest:",{"$f":"'INPUT_Pre-check'!D7","v":0},null,null,null,"Assessor name:",null,{"$f":"'INPUT_Pre-check'!D9","v":0}]
[null,"Total Score (%)",{"$nulls":5},"Overview of Relevance Ratings"]
{"$rows_empty":12}
[null,"B. Market Potential for SPIS: Overall Score"]
{"$rows_empty":9}
[null,"Low Market Potential"]
[null,"Marginal Market Potential"]
[null,"Moderate Market Potential"]
[null,"High Market Potential"]

{"sheet":"Calculations","index":6,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Enabling SPIS Business Factors","Initial weight setting","Actually attained score ","Difference ",null,"Attained Score"]
[1,"Geophysical Parameters",{"$f":"' INPUT_Geophysical Parameters'!E6","v":9.0909090909090912E-2},{"$f":"' INPUT_Geophysical Parameters'!F6","v":7.2727272727272738E-2},{"$f":"C4-D4","v":1.8181818181818174E-2},{"$f":"100%-C4","v":0.90909090909090906},{"$f":"D4/C4","v":0.8}]
[2,"Government interventions",{"$f":"'INPUT_Business Conditions'!E6","v":0.18181818181818182},{"$f":"'INPUT_Business Conditions'!F6","v":7.0707070707070704E-2},{"$f":"C5-D5","v":0.11111111111111112},{"$f":"100%-C5","v":0.81818181818181812},{"$f":"D5/C5","v":0.38888888888888884}]
[3,"Development Organizations Interventions",{"$f":"'INPUT_Business Conditions'!E15","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F15","v":9.0909090909090912E-2},{"$f":"C6-D6","v":0},{"$f":"100%-C6","v":0.90909090909090906},1]
[4,"Financing",{"$f":"'INPUT_Business Conditions'!E23","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F23","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[5,"Availability  and cost of alternative sources of power for pumping",{"$f":"'INPUT_Business Conditions'!E36","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F36","v":5.6818181818181823E-2},3.4090909090909088E-2,0.90909090909090906,0.625]
[6,"Technical capacity for SPIS",{"$f":"'INPUT_Business Conditions'!E54","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F54","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[7,"Awareness of solar PV and irrigation technologies ",{"$f":"'INPUT_Business Conditions'!E61","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F61","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[8,"Significance of agriculture in the local economy",{"$f":"'INPUT_Business Conditions'!E72","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F72","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[9,"Land use rights, ownership and tenure ",{"$f":"'INPUT_Business Conditions'!E81","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F81","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[10,"Transportation and communication infrastructure ",{"$f":"'INPUT_Business Conditions'!E91","v":9.0909090909090912E-2},{"$f":"'INPUT_Business Conditions'!F91","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[null,null,{"$f":"SUM(C4:C13)","v":1.0000000000000002},{"$f":"SUM(D4:D13)","v":0.56388888888888888},{"$f":"C14-D14","v":0.43611111111111134}]
[]
[]
[]
[]
[]
[]
[null,"GEOPHYSICAL Parameters "]
[null,null,"Doughnut","Pie"]
[null,"Red Zone",30,{"$f":"IF('INPUT_Pre-check'!T14=0,10, IF('INPUT_Pre-check'!T14=1,7, IF('INPUT_Pre-check'!T14=2,14, IF('INPUT_Pre-check'!T14=3,21, IF('INPUT_Pre-check'!T14=4,30, IF('INPUT_Pre-check'!T14=5,45, IF('INPUT_Pre-check'!T14=6,60, IF('INPUT_Pre-check'!T14=7,75, IF('INPUT_Pre-check'!T14=8,100,115)))))))))","v":100},"Value"]
[null,"Orange Zone",30,1,"Ticker"]
[null,"Yellow Zone",30,{"$f":"240-D23-D24","v":139},"Rest Value"]
[null,"Green Zone",30]
[null,"Hidden Zone",120]
[]
[]
[null,"Relevance","Business","Geophysical","Total"]
[null,"Inconsequential",{"$f":"(COUNTIF('INPUT_Business Conditions'!$F$8:$F$102,Calculations!B31))/44","v":0.84090909090909094},{"$f":"(COUNTIF(' INPUT_Geophysical Parameters'!$F$8:$F$11,Calculations!B31))/44","v":9.0909090909090912E-2},{"$f":"SUM(C31:D31)","v":0.93181818181818188}]
[null,"Slightly important",{"$f":"(COUNTIF('INPUT_Business Conditions'!$F$8:$F$102,Calculations!B32))/44","v":0},{"$f":"(COUNTIF(' INPUT_Geophysical Parameters'!$F$8:$F$11,Calculations!B32))/44","v":0},{"$f":"SUM(C32:D32)","v":0}]
[null,"Important",{"$f":"(COUNTIF('INPUT_Business Conditions'!$F$8:$F$102,Calculations!B33))/44","v":2.2727272727272728E-2},{"$f":"(COUNTIF(' INPUT_Geophysical Parameters'!$F$8:$F$11,Calculations!B33))/44","v":0},{"$f":"SUM(C33:D33)","v":2.2727272727272728E-2}]
[null,"Very important",{"$f":"(COUNTIF('INPUT_Business Conditions'!$F$8:$F$102,Calculations!B34))/44","v":0},{"$f":"(COUNTIF(' INPUT_Geophysical Parameters'!$F$8:$F$11,Calculations!B34))/44","v":0},{"$f":"SUM(C34:D34)","v":0}]
[null,"Critical",{"$f":"(COUNTIF('INPUT_Business Conditions'!$F$8:$F$102,Calculations!B35))/44","v":4.5454545454545456E-2},{"$f":"(COUNTIF(' INPUT_Geophysical Parameters'!$F$8:$F$11,Calculations!B35))/44","v":0},{"$f":"SUM(C35:D35)","v":4.5454545454545456E-2}]
[null,null,{"$f":"SUM(C31:C35)","v":0.90909090909090906},{"$f":"SUM(D31:D35)","v":9.0909090909090912E-2},{"$f":"SUM(E31:E35)","v":1}]

{"sheet":"Lists","index":7,"n_rows":241,"n_cols":7,"rows_kept":241,"cut":false,"hidden":true,"merged":[]}
["Countries","Development Agencies","Facilitites and Funds","Other NGOs, Foundations","Rural MPI","GNI per Capita","pump manufacturers"]
["Afghanistan","African Development Bank","CTF (Clean Technology Fund)","AAA (Adaptation of African Agriculture)","0.10 - 1.86","Low income ($1,005 or less)","AllightSykes"]
[" Albania","CGIAR (Climate Change, Agriculture and Food Security)","EcoMicro","AGRA","1.87 - 8.80","Lower Middle Income ($1,006 to $3,955)","Ebara"]
[" Algeria","DFID ( Department for International Development - United Kingdom)","GEF (Global Environment Facility)","Energy 4Impact","8.81 - 26.06","Upper Middle Income ($3,956 tp $12,235)","Flowserve"]
[" American Samoa","FAO (Food and Agriculture Organization) ","GPOBA (Global Partnershi on Output Based Aid)","IFPRI (International Food Policy Research Institute)","26.07 - 48.54","High Income ($12.236 or more)","Grundfos"]
[" Andorra","GACSA (Global Alliance For Climate-Smart Agriculture)","ICBA","Lutheran World Relief","48.55 - 68.29",null,"Kirloskar Brothers Lt"]
[" Angola","GIZ (Deutsche Gesellschaft für Internationale Zusammenarbeit GmbH)","ICBA (International Center for Biosaline Agriculture)","The Practica Foundation","68.30 - 84.33",null,"KSB"]
[" Anguilla","IFAD (International Fund for Agriculture Development)",null,null,"84.34 - 96.90",null,"Lorentz"]
[" Antarctica","JICA (Japan International Cooperation Agency)",null,null,"No data",null,"Ruhrpumpen Group"]
[" Antigua and Barbuda","Nordic Development Fund",{"$nulls":4},"Suzler Ltd"]
[" Argentina","OECD (Organisation for Economic Co-operation and Development)",{"$nulls":4},"Weir Group"]
[" Armenia","OFID (OPEC Fund for International Development)",{"$nulls":4},"Wilo SE"]
[" Aruba","SIDA (Swedish International Development Cooperation Agency)",{"$nulls":4},"Xylem"]
[" Australia","USAID"]
[" Austria","World Bank Group"]
[" Azerbaijan","World Food Programme"]
[" Bahamas"]
[" Bahrain"]
[" Bangladesh"]
[" Barbados"]
[" Belarus"]
[" Belgium"]
[" Belize"]
[" Benin"]
[" Bermuda"]
[" Bhutan"]
[" Bolivia"]
[" Bosnia and Herzegovina"]
[" Botswana"]
[" Bouvet Island"]
[" Brazil"]
[" British Indian Ocean Territory"]
[" Brunei Darussalam"]
[" Bulgaria"]
[" Burkina Faso"]
[" Burundi"]
[" Cambodia"]
[" Cameroon"]
[" Canada"]
[" Cape Verde"]
[" Cayman Islands"]
[" Central African Republic"]
[" Chad"]
[" Chile"]
[" China"]
[" Christmas Island"]
[" Cocos (Keeling Islands)"]
[" Colombia"]
[" Comoros"]
[" Congo"]
[" Cook Islands"]
[" Costa Rica"]
[" Cote D'Ivoire (Ivory Coast)"]
[" Croatia (Hrvatska"]
[" Cuba"]
[" Cyprus"]
[" Czech Republic"]
[" Denmark"]
[" Djibouti"]
[" Dominica"]
[" Dominican Republic"]
[" East Timor"]
[" Ecuador"]
[" Egypt"]
[" El Salvador"]
[" Equatorial Guinea"]
[" Eritrea"]
[" Estonia"]
[" Ethiopia"]
[" Falkland Islands (Malvinas)"]
[" Faroe Islands"]
[" Fiji"]
[" Finland"]
[" France"]
[" France"]
[" Metropolitan"]
[" French Guiana"]
[" French Polynesia"]
[" French Southern Territories"]
[" Gabon"]
[" Gambia"]
[" Georgia"]
[" Germany"]
[" Ghana"]
[" Gibraltar"]
[" Greece"]
[" Greenland"]
[" Grenada"]
[" Guadeloupe"]
[" Guam"]
[" Guatemala"]
[" Guinea"]
[" Guinea-Bissau"]
[" Guyana"]
[" Haiti"]
[" Heard and McDonald Islands"]
[" Honduras"]
[" Hong Kong"]
[" Hungary"]
[" Iceland"]
[" India"]
[" Indonesia"]
[" Iran"]
[" Iraq"]
[" Ireland"]
[" Israel"]
[" Italy"]
[" Jamaica"]
[" Japan"]
[" Jordan"]
[" Kazakhstan"]
[" Kenya"]
[" Kiribati"]
[" Korea (North)"]
[" Korea (South)"]
[" Kuwait"]
[" Kyrgyzstan"]
[" Laos"]
[" Latvia"]
[" Lebanon"]
[" Lesotho"]
[" Liberia"]
[" Libya"]
[" Liechtenstein"]
[" Lithuania"]
[" Luxembourg"]
[" Macau"]
[" Macedonia"]
[" Madagascar"]
[" Malawi"]
[" Malaysia"]
[" Maldives"]
[" Mali"]
[" Malta"]
[" Marshall Islands"]
[" Martinique"]
[" Mauritania"]
[" Mauritius"]
[" Mayotte"]
[" Mexico"]
[" Micronesia"]
[" Moldova"]
[" Monaco"]
[" Mongolia"]
[" Montserrat"]
[" Morocco"]
[" Mozambique"]
[" Myanmar"]
[" Namibia"]
[" Nauru"]
[" Nepal"]
[" Netherlands"]
[" Netherlands Antilles"]
[" New Caledonia"]
[" New Zealand"]
[" Nicaragua"]
[" Niger"]
[" Nigeria"]
[" Niue"]
[" Norfolk Island"]
[" Northern Mariana Islands"]
[" Norway"]
[" Oman"]
[" Pakistan"]
[" Palau"]
[" Panama"]
[" Papua New Guinea"]
[" Paraguay"]
[" Peru"]
[" Philippines"]
[" Pitcairn"]
[" Poland"]
[" Portugal"]
[" Puerto Rico"]
[" Qatar"]
[" Reunion"]
[" Romania"]
[" Russian Federation"]
[" Rwanda"]
[" Saint Kitts and Nevis"]
[" Saint Lucia"]
[" Saint Vincent and The Grenadines"]
[" Samoa"]
[" San Marino"]
[" Sao Tome and Principe"]
[" Saudi Arabia"]
[" Senegal"]
[" Seychelles"]
[" Sierra Leone"]
[" Singapore"]
[" Slovak Republic"]
[" Slovenia"]
[" Solomon Islands"]
[" Somalia"]
[" South Africa"]
[" S. Georgia and S. Sandwich Isls."]
[" Spain"]
[" Sri Lanka"]
[" St. Helena"]
[" St. Pierre and Miquelon"]
[" Sudan"]
[" Suriname"]
[" Svalbard and Jan Mayen Islands"]
[" Swaziland"]
[" Sweden"]
[" Switzerland"]
[" Syria"]
[" Taiwan"]
[" Tajikistan"]
[" Tanzania"]
[" Thailand"]
[" Togo"]
[" Tokelau"]
[" Tonga"]
[" Trinidad and Tobago"]
[" Tunisia"]
[" Turkey"]
[" Turkmenistan"]
[" Turks and Caicos Islands"]
[" Tuvalu"]
[" Uganda"]
[" Ukraine"]
[" United Arab Emirates"]
[" United Kingdom (Britain / UK)"]
[" United States of America (USA)"]
[" US Minor Outlying Islands"]
[" Uruguay"]
[" Uzbekistan"]
[" Vanuatu"]
[" Vatican City State (Holy See)"]
[" Venezuela"]
[" Viet Nam"]
[" Virgin Islands (British)"]
[" Virgin Islands (US)"]
[" Wallis and Futuna Islands"]
[" Western Sahara"]
[" Yemen"]
[" Yugoslavia"]
[" Zaire"]
[" Zambia"]
[" Zimbabwe"]

{"sheet":"Lists 2","index":8,"n_rows":241,"n_cols":16,"rows_kept":241,"cut":false,"hidden":true,"merged":[]}
["Column1","Column2","Column3","Column4","Column1",null,null,"Solar Ranges",null,"Groundwater Depth",null,"Topography",null,"Ambient temperature",null,"Population Density"]
["Cropland, rainfed","Highly Suitable",null,null," Afghanistan",null,null,"0 - 948",null,"Up to 7m",null,"Mountainous",null,"Below 1C",null,"<1"]
["Cropland irrigated or post-flooding","Highly Suitable",null,null," Albania",null,null,"949 - 1094",null,"7m - 25m",null,"Steep hills",null,"1C to 30C",null,"1 - 5"]
["Mosaic crop land with natural vegetation","Highly Suitable",null,null," Algeria",null,null,"1095 - 1460",null,"25m - 50m",null,"Rolling hills",null,null,null,"5 - 25"]
["Light forest open (tree cover up to 40%)","Moderately Suitable",null,null," American Samoa",null,null,"Above 1460",null,"50m - 100m",null,"Level",null,null,null,"25 - 250"]
["Medium forest open to closed (tree cover above 40%)","Marginally Suitable",null,null," Andorra",{"$nulls":4},"Beyond 100m",null,"Mixed various",null,null,null,"250 - 1000"]
["Dense forest closed (tree cover above 40%)","Not Suitable",null,null," Angola",{"$nulls":4},"Unknown",{"$nulls":5},">1000"]
["Shrubland","Moderately Suitable",null,null," Anguilla"]
["Grassland","Moderately Suitable",null,null," Antarctica"]
["Lichens and mosses","Marginally Suitable",null,null," Antigua and Barbuda"]
["Semi arid sparse vegetation","Moderately Suitable",null,null," Argentina"]
["Flood plains fresh water","Marginally Suitable",null,null," Armenia"]
["Flood plains brackish water","Not Suitable",null,null," Aruba"]
["Urban areas","Not Suitable",null,null," Australia"]
["Bare areas (sand dunes, gravel plains, etc)","Marginally Suitable",null,null," Austria"]
["Water bodies","Not Suitable",null,null," Azerbaijan"]
["Permanent snow and ice","Not Suitable",null,null," Bahamas"]
[{"$nulls":4}," Bahrain"]
[{"$nulls":4}," Bangladesh"]
[{"$nulls":4}," Barbados"]
[{"$nulls":4}," Belarus"]
[{"$nulls":4}," Belgium"]
[{"$nulls":4}," Belize"]
[{"$nulls":4}," Benin"]
[{"$nulls":4}," Bermuda"]
[{"$nulls":4}," Bhutan"]
[{"$nulls":4}," Bolivia"]
[{"$nulls":4}," Bosnia and Herzegovina"]
[{"$nulls":4}," Botswana"]
[{"$nulls":4}," Bouvet Island"]
[{"$nulls":4}," Brazil"]
[{"$nulls":4}," British Indian Ocean Territory"]
[{"$nulls":4}," Brunei Darussalam"]
[{"$nulls":4}," Bulgaria"]
[{"$nulls":4}," Burkina Faso"]
[{"$nulls":4}," Burundi"]
[{"$nulls":4}," Cambodia"]
[{"$nulls":4}," Cameroon"]
[{"$nulls":4}," Canada"]
[{"$nulls":4}," Cape Verde"]
[{"$nulls":4}," Cayman Islands"]
[{"$nulls":4}," Central African Republic"]
[{"$nulls":4}," Chad"]
[{"$nulls":4}," Chile"]
[{"$nulls":4}," China"]
[{"$nulls":4}," Christmas Island"]
[{"$nulls":4}," Cocos (Keeling Islands)"]
[{"$nulls":4}," Colombia"]
[{"$nulls":4}," Comoros"]
[{"$nulls":4}," Congo"]
[{"$nulls":4}," Cook Islands"]
[{"$nulls":4}," Costa Rica"]
[{"$nulls":4}," Cote D'Ivoire (Ivory Coast)"]
[{"$nulls":4}," Croatia (Hrvatska"]
[{"$nulls":4}," Cuba"]
[{"$nulls":4}," Cyprus"]
[{"$nulls":4}," Czech Republic"]
[{"$nulls":4}," Denmark"]
[{"$nulls":4}," Djibouti"]
[{"$nulls":4}," Dominica"]
[{"$nulls":4}," Dominican Republic"]
[{"$nulls":4}," East Timor"]
[{"$nulls":4}," Ecuador"]
[{"$nulls":4}," Egypt"]
[{"$nulls":4}," El Salvador"]
[{"$nulls":4}," Equatorial Guinea"]
[{"$nulls":4}," Eritrea"]
[{"$nulls":4}," Estonia"]
[{"$nulls":4}," Ethiopia"]
[{"$nulls":4}," Falkland Islands (Malvinas)"]
[{"$nulls":4}," Faroe Islands"]
[{"$nulls":4}," Fiji"]
[{"$nulls":4}," Finland"]
[{"$nulls":4}," France"]
[{"$nulls":4}," France"]
[{"$nulls":4}," Metropolitan"]
[{"$nulls":4}," French Guiana"]
[{"$nulls":4}," French Polynesia"]
[{"$nulls":4}," French Southern Territories"]
[{"$nulls":4}," Gabon"]
[{"$nulls":4}," Gambia"]
[{"$nulls":4}," Georgia"]
[{"$nulls":4}," Germany"]
[{"$nulls":4}," Ghana"]
[{"$nulls":4}," Gibraltar"]
[{"$nulls":4}," Greece"]
[{"$nulls":4}," Greenland"]
[{"$nulls":4}," Grenada"]
[{"$nulls":4}," Guadeloupe"]
[{"$nulls":4}," Guam"]
[{"$nulls":4}," Guatemala"]
[{"$nulls":4}," Guinea"]
[{"$nulls":4}," Guinea-Bissau"]
[{"$nulls":4}," Guyana"]
[{"$nulls":4}," Haiti"]
[{"$nulls":4}," Heard and McDonald Islands"]
[{"$nulls":4}," Honduras"]
[{"$nulls":4}," Hong Kong"]
[{"$nulls":4}," Hungary"]
[{"$nulls":4}," Iceland"]
[{"$nulls":4}," India"]
[{"$nulls":4}," Indonesia"]
[{"$nulls":4}," Iran"]
[{"$nulls":4}," Iraq"]
[{"$nulls":4}," Ireland"]
[{"$nulls":4}," Israel"]
[{"$nulls":4}," Italy"]
[{"$nulls":4}," Jamaica"]
[{"$nulls":4}," Japan"]
[{"$nulls":4}," Jordan"]
[{"$nulls":4}," Kazakhstan"]
[{"$nulls":4}," Kenya"]
[{"$nulls":4}," Kiribati"]
[{"$nulls":4}," Korea (North)"]
[{"$nulls":4}," Korea (South)"]
[{"$nulls":4}," Kuwait"]
[{"$nulls":4}," Kyrgyzstan"]
[{"$nulls":4}," Laos"]
[{"$nulls":4}," Latvia"]
[{"$nulls":4}," Lebanon"]
[{"$nulls":4}," Lesotho"]
[{"$nulls":4}," Liberia"]
[{"$nulls":4}," Libya"]
[{"$nulls":4}," Liechtenstein"]
[{"$nulls":4}," Lithuania"]
[{"$nulls":4}," Luxembourg"]
[{"$nulls":4}," Macau"]
[{"$nulls":4}," Macedonia"]
[{"$nulls":4}," Madagascar"]
[{"$nulls":4}," Malawi"]
[{"$nulls":4}," Malaysia"]
[{"$nulls":4}," Maldives"]
[{"$nulls":4}," Mali"]
[{"$nulls":4}," Malta"]
[{"$nulls":4}," Marshall Islands"]
[{"$nulls":4}," Martinique"]
[{"$nulls":4}," Mauritania"]
[{"$nulls":4}," Mauritius"]
[{"$nulls":4}," Mayotte"]
[{"$nulls":4}," Mexico"]
[{"$nulls":4}," Micronesia"]
[{"$nulls":4}," Moldova"]
[{"$nulls":4}," Monaco"]
[{"$nulls":4}," Mongolia"]
[{"$nulls":4}," Montserrat"]
[{"$nulls":4}," Morocco"]
[{"$nulls":4}," Mozambique"]
[{"$nulls":4}," Myanmar"]
[{"$nulls":4}," Namibia"]
[{"$nulls":4}," Nauru"]
[{"$nulls":4}," Nepal"]
[{"$nulls":4}," Netherlands"]
[{"$nulls":4}," Netherlands Antilles"]
[{"$nulls":4}," New Caledonia"]
[{"$nulls":4}," New Zealand"]
[{"$nulls":4}," Nicaragua"]
[{"$nulls":4}," Niger"]
[{"$nulls":4}," Nigeria"]
[{"$nulls":4}," Niue"]
[{"$nulls":4}," Norfolk Island"]
[{"$nulls":4}," Northern Mariana Islands"]
[{"$nulls":4}," Norway"]
[{"$nulls":4}," Oman"]
[{"$nulls":4}," Pakistan"]
[{"$nulls":4}," Palau"]
[{"$nulls":4}," Panama"]
[{"$nulls":4}," Papua New Guinea"]
[{"$nulls":4}," Paraguay"]
[{"$nulls":4}," Peru"]
[{"$nulls":4}," Philippines"]
[{"$nulls":4}," Pitcairn"]
[{"$nulls":4}," Poland"]
[{"$nulls":4}," Portugal"]
[{"$nulls":4}," Puerto Rico"]
[{"$nulls":4}," Qatar"]
[{"$nulls":4}," Reunion"]
[{"$nulls":4}," Romania"]
[{"$nulls":4}," Russian Federation"]
[{"$nulls":4}," Rwanda"]
[{"$nulls":4}," Saint Kitts and Nevis"]
[{"$nulls":4}," Saint Lucia"]
[{"$nulls":4}," Saint Vincent and The Grenadines"]
[{"$nulls":4}," Samoa"]
[{"$nulls":4}," San Marino"]
[{"$nulls":4}," Sao Tome and Principe"]
[{"$nulls":4}," Saudi Arabia"]
[{"$nulls":4}," Senegal"]
[{"$nulls":4}," Seychelles"]
[{"$nulls":4}," Sierra Leone"]
[{"$nulls":4}," Singapore"]
[{"$nulls":4}," Slovak Republic"]
[{"$nulls":4}," Slovenia"]
[{"$nulls":4}," Solomon Islands"]
[{"$nulls":4}," Somalia"]
[{"$nulls":4}," South Africa"]
[{"$nulls":4}," S. Georgia and S. Sandwich Isls."]
[{"$nulls":4}," Spain"]
[{"$nulls":4}," Sri Lanka"]
[{"$nulls":4}," St. Helena"]
[{"$nulls":4}," St. Pierre and Miquelon"]
[{"$nulls":4}," Sudan"]
[{"$nulls":4}," Suriname"]
[{"$nulls":4}," Svalbard and Jan Mayen Islands"]
[{"$nulls":4}," Swaziland"]
[{"$nulls":4}," Sweden"]
[{"$nulls":4}," Switzerland"]
[{"$nulls":4}," Syria"]
[{"$nulls":4}," Taiwan"]
[{"$nulls":4}," Tajikistan"]
[{"$nulls":4}," Tanzania"]
[{"$nulls":4}," Thailand"]
[{"$nulls":4}," Togo"]
[{"$nulls":4}," Tokelau"]
[{"$nulls":4}," Tonga"]
[{"$nulls":4}," Trinidad and Tobago"]
[{"$nulls":4}," Tunisia"]
[{"$nulls":4}," Turkey"]
[{"$nulls":4}," Turkmenistan"]
[{"$nulls":4}," Turks and Caicos Islands"]
[{"$nulls":4}," Tuvalu"]
[{"$nulls":4}," Uganda"]
[{"$nulls":4}," Ukraine"]
[{"$nulls":4}," United Arab Emirates"]
[{"$nulls":4}," United Kingdom (Britain / UK)"]
[{"$nulls":4}," United States of America (USA)"]
[{"$nulls":4}," US Minor Outlying Islands"]
[{"$nulls":4}," Uruguay"]
[{"$nulls":4}," Uzbekistan"]
[{"$nulls":4}," Vanuatu"]
[{"$nulls":4}," Vatican City State (Holy See)"]
[{"$nulls":4}," Venezuela"]
[{"$nulls":4}," Viet Nam"]
[{"$nulls":4}," Virgin Islands (British)"]
[{"$nulls":4}," Virgin Islands (US)"]
[{"$nulls":4}," Wallis and Futuna Islands"]
[{"$nulls":4}," Western Sahara"]
[{"$nulls":4}," Yemen"]
[{"$nulls":4}," Yugoslavia"]
[{"$nulls":4}," Zaire"]
[{"$nulls":4}," Zambia"]
[{"$nulls":4}," Zimbabwe"]