{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Lisez Moi","INTRANT_Vérification préliminai","INTRANT_Facteurs de pondération","INTRANT_Paramètres géophysiques","INTRANT_Environnement commercia","RÉSULTAT PRODUIT_Résultat","Calculations","Feuille de Traduction","Lists","Lists 2"],"not_rendered":{"charts":9,"images":45,"macros":0,"external_links":1,"defined_names":26,"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":"Lisez Moi","index":0,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Lisez-moi"]
[]
[]
[]
[]
[null,null,"MARCHÉ – Outil d'analyse du marché"]
[]
[null,null,"Introduction"]
[null,null,"Cet outil vient compléter le module MARCHÉ de la boîte à outils SPIS. Il sert à déterminer les paramètres géophysiques décisifs. Si l'un des paramètres obtient un score de 0, la zone est considérée comme ayant un potentiel très faible pour les SPIS. Un \"Oui\" dans cette évaluation permet de prendre en compte d'autres paramètres."]
[]
[null,null,"Conseils et astuces"]
{"$rows_empty":8}
[null,null,"Aperçu"]
[null,null,"Cet outil comprend les feuilles suivantes :"]
[null,null,"Intrant_Vérification préliminaire : permet une première vérification de l'aptitude du SPIS à faire l'objet d'une évaluation"]
[null,null,"Intrant_Définition des facteurs de pondération : fournit une description des paramètres et permet d'ajuster les coefficients de pondération"]
[null,null,"Intrant_Paramètres géophysiques : permet de définir les paramètres géophysiques dans la région cible"]
[null,null,"Intrant_Environnement économique : permet de définir les paramètres économiques pertinents pour la zone cible"]
[null,null,"PRODUIT_RÉSULTAT : donne un aperçu graphique du potentiel de marché d'un SPIS dans une région"]
[]
[]
[null,null,"En savoir plus"]
[null,null,"Publié par : GIZ et FAO"]
[null,null,"Responsable : Projet de la GIZ « Énergie durable pour l'alimentation - Propulser l'agriculture »  (Sustainable Energy for Food - Powering Agriculture) \n                      Rebecca Navarro"]
[null,null,"Contact : Powering.Agriculture@giz.de"]
[null,null,"Lien de téléchargement : https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,"À propos de : Propulser l'agriculture : un grand défi énergétique pour le développement. Disponible à l'adresse :  https://poweringag.org"]
[null,null,"Version : 1.3 (janvier 2019)"]
[null,null,"La boîte à outils pour les systèmes d'irrigation à énergie solaire (Solar Powered Irrigation Systems) est rendue possible grâce à 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 développement et coopération internationale (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 créer l’initiative PAEGC. Cette initiative a pour objectif d’appuyer de nouvelles approches durables afin d’accélérer le développement et le déploiement de solutions énergétiques propres visant à accroître la productivité et/ou la valeur agricole pour les agriculteurs et les agroindustries dans les pays en développement et dans les régions émergentes qui n’ont pas accès à une énergie propre, fiable et abordable."]
[null,null,"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 de l’auteur et ne reflètent pas nécessairement celles de la GIZ, de la FAO, ou de l’un des partenaires fondateurs du PAEGC."]
[null,null,"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."]
[null,null,"© GIZ et FAO, 2018"]

{"sheet":"INTRANT_Vérification préliminai","index":1,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[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],[16,14,17,14],[14,2,14,13],[15,2,15,13],[20,14,20,15],[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],[15,1,17,1],[16,13,17,13],[16,11,17,11],[16,12,17,12],[16,5,17,5],[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]]}
[]
[{"$nulls":4},"INTRANT - Vérification préliminaire"]
[]
[]
[]
[null,"Pays :",null," Angola"]
[null,"Zone spécifique concernée :"]
[null,"Date de l'évaluation :"]
[null,"Nom de l’évaluateur :"]
[]
[1,"Paramètres géophysiques décisifs",{"$nulls":12},"Meilleur score possible","Score obtenu"]
[{"$nulls":14},9,{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":7}]
[null,"Questions","Sources des données",{"$nulls":11},"Réponse","Aptitude",null,"Paramètre","Score","Score brut"]
["a)",{"$f":"\"Quel est le type d'occupation des sols prédominant dans la zone concernée ?\"","v":"Quel est le type d'occupation des sols prédominant dans la zone concernée ?"},"Carte mondiale de l'occupation des sols\n",{"$nulls":11},"Medium forest open to closed (tree cover above 40%)",{"$f":"VLOOKUP(O14,'Lists 2'!A:B,2,0)","v":"Marginally Suitable"},null,"Occupation des sols",{"$f":"IF(P14=\"Highly Suitable\", \"3\", IF(P14=\"Moderately Suitable\", \"2\", IF(P14=\"Marginally Suitable\", \"1\", \"0\")))","v":"1"},{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":7}]
["b)",{"$f":"\"Quelle est l'irradiation solaire annuelle moyenne de la région ? (kWh/kW crête - valeur PVOUT)\"","v":"Quelle est l'irradiation solaire annuelle moyenne de la région ? (kWh/kW crête - valeur PVOUT)"},"Carte des ressources en énergie solaire de la Banque mondiale",{"$nulls":11},"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,"Irradiation solaire",{"$f":"IF(O15=\"Above 1460\", \"3\", IF(O15=\"1095 - 1460\", \"2\", IF(O15=\"949 - 1094\", \"1\", \"0\")))","v":"3"}]
["c)",{"$f":"\"Quelles sont les valeurs mensuelles moyennes des températures et des précipitations de la région ?\"","v":"Quelles sont les valeurs mensuelles moyennes des températures et des précipitations de la région ?"},"\nDonnées sur les précipitations mondiales de la Banque mondiale",{"$nulls":12},{"$f":"IF(O19=0, \"Low Irrigation Requirement\",IF(O19=1,\"Marginally Suitable\",IF(O19=2,\"Moderately Suitable\",\"Highly Suitable\")))","v":"Highly Suitable"},null,"Précipitations",{"$f":"IF(P16=\"Moderately Suitable\",2,IF(P16=\"Marginally Suitable\",1,IF(P16=\"Low Irrigation Requirement\",0,3)))","v":3}]
[null,null,"J","F","M","A","M","J","J","A","S","O","N","D","Nombre de mois arides :"]
[]
[null,"Températures moyennes mensuelles (°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,"Tmoy",{"$f":"AVERAGE(C19:N19)","v":22.166666666666668},"TSD",{"$f":"STDEV(C19:N19)","v":2.6213575016611501}]
[null,"Précipitations moyennes mensuelles (mm)",221,195,157,43,6,0,0,0,3.6,27.4,107.6,214.8,null,null,null,"Pmoy",{"$f":"AVERAGE(C20:N20)","v":81.283333333333346},"PSD",{"$f":"STDEV(C20:N20)","v":91.749043426604572}]
[null,"Indice d'aridité (Harouna & Carlson 1994)",{"$f":"((C19-$S$19)/$U$19)-((C20-$S$20)/$U$20)","v":-1.2049118901511016},{"$f":"((D19-$S$19)/$U$19)-((D20-$S$20)/$U$20)","v":-0.92153018905686723},-0.50735693361144751,0.35368110069615788,1.9014002560316068,-0.70357609099337681,-1.0850578230220305,-0.13135349295039633,1.1264469296416704,1.6300071442357935,0.56514272330771287,-1.0228917341277264,"http://agron-www.agron.iastate.edu/courses/Agron541/classes/541/lesson04a/4a.3.html"]
[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},"Non apte"]
[{"$nulls":5},"Peu apte"]
[{"$nulls":5},"Moyennement apte"]
[{"$nulls":5},"Très apte"]

{"sheet":"INTRANT_Facteurs de pondération","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,"INTRANT – Facteurs de pondération"]
[]
[]
[]
[null,"Paramètres géophysiques :"]
[null,"Paramètres géophysiques non critiques"]
[null,"Paramètres complémentaires essentiels à l’évaluation du marché d’un SPIS. Ils n’affectent pas la viabilité générale d’un SPIS mais le succès de son adoption dans une région en fonction des conditions géophysiques dominantes (par ex. nappe phréatique, présence de gel, topographie, système de production agricole, etc.)."]
[null,"Important"]
[null,{"$f":"H40","v":0.13636363636363635}]
[]
[null,"Conditions économiques :"]
[null,"1. Action gouvernementale",null,"2. Action des organismes de développement",null,"3. Financement"]
[null,"Évaluation de l'action gouvernementale en tant que paramètre de l’environnement économique d’un SPIS, en consultant les politiques, les règles et les régulations qui régissent les secteurs solaires et ceux de l’irrigation.",null,"Cette section évalue l'action des organismes de développement susceptibles d’avoir une influence significative sur l’adoption de SPIS dans un pays ou une région.",null,"Ce paramètre examine la capacité des utilisateurs finaux à faire face aux coûts d’investissement élevés d’un SPIS ainsi que les subventions du gouvernement, des agences de développement et du secteur privé"]
[null,"Important",null,"Important",null,"Important"]
[null,{"$f":"H31","v":0.13636363636363635},null,{"$f":"H32","v":0.13636363636363635},null,{"$f":"H33","v":0.13636363636363635}]
[]
[null,"4. Disponibilité et coûts des énergies non solaires",null,"5. Capacité technique",null,"6. Sensibilisation aux technologies des SPIS"]
[null,"Ce critère examine l’existence de sources d’énergie concurrentielles pour les systèmes d’irrigation et leur coût.",null,"Cette section évalue les compétences du personnel des pays dans la conception, la mise en œuvre et l'entretien des SPIS.",null,"Ce paramètre évalue la sensibilisation générale de la population du pays concerné aux technologies solaires telles que l’éclairage et le chauffage solaires et aux systèmes d’irrigation à énergie solaire tels que les pompes solaires."]
[null,"Important",null,"Critical",null,"Ignore"]
[null,{"$f":"H34","v":0.13636363636363635},null,{"$f":"H35","v":0.22727272727272727},null,{"$f":"H36","v":0}]
[]
[null,"7. Part de l’agriculture dans l’économie locale",null,"8. Régime foncier",null,"9. Infrastructures de transport et de communication"]
[null,"Cette section évalue l’importance de l’agriculture pour l’économie de la région cible en évaluant sa contribution au PIB et à l’emploi ainsi que la proportion de terres arables utilisées pour l’agriculture.",null,"Ce paramètre s'intéresse aux droits fonciers susceptibles d’entraver ou au contraire de favoriser l’adoption des SPIS. Importants en termes de sécurité d’investissement, les droits fonciers peuvent aussi servir à garantir les prêts.",null,"Cette section évalue la disponibilité des infrastructures et des systèmes de communication tels que les routes et les réseaux mobiles pour faciliter les chaînes d’approvisionnement ainsi que la circulation des personnes et des biens."]
[null,"Slightly important",null,"Ignore",null,"Ignore"]
[null,{"$f":"H37","v":9.0909090909090912E-2},null,{"$f":"H38","v":0},null,{"$f":"H39","v":0}]
[]
[]
[]
[{"$nulls":5},"Paramètre","Pondération","Pourcentage","Score"]
[{"$nulls":5},"Action gouvernementale",{"$f":"B15","v":"Important"},{"$f":"I31/$I$41","v":0.13636363636363635},{"$f":"IF(B15=\"Inconsequential\",2,IF(B15=\"Slightly important\",4,IF(B15=\"Important\",6,IF(B15=\"Very Important\",8,IF(B15=\"Critical\",10)))))","v":6}]
[{"$nulls":5},"Action des agences de développement",{"$f":"D15","v":"Important"},{"$f":"I32/$I$41","v":0.13636363636363635},{"$f":"IF(D15=\"Inconsequential\",2,IF(D15=\"Slightly important\",4,IF(D15=\"Important\",6,IF(D15=\"Very Important\",8,IF(D15=\"Critical\",10)))))","v":6}]
[{"$nulls":5},"Financement",{"$f":"F15","v":"Important"},{"$f":"I33/$I$41","v":0.13636363636363635},{"$f":"IF(F15=\"Inconsequential\",2,IF(F15=\"Slightly important\",4,IF(F15=\"Important\",6,IF(F15=\"Very Important\",8,IF(F15=\"Critical\",10)))))","v":6}]
[{"$nulls":5},"Disponibilité et coûts des énergies non solaires",{"$f":"B20","v":"Important"},0.13636363636363635,{"$f":"IF(B20=\"Inconsequential\",2,IF(B20=\"Slightly important\",4,IF(B20=\"Important\",6,IF(B20=\"Very Important\",8,IF(B20=\"Critical\",10)))))","v":6}]
[{"$nulls":5},"Capacité technique",{"$f":"D20","v":"Critical"},0.22727272727272727,{"$f":"IF(D20=\"Inconsequential\",2,IF(D20=\"Slightly important\",4,IF(D20=\"Important\",6,IF(D20=\"Very Important\",8,IF(D20=\"Critical\",10)))))","v":10}]
[{"$nulls":5},"Sensibilisation aux technologies PV et d'irrigation à énergie solaire",{"$f":"F20","v":"Ignore"},0,{"$f":"IF(F20=\"Inconsequential\",2,IF(F20=\"Slightly important\",4,IF(F20=\"Important\",6,IF(F20=\"Very Important\",8,IF(F20=\"Critical\",10)))))","v":false}]
[{"$nulls":5},"Part de l'agriculture dans l'économie locale",{"$f":"B25","v":"Slightly important"},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":4}]
[{"$nulls":5},"Régime foncier",{"$f":"D25","v":"Ignore"},0,{"$f":"IF(D25=\"Inconsequential\",2,IF(D25=\"Slightly important\",4,IF(D25=\"Important\",6,IF(D25=\"Very Important\",8,IF(D25=\"Critical\",10)))))","v":false}]
[{"$nulls":5},"Infrastructures de transport et de communication",{"$f":"F25","v":"Ignore"},0,{"$f":"IF(F25=\"Inconsequential\",2,IF(F25=\"Slightly important\",4,IF(F25=\"Important\",6,IF(F25=\"Very Important\",8,IF(F25=\"Critical\",10)))))","v":false}]
[{"$nulls":5},"Paramètres géophysiques complémentaires",{"$f":"B9","v":"Important"},0.13636363636363635,{"$f":"IF(B9=\"Inconsequential\",2,IF(B9=\"Slightly important\",4,IF(B9=\"Important\",6,IF(B9=\"Very Important\",8,IF(B9=\"Critical\",10)))))","v":6}]
[{"$nulls":5},"Total",{"$f":"SUM(G31:G40)","v":0},{"$f":"SUM(H31:H40)","v":1},{"$f":"SUM(I31:I40)","v":44}]

{"sheet":"INTRANT_Paramètres géophysiques","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,2,14,3],[15,2,15,3],[16,2,16,3],[11,1,11,5],[4,0,5,0],[6,2,6,3],[4,1,5,3],[3,0,3,5],[13,2,13,3],[10,2,10,3],[1,2,1,3],[7,2,7,3],[8,2,8,3],[9,2,9,3]]}
[]
[null,null,"INTRANT - Paramètres géophysiques"]
[]
[]
[2,"Paramètres géophysiques complémentaires",null,null,"Score maximum","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!B10","v":0.13636363636363635},{"$f":"SUM(I8:I11)","v":7.2727272727272724E-2}]
[null,"Questions","Sources de données",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Quel est le niveau de nappe phréatique adapté à un SPIS?","Estimation de la profondeur de la nappe phréatique",null,"50m - 100m","Inconsequential",null,{"$f":"E6/COUNTA(B8,B9,B10,B11)","v":3.4090909090909088E-2},{"$f":"(J8*H8)","v":3.4090909090909094E-3},{"$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.10000000000000002}]
["b)","Quelle est la température ambiante annuelle minimum et notamment la fréquence du gel ?","Base des températures mondiales de la World Bank",null,"Below 1C","Important",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":3.4090909090909088E-2},{"$f":"(J9*H9)","v":1.1363636363636362E-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":0.33333333333333331}]
["c)","Quelle est la topographie générale de la zone considérée ?","Quelle est la pente de la région concernée ?",null,"Flat","Inconsequential",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":3.4090909090909088E-2},{"$f":"(J10*H10)","v":3.4090909090909088E-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":1}]
["d)","Quel est le type de système de production agricole prédominant ?","Cartes des systèmes agricoles de la FAO",null,"Livestock and Crops","Inconsequential",null,{"$f":"(E6/COUNTA(B8,B9,B10,B11))","v":3.4090909090909088E-2},{"$f":"(J11*H11)","v":2.3863636363636358E-2},{"$f":"IF(E11=\"Seasonal Crops\",0.6,IF(E11=\"Perennial Crops\",0.8,IF(E11=\"Small Livestock\",1,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.69999999999999984}]
[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,"Vous disposez de sources de données plus actuelles ? "]
[null,null,"MERCI DE NOUS LES COMMUNIQUER"]
[null,null," et de nous aider à améliorer cet outil."]
[null,null,"Nous apprécions votre coopération."]

{"sheet":"INTRANT_Environnement commercia","index":4,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":false,"merged":[[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],[63,2,65,3],[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],[84,0,85,0],[84,3,87,3],[86,1,87,1],[86,0,87,0],[86,5,87,5],[89,1,90,3],[91,2,91,3],[83,3,83,5],[89,0,90,0],[88,1,88,5],[84,2,87,2],[39,7,43,7],[39,8,43,8],[39,9,43,9],[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],[92,1,92,5],[93,2,96,3],[83,9,85,9],[58,1,58,5],[51,1,51,5],[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],[33,1,33,5],[20,1,20,5],[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],[102,1,102,5],[69,1,69,5],[59,0,60,0],[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],[17,8,19,8],[17,9,19,9],[19,2,19,3],[21,0,22,0],[17,7,19,7]]}
[]
[null,null,"INTRANT - Paramètres Environnement commercial"]
[]
[]
[1,"Action gouvernementale",null,null,"Score maximum possible ","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!B16","v":0.13636363636363635},{"$f":" IF(OR(AND(E8=\"No\",F8=\"Critical\"),AND(E11=\"No\",F11=\"Critical\"),AND(E12=\"No\",F12=\"Critical\")),0,SUM(I8:I12))","v":0.13636363636363635}]
[null,"Questions","Sources des données",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Existe-t-il des politiques et des lois gouvernementales et locales de promotion des équipements solaires et d'irrigation ?","• Politiques, projets de loi, lois, décrets, plans de développement sectoriels émis par le gouvernement en matière d'irrigation et/ou d'énergie solaire\n• Accréditation des techniciens, des fournisseurs et des entreprises sous-traitantes du solaire\n• Réglementations douanières et fiscales telles qu'exonérations des droits de douane et de TVA\n","Politiques de développement des énergies renouvelables","Yes","Inconsequential",null,{"$f":"E6/COUNTA(B8:B12)","v":4.5454545454545449E-2},{"$f":"(J8*H8)","v":4.5454545454545449E-2},{"$f":"(IF(E8=\"Yes\",(IF(F8=\"Inconsequential\",6,IF(F8=\"Slightly important\",5,IF(F8=\"Important\",4,IF(F8=\"Very important\",3,IF(F8=\"Critical\",2)))))),(IF(F8=\"Inconsequential\",3,IF(F8=\"Slightly important\",2,IF(F8=\"Important\",1,IF(F8=\"Very important\",1,IF(F8=\"Critical\",0))))))))/6","v":1}]
[null,null,null,"Politique de soutien aux EnR dans les pays en développement : tableau 4, p. 121 "]
[null,null,null,"Documents de politique générale des Pays de l'Asie-Pacifique"]
["b)","Existe-t-il des programmes gouvernementaux faisant la promotion des équipements SPIS ?","• Programme d'irrigation et d'énergie solaires soutenus par des ressources gouvernementales",null,"Yes","Inconsequential",null,{"$f":"E6/COUNTA(B8:B12)","v":4.5454545454545449E-2},{"$f":"(J11*H11)","v":4.5454545454545449E-2},{"$f":"(IF(E11=\"Yes\",(IF(F11=\"Inconsequential\",6,IF(F11=\"Slightly important\",5,IF(F11=\"Important\",4,IF(F11=\"Very important\",3,IF(F11=\"Critical\",2)))))),(IF(F11=\"Inconsequential\",3,IF(F11=\"Slightly important\",2,IF(F11=\"Important\",1,IF(F11=\"Very important\",1,IF(F11=\"Critical\",0))))))))/6","v":1}]
["c)","Existe-t-il des ministères et/ou des organismes gouvernementaux compétents qui apportent un soutien au secteur ?","• Les ministères de l'agriculture et de l'énergie intervenant dans le secteur des SPIS\n• Organismes, comités, groupes de travail gouvernementaux du secteur de l'irrigation\n• Organismes gouvernementaux fournissant des informations relatives aux SPIS\n• Réglementation et application de la qualité et des normes gouvernementales","Réglementations spécifiques des systèmes et incitations","Yes","Inconsequential",null,{"$f":"E6/COUNTA(B8:B12)","v":4.5454545454545449E-2},{"$f":"(J12*H12)","v":4.5454545454545449E-2},{"$f":"(IF(E12=\"Yes\",(IF(F12=\"Inconsequential\",6,IF(F12=\"Slightly important\",5,IF(F12=\"Important\",4,IF(F12=\"Very important\",3,IF(F12=\"Critical\",2)))))),(IF(F12=\"Inconsequential\",3,IF(F12=\"Slightly important\",2,IF(F12=\"Important\",1,IF(F12=\"Very important\",1,IF(F12=\"Critical\",0))))))))/6","v":1}]
[]
[2,"Action des agences de développement",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!D16","v":0.13636363636363635},{"$f":" IF(OR(AND(E17=\"No\",F17=\"Critical\"),AND(E18=\"No\",F18=\"Critical\")),0,SUM(I17:I20))","v":0.13636363636363635}]
[null,"Questions","Sources des données",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Existe-t-il des programmes nationaux mis en place par des institutions non-gouvernementales qui encouragent l'adoption des SPIS ?","• Liste* d'agences de développement et d'organisations multilatérales : ","GIZ (Deutsche Gesellschaft für Internationale Zusammenarbeit GmbH)","Yes","Inconsequential",null,{"$f":"E15/(COUNTA(B17:B20))","v":6.8181818181818177E-2},{"$f":"(J17*H17)","v":6.8181818181818177E-2},{"$f":"(IF(E17=\"Yes\",(IF(F17=\"Inconsequential\",6,IF(F17=\"Slightly important\",5,IF(F17=\"Important\",4,IF(F17=\"Very important\",3,IF(F17=\"Critical\",2)))))),(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)","Existe-t-il des programmes nationaux mis en place par des institutions non gouvernementales qui font spécifiquement la promotion des équipements SPIS ?","• Liste* d'organismes et de fonds :","GEF (Global Environment Facility)","Yes","Inconsequential",null,{"$f":"E15/COUNTA(B17:B20)","v":6.8181818181818177E-2},{"$f":"(J18*H18)","v":6.8181818181818177E-2},{"$f":"(IF(E18=\"Yes\",(IF(F18=\"Inconsequential\",6,IF(F18=\"Slightly important\",5,IF(F18=\"Important\",4,IF(F18=\"Very important\",3,IF(F18=\"Critical\",2)))))),(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,"• Liste* de centres de recherche et d'autres ONG :","AGRA"]
[null,null,"* Liste non exhaustive"]
[]
[3,"Financement",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!F16","v":0.13636363636363635},{"$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":0.13636363636363635}]
[null,"Questions","Sources de données nationales",null,"Questions","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Capacité financière des utilisateurs finaux",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":4.5454545454545449E-2},{"$f":"I26+I27","v":4.5454545454545449E-2}]
["i)","Quelle proportion de la population rurale est pauvre selon l'indice de pauvreté multidimensionnelle ?","OPHI Global MPI Interactive Databank: Population in multidimensional poverty (H) (%), Rural MPI Poor",null,0.2,"Inconsequential",null,{"$f":"H25/COUNTA(B26:B27)","v":2.2727272727272724E-2},{"$f":"(H26*J26)","v":2.2727272727272724E-2},{"$f":"IF(F26=\"Inconsequential\",1,(1-E26))","v":1}]
["ii)","Quelle est la valeur du RNB par habitant ?"," Données de la Banque mondiale : RNB par habitant, méthode Atlas ($ US courants) 2016",null,"Low income ($1,005 or less)","Inconsequential",null,{"$f":"H25/COUNTA(B26:B27)","v":2.2727272727272724E-2},{"$f":"(H27*J27)","v":2.2727272727272724E-2},{"$f":"(IF(F27=\"Inconsequential\",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":1}]
["b)","Existence de soutien par des institutions financières ?",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":4.5454545454545449E-2},{"$f":"I29+I30+I32","v":4.5454545454545449E-2}]
["i)","Quelle est la proportion de la population âgée de plus de 15 ans qui dispose d'un propre compte dans une institution financière ?","i) Compte (% âge 15+) basé sur le pays\nii) Emprunt officiel (% âge 15+) basé sur le pays","Banque mondiale, Données sur l'inclusion financière",0.3,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.515151515151515E-2},{"$f":"H29*J29","v":1.515151515151515E-2},{"$f":"IF(F29=\"Inconsequential\",1,E29)","v":1}]
["ii)","Quelle est la proportion de la population âgée de plus de 15 ans qui a contracté un emprunt auprès d'une institution financière au cours d'une année donnée* ?",null,null,0.2,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.515151515151515E-2},{"$f":"H30*J30","v":1.515151515151515E-2},{"$f":"IF(F30=\"Inconsequential\",1,E30)","v":1}]
[null,"* l'année donnée est l'année la plus récente dans les données disponibles "]
["iii)","Quel est le positionnement dans le classement de la facilité d'obtention de prêt ?","Banque mondiale - Classement des économies (facilité à faire des affaires) 2017",null,77,"Inconsequential",null,{"$f":"H28/COUNTA(B29:B30,B32)","v":1.515151515151515E-2},{"$f":"(H32*J32)","v":1.515151515151515E-2},{"$f":"(IF(F32=\"Inconsequential\",186,(186-E32)))/186","v":1}]
["c)","Existe-t-il des incitatifs économiques gouvernementaux qui influent sur l'adoption des dispositifs SPIS ?","• Exonérations fiscales, subventions, rabais, crédits, etc. accordés aux clients des produits SPIS, aux fournisseurs ou à d'autres intermédiaires tels que les financiers",null,"Yes","Inconsequential",null,{"$f":"E23/COUNTA(B25,B28,B33)","v":4.5454545454545449E-2},{"$f":"H33*J33","v":4.5454545454545449E-2},{"$f":"(IF(E33=\"Yes\",(IF(F33=\"Inconsequential\",6,IF(F33=\"Slightly important\",5,IF(F33=\"Important\",4,IF(F33=\"Very important\",3,IF(F33=\"Critical\",2)))))),(IF(F33=\"Inconsequential\",3,IF(F33=\"Slightly important\",2,IF(F33=\"Important\",1,IF(F33=\"Very important\",1,IF(F33=\"Critical\",0))))))))/6","v":1}]
[]
[4,"Disponibilité et coût des sources d'énergie non solaires pour le pompage",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!B21","v":0.13636363636363635},{"$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":9.0909090909090898E-2}]
[null,"Questions","Sources de données régionales","Sources de données nationales","Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Disponibilité de sources d’énergie alternatives concurrentielles ",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":4.5454545454545449E-2},{"$f":"I39+I40+I45","v":4.5454545454545449E-2}]
["i)","La zone concernée possède-t-elle des ressources en énergie fossile qu'elle exploite ? ","Réserves nationales en énergie fossile",null,"No","Inconsequential",null,{"$f":"H38/(COUNTA(B39:B45)-1)","v":2.2727272727272724E-2},{"$f":"H39*J39","v":2.2727272727272724E-2},{"$f":"IF(E39=\"No\",IF(F39=\"Inconsequential\",1,IF(F39=\"Important\",0.5)),0)","v":1}]
["ii)"," \nLa zone concernée se trouve-t-elle à proximité immédiate du réseau (à moins de 5 km d'un point d'accès au réseau) ou le taux d'électrification rurale est-il supérieur à 80 % ? ","Afrique - Réseau électrique","Accès à l'électricité, taux d'électrification rurale","No","Inconsequential",null,{"$f":"H38/((COUNTA(B39:B45)-1)*2)","v":1.1363636363636362E-2},{"$f":"H40*J40","v":1.1363636363636362E-2},{"$f":"IF(E40=\"No\",IF(F40=\"Inconsequential\",1,IF(F40=\"Important\",0.5)),0)","v":1}]
[null,null,"Europe - Réseau électrique"]
[null,null,"USA - Réseau électrique","Tracking SDG 7 "]
[null,null,"Australie - Réseau électrique","Cartes du réseau"]
[null,null,"Pour plus de précision, consulter les données réseau spécifiques à chaque pays"]
["iii)"," \nQuelle est la fréquence des coupures d'électricité dans la zone concernée ?","• Fiabilité de l'approvisionnement local en électricité de la zone concernée ","Fréquence des coupures d'électricité ","Low","Inconsequential",null,{"$f":"H38/((COUNTA(B39:B45)-1)*2)","v":1.1363636363636362E-2},{"$f":"H45*J45","v":1.1363636363636362E-2},{"$f":"(IF(F45=\"Inconsequential\",5,IF(E45=\"Low\",1,IF(E45=\"Regular\",2,IF(E45=\"High\",4,IF(E45=\"Very high\",5,))))))/5","v":1}]
["b)","Subventions",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":4.5454545454545449E-2},{"$f":"I47+I48","v":4.5454545454545449E-2}]
["i)"," \nY a-t-il une subvention de réseau dans la zone concernée, y compris pour les frais d'électricité et/ou les frais de raccordement au réseau ? ","• Réglementation locale de l'approvisionnement en électricité de la zone concernée ","Existence d'une subvention nationale à l'électricité","No","Inconsequential",null,{"$f":"H38/COUNTA(B47:B48)","v":2.2727272727272724E-2},{"$f":"H47*J47","v":2.2727272727272724E-2},{"$f":"IF(E47=\"No\",IF(F47=\"Inconsequential\",1,IF(F47=\"Important\",0.5)),0)","v":1}]
["ii)","Y a-t-il une subvention pour le carburant dans la zone concernée ? ","• Réglementation locale de l'approvisionnement en carburant de la zone concernée ","Existence d'une subvention nationale au carburant (diesel, kérosène, etc.)","No","Inconsequential",null,{"$f":"H38/COUNTA(B47:B48)","v":2.2727272727272724E-2},{"$f":"H48*J48","v":2.2727272727272724E-2},{"$f":"IF(E48=\"No\",IF(F48=\"Inconsequential\",1,IF(F48=\"Important\",0.5)),0)","v":1}]
["c)","Comparaison des coûts ",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":4.5454545454545449E-2},{"$f":"I50+I51","v":0}]
["i)","Quel est le tarif moyen de l'électricité en USD par kWh pour les agriculteurs dans la zone concernée ? ","• Coût de l'approvisionnement local en électricité en USD par kWh dans la zone concernée ","Tarif de l'électricité (moyenne de tous les consommateurs finaux) en USD/kWh",null,"La référence pour la pénalité la moins élevée sera de 1 USD/kWh, avec l'électricité la plus chère, arrondie au nombre entier supérieur (0,61)",null,{"$f":"H49/COUNTA(B50:B51)","v":2.2727272727272724E-2},{"$f":"H50*J50","v":0},{"$f":"E50","v":0}]
["ii)","Quel est le prix de détail moyen du diesel en USD par litre dans la zone concernée ?","• Coût moyen local du diesel en USD/Litre de la zone concernée ","Prix du diesel en USD/Liter\n",null,"La référence pour la pénalité la moins élevée sera de 3 USD/L , prix de l'Islande, avec le diesel le plus cher, arrondie au nombre entier supérieur (2.03)",null,{"$f":"H49/COUNTA(B50:B51)","v":2.2727272727272724E-2},{"$f":"H51*J51","v":0},{"$f":"E51/3","v":0}]
[]
[5,"Capacité technique pour les SPIS",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!D21","v":0.22727272727272727},{"$f":" IF(OR(AND(E56=\"No\",F56=\"Critical\"),AND(E57=\"No\",F57=\"Critical\"),AND(E58=\"No\",F58=\"Critical\")),0,SUM(I56:I58))","v":0.18939393939393939}]
[null,"Questions","Sources de données nationales",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Existe-t-il des sessions de formation sur les technologies solaires et leurs applications (conception, O&M et réparations) ?",{"$f":"\"• Cours sur les systèmes et technologies solaires dans les établissements d'enseignement\"","v":"• Cours sur les systèmes et technologies solaires dans les établissements d'enseignement"},null,"No","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":7.575757575757576E-2},{"$f":"(J56*H56)","v":3.787878787878788E-2},{"$f":"(IF(E56=\"Yes\",(IF(F56=\"Inconsequential\",6,IF(F56=\"Slightly important\",5,IF(F56=\"Important\",4,IF(F56=\"Very important\",3,IF(F56=\"Critical\",2)))))),(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)","Les techniciens solaires ont-ils été accrédités par le gouvernement pour effectuer ce travail ?","• Réglementation gouvernementale sur l'accréditation des techniciens solaires ",null,"Yes","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":7.575757575757576E-2},{"$f":"(J57*H57)","v":7.575757575757576E-2},{"$f":"(IF(E57=\"Yes\",(IF(F57=\"Inconsequential\",6,IF(F57=\"Slightly important\",5,IF(F57=\"Important\",4,IF(F57=\"Very important\",3,IF(F57=\"Critical\",2)))))),(IF(F57=\"Inconsequential\",3,IF(F57=\"Slightly important\",2,IF(F57=\"Important\",1,IF(F57=\"Very important\",1,IF(F57=\"Critical\",0))))))))/6","v":1}]
["c)","La technologie solaire est-elle intégrée au programme d'études des cours ou des programmes agricoles dispensés par les établissements de formation agricole ?",{"$f":"\"• Cours sur les systèmes et les technologies solaires des établissements d'enseignement.\"","v":"• Cours sur les systèmes et les technologies solaires des établissements d'enseignement."},null,"Yes","Inconsequential",null,{"$f":"E54/COUNTA(B56:B58)","v":7.575757575757576E-2},{"$f":"(J58*H58)","v":7.575757575757576E-2},{"$f":"(IF(E58=\"Yes\",(IF(F58=\"Inconsequential\",6,IF(F58=\"Slightly important\",5,IF(F58=\"Important\",4,IF(F58=\"Very important\",3,IF(F58=\"Critical\",2)))))),(IF(F58=\"Inconsequential\",3,IF(F58=\"Slightly important\",2,IF(F58=\"Important\",1,IF(F58=\"Very important\",1,IF(F58=\"Critical\",0))))))))/6","v":1}]
[]
[6,"Sensibilisation aux technologies PV et d’irrigation à énergie solaire ",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!F21","v":0},{"$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":0}]
[null,"Questions","Sources de données nationales",null,"Question","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Énergie solaire",{"$nulls":5},{"$f":"E61/COUNTA(B63,B67)","v":0},{"$f":"I64+I65+I66","v":0}]
["i)","Y a-t-il une augmentation cumulative de la puissance installée de l'énergie solaire entre 2012 et 2016 ?","IRENA dashboard: Trends in Renewable Energy",null,"Yes","Inconsequential",null,{"$f":"H63/COUNTA(B64:B66)","v":0},{"$f":"(J64*H64)","v":0},{"$f":"(IF(E64=\"Yes\",(IF(F64=\"Inconsequential\",6,IF(F64=\"Slightly important\",5,IF(F64=\"Important\",4,IF(F64=\"Very important\",3,IF(F64=\"Critical\",2)))))),(IF(F64=\"Inconsequential\",3,IF(F64=\"Slightly important\",2,IF(F64=\"Important\",1,IF(F64=\"Very important\",1,IF(F64=\"Critical\",0))))))))/6","v":1}]
["ii)","Y a-t-il une augmentation générale de l'énergie solaire nette additionnelle annuelle installée entre 2012 et 2016 ?",null,null,"Yes","Inconsequential",null,{"$f":"H63/COUNTA(B64:B66)","v":0},{"$f":"(J65*H65)","v":0},{"$f":"(IF(E65=\"Yes\",(IF(F65=\"Inconsequential\",6,IF(F65=\"Slightly important\",5,IF(F65=\"Important\",4,IF(F65=\"Very important\",3,IF(F65=\"Critical\",2)))))),(IF(F65=\"Inconsequential\",3,IF(F65=\"Slightly important\",2,IF(F65=\"Important\",1,IF(F65=\"Very important\",1,IF(F65=\"Critical\",0))))))))/6","v":1}]
["iii)"," Quelle est la part de l'énergie solaire dans la capacité énergétique totale installée ?",null,null,0.05,"Important",null,{"$f":"H63/COUNTA(B64:B66)","v":0},{"$f":"(J66*H66)","v":0},{"$f":"IF(F66=\"Inconsequential\",0.5,E66)","v":0.05}]
["b)","Réseaux de distribution pour systèmes solaires et d'irrigation à énergie solaire",{"$nulls":5},{"$f":"E61/COUNTA(B63,B67)","v":0},{"$f":"I68+I69","v":0}]
["i)","Existe-t-il sur le marché des fournisseurs et/ou des distributeurs de systèmes de pompes à eau de marque mondiale ? ","• Liste des principaux systèmes et fournisseurs de pompes à eau ","Ebara","Yes","Inconsequential",null,{"$f":"H67/COUNTA(B68:B69)","v":0},{"$f":"(J68*H68)","v":0},{"$f":"(IF(E68=\"Yes\",(IF(F68=\"Inconsequential\",6,IF(F68=\"Slightly important\",5,IF(F68=\"Important\",4,IF(F68=\"Very important\",3,IF(F68=\"Critical\",2)))))),(IF(F68=\"Inconsequential\",3,IF(F68=\"Slightly important\",2,IF(F68=\"Important\",1,IF(F68=\"Very important\",1,IF(F68=\"Critical\",0))))))))/6","v":1}]
["ii)","Existe-t-il sur le marché des fournisseurs et/ou des distributeurs de systèmes photovoltaïques solaires de marque mondiale ? ","• Liste des principaux systèmes et fournisseurs de solaire PV ","Ebara","Yes","Inconsequential",null,{"$f":"H67/COUNTA(B68:B69)","v":0},{"$f":"(J69*H69)","v":0},{"$f":"(IF(E69=\"Yes\",(IF(F69=\"Inconsequential\",6,IF(F69=\"Slightly important\",5,IF(F69=\"Important\",4,IF(F69=\"Very important\",3,IF(F69=\"Critical\",2)))))),(IF(F69=\"Inconsequential\",3,IF(F69=\"Slightly important\",2,IF(F69=\"Important\",1,IF(F69=\"Very important\",1,IF(F69=\"Critical\",0))))))))/6","v":1}]
[]
[7,"Part de l'agriculture dans l'économie locale",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!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","Sources de données nationales",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Quelle est la proportion de la population active employée dans le secteur agricole ?","Banque mondiale - Indicateurs par pays en 2018 (données les plus récentes) - Emplois dans l'agriculture (% du total des emplois)",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)","Quelle est la proportion de la population rurale ?"," Banque mondiale - Population rurale (% de la population totale) en 2017",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)","Quelle est la part de la production agricole dans le PIB national ?","Banque mondiale - Indicateurs par pays en 2017  (données les plus récentes) - Agriculture, valeur ajoutée (% du PIB)\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)","Quelle est la proportion des terres agricoles par rapport à l'ensemble des terres ?","Banque mondiale - Indicateurs par pays en 2016 (données les plus récentes) - Terres agricoles (% du territoire)",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)","Quel pourcentage des terres cultivées est déjà irrigué ?","FAO, carte Aquastat - Part de la superficie cultivée irriguée (%)",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,"Droits d'utilisation des terres, propriété et régime foncier",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!D26","v":0},{"$f":"SUM(I83:I87)","v":0}]
[null,"Questions","Sources de données nationales",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Quelle proportion de la superficie totale des terres est constituée de terres autochtones et communautaires ?"," Landmark: Global platform of indigenous and community lands",null,0.6,"Inconsequential",null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":0},{"$f":"(J83*H83)","v":0},{"$f":"IF(F83=\"Inconsequential\",0.5,(1-E83))","v":0.5}]
[null,"Impact de la densité de population sur les SPIS","Sources de données sur la densité de population","Densité de population",null,null,null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":0},{"$f":"(J84*H84)","v":0},{"$f":"IF(E85=\"Positive\",(IF(F85=\"Inconsequential\",6,IF(F85=\"Slightly important\",5,IF(F85=\"Important\",4,IF(F85=\"Very important\",3,IF(F85=\"Critical\",2)))))),(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.66666666666666663}]
["b)","La densité de population a-t-elle un effet positif ou négatif sur le marché des SPIS ?","Index Mundi - Densité de population - Monde","<1","Positive","Important"]
[]
["c)","La densité de population a-t-elle un effet positif ou négatif sur la surface de terres agricoles disponibles ?",null,null,"Positive","Inconsequential",null,{"$f":"$E$81/COUNTA(B83,B85,B87)","v":0},{"$f":"(J87*H87)","v":0},{"$f":"IF(E87=\"Positive\",(IF(F87=\"Inconsequential\",6,IF(F87=\"Slightly important\",5,IF(F87=\"Important\",4,IF(F87=\"Very important\",3,IF(F87=\"Critical\",2)))))),(IF(F87=\"Inconsequential\",3,IF(F87=\"Slightly important\",2,IF(F87=\"Important\",1,IF(F87=\"Very important\",1,IF(F87=\"Critical\",0)))))))/6","v":1}]
[]
[]
[9,"Infrastructures de transport et de communication",null,null,"Score maximum possible","Score obtenu"]
[{"$nulls":4},{"$f":"'INTRANT_Facteurs de pondération'!F26","v":0},{"$f":"I93+I99","v":0}]
[null,"Questions","Sources de données nationales",null,"Réponse","Pertinence",null,"Pondération","Score obtenu","Score brut"]
["a)","Transport",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":0},{"$f":"I94+I95+I97+I98+I96","v":0}]
["i)","Quel est le score de qualité des infrastructures du transport aérien ?","Données sur la mobilité à travers le monde - Aperçu par pays \n",null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":0},{"$f":"(J94*H94)","v":0},{"$f":"(IF(F94=\"Inconsequential\",3.5,E94))/7","v":0.5}]
["ii)","Quel est le score de qualité des infrastructures portuaires ?",null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":0},{"$f":"(J95*H95)","v":0},{"$f":"(IF(F95=\"Inconsequential\",3.5,E95))/7","v":0.5}]
["iii)","Quel est le score de qualité des infrastructures du réseau routier ?",null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":0},{"$f":"(J96*H96)","v":0},{"$f":"(IF(F96=\"Inconsequential\",3.5,E96))/7","v":0.5}]
["iv)","Quel est le score de qualité des infrastructures du réseau ferroviaire ?",null,null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":0},{"$f":"(J97*H97)","v":0},{"$f":"(IF(F97=\"Inconsequential\",3.5,E97))/7","v":0.5}]
["v)","Quel est le niveau de l'indice de performance logistique global ?","Indice de performance logistique : Qualité de l'infrastructure commerciale et des transports (1=faible à 5=élevée)",null,null,"Inconsequential",null,{"$f":"H93/COUNTA(B94:B98)","v":0},{"$f":"(J98*H98)","v":0},{"$f":"(IF(F98=\"Inconsequential\",2.5,E98))/5","v":0.5}]
["b)","Communication",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":0},{"$f":"I100+I101+I102","v":0}]
["i)","Quel est le nombre d'abonnés à des services de téléphonie mobile cellulaire pour 100 habitants ?","International Telecommunications Union, global ICT Development Index (IDI) statistics",null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":0},{"$f":"(J100*H100)","v":0},{"$f":"(IF(F100=\"Inconsequential\",50,E100))/100","v":0.5}]
["i)","Quel est le nombre d'abonnements actifs au haut-débit mobile pour 100 habitants ? ",null,null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":0},{"$f":"(J101*H101)","v":0},{"$f":"(IF(F101=\"Inconsequential\",50,E101))/100","v":0.5}]
["iii)","Quel est l'indice de développement des TIC global  - IDI - en 2017?",null,null,null,"Inconsequential",null,{"$f":"H99/COUNTA(B100:B102)","v":0},{"$f":"(J102*H102)","v":0},{"$f":"(IF(F102=\"Inconsequential\",5,E102))/10","v":0.5}]
[]
[]
[null,null,"Vous disposez de sources de données plus actuelles? "]
[null,null,"MERCI DE NOUS LES COMMUNIQUER"]
[null,null," et de nous aider à améliorer cet outil."]
[null,null,"Nous apprécions votre coopération."]

{"sheet":"RÉSULTAT PRODUIT_Résultat","index":5,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,12],[6,1,6,12],[1,3,1,8],[3,2,3,3],[4,2,4,3],[3,6,3,7],[3,8,3,9],[4,6,4,7],[4,8,4,10],[8,1,8,4],[22,1,22,12],[8,7,8,12]]}
[]
[null,null,null,"RÉSULTAT PRODUIT - Résultats de l’analyse du marché  "]
[]
[null,"Pays :",{"$f":"'INTRANT_Vérification préliminai'!D6","v":" Angola"},null,null,null,"Date d'évaluation :",null,{"$f":"'INTRANT_Vérification préliminai'!D8","v":"00:00:00"}]
[null,"Zone spécifique concernée :",{"$f":"'INTRANT_Vérification préliminai'!D7","v":0},null,null,null,"Nom de l'évaluateur :",null,{"$f":"'INTRANT_Vérification préliminai'!D9","v":0}]
[]
[null,"A. Potentiel de marché pour SPIS : scores et pertinences"]
[]
[null,"Score total (%)",{"$nulls":5},"Aperçu des résultats de pertinence "]
{"$rows_empty":13}
[null,"B. Potentiel de marché pour SPIS : score global"]
[]
[]
[]
[{"$nulls":11},"Obstacle majeur à l'accès au marché"]
[{"$nulls":11},"Obstacle mineur à l'accès au marché"]
[{"$nulls":11},"Puissance de marché mineure"]
[{"$nulls":11},"Puissance de marché majeure"]
{"$rows_empty":21}
[null,"C. Potentiel de marché pour SPIS : score comparé  à la pondération"]

{"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":"'INTRANT_Paramètres géophysiques'!E6","v":0.13636363636363635},{"$f":"'INTRANT_Paramètres géophysiques'!F6","v":7.2727272727272724E-2},{"$f":"C4-D4","v":6.363636363636363E-2},{"$f":"100%-C4","v":0.86363636363636365},{"$f":"D4/C4","v":0.53333333333333333}]
[2,"Government interventions",{"$f":"'INTRANT_Environnement commercia'!E6","v":0.13636363636363635},{"$f":"'INTRANT_Environnement commercia'!F6","v":0.13636363636363635},{"$f":"C5-D5","v":0},{"$f":"100%-C5","v":0.86363636363636365},{"$f":"D5/C5","v":1}]
[3,"Development Organizations Interventions",{"$f":"'INTRANT_Environnement commercia'!E15","v":0.13636363636363635},{"$f":"'INTRANT_Environnement commercia'!F15","v":0.13636363636363635},{"$f":"C6-D6","v":0},{"$f":"100%-C6","v":0.86363636363636365},1]
[4,"Financing",{"$f":"'INTRANT_Environnement commercia'!E23","v":0.13636363636363635},{"$f":"'INTRANT_Environnement commercia'!F23","v":0.13636363636363635},0,0.86363636363636365,1]
[5,"Availability  and cost of alternative sources of power for pumping",{"$f":"'INTRANT_Environnement commercia'!E36","v":0.13636363636363635},{"$f":"'INTRANT_Environnement commercia'!F36","v":9.0909090909090898E-2},4.5454545454545456E-2,0.86363636363636365,0.66666666666666663]
[6,"Technical capacity for SPIS",{"$f":"'INTRANT_Environnement commercia'!E54","v":0.22727272727272727},{"$f":"'INTRANT_Environnement commercia'!F54","v":0.18939393939393939},3.7878787878787873E-2,0.77272727272727271,0.83333333333333337]
[7,"Awareness of solar PV and irrigation technologies ",{"$f":"'INTRANT_Environnement commercia'!E61","v":0},{"$f":"'INTRANT_Environnement commercia'!F61","v":0},0,1,{"$error":"#DIV/0!"}]
[8,"Significance of agriculture in the local economy",{"$f":"'INTRANT_Environnement commercia'!E72","v":9.0909090909090912E-2},{"$f":"'INTRANT_Environnement commercia'!F72","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[9,"Land use rights, ownership and tenure ",{"$f":"'INTRANT_Environnement commercia'!E81","v":0},{"$f":"'INTRANT_Environnement commercia'!F81","v":0},0,1,{"$error":"#DIV/0!"}]
[10,"Transportation and communication infrastructure ",{"$f":"'INTRANT_Environnement commercia'!E91","v":0},{"$f":"'INTRANT_Environnement commercia'!F91","v":0},0,1,{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C4:C13)","v":1},{"$f":"SUM(D4:D13)","v":0.80757575757575761},{"$f":"C14-D14","v":0.19242424242424239}]
[]
[]
[]
[]
[]
[]
[null,"GEOPHYSICAL Parameters "]
[null,null,"Doughnut","Pie"]
[null,"Red Zone",30,{"$f":"IF('INTRANT_Vérification préliminai'!T14=0,10, IF('INTRANT_Vérification préliminai'!T14=1,7, IF('INTRANT_Vérification préliminai'!T14=2,14, IF('INTRANT_Vérification préliminai'!T14=3,21, IF('INTRANT_Vérification préliminai'!T14=4,30, IF('INTRANT_Vérification préliminai'!T14=5,45, IF('INTRANT_Vérification préliminai'!T14=6,60, IF('INTRANT_Vérification préliminai'!T14=7,75, IF('INTRANT_Vérification préliminai'!T14=8,100,115)))))))))","v":75},"Value"]
[null,"Orange Zone",30,1,"Ticker"]
[null,"Yellow Zone",30,{"$f":"240-D23-D24","v":164},"Rest Value"]
[null,"Green Zone",30]
[null,"Hidden Zone",120]
[]
[]
[null,"Relevance","Business","Geophysical","Total"]
[null,"Inconsequential",{"$f":"(COUNTIF('INTRANT_Environnement commercia'!$F$8:$F$102,Calculations!B31))/44","v":0.86363636363636365},{"$f":"(COUNTIF('INTRANT_Paramètres géophysiques'!$F$8:$F$11,Calculations!B31))/44","v":6.8181818181818177E-2},{"$f":"SUM(C31:D31)","v":0.93181818181818188}]
[null,"Slightly important",{"$f":"(COUNTIF('INTRANT_Environnement commercia'!$F$8:$F$102,Calculations!B32))/44","v":0},{"$f":"(COUNTIF('INTRANT_Paramètres géophysiques'!$F$8:$F$11,Calculations!B32))/44","v":0},{"$f":"SUM(C32:D32)","v":0}]
[null,"Important",{"$f":"(COUNTIF('INTRANT_Environnement commercia'!$F$8:$F$102,Calculations!B33))/44","v":4.5454545454545456E-2},{"$f":"(COUNTIF('INTRANT_Paramètres géophysiques'!$F$8:$F$11,Calculations!B33))/44","v":2.2727272727272728E-2},{"$f":"SUM(C33:D33)","v":6.8181818181818177E-2}]
[null,"Very important",{"$f":"(COUNTIF('INTRANT_Environnement commercia'!$F$8:$F$102,Calculations!B34))/44","v":0},{"$f":"(COUNTIF('INTRANT_Paramètres géophysiques'!$F$8:$F$11,Calculations!B34))/44","v":0},{"$f":"SUM(C34:D34)","v":0}]
[null,"Critical",{"$f":"(COUNTIF('INTRANT_Environnement commercia'!$F$8:$F$102,Calculations!B35))/44","v":0},{"$f":"(COUNTIF('INTRANT_Paramètres géophysiques'!$F$8:$F$11,Calculations!B35))/44","v":0},{"$f":"SUM(C35:D35)","v":0}]
[null,null,{"$f":"SUM(C31:C35)","v":0.90909090909090906},{"$f":"SUM(D31:D35)","v":9.0909090909090912E-2},{"$f":"SUM(E31:E35)","v":1}]

{"sheet":"Feuille de Traduction","index":7,"n_rows":87,"n_cols":3,"rows_kept":87,"cut":false,"hidden":false,"merged":[[1,0,1,2],[4,0,4,4]]}
[]
["FEUILLE DE TRADUCTION"]
[]
["INTRODUCTION"]
["Certains textes utilisés dans cet outil sont utilisés dans des formules qui utilisent la reconnaissance de texte. Afin de préserver l'intégrité et la fonctionnalité de la formule, ces textes resteront en anglais. Une liste de ces textes et leur traduction correspondante est compilée ci-dessous : "]
["Texte original en anglais","Feuille","Traduction francaise"]
["1C to 30C","INPUT_Geophysical Parameters","De 1° C à 30° C "]
["Actually attained score","OUTPUT_Result","Score actuellement obtenu "]
["Additional Geophysical Parameters ","INPUT_Weight setting","Paramètres géophysiques complémentaires"]
["Additional Geophysical Parameters ","OUTPUT_Result","Paramètres géophysiques complémentaires"]
["Availability and Cost of Alternatives","INPUT_Weight setting","Disponibilité et coûts des énergies non solaires"]
["Availability and Cost of Alternatives","OUTPUT_Result","Disponibilité et coûts des énergies non solaires"]
["Awareness of Solar PV and Irrigation Tecnologies","INPUT_Weight setting","Sensibilisation au PV et aux technologies d'irrigation à énergie solaire"]
["Awareness of Solar PV and Irrigation Tecnologies","OUTPUT_Result","Sensibilisation au PV et aux technologies d'irrigation à énergie solaire"]
["Bare areas (sand dunes, gravel plains, etc)","INPUT_Pre-check","Zones dénudées (dunes de sable, plaines de gravier, etc.) "]
["Below 1C","INPUT_Geophysical Parameters","Inférieur à 1° C "]
["Beyond 100 m","INPUT_Geophysical Parameters","Sup. à 100 m "]
["Critical","various sheets","Critique"]
["Cropland irrigated or post-flooding","INPUT_Pre-check","Terres cultivées irriguées ou après inondation "]
["Cropland, rainfed","INPUT_Pre-check","Terres cultivées, pluviales "]
["Dense forest closed (tree cover above 40%)","INPUT_Pre-check","Forêt dense fermée (couvert forestier supérieur à 40 %) "]
["Development Organizations Interventions","INPUT_Weight setting","Action des organismes de développement"]
["Development Organizations Interventions","OUTPUT_Result","Action des organismes de développement"]
["Financing","INPUT_Weight setting","Financement"]
["Financing","OUTPUT_Result","Financement"]
["Flat","INPUT_Geophysical Parameters","Plane"]
["Flood plains brackish water","INPUT_Pre-check","Eaux saumâtres des plaines inondables "]
["Flood plains fresh water","INPUT_Pre-check","Plaines inondables eau douce "]
["Geophysical Parameters","OUTPUT_Result","Paramètres géophysiques"]
["Government Interventions","INPUT_Weight setting","Action gouvernementale"]
["Government Interventions","OUTPUT_Result","Action gouvernementale"]
["Grassland","INPUT_Pre-check","Pâturage"]
["High","INPUT_Business Conditions","Élevée"]
["High Income ($12.236 or more)","INPUT_Business Conditions","Revenu élevé ($ 12 236 ou plus)"]
["Highly Suitable","INPUT_Pre-check","Très apte"]
["Ignore","various sheets","Négligeable"]
["Important","various sheets","Importante"]
["Inconsequential","various sheets","Inconséquente"]
["Initial weight setting","OUTPUT_Result","Pondération initiale"]
["Land Tenure","INPUT_Weight setting","Régime foncier"]
["Land Tenure","OUTPUT_Result","Régime foncier"]
["Large Livestock","INPUT_Geophysical Parameters","Grand élevage"]
["Lichens and mosses","INPUT_Pre-check","Lichens et mousses"]
["Light forest open (tree cover up to 40%)","INPUT_Pre-check","Forêt claire ouverte (couvert forestier jusqu'à 40 %) "]
["Livestock and Crops","INPUT_Geophysical Parameters","Cultures et élevages"]
["Low","INPUT_Business Conditions","Faible"]
["Low income ($1,005 or less)","INPUT_Business Conditions","Bas revenu ($ 1 005 ou moins)"]
["Lower Middle Income ($1,006 to $3,955)","INPUT_Business Conditions","Revenu moyen inférieur  ($ 1 006 à $ 3 955) "]
["Marginally Suitable","INPUT_Pre-check","Peu apte"]
["Medium forest open to closed (tree cover above 40%)","INPUT_Pre-check","Forêt à densité moyenne (couverture arborée supérieure à 40%)"]
["Moderate","INPUT_Geophysical Parameters","Modérée"]
["Moderately Suitable","INPUT_Pre-check","Moyennement apte "]
["Mosaic crop land with natural vegetation","INPUT_Pre-check","Terres cultivées en mosaïque avec végétation naturelle "]
["Negative","INPUT_Business Conditions","Négatif"]
["No","various sheets","Non"]
["Not Suitable","INPUT_Pre-check","Non apte"]
["Perennial Crops","INPUT_Geophysical Parameters","Cultures vivaces "]
["Permanent snow and ice","INPUT_Pre-check","Neige et glace permanentes "]
["Positive","INPUT_Business Conditions","Positif"]
["Regular","INPUT_Business Conditions","Moyenne"]
["Seasonal and Perennial Crops","INPUT_Geophysical Parameters","Cultures saisonnières et vivaces "]
["Seasonal Crops","INPUT_Geophysical Parameters","Cultures saisonnières "]
["Semi arid sparse vegetation","INPUT_Pre-check","Végétation clairsemée semi-aride "]
["Shrubland","INPUT_Pre-check","Arbustes "]
["Significance of Agriculture to the Local Economy","INPUT_Weight setting","Part de l'agriculture dans l'économie locale"]
["Significance of Agriculture to the Local Economy","OUTPUT_Result","Part de l'agriculture dans l'économie locale"]
["Slightly important","various sheets","Peu importante "]
["Small Livestock","INPUT_Geophysical Parameters","Petit élevage"]
["SPIS Suitability","INPUT_Pre-check","Aptitude d'un SPIS"]
["Steep","INPUT_Geophysical Parameters","Escarpée"]
["Technical Capacity","INPUT_Weight setting","Capacité technique"]
["Technical Capacity","OUTPUT_Result","Capacité technique"]
["Transport and Communication Infrastructure","INPUT_Weight setting","Infrastructures de transport et de communication"]
["Transport and Communication Infrastructure","OUTPUT_Result","Infrastructures de transport et de communication"]
["Unknown","various sheets","Non renseigné "]
["Unknown","INPUT_Business Conditions","Non renseigné "]
["Up to 7 m ","INPUT_Geophysical Parameters","Jusqu’à 7m "]
["Upper Middle Income ($3,956 to $12,235)","INPUT_Business Conditions","Revenu moyen (de $ 3 956 à $ 12 235) "]
["Urban areas","INPUT_Pre-check","Zones urbaines"]
["Very High","INPUT_Business Conditions","Très élevée"]
["Very important","various sheets","Très importante"]
["Water bodies","INPUT_Pre-check","Plans d'eau"]
["Weight Setting","INPUT_Weight setting","Pondération"]
["Yes","various sheets","Oui"]
[]
["Critical Geophysical Parameters NOT IDEAL for SPIS","INPUT_Pre-check","Paramètres géophysiques critiques - NON IDÉAL pour les SPIS"]
["Proceed to INPUT_Weight Setting","INPUT_Pre-check","Se reporter à INTRANT – Facteurs de pondération"]

{"sheet":"Lists","index":8,"n_rows":200,"n_cols":7,"rows_kept":200,"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 to $12,235)","Flowserve"]
["Andorra","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"]
["Angola","GACSA (Global Alliance For Climate-Smart Agriculture)","ICBA","Lutheran World Relief","48.55 - 68.29",null,"Kirloskar Brothers Lt"]
["Anguilla","GIZ (Deutsche Gesellschaft für Internationale Zusammenarbeit GmbH)","ICBA (International Center for Biosaline Agriculture)","The Practica Foundation","68.30 - 84.33",null,"KSB"]
["Antigua & Barbuda","IFAD (International Fund for Agriculture Development)",null,null,"84.34 - 96.90",null,"Lorentz"]
["Argentina","JICA (Japan International Cooperation Agency)",null,null,"No data",null,"Ruhrpumpen Group"]
["Armenia","Nordic Development Fund",{"$nulls":4},"Suzler Ltd"]
["Australia","OECD (Organisation for Economic Co-operation and Development)",{"$nulls":4},"Weir Group"]
["Austria","OFID (OPEC Fund for International Development)",{"$nulls":4},"Wilo SE"]
["Azerbaijan","SIDA (Swedish International Development Cooperation Agency)",{"$nulls":4},"Xylem"]
["Bahamas","USAID"]
["Bahrain","World Bank Group"]
["Bangladesh","World Food Programme"]
["Barbados"]
["Belarus"]
["Belgium"]
["Belize"]
["Benin"]
["Bermuda"]
["Bhutan"]
["Bolivia"]
["Bosnia & Herzegovina"]
["Botswana"]
["Brazil"]
["Brunei Darussalam"]
["Bulgaria"]
["Burkina Faso"]
["Burundi"]
["Cambodia"]
["Cameroon"]
["Canada"]
["Cape Verde"]
["Cayman Islands"]
["Central African Republic"]
["Chad"]
["Chile"]
["China"]
["China - Hong Kong / Macau"]
["Colombia"]
["Comoros"]
["Congo"]
["Congo, Democratic Republic of (DRC)"]
["Costa Rica"]
["Croatia"]
["Cuba"]
["Cyprus"]
["Czech Republic"]
["Denmark"]
["Djibouti"]
["Dominica"]
["Dominican Republic"]
["Ecuador"]
["Egypt"]
["El Salvador"]
["Equatorial Guinea"]
["Eritrea"]
["Estonia"]
["Ethiopia"]
["Fiji"]
["Finland"]
["France"]
["French Guiana"]
["Gabon"]
["Gambia"]
["Georgia"]
["Germany"]
["Ghana"]
["Great Britain"]
["Greece"]
["Grenada"]
["Guadeloupe"]
["Guatemala"]
["Guinea"]
["Guinea-Bissau"]
["Guyana"]
["Haiti"]
["Honduras"]
["Hungary"]
["Iceland"]
["India"]
["Indonesia"]
["Iran"]
["Iraq"]
["Israel and the Occupied Territories"]
["Italy"]
["Ivory Coast (Cote d'Ivoire)"]
["Jamaica"]
["Japan"]
["Jordan"]
["Kazakhstan"]
["Kenya"]
["Korea, Democratic Republic of (North Korea)"]
["Korea, Republic of (South Korea)"]
["Kosovo"]
["Kuwait"]
["Kyrgyz Republic (Kyrgyzstan)"]
["Laos"]
["Latvia"]
["Lebanon"]
["Lesotho"]
["Liberia"]
["Libya"]
["Liechtenstein"]
["Lithuania"]
["Luxembourg"]
["Macedonia, Republic of"]
["Madagascar"]
["Malawi"]
["Malaysia"]
["Maldives"]
["Mali"]
["Malta"]
["Martinique"]
["Mauritania"]
["Mauritius"]
["Mayotte"]
["Mexico"]
["Moldova, Republic of"]
["Monaco"]
["Mongolia"]
["Montenegro"]
["Montserrat"]
["Morocco"]
["Mozambique"]
["Myanmar/Burma"]
["Namibia"]
["Nepal"]
["New Zealand"]
["Nicaragua"]
["Niger"]
["Nigeria"]
["Norway"]
["Oman"]
["Pacific Islands"]
["Pakistan"]
["Panama"]
["Papua New Guinea"]
["Paraguay"]
["Peru"]
["Philippines"]
["Poland"]
["Portugal"]
["Puerto Rico"]
["Qatar"]
["Reunion"]
["Romania"]
["Russian Federation"]
["Rwanda"]
["Saint Kitts and Nevis"]
["Saint Lucia"]
["Saint Vincent and the Grenadines"]
["Samoa"]
["Sao Tome and Principe"]
["Saudi Arabia"]
["Senegal"]
["Serbia"]
["Seychelles"]
["Sierra Leone"]
["Singapore"]
["Slovak Republic (Slovakia)"]
["Slovenia"]
["Solomon Islands"]
["Somalia"]
["South Africa"]
["South Sudan"]
["Spain"]
["Sri Lanka"]
["Sudan"]
["Suriname"]
["Swaziland"]
["Sweden"]
["Switzerland"]
["Syria"]
["Tajikistan"]
["Tanzania"]
["Thailand"]
["Netherlands"]
["Timor Leste"]
["Togo"]
["Trinidad & Tobago"]
["Tunisia"]
["Turkey"]
["Turkmenistan"]
["Turks & Caicos Islands"]
["Uganda"]
["Ukraine"]
["United Arab Emirates"]
["United States of America (USA)"]
["Uruguay"]
["Uzbekistan"]
["Venezuela"]
["Vietnam"]
["Virgin Islands (UK)"]
["Virgin Islands (US)"]
["Yemen"]
["Zambia"]
["Zimbabwe"]

{"sheet":"Lists 2","index":9,"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"]