{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["LÉEME","ENTRADA_Precontrol","ENTRADA_Adjuste de Valoración","ENTRADA_Parámetros Geofísicos","ENTRADA_Condiciones de Mercado","SALIDA_Resultados","Traducción","Calculations","Lists","Lists 2"],"not_rendered":{"charts":9,"images":51,"macros":0,"external_links":4,"defined_names":232,"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":"LÉEME","index":0,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Hoja Léeme"]
[]
[]
[]
[]
[null,null,"MERCADO - Herramienta de Evaluación de Mercado"]
[]
[null,null,"Introducción"]
[null,null,"Esta herramienta complementa el módulo MERCADO en la Caja de herramientas de SPIS. La herramienta sirve para determinar los parámetros geofísicos resaltados como hacer o deshacer. Si cualquiera de los parámetros obtiene un puntaje de 0, se considera que el área tiene muy poco potencial para SPIS. Un 'sí' de esta evaluación permite la consideración de otros parámetros."]
[]
[null,null,"Consejos & trucos"]
{"$rows_empty":12}
[null,null,"Sinopsis"]
[null,null,"Esta herramienta incluye las siguientes hojas:"]
[null,null,"Entrada_Precontrol: Permite un primer control de aptitud del SPIS para proceder con la evaluación detallada."]
[null,null,"Entrada_Adjuste de valoración: Proporciona una descripción de los parámetros y permite ajustar una valoración del impacto de las condiciones de mercado"]
[null,null,"Entrada_Parámetros Geofísicos: Para definir los parámetros geofísicos en el área de interés"]
[null,null,"Entrada_Condiciones de Mercado: Para definir los parámetros relevantes de negocio importantes para el área objetivo"]
[null,null,"Salida_Resultados: Muestra una descripción gráfica del potencial de mercado de SPIS en un área"]
[null,null,"Traducción: Traducción de términos claves usados en la herramienta"]
[null,null,"Acerca de"]
[null,null,"Publicado por: GIZ & FAO"]
[null,null,"Responsable: Proyecto de la GIZ Sustainable Energy for Food - Powering Agriculture\n                      Rebecca Navarro"]
[null,null,"Contacto: Powering.Agriculture@giz.de"]
[null,null,"Download link: https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,"Acerca de: Powering Agriculture: An Energy Grand Challenge for Development. Disponible en:  https://poweringag.org"]
[null,null,"Versión: 1.0 (Julio 2018)"]
[null,null,"La publicación de la Caja de herramientas de sistemas de riego solar ha sido posible gracias al apoyo brindado por la iniciativa mundial Powering Agriculture: An Energy Grand Challenge for Development (PAEGC) (Energización Rural: Un gran desafío energético para el desarrollo). En 2012, la Agencia de los Estados Unidos para el Desarrollo Internacional (USAID), la Agencia Sueca de Cooperación Internacional para el Desarrollo (Sida), el Ministerio Federal de Cooperación Económica y Desarrollo (BMZ) de Alemania, la empresa de energía Duke Energy Corporation y la Corporación de Inversiones Privadas en el Extranjero (OPIC) juntaron recursos para crear la iniciativa PAEGC. El objetivo de PAEGC es fomentar nuevos enfoques sostenibles con el fin de acelerar el desarrollo y asegurar el establecimiento de energías limpias que incrementen la productividad y/o el valor de la agricultura en países en desarrollo y regiones emergentes sin acceso a fuentes de energía confiables, asequibles y limpias."]
[null,null,"Las denominaciones empleadas y la presentación del material en este producto informativo no implican juicio alguno por parte de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, la Organización de las Naciones Unidas para la Alimentación y la Agricultura (FAO), o los socios fundadores de la iniciativa PAEGC, sobre la condición jurídica o el grado de desarrollo de ninguno de los países, territorios, ciudades o zonas citados o de sus autoridades, ni respecto de la delimitación de sus fronteras o límites. La mención de empresas o productos de fabricantes en particular, estén o no patentados, no implica que la GIZ, la FAO o alguno de los socios fundadores de la iniciativa PAEGC los aprueben o recomienden, dándoles preferencia sobre otros de naturaleza similar que no se mencionan. Las opiniones expresadas en este producto informativo son las de su(s) autor(es) o autora(s), y no reflejan necesariamente los puntos de vista o las políticas de la GIZ, la FAO o ninguno de los socios fundadores de la iniciativa PAEGC."]
[null,null,"La GIZ, la FAO y los socios fundadores de la iniciativa PAEGC fomentan la utilización, la reproducción y la difusión del material presentado en este producto informativo. A menos que se indique lo contrario, el material puede ser copiado, descargado e impreso con fines de estudio privado, enseñanza e investigación científica, o para su utilización en productos o servicios no comerciales, siempre que se otorgue a la GIZ y la FAO el debido reconocimiento como fuentes y como titulares de los derechos de autor."]
[null,null,"© GIZ y FAO, 2018"]

{"sheet":"ENTRADA_Precontrol","index":1,"n_rows":32,"n_cols":20,"rows_kept":32,"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],[15,2,15,7],[15,8,15,13],[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],[15,14,17,14],[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},"ENTRADA - Precontrol"]
[]
[]
[]
[null,"País:",null," Kenya"]
[null,"Área de interés:"]
[null,"Fecha de evaluación:"]
[null,"Nombre del evaluador/a:"]
[]
[1,"Parámetros Geofísicos",{"$nulls":12},"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":14},9,{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":9}]
[null,"Preguntas","Fuente de datos de muestra",{"$nulls":11},"Respuesta","Aptitud",null,"Parameter","Score","Raw Score"]
["a)",{"$f":"\"¿Cuál es la cobertura de terreno predominante en \"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es la cobertura de terreno predominante en  Kenya?"},"Cobertura global de terreno",{"$nulls":11},"Mosaic crop land with natural vegetation",{"$f":"VLOOKUP(O14,'Lists 2'!A:B,2,0)","v":"Highly Suitable"},null,"Land Cover",{"$f":"IF(P14=\"Highly Suitable\", \"3\", IF(P14=\"Moderately Suitable\", \"2\", IF(P14=\"Marginally Suitable\", \"1\", \"0\")))","v":"3"},{"$f":"IF(COUNTIF(S14:S17,0)=0,S14+S15+S16,0)","v":9}]
["b)",{"$f":"\"¿Cuál es la irradiación solar anual promedio en \"&ENTRADA_Precontrol!D6&\"? (kWh/kW pico - valor PVOUT)\"","v":"¿Cuál es la irradiación solar anual promedio en  Kenya? (kWh/kW pico - valor PVOUT)"},"\nMapa solar del Banco Mundial",{"$nulls":5},"Atlas global de IRENA para la energía renovable",{"$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":"\"¿Cuáles son los valores promedio mensuales de temperatura y precipitación en  \"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuáles son los valores promedio mensuales de temperatura y precipitación en   Kenya?"},"\n\nDatos precipitación del Banco Mundial",{"$nulls":5},"World Climate.com",{"$nulls":5},"Cantidad de meses áridos",{"$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,"E","F","M","A","M","J","J","A","S","O","N","D"]
[]
[null,"Temperatura promedio mensual (°C)",25,26,26,26,25,23,22,23,24,25,25,25,{"$f":"COUNTIF(C21:N21,\"Árido\")","v":7},null,null,"Tavg",{"$f":"AVERAGE(C19:N19)","v":24.583333333333332}]
[null,"Precipitación media mensual (mm)",30,26,60,130,90,37,30,30,28,57,90,50,null,null,null,"Pavg",{"$f":"AVERAGE(C20:N20)","v":54.833333333333336}]
[null,"Índice de Aridez",{"$f":"IF(C20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(D20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(E20<S20, \"Árido\", \"\")","v":""},{"$f":"IF(F20<S20, \"Árido\", \"\")","v":""},{"$f":"IF(G20<S20, \"Árido\", \"\")","v":""},{"$f":"IF(H20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(I20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(J20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(K20<S20, \"Árido\", \"\")","v":"Árido"},{"$f":"IF(L20<S20, \"Árido\", \"\")","v":""},{"$f":"IF(M20<S20, \"Árido\", \"\")","v":""},{"$f":"IF(N20<S20, \"Árido\", \"\")","v":"Árido"}]
[null,{"$f":"IF(P12=0,\"Parámetros geofísicos críticos NO IDEALES para SPIS\",\"Proceder a ENTRADA_Adjuste de Valoración\")","v":"Proceder a ENTRADA_Adjuste de Valoración"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"No recomendable"]
[{"$nulls":5},"Marginalmente apto"]
[{"$nulls":5},"Moderadamente apto"]
[{"$nulls":5},"Muy apto"]

{"sheet":"ENTRADA_Adjuste de Valoración","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,"ENTRADA - Adjuste de Valoración"]
[]
[]
[]
[null,"Parámetros Geofísicos:"]
[null,"Parámetros Geofísicos no críticos"]
[null,"Parámetros adicionales que son clave para la evaluación del mercado para SPIS. Estos no afectan la viabilidad general de SPIS; afectan el éxito de la adopción de SPIS en una región según las condiciones geofísicas prevalecientes (por ejemplo, nivel freático, presencia de heladas, topografía, sistema agrícola de producción agrícola, etc.)."]
[null,"Inconsequential"]
[null,{"$f":"H40","v":9.0909090909090912E-2}]
[]
[null,"Condiciónes de Negocio:"]
[null,"1. Intervenciones del gobierno",null,"2. Intervenciones de organizaciones de desarrollo",null,"3. Financiación"]
[null,"Evaluación de las intervenciones del gobierno como un parámetro del entorno empresarial para SPIS, analizando las políticas, normas y reglamentos que gobiernan los sectores del riego y la energía solar.",null,"Esta sección evalúa las intervenciones de las organizaciones de desarrollo que pueden influir de manera significativa en la adopción de SPIS dentro de un país o región.",null,"El parámetro analiza la capacidad de los usuarios finales para cubrir el alto costo de capital de SPIS, incluyendo el apoyo financiero del gobierno, las agencias de desarrollo y el sector privado."]
[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. Disponibilidad y Costo de Alternativas",null,"5. Capacidad Técnica",null,"6. Conocimiento de las Tecnologías SPIS"]
[null,"Considera la disponibilidad y el costo de las fuentes de energía competidoras para los sistemas de riego.",null,"Esta sección evalúa la capacidad del personal en el país para diseñar, implementar y mantener sistemas SPIS.",null,"Evalúa la conciencia general de las tecnologías solares en el país, como la iluminación solar y los sistemas de calefacción, y los sistemas de riego (bombas solares)."]
[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. Importancia de la Agricultura para la Economía Local",null,"8. Tenencia de la Tierra",null,"9. Infraestructura de transporte y comunicación"]
[null,"Esta sección evalúa la importancia del sector agrícola para la economía del área a evaluar, determinando su contribución al PIB y al empleo junto con la proporción de tierra cultivable utilizada para la agricultura.",null,"Este parámetro busca una comprensión de los derechos de tenencia de la tierra que pueden obstaculizar o promover la adopción de SPIS. Los derechos de tenencia no solo determinan la seguridad de la inversión, sino también pueden servir como garantía para los préstamos.",null,"Esta sección evalúa la disponibilidad de infraestructura y sistemas de comunicación, como carreteras y redes móviles, para habilitar las cadenas de suministro y facilitar el movimiento de personas y bienes."]
[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":"ENTRADA_Parámetros Geofísicos","index":3,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[11,1,11,5],[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]]}
[]
[null,null,"ENTRADA - Parámetros Geofísicos"]
[]
[]
[2,"Parámetros Geofísicos Adicionales",null,null,"Puntuación más alta posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!B10","v":9.0909090909090912E-2},{"$f":"SUM(I8:I11)","v":7.2727272727272738E-2}]
[null,"Preguntas","Fuente de datos de muestra",null,"Repuesta","Relevancia",null,"Weight","Attained Score","Raw Score"]
["a)",{"$f":"\"¿Cuál es el nivel freático promedio en\"&ENTRADA_Precontrol!D6&\" asignado por SPIS?\"","v":"¿Cuál es el nivel freático promedio en Kenya asignado por SPIS?"},"Profundidad estimada de los recursos de aguas subterráneas",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":"\"¿Cuál es la temperatura ambiente anual mínima de\"&ENTRADA_Precontrol!D6&\" en relación con la frecuencia de heladas?\"","v":"¿Cuál es la temperatura ambiente anual mínima de Kenya en relación con la frecuencia de heladas?"},"Datos de temperatura global del Banco Mundial",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":"\"¿Cómo se considera la topografía general de\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cómo se considera la topografía general de Kenya?"},"¿Cuál es la pendiente del área?",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":"\"¿Cuál es el principal tipo de producción en el sistema agrícola de\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es el principal tipo de producción en el sistema agrícola de Kenya?"},"Zonas agroecológicas globales","Mapas de Sistemas de Agricultura 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 %), \"¡Su puntuación está por debajo del 50% de sus valores iniciales para los parámetros geofísicos! Por favor revise su configuración de valoración!\", \"\")","v":""}]
[]
[null,null,"¿Conoce fuentes de datos más recientes?"]
[null,null,"POR FAVOR COMPARTA"]
[null,null,"y ayúdenos a mejorar nuestras herramientas."]
[null,null,"Gracias"]

{"sheet":"ENTRADA_Condiciones de Mercado","index":4,"n_rows":108,"n_cols":10,"rows_kept":108,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[63,2,63,3],[64,2,64,3],[65,2,65,3],[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],[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]]}
[]
[null,null,"ENTRADA - Condiciones de Mercado"]
[]
[]
[1,"Intervenciones Gubernamentales",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":" \"¿El gobierno de\" &ENTRADA_Precontrol!D6&\", las políticas y leyes nacionales y locales fomentan el uso de equipos de riego solar?\"","v":"¿El gobierno de Kenya, las políticas y leyes nacionales y locales fomentan el uso de equipos de riego solar?"},"• Políticas de riego y / o energía solar, leyes, planes de desarrollo del sector\n• Licencias de técnicos en energía solar, proveedores y / o empresas contratistas\n• Regulación fiscal del gobierno como exenciones de impuestos y aranceles","Políticas de desarrollo de energía limpia","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,"Políticas de apoyo a las energías renovables en los países en desarrollo: tabla 4, pág. 121"]
[null,null,null,"Documentos de política de países de Asia-Pacífico"]
["b)",{"$f":"\"¿Hay programas gubernamentales en\"&ENTRADA_Precontrol!D6&\" que fomenten el uso de dispositivos SPIS?\"","v":"¿Hay programas gubernamentales en Kenya que fomenten el uso de dispositivos SPIS?"},"• Programas de riego y energía solar apoyados por recursos del gobierno",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":"\"¿Existen ministerios y instituciones relevantes del gobierno de\"&ENTRADA_Precontrol!D6&\" que brinden apoyo al sector?\"","v":"¿Existen ministerios y instituciones relevantes del gobierno de Kenya que brinden apoyo al sector?"},"• Ministerios de agricultura y energía con participación en el sector SPIS\n• Organizaciones gubernamentales de riego, juntas, grupos\n• Organizaciones gubernamentales que brindan información relacionada con SPIS\n• Regulación y cumplimiento de normas gubernamentales de calidad y estándares","Regulaciones e incentivos de sistemas aislados","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,"Intervenciones de Organizaciones de Desarrollo",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"¿Existen en\"&ENTRADA_Precontrol!D6&\" programas nacionales ofrecidos por instituciones no gubernamentales que promuevan la adopción del riego?\"","v":"¿Existen en Kenya programas nacionales ofrecidos por instituciones no gubernamentales que promuevan la adopción del riego?"},"• Lista de posibles * agencias de desarrollo y organizaciones multilaterales:","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":"\"¿Existen en\"&ENTRADA_Precontrol!D6&\" programas nacionales ofrecidos por instituciones no gubernamentales que promuevan específicamente la adopción de dispositivos SPIS?\"","v":"¿Existen en Kenya programas nacionales ofrecidos por instituciones no gubernamentales que promuevan específicamente la adopción de dispositivos SPIS?"},"• Lista de posibles servicios y fondos:","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,"• Lista de posibles * centros de investigación y otras ONG:","AGRA"]
[null,null,"* La lista no es exhaustiva"]
[]
[3,"Financiación",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)","Capacidad financiera de los usuarios finales",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":3.0303030303030304E-2},{"$f":"I26+I27","v":1.5151515151515152E-2}]
["i)",{"$f":"\"¿Qué proporción de la población rural en \"&ENTRADA_Precontrol!D6&\" es pobre según el índice de pobreza multidimensional?\"","v":"¿Qué proporción de la población rural en  Kenya es pobre según el índice de pobreza multidimensional?"},"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":"\"¿Cuál es el valor del INB per cápita de \"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es el valor del INB per cápita de  Kenya?"}," INB per cápita, método Atlas (US $ a precios actuales, 2016)\n(Banco Mundial)",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)","Disponibilidad de apoyo de instituciones financieras",{"$nulls":5},{"$f":"E23/COUNTA(B25,B28,B33)","v":3.0303030303030304E-2},{"$f":"I29+I30+I32","v":1.5151515151515152E-2}]
["i)",{"$f":"\"¿Qué proporción de la población mayor de 15 años en\"&ENTRADA_Precontrol!D6&\" posee una cuenta financiera? \"","v":"¿Qué proporción de la población mayor de 15 años en Kenya posee una cuenta financiera? "},"i) Cuenta (% de más de 15 años) según el país\nii) Préstamo formal (% de más de 15 años) según el país","Datos de inclusión financiera\nBanco Mundial",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":"\"¿Cuál es la proporción de la población mayor de 15 años en\"&ENTRADA_Precontrol!D6&\" que pidió un préstamo de una institución financiera en el año dado *?\"","v":"¿Cuál es la proporción de la población mayor de 15 años en Kenya que pidió un préstamo de una institución financiera en el año dado *?"},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,"* año dado es el año más reciente de cual datos están disponibles"]
["iii)",{"$f":"\"¿Cuál es la facilidad en\"&ENTRADA_Precontrol!D6&\" para obtener clasificación de crédito??\"","v":"¿Cuál es la facilidad en Kenya para obtener clasificación de crédito??"},"Clasificación de crédito 2017\n(Banco Mundial)",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":"\"¿Hay algún incentivo económico del gobierno de\"&ENTRADA_Precontrol!D6&\" que afecte la adopción de dispositivos SPIS?\"","v":"¿Hay algún incentivo económico del gobierno de Kenya que afecte la adopción de dispositivos SPIS?"},"• Exenciones de impuestos gubernamentales, subsidios, reembolsos, créditos, etc. otorgados a clientes de productos SPIS, proveedores u otros intermediarios tales como financieros",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,"Disponibilidad y costo de alternativas fuentes de energía para el bombeo\n",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Muestra de fuentes de datos locales","Muestra de fuentes de datos nacionales","Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)","Disponibilidad de fuentes alternativas competitivas de energía",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I39+I40+I45","v":2.6515151515151516E-2}]
["i)",{"$f":"\"¿\"&ENTRADA_Precontrol!D6&\" tiene recursos de combustibles fósiles que explota?\"","v":"¿ Kenya tiene recursos de combustibles fósiles que explota?"},"Reservas nacionales de combustibles fósiles",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":"\"¿El área de interés está muy cerca (a menos de 5 km de un punto de acceso a la red) de la red o la tasa de electrificación rural de\"&ENTRADA_Precontrol!D6&\" es mayor al 80 %?\"","v":"¿El área de interés está muy cerca (a menos de 5 km de un punto de acceso a la red) de la red o la tasa de electrificación rural de Kenya es mayor al 80 %?"},"Red africana","Acceso a la electricidad, tasa de electrificación rural","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,"Red europea"]
[null,null,"Red estadounidense","Seguimiento de SDG 7 "]
[null,null,"Red australiana","Mapa de redes"]
[null,null,"Para una mayor precisión, utilice datos específicos del país"]
["iii)",{"$f":"\"¿Cuál es la frecuencia de caídas de corriente en el área de interés o en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es la frecuencia de caídas de corriente en el área de interés o en Kenya?"},"• Confiabilidad local del suministro de electricidad en el área de interés","Frecuencia de caídas de corriente","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)","Subsidios",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I47+I48","v":3.0303030303030304E-2}]
["i)",{"$f":"\"¿Existe un subsidio a la red en\"&ENTRADA_Precontrol!D6&\" o en el área de interés, incluyendo el costo de la electricidad y / o la tarifa de conexión a la red?\"","v":"¿Existe un subsidio a la red en Kenya o en el área de interés, incluyendo el costo de la electricidad y / o la tarifa de conexión a la red?"},"• Área de interés regulación de suministro de electricidad local","Subsidio nacional de electricidad","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":"\"¿Existe un subsidio al combustible en\"&ENTRADA_Precontrol!D6&\" o en el área de interés? \"","v":"¿Existe un subsidio al combustible en Kenya o en el área de interés? "},"• Área de interés regulación de suministro de combustible local","Subsidio nacional al combustible","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)","Comparación de costos",{"$nulls":5},{"$f":"E36/COUNTA(B38,B46,B49)","v":3.0303030303030304E-2},{"$f":"I50+I51","v":0}]
["i)",{"$f":"\"¿Cuál es la tarifa minorista de electricidad promedio en USD por kWh para todos los usuarios finales en\"&ENTRADA_Precontrol!D6&\" o en el área de interés?\"","v":"¿Cuál es la tarifa minorista de electricidad promedio en USD por kWh para todos los usuarios finales en Kenya o en el área de interés?"},"• Costo del suministro local de electricidad en USD por kWh en área de interés","Tarifa de electricidad minorista (promedio de todos los usuarios finales) en USD / kWh",null,"La referencia para una penalización mínima será de 1 USD / kWh, con la potencia más cara, redondeada al siguiente número entero (0,61)",null,{"$f":"H49/COUNTA(B50:B51)","v":1.5151515151515152E-2},{"$f":"H50*J50","v":0},{"$f":"E50","v":0}]
["ii)",{"$f":"\"¿Cuál es el precio promedio de venta al público de diésel en USD por litro en\"&ENTRADA_Precontrol!D6&\" o en el área de interés?\"","v":"¿Cuál es el precio promedio de venta al público de diésel en USD por litro en Kenya o en el área de interés?"},"• Costo promedio local de diesel en USD por litro en área de interés","Precios de diesel USD / litro",null,"La referencia para la multa mínima será de 3 USD / litro el precio de Islandia, con el diésel más caro, redondeado al siguiente número entero (2.03)",null,{"$f":"H49/COUNTA(B50:B51)","v":1.5151515151515152E-2},{"$f":"H51*J51","v":0},{"$f":"E51/3","v":0}]
[]
[5,"Capacidad técnica por SPIS",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos nacionales de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"¿Hay sesiones de capacitación sobre tecnologías y aplicaciones solares (Diseño, operación, mantenimiento y reparaciones) disponibles en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Hay sesiones de capacitación sobre tecnologías y aplicaciones solares (Diseño, operación, mantenimiento y reparaciones) disponibles en Kenya?"},{"$f":"\"• Cursos de sistemas y tecnologías solares en instituciones educativas en\" & ENTRADA_Precontrol!D6& \".\"","v":"• Cursos de sistemas y tecnologías solares en instituciones educativas en Kenya."},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":"\"¿Los técnicos de energía solar en\"&ENTRADA_Precontrol!D6&\" tienen licencia para llevar a cabo su trabajo por parte del gobierno?\"","v":"¿Los técnicos de energía solar en Kenya tienen licencia para llevar a cabo su trabajo por parte del gobierno?"},"• Reglamento gubernamental sobre licencias de técnicos de energía solar.",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)","¿La tecnología solar forma parte del currículo en cursos o programas agrícolas en instituciones de capacitación agrícola?",{"$f":"\"• Cursos de sistemas y tecnologías solares en instituciones educativas en\" & ENTRADA_Precontrol!D6& \".\"","v":"• Cursos de sistemas y tecnologías solares en instituciones educativas en Kenya."},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,"Conocimiento de tecnologías de SPIS y de riego",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos nacionales de muestra",null,"Repuesta","Relevancia",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":"\"¿Ha habido un aumento cumulativo en la capacidad instalada de energía solar entre los años 2012 - 2016 en\" &ENTRADA_Precontrol!D6&\"?\"","v":"¿Ha habido un aumento cumulativo en la capacidad instalada de energía solar entre los años 2012 - 2016 en Kenya?"},"IRENA Renewable Energy Capacity Statistics \nPg 21 ",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":"\"¿Hay un aumento general en la energía solar adicional neta anual instalada entre los años 2012 - 2016 en \" &ENTRADA_Precontrol!D6&\"?\"","v":"¿Hay un aumento general en la energía solar adicional neta anual instalada entre los años 2012 - 2016 en  Kenya?"},"IRENA dashboard: Trends in Renewable Energy",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)","¿Cuál es la proporción de energía solar de la capacidad total de energía instalada?","Nivel de detalle: i) y iii) acumulativo, ii) Adiciones netas\nFlujo: capacidad instalada\nConexión a la red: i) y ii) Red sin conexión, iii) Todos\nTecnología: i) y ii) Solar, iii) Todo\nSub Tecnología: i) y ii) Solar Fotovoltaica, iii) Todo\nAño: i) y ii) (valores múltiples), iii) 2016",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)","Redes de distribución para sistemas solares y de riego",{"$nulls":5},{"$f":"E61/COUNTA(B63,B67)","v":4.5454545454545456E-2},{"$f":"I68+I69","v":2.2727272727272728E-2}]
["i)",{"$f":"\"¿Existen proveedores y / o distribuidores de productos de bombeo de agua de fabricantes internacionales en el mercado de\"&ENTRADA_Precontrol!D6&\"? \"","v":"¿Existen proveedores y / o distribuidores de productos de bombeo de agua de fabricantes internacionales en el mercado de Kenya? "},"• Lista de los principales productos y proveedores de bombas de agua","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":"\"¿Existen proveedores y / o distribuidores de sistemas solares de fabricantes globales en el mercado de\"&ENTRADA_Precontrol!D6&\"? \"","v":"¿Existen proveedores y / o distribuidores de sistemas solares de fabricantes globales en el mercado de Kenya? "},"• Lista de los principales productos y proveedores de energía solar fotovoltaica","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,"Importancia de la agricultura para la economía local",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!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,"Preguntas","Fuentes de datos nacionales de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"¿Qué proporción de la población empleada en\"&ENTRADA_Precontrol!D6& \" trabaja en el sector agrícola?\"","v":"¿Qué proporción de la población empleada en Kenya trabaja en el sector agrícola?"},"Empleo en Agricultura\n (% del empleo total, indicadores por país en 2017, año más reciente) (Banco Mundial)",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":"\"¿Qué proporción de la población es rural?\"","v":"¿Qué proporción de la población es rural?"},"Población rural\n (% de la población total en 2016) \n(Banco Mundial)",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":"\"¿Qué proporción del PIB de\"&ENTRADA_Precontrol!D6& \" es de origen agrícola? \"","v":"¿Qué proporción del PIB de Kenya es de origen agrícola? "},"Agricultura, valor agregado \n(% del PIB, Indicadores por país en 2016, año más reciente)\n(Banco Mundial)",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":"\"¿Qué proporción de la tierra total de\"&ENTRADA_Precontrol!D6&\" es tierra agrícola?\"","v":"¿Qué proporción de la tierra total de Kenya es tierra agrícola?"},"  Tierra agrícola \n(% del área de tierra, Indicadores por país en 2015, año más reciente)\n(Banco Mundial)",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":"\"¿Qué porcentaje de las tierras cultivadas en\"&ENTRADA_Precontrol!D6&\" es de regadío?\"","v":"¿Qué porcentaje de las tierras cultivadas en Kenya es de regadío?"},"Área cultivada en regadío\n (% del área total cultivada)\n(FAO, mapa Aquastat)",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,"Derechos de uso del suelo, propiedad y tenencia",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!D26","v":9.0909090909090912E-2},{"$f":"SUM(I83:I87)","v":4.5454545454545456E-2}]
[null,"Preguntas","Fuentes de datos nacionales de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)",{"$f":"\"¿Qué proporción de la superficie total de\" &ENTRADA_Precontrol!D6&\" es de tierras indígenas y comunitarias?\"","v":"¿Qué proporción de la superficie total de Kenya es de tierras indígenas y comunitarias?"},"Punto de referencia: plataforma global de tierras indígenas y comunitarias",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,"Impacto de la densidad de población en SPIS","Fuentes de datos para densidad de población","Densidad de población",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)","¿La densidad de población afecta positivamente o negativamente el mercado para SPIS?","Datos de densidad de población del Banco Mundial a nivel de país","<1","Unknown","Inconsequential"]
[null,null,"Distribución de población mundial a nivel regional"]
["c)","¿Tiene la densidad de población un efecto positivo o negativo en la disponibilidad de tierras de uso agrícola?",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,"Datos de Densidad de Población Mundial"]
[]
[9,"Infraestructura de transporte y comunicación",null,null,"Puntuación máx. posible","Puntuación alcanzada"]
[{"$nulls":4},{"$f":"'ENTRADA_Adjuste de Valoración'!F26","v":9.0909090909090912E-2},{"$f":"I93+I99","v":4.5454545454545456E-2}]
[null,"Preguntas","Fuentes de datos nacionales de muestra",null,"Respuesta","Relevancia",null,"Weight","Attained score","Raw Score"]
["a)","Transporte",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":4.5454545454545456E-2},{"$f":"I94+I95+I97+I98+I96","v":2.2727272727272728E-2}]
["i)",{"$f":"\"¿Cómo es la calidad de la infraestructura del transporte aéreo en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cómo es la calidad de la infraestructura del transporte aéreo en Kenya?"},"Datos de movilidad global \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":"\"¿Cómo es la calidad de la infraestructura portuaria en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cómo es la calidad de la infraestructura portuaria en Kenya?"},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":"\"¿Cómo es la calidad de las autovías en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cómo es la calidad de las autovías en Kenya?"},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":"\"¿Cómo es la calidad de la infraestructura ferroviaria en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cómo es la calidad de la infraestructura ferroviaria en Kenya?"},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":"\"¿Qué puntuación alcanza el índice de rendimiento logístico de\"&ENTRADA_Precontrol!D6&\" en 2016?\"","v":"¿Qué puntuación alcanza el índice de rendimiento logístico de Kenya en 2016?"},"Índice de rendimiento logístico: calidad del comercio y la infraestructura relacionada con el transporte (1 = bajo a 5 = alto)",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)","Comunicación",{"$nulls":5},{"$f":"E91/COUNTA(B93,B99)","v":4.5454545454545456E-2},{"$f":"I100+I101+I102","v":2.2727272727272728E-2}]
["i)",{"$f":"\"¿Cuál es el número de suscripciones de telefonía móvil por cada 100 habitantes en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es el número de suscripciones de telefonía móvil por cada 100 habitantes en Kenya?"},"Unión Internacional de Telecomunicaciones, estadísticas globales del ICT Development Index (IDI)",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":"\"¿Cuál es el número de suscripciones activas de banda ancha móvil por cada 100 habitantes en\"&ENTRADA_Precontrol!D6&\"?\"","v":"¿Cuál es el número de suscripciones activas de banda ancha móvil por cada 100 habitantes en Kenya?"},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":"\"¿Cuál es el valor general del Índice de Desarrollo ICT Development Index (IDI) en\"&ENTRADA_Precontrol!D6&\" en 2017?\"","v":"¿Cuál es el valor general del Índice de Desarrollo ICT Development Index (IDI) en Kenya en 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,"¿Conoce fuentes de datos más recientes?"]
[null,null,"POR FAVOR COMPARTA"]
[null,null,"y ayúdenos a mejorar nuestras herramientas."]
[null,null,"Gracias"]

{"sheet":"SALIDA_Resultados","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,"SALIDA - Resultados"]
[]
[null,"País:",{"$f":"ENTRADA_Precontrol!D6","v":" Kenya"},null,null,null,"Fecha de evaluación:","Fecha de evaluación:",{"$f":"ENTRADA_Precontrol!D8","v":"00:00:00"}]
[null,"Área de interés:",{"$f":"ENTRADA_Precontrol!D7","v":0},null,null,null,"Nombre del evaluador/a:","Nombre del evaluador:",{"$f":"ENTRADA_Precontrol!D9","v":0}]
[null,"Puntuación total (%)",{"$nulls":5},"Resumen de las Calificaciones de Relevancia"]
{"$rows_empty":12}
[null,"B. Potencial de Mercado para SPIS: Puntuación General"]
{"$rows_empty":9}
[null,"Potencial de Mercado Bajo"]
[null,"Potencial de Mercado Insignificante"]
[null,"Potencial de Mercado Moderado"]
[null,"Potencial de Mercado Alto"]

{"sheet":"Traducción","index":6,"n_rows":87,"n_cols":10,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,"English",null,null,null,"Français",null,null,null,"Español"]
[]
[{"$nulls":9},"Hoja: ENTRADA_Pre-Verificación"]
[null,"Cropland, rainfed",{"$nulls":7},"Tierras de cultivo, secano"]
[null,"Cropland irrigated or post-flooding",{"$nulls":7},"Tierras de cultivo irrigadas o posteriores a las inundaciones"]
[null,"Mosaic crop land with natural vegetation",{"$nulls":7},"Tierra de cultivos de mosaico con vegetación natural"]
[null,"Light forest (tree cover up to 40%)",{"$nulls":7},"Bosque claro (cobertura de árboles hasta 40%)"]
[null,"Dense forest (tree cover above 40%)",{"$nulls":7},"Bosque denso (cobertura arbórea superior al 40%)"]
[null,"Shrubland",{"$nulls":7},"Matorral"]
[null,"Grassland",{"$nulls":7},"Pradera"]
[null,"Lichens and mosses",{"$nulls":7},"Líquenes y musgos"]
[null,"Semi arid sparse vegetation",{"$nulls":7},"Vegetación escasa semi árida"]
[null,"Flood plains fresh water",{"$nulls":7},"Inundaciones, llanuras, agua dulce"]
[null,"Flood plains brackish water",{"$nulls":7},"Inundaciones, llanuras, agua salobre"]
[null,"Urban areas",{"$nulls":7},"Áreas urbanas"]
[null,"Bare areas",{"$nulls":7},"Zonas desnudas"]
[null,"Water bodies",{"$nulls":7},"Cuerpos de agua"]
[null,"Permanent snow and ice",{"$nulls":7},"Nieve permanente y hielo"]
[]
[null,"Not Suitable",{"$nulls":7},"No adecuado"]
[null,"Marginally Suitable",{"$nulls":7},"Marginalmente adecuado"]
[null,"Moderately Suitable",{"$nulls":7},"Moderadamente adecuado"]
[null,"Highly Suitable",{"$nulls":7},"Muy adecuado"]
[]
[]
[]
[{"$nulls":9},"Hoja: ENTRADA_ Adjuste de Valoración"]
[]
[null,"Inconsequential",{"$nulls":7},"Inconsecuente"]
[null,"Slightly important",{"$nulls":7},"Ligeramente importante"]
[null,"Important",{"$nulls":7},"Importante"]
[null,"Very important",{"$nulls":7},"Muy importante"]
[null,"Critical",{"$nulls":7},"Crítico"]
[]
[{"$nulls":9},"Hoja: ENTRADA_Parámetros geofísicos"]
[]
[null,"Beyond",{"$nulls":7},"Encima"]
[null,"Unknown",{"$nulls":7},"Desconocido"]
[null,"Below",{"$nulls":7},"Abajo"]
[]
[null,"Steep",{"$nulls":7},"Empinado"]
[null,"Moderate ",{"$nulls":7},"Moderado"]
[null,"Flat",{"$nulls":7},"Plano"]
[]
[null,"Seasonal Crops",{"$nulls":7},"Cultivos estacionales"]
[null,"Perennial Crops",{"$nulls":7},"Cultivos perennes"]
[null,"Small Livestock",{"$nulls":7},"Pequeño ganado"]
[null,"Large Livestock",{"$nulls":7},"Ganado grande"]
[null,"Seasonal and Perennial Crops",{"$nulls":7},"Cultivos estacionales y perennes"]
[null,"Livestock and crops",{"$nulls":7},"Ganadería y cultivos"]
[]
[]
[{"$nulls":9},"Hoja: Condiciones de Negocio"]
[]
[null,"Yes",{"$nulls":7},"Sí"]
[null,"No ",{"$nulls":7},"No"]
[null,"Unknown",{"$nulls":7},"Desconocido"]
[]
[null,"Inconsequential",{"$nulls":7},"Inconsecuente"]
[null,"Slightly important",{"$nulls":7},"Ligeramente importante"]
[null,"Important",{"$nulls":7},"Importante"]
[null,"Very important",{"$nulls":7},"Muy importante"]
[null,"Critical",{"$nulls":7},"Crítico"]
[]
[null,"Low income",{"$nulls":7},"Ingreso bajo"]
[null,"Lower Middle Income",{"$nulls":7},"Ingreso Medio Inferior"]
[null,"Upper Middle Income",{"$nulls":7},"Ingreso medio alto"]
[null,"High Income",{"$nulls":7},"Altos ingresos"]
[null,"Less",{"$nulls":7},"Menos"]
[null,"More",{"$nulls":7},"Más"]
[]
[null,"Low",{"$nulls":7},"Bajo"]
[null,"Regular ",{"$nulls":7},"Regular"]
[null,"High ",{"$nulls":7},"Alto"]
[null,"Very high",{"$nulls":7},"Muy alto"]
{"$rows_empty":8}
[{"$nulls":9},"Hoja: SALIDA_Resultados"]
[]
[null,"Initial weight setting",{"$nulls":7},"Ajuste de peso inicial"]
[null,"Actually attained score",{"$nulls":7},"Puntuación realmente lograda"]

{"sheet":"Calculations","index":7,"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":"'ENTRADA_Parámetros Geofísicos'!E6","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Parámetros Geofísicos'!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":"'ENTRADA_Condiciones de Mercado'!E6","v":0.18181818181818182},{"$f":"'ENTRADA_Condiciones de Mercado'!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":"'ENTRADA_Condiciones de Mercado'!E15","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F15","v":9.0909090909090912E-2},{"$f":"C6-D6","v":0},{"$f":"100%-C6","v":0.90909090909090906},1]
[4,"Financing",{"$f":"'ENTRADA_Condiciones de Mercado'!E23","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F23","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[5,"Availability  and cost of alternative sources of power for pumping",{"$f":"'ENTRADA_Condiciones de Mercado'!E36","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F36","v":5.6818181818181823E-2},3.4090909090909088E-2,0.90909090909090906,0.625]
[6,"Technical capacity for SPIS",{"$f":"'ENTRADA_Condiciones de Mercado'!E54","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F54","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[7,"Awareness of solar PV and irrigation technologies ",{"$f":"'ENTRADA_Condiciones de Mercado'!E61","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F61","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[8,"Significance of agriculture in the local economy",{"$f":"'ENTRADA_Condiciones de Mercado'!E72","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F72","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[9,"Land use rights, ownership and tenure ",{"$f":"'ENTRADA_Condiciones de Mercado'!E81","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!F81","v":4.5454545454545456E-2},4.5454545454545456E-2,0.90909090909090906,0.5]
[10,"Transportation and communication infrastructure ",{"$f":"'ENTRADA_Condiciones de Mercado'!E91","v":9.0909090909090912E-2},{"$f":"'ENTRADA_Condiciones de Mercado'!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(ENTRADA_Precontrol!T14=0,10, IF(ENTRADA_Precontrol!T14=1,7, IF(ENTRADA_Precontrol!T14=2,14, IF(ENTRADA_Precontrol!T14=3,21, IF(ENTRADA_Precontrol!T14=4,30, IF(ENTRADA_Precontrol!T14=5,45, IF(ENTRADA_Precontrol!T14=6,60, IF(ENTRADA_Precontrol!T14=7,75, IF(ENTRADA_Precontrol!T14=8,100,115)))))))))","v":115},"Value"]
[null,"Orange Zone",30,1,"Ticker"]
[null,"Yellow Zone",30,{"$f":"240-D23-D24","v":124},"Rest Value"]
[null,"Green Zone",30]
[null,"Hidden Zone",120]
[]
[]
[null,"Relevance","Business","Geophysical","Total"]
[null,"Inconsequential",{"$f":"(COUNTIF('ENTRADA_Condiciones de Mercado'!$F$8:$F$102,Calculations!B31))/44","v":0.84090909090909094},{"$f":"(COUNTIF('ENTRADA_Parámetros Geofísicos'!$F$8:$F$11,Calculations!B31))/44","v":9.0909090909090912E-2},{"$f":"SUM(C31:D31)","v":0.93181818181818188}]
[null,"Slightly important",{"$f":"(COUNTIF('ENTRADA_Condiciones de Mercado'!$F$8:$F$102,Calculations!B32))/44","v":0},{"$f":"(COUNTIF('ENTRADA_Parámetros Geofísicos'!$F$8:$F$11,Calculations!B32))/44","v":0},{"$f":"SUM(C32:D32)","v":0}]
[null,"Important",{"$f":"(COUNTIF('ENTRADA_Condiciones de Mercado'!$F$8:$F$102,Calculations!B33))/44","v":2.2727272727272728E-2},{"$f":"(COUNTIF('ENTRADA_Parámetros Geofísicos'!$F$8:$F$11,Calculations!B33))/44","v":0},{"$f":"SUM(C33:D33)","v":2.2727272727272728E-2}]
[null,"Very important",{"$f":"(COUNTIF('ENTRADA_Condiciones de Mercado'!$F$8:$F$102,Calculations!B34))/44","v":0},{"$f":"(COUNTIF('ENTRADA_Parámetros Geofísicos'!$F$8:$F$11,Calculations!B34))/44","v":0},{"$f":"SUM(C34:D34)","v":0}]
[null,"Critical",{"$f":"(COUNTIF('ENTRADA_Condiciones de Mercado'!$F$8:$F$102,Calculations!B35))/44","v":4.5454545454545456E-2},{"$f":"(COUNTIF('ENTRADA_Parámetros Geofísicos'!$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":8,"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":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 (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"]
["Dense forest (tree cover above 40%)","Moderately Suitable",null,null," Andorra",{"$nulls":4},"Beyond 100m",null,"Mixed various",null,null,null,"250 - 1000"]
["Shrubland","Marginally Suitable",null,null," Angola",{"$nulls":4},"Unknown",{"$nulls":5},">1000"]
["Grassland","Moderately Suitable",null,null," Anguilla"]
["Lichens and mosses","Marginally Suitable",null,null," Antarctica"]
["Semi arid sparse vegetation","Marginally Suitable",null,null," Antigua and Barbuda"]
["Flood plains fresh water","Marginally Suitable",null,null," Argentina"]
["Flood plains brackish water","Not Suitable",null,null," Armenia"]
["Urban areas","Not Suitable",null,null," Aruba"]
["Bare areas","Marginally Suitable",null,null," Australia"]
["Water bodies","Not Suitable",null,null," Austria"]
["Permanent snow and ice","Not Suitable",null,null," Azerbaijan"]
[{"$nulls":4}," 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"]