{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["READ ME","1. Financing models","Translate","How does it work"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":33,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"READ ME","index":0,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[[10,3,10,5],[10,6,10,8],[42,3,44,4],[36,3,37,9],[39,3,39,9],[38,3,38,9],[42,5,43,9],[12,3,12,9],[17,3,17,9],[19,3,19,9],[32,6,33,9],[29,3,29,9],[20,3,22,9],[24,3,24,9],[32,3,33,5],[26,3,27,9],[52,3,70,9],[45,5,45,7],[45,3,45,4],[30,3,30,9],[41,5,41,9],[94,3,94,5],[40,3,40,9],[86,3,92,9],[72,3,84,9],[49,5,49,7],[47,3,49,4],[41,3,41,4],[50,3,50,4],[46,3,46,4],[46,5,46,9],[50,5,50,7],[47,5,48,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$17","v":"Select language"},null,null,"English"]
[]
[null,null,null,{"$f":"Translate!$C$18","v":"Read Me Sheet"}]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$19","v":"FINANCE – Finance Deployment Tools"}]
[]
[null,null,null,{"$f":"Translate!$C$20","v":"Introduction"}]
[null,null,null,{"$f":"Translate!$C$21","v":"This tool serves to identify the most suitable financial products available on the market for the use of an SPIS."}]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$22","v":"Tips & Tricks"}]
[]
[null,null,null,{"$f":"Translate!$C$23","v":"● This tool comprises dropdown lists: choose among the answers YES, NO and N/A\n● For the multilanguage option to work properly, do NOT delete sheets\n● Make sure that this file is always saved as \".xlsm\""}]
[]
[]
[null,null,null,{"$f":"Translate!$C$24","v":"Overview"}]
[null,null,null,{"$f":"Translate!$C$25","v":"This tool comprises the following sheet:"}]
[]
[null,null,null,{"$f":"Translate!$C$8","v":"1. Financing models"},null,null,{"$f":"Translate!C26","v":"identify a suitable financing option as per your prevailing circumstances"}]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$27","v":"This tool is based on the FAO Training Manual no. 3: Irrigation Water Management: Irrigation Water Needs, available at: "}]
[]
[null,null,null,"http://www.fao.org/docrep/s2022e/s2022e07.htm"]
[]
[null,null,null,{"$f":"Translate!$C$28","v":"About"}]
[null,null,null,{"$f":"Translate!$C$29","v":"Published by: "},null,{"$f":"Translate!$C$35","v":"GIZ & FAO"}]
[null,null,null,{"$f":"Translate!$C$30","v":"Responsible:"},null,{"$f":"Translate!$C$36","v":"GIZ project \"Water and Energy for Food (WE4F)\""}]
[]
[null,null,null,null,null,"Johannes Muntau"]
[null,null,null,{"$f":"Translate!$C$31","v":"Contact:"},null,"we4f@giz.de"]
[null,null,null,{"$f":"Translate!$C$32","v":"Download link:"},null,"https://energypedia.info/wiki/Toolbox_on_SPIS"]
[null,null,null,{"$f":"Translate!$C$33","v":"About:"},null,{"$f":"Translate!$C$37","v":"Water and Energy for Food Grand Challenge at:  "}]
[]
[null,null,null,null,null,"https://we4f.org/"]
[null,null,null,{"$f":"Translate!$C$34","v":"Version:"},null,{"$f":"Translate!$C$38","v":"3.0 (June 2021)"}]
[]
[null,null,null,{"$f":"Translate!$C$39","v":"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$40","v":"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$41","v":"GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given."}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"Translate!$C$42","v":"© GIZ and FAO, 2020"}]

{"sheet":"1. Financing models","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,13,10],[11,11,13,13],[7,8,9,10],[7,11,9,13],[21,1,21,5],[20,1,20,5],[18,8,20,10],[2,1,2,5],[4,1,4,5],[11,1,11,5],[12,1,12,5],[15,1,15,5],[6,1,6,5],[14,1,14,5],[13,1,13,5],[8,1,8,5],[1,1,1,8],[0,0,0,13],[9,1,9,5],[10,1,10,5],[19,1,19,5],[18,1,18,5],[17,1,17,5],[3,1,3,5],[5,1,5,5],[7,1,7,5],[16,1,16,5],[15,8,16,10],[15,11,16,13],[2,8,2,13],[3,8,5,10],[3,11,5,13]]}
[{"$f":"Translate!$C$44","v":"FINANCE-Finance Deployment Tool"}]
[null,{"$f":"Translate!$C$45","v":"Answer the following questions (1-19) choosing among YES, NO or N/A on the drop down menu. On the right side of the excel sheet the financial products most suitable for your needs will compare."}]
["1)",{"$f":"Translate!$C46","v":"Do you possess any collateral?"},null,null,null,null,"Yes",null,{"$f":"Translate!$C$65","v":"Possible financing options:"}]
["2)",{"$f":"Translate!$C47","v":"Do you possess any soft collateral?"},null,null,null,null,"Yes",null,{"$f":"Translate!$C$66","v":"COMMERCIAL BANK LOAN\nis a loan from a financial institution whose main occupations consist in giving loans and taking deposits "},null,null,{"$f":"Translate!$C$67","v":"DEVELOPMENT BANK LOAN\nis a loan from financial institutions which provides financial services  to actors involved in the food value chain"}]
["3)",{"$f":"Translate!$C48","v":"Do you have access to alternative sources of income?"},null,null,null,null,"Yes"]
["4)",{"$f":"Translate!$C49","v":"Can other people/companies guarantee for you?"},null,null,null,null,"Yes"]
["5)",{"$f":"Translate!$C50","v":"Do you possess a bank account?"},null,null,null,null,"Yes"]
["6)",{"$f":"Translate!$C51","v":"Do you possess a mobile device with access to the internet?"},null,null,null,null,"Yes",null,{"$f":"Translate!$C$68","v":"MFIs\nare organizations, which provide financial inclusion to the poor strata of the population"},null,null,{"$f":"Translate!$C$69","v":"VALUE-CHAIN LOAN\nis a loan in-between the value chain actors"}]
["7)",{"$f":"Translate!$C52","v":"Are you able to pay a commercial interest rate?"},null,null,null,null,"Yes"]
["8)",{"$f":"Translate!$C53","v":"Do you possess starting capital?"},null,null,null,null,"Yes"]
["9)",{"$f":"Translate!$C54","v":"Does your government subsidize your farm activity?"},null,null,null,null,"Yes"]
["10)",{"$f":"Translate!$C55","v":"Do you work in an established value chain with downstream and upstream players?"},null,null,null,null,"Yes",null,{"$f":"Translate!$C$70","v":"LEASING\nis a financial instrument which allows the use of an equipment without the need to purchase it"},null,null,{"$f":"Translate!$C$71","v":"COOPERATIVES\nare institutions that bring farmers together enabling them financial and economic advantages"}]
["11)",{"$f":"Translate!$C56","v":"Is the private sector interested in your products (i.e. for export reasons)?"},null,null,null,null,"Yes"]
["12)",{"$f":"Translate!$C57","v":"Are there international cooperation programs investing in your farm activities? "},null,null,null,null,"Yes"]
["13)",{"$f":"Translate!$C58","v":"Can you imagine to use a SPIS without buying it?"},null,null,null,null,"Yes"]
["14)",{"$f":"Translate!$C59","v":"Do you live in a community of people with a common bond? "},null,null,null,null,"Yes",null,{"$f":"Translate!$C$72","v":"INFORMAL SAVING GROUPS\nare groups of people who save money in a common fund and borrow directly from their savings "},null,null,{"$f":"Translate!$C$73","v":"PAY-PER-USE\nis a business model offered by equipment manufacturers and dealers"}]
["15)",{"$f":"Translate!$C60","v":"Can you imagine becoming a member of an organization: Deposit monthly payments, attend meetings and participate in group activities?"},null,null,null,null,"Yes"]
["16)",{"$f":"Translate!$C61","v":"Is there a reciprocal trust between you and the people of your community?"},null,null,null,null,"Yes"]
["17)",{"$f":"Translate!$C62","v":"Can you imagine depositing your saving in local saving groups?"},null,null,null,null,"Yes",null,{"$f":"Translate!$C$74","v":"MOBILE MONEY\na service that uses mobile telecommunication to offer credit to people having or not having bank accounts"}]
["18)",{"$f":"Translate!$C63","v":"Do you only have a limited and sporadic need for irrigation?"},null,null,null,null,"Yes"]
["19)",{"$f":"Translate!$C64","v":"Are you able to depend on other people and on a predetermined schedule for the irrigation of your fields?"},null,null,null,null,"Yes"]

{"sheet":"Translate","index":2,"n_rows":89,"n_cols":7,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,1,2,2],[6,1,9,1],[4,1,4,8]]}
[]
[null,{"$f":"$C$12","v":"Do not modify this sheet"}]
[]
[]
[null,{"$f":"$C$13","v":"Reference Row"}]
[null,{"$f":"$C$14","v":"Selected Language:"},{"$f":"'READ ME'!$G$11","v":"English"},"English","Français","Español","العربية"]
[null,{"$f":"$C$15","v":"Sheet name"},{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"READ ME"},"READ ME","Lisez Moi","LÉEME","اقرأ هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"1. Financing models"},"1. Financing models","1. Modèles de financement","1. Modelos Financieros","1. نماذج التمويل"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"How does it work"},"How does it work","Comment ça fonctionne","Como funciona","كيف تعمل هذه الأداة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Translate"},"Translate","Traduire","Traducción","ترجمة"]
[]
[null,{"$f":"$C$10","v":"Translate"},{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Do not modify this sheet"},"Do not modify this sheet","Ne modifiez pas cette feuille","No modifique esta hoja","لا تعدل هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Reference Row"},"Reference Row","Ligne de référence","Fila de referencia","صف مرجعي"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Selected Language:"},"Selected Language:","Langue sélectionnée:","Idioma seleccionado:","اللغة المختارة:"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Sheet name"},"Sheet name","Nom de la feuille","Nombre de la hoja","اسم الصفحة"]
[]
[null,{"$f":"$C$7","v":"READ ME"},{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Select language"},"Select language","Sélectionner la langue","Seleccione el idioma","اختار اللغة"]
[null,null,"Read Me Sheet","Read Me Sheet","Feuille Lisez-moi","Léeme","اقرأ هذه الصفحة"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"FINANCE – Finance Deployment Tools"},"FINANCE – Finance Deployment Tools","FINANCER – Outils de déploiement financier","FINANZAS – Herramienta de Gestión Financiera","التمويل - أداة توظيف التمويل "]
[null,null,"Introduction","Introduction","Introduction","Introducción","مقدمة"]
[null,null,"This tool serves to identify the most suitable financial products available on the market for the use of an SPIS.","This tool serves to identify the most suitable financial products available on the market for the use of an SPIS.","Cet outil permet d'identifier sur le marché les produits financiers les plus adaptés à l'utilisation d'un SPIS.","Esta herramienta sirve para identificar los productos financieros más adecuados disponibles en el mercado para el uso de SPIS.","تعمل هذه الأداة على تحديد أنسب المنتجات المالية المتاحة في السوق لاستخدام نظام SPIS"]
[null,null,"Tips & Tricks","Tips & Tricks","Conseils et Astuces","Consejos y trucos","نصائح وحيل"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"● This tool comprises dropdown lists: choose among the answers YES, NO and N/A\n● For the multilanguage option to work properly, do NOT delete sheets\n● Make sure that this file is always saved as \".xlsm\""},"● This tool comprises dropdown lists: choose among the answers YES, NO and N/A\n● For the multilanguage option to work properly, do NOT delete sheets\n● Make sure that this file is always saved as \".xlsm\"","● Cet outil comprend des listes déroulantes: choisissez parmi les réponses OUI, NON et N/A\n● Pour que l'option multilingue fonctionne correctement, ne supprimez PAS les feuilles\n● Assurez-vous que ce fichier est toujours enregistré sous \".xlsm\"","● Esta herramienta incluye listas desplegables: elija entre las respuestas SÍ, NO y N/A.\n● Para que la opción de varios idiomas funcione correctamente, NO elimine las hojas.\n● Asegúrese de que este archivo siempre se guarde como \".xlsm\".","● تتكون هذه الأداة من قوائم منسدلة: اختر من بين الإجابات نعم ، لا ، غير موجود\n● لكي يعمل خيار اللغات المتعددة بشكل صحيح ، لا تحذف الصفحات\n● تأكد من حفظ هذا الملف دائمًا باسم \".xlsm\""]
[null,null,"Overview","Overview","Aperçu","Sinopsis","نظرة عامة"]
[null,null,"This tool comprises the following sheet:","This tool comprises the following sheet:","Cet outil est composé des feuilles suivantes:","Esta herramienta incluye las siguientes hojas:","تتكون هذه الأداة من الصفحات التالية:"]
[null,null,"identify a suitable financing option as per your prevailing circumstances","identify a suitable financing option as per your prevailing circumstances","identifier une solution de financement adaptée à votre propre situation","identifica la opción financiera más adecuada para las condiciones imperantes","تحديد خيار التمويل المناسب حسب الظروف السائدة"]
[null,null,"This tool is based on the FAO Training Manual no. 3: Irrigation Water Management: Irrigation Water Needs, available at: ","This tool is based on the FAO Training Manual no. 3: Irrigation Water Management: Irrigation Water Needs, available at: ","Cet outil se réfère au Manuel de Formation N°3 de la FAO : Gestion de l'Irrigation : Besoin en eau d'irrigation (Irrigation Water Management: Irrigation Water Needs), disponible sur: ","Esta herramienta está basada en el manual de entrenamiento no. 3 de la FAO: Irrigation Water Management: Irrigation Water Needs, disponible en: ","تعتمد هذه الأداة على دليل التدريب رقم. 3 الصادر عن منظمة الأغذية والزراعة: إدارة مياه الري: احتياجات مياه الري ، متوفرة في:"]
[null,null,"About","About","En savoir plus","Acerca de","حول"]
[null,null,"Published by: ","Published by: ","Publié par: ","Publicado por: ","نشرت من قبل:"]
[null,null,"Responsible:","Responsible:","Responsables:","Responsable:","مسؤول:"]
[null,null,"Contact:","Contact:","Contact:","Contacto: ","اتصال:"]
[null,null,"Download link:","Download link:","Lien de téléchargement:","Enlace descarga: ","رابط التحميل:"]
[null,null,"About:","About:","À propos de: ","Acerca de:","حول:"]
[null,null,"Version:","Version:","Version:","Versión:","إصدار:"]
[null,null,"GIZ & FAO","GIZ & FAO","GIZ et FAO","GIZ & FAO","الوكالة الألمانية للتعاون الدولي (GIZ) ومنظمة الأغذية والزراعة (FAO)"]
[null,null,"GIZ project \"Water and Energy for Food (WE4F)\"","GIZ project \"Water and Energy for Food (WE4F)\"","Projet de la GIZ « Les innovations dans l’agriculture et la production alimentaire protègent le climat (PEEPA/WE4F) » (Water and Energy for Food)","GIZ project \"Water and Energy for Food (WE4F)\"","مشروع الوكالة الألمانية للتعاون الدولي \"المياه والطاقة من أجل الغذاء Water and Energy for Food (WE4F)\""]
[null,null,"Water and Energy for Food Grand Challenge at:  ","Water and Energy for Food Grand Challenge at:  ","Eau et Energie pour l'Alimentation (PEEPA). Disponible à l’adresse :  ","Water and Energy for Food Grand Challenge at:  ","التحدي الكبير للمياه والطاقة من أجل الغذاء في:"]
[null,null,"3.0 (June 2021)","3.0 (June 2021)","3.0 (Juin 2021)","3.0 (Junio 2021)","3.0 (يونيو 2021)"]
[null,null,"The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","The Toolbox on Solar Powered Irrigation Systems (SPIS) is a legacy project of the global initiative Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). In 2012, the United States Agency for International Development (USAID), the Swedish International Development Cooperation Agency (Sida), the German Federal Ministry for Economic Cooperation and Development (BMZ), Duke Energy, and the Overseas Private Investment Corporation (OPIC) combined resources to support new and sustainable approaches to accelerate the development and deployment of clean energy solutions for increasing agriculture productivity.\n\nThe Toolbox on SPIS has now been embraced for further development by PAEGC's successor program Water and Energy for Food (WE4F). WE4F is a joint international initiative of the European Union (EU), German Federal Ministry for Economic Cooperation and Development (BMZ), the Ministry of Foreign Affairs of the Kingdom of the Netherlands, Sweden through the Swedish International Development Cooperation Agency (Sida), and the U.S. Agency for International Development (USAID). WE4F aims to increase food production along the value chain through a more sustainable and efficient usage of water and/or energy.","La boîte à outils pour les systèmes d’irrigation à énergie solaire (Solar Powered Irrigation Systems, SPIS) est un projet hérité de l'initiative mondiale « Propulser l’agriculture : un grand défi énergétique pour le développement » (Powering Agriculture: An Energy Grand Challenge for Development – PAEGC). En 2012, l’Agence des États-Unis pour le développement international (USAID), l’Agence suédoise de coopération internationale au développement (Sida), le ministère fédéral allemand de la Coopération économique et du Développement (BMZ), Duke Energy et l’Overseas Private Investment Cooperation (OPIC) ont mis leurs ressources en commun pour soutenir des approches nouvelles et durables afin d'accélérer le développement et le déploiement des solutions énergétiques propres pour accroître la productivité agricole.\n\nLa boîte à outils sur les SPIS a maintenant été adoptée pour un développement ultérieur par le programme successeur du PAEGC, Eau et Energie pour l'Alimentation (PEEPA) - Water and Energy for Food (WE4F). WE4F/PEEPA est une initiative commune de l'Union européenne, du Ministère fédéral allemand de la coopération économique et du développement (BMZ), du Ministère des affaires étrangères du royaume des Pays-Bas, de l’Agence suédoise de développement (Sida) et de l’Agence de développement des États-Unis (USAID). WE4F/PEEPA vise à accroître la production alimentaire tout au long de la chaîne de valeur grâce à une utilisation plus durable et plus efficace de l'eau et/ou de l'énergie.","La publicación de la Caja de herramientas de sistemas de riego solar ha sido posible gracias al apoyo brindado por la iniciativa mundial Powering Agriculture: An Energy Grand Challenge for Development (PAEGC) (Energización Rural: Un gran desafío energético para el desarrollo). En 2012, la Agencia de los Estados Unidos para el Desarrollo Internacional (USAID), la Agencia Sueca de Cooperación Internacional para el Desarrollo (Sida), el Ministerio Federal de Cooperación Económica y Desarrollo (BMZ) de Alemania, la empresa de energía Duke Energy Corporation y la Corporación de Inversiones Privadas en el Extranjero (OPIC) juntaron recursos para crear la iniciativa PAEGC. El objetivo de PAEGC es fomentar nuevos enfoques sostenibles con el fin de acelerar el desarrollo y asegurar el establecimiento de energías limpias que incrementen la productividad y/o el valor de la agricultura en países en desarrollo y regiones emergentes sin acceso a fuentes de energía confiables, asequibles y limpias.","يعتبر صندوق الأدوات الخاص بأنظمة الري التي تعمل بالطاقة الشمسية (SPIS) مشروعًا هاما للمبادرة العالمية \"دعم الزراعة: تحدي الطاقة الكبير من أجل التنمية\" Powering Agriculture: An Energy Grand Challenge for Development (PAEGC). في عام 2012 ، قامت الوكالة الأمريكية للتنمية الدولية (USAID) ، والوكالة السويدية للتعاون الإنمائي الدولي (ٍSida) ، والوزارة الفيدرالية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، وشركة Duke Energy ، ومؤسسة الاستثمار الخاص لما وراء البحار (OPIC) بجهود مشتركة لدعم الأساليب الجديدة والمستدامة لتسريع تطوير ونشر حلول الطاقة النظيفة لزيادة الإنتاجية الزراعية.\n\nتم اعتماد صندوق SPIS الآن لمزيد من التطوير من قبل البرنامج اللاحق لـ PAEGC \"الماء والطاقة من اجل الغذاء\" Water and Energy for Food (WE4F). الاخير هو مبادرة دولية مشتركة من الاتحاد الأوروبي (EU) ، والوزارة الاتحادية الألمانية للتعاون الاقتصادي والتنمية (BMZ) ، ووزارة الشؤون الخارجية لمملكة هولندا ، والسويد من خلال الوكالة السويدية للتعاون الإنمائي الدولي (Sida) ، والوكالة الأمريكية للتنمية الدولية (USAID). تهدف WE4F إلى زيادة إنتاج الغذاء على امتداد سلاسل القيمة الغذائية من خلال استخدام المياه و / أو الطاقة بطريقة أكثر استدامة وكفاءة."]
[null,null,"The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners.","The designations employed and the presentation of material in this information product do not imply the expression of any opinion whatsoever on the part of Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, Food and Agriculture Organization of the United Nations (FAO) or any of the PAEGC Founding Partners concerning the legal or development status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. The mention of specific companies or products of manufacturers, whether or not these have been patented, does not imply that these have been endorsed or recommended by GIZ, FAO, or any of the PAEGC Founding Partners in preference to others of a similar nature that are not mentioned. The views expressed in this information product are those of the author and do not necessarily reflect the views or policies of GIZ, FAO, or any of the PAEGC Founding Partners.","Les appellations employées dans ce produit d’information et la présentation des documents qui y figurent n’impliquent de la part de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, de l’Organisation des Nations unies pour l’alimentation et l’agriculture (FAO) ou de l’un des partenaires fondateurs de l’initiative PAEGC aucune prise de position quant au statut juridique ou au stade de développement des pays, territoires, villes ou zones ou de leurs autorités, ni quant au tracé de leurs frontières ou limites. La mention de sociétés déterminées ou de produits de fabricants, qu’ils soient ou non brevetés, n’entraîne de la part de la GIZ, de la FAO ou de l’un des partenaires fondateurs du PAEGC aucune approbation ou recommandation desdits produits de préférence à d’autres de nature analogue qui ne sont pas cités. Les opinions exprimées dans ce produit d’information sont celles des auteurs et ne reflètent pas nécessairement celles de la GIZ, de la FAO, ou de l’un des partenaires fondateurs du PAEGC.","Las denominaciones empleadas y la presentación del material en este producto informativo no implican juicio alguno por parte de la Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH, la Organización de las Naciones Unidas para la Alimentación y la Agricultura (FAO), o los socios fundadores de la iniciativa PAEGC, sobre la condición jurídica o el grado de desarrollo de ninguno de los países, territorios, ciudades o zonas citados o de sus autoridades, ni respecto de la delimitación de sus fronteras o límites. La mención de empresas o productos de fabricantes en particular, estén o no patentados, no implica que la GIZ, la FAO o alguno de los socios fundadores de la iniciativa PAEGC los aprueben o recomienden, dándoles preferencia sobre otros de naturaleza similar que no se mencionan. Las opiniones expresadas en este producto informativo son las de su(s) autor(es) o autora(s), y no reflejan necesariamente los puntos de vista o las políticas de la GIZ, la FAO o ninguno de los socios fundadores de la iniciativa PAEGC.","التسميات المستخدمة وطريقة عرض المواد في هذا المنتج المعلوماتي لا تعبر عن أي رأي من جانب Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ) GmbH أو منظمة الأغذية والزراعة للأمم المتحدة (FAO) أو أي من الشركاء المؤسسين لـ PAEGC فيما يتعلق بالوضع القانوني أو التنموي لأي بلد أو إقليم أو مدينة أو منطقة أو لسلطاتها ، أو فيما يتعلق بترسيم حدودها أو نطاقاتها. إن ذكر شركات أو منتجات معينة من الشركات المصنعة ، سواء تم تسجيل براءات اختراع لها أم لا ، لا يعني أن هذه الشركات أو المنتجات قد تم اعتمادها أو التوصية بها من قبل GIZ أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين لـ PAEGC او تفضيلها على الشركات أو المنتجات الاخرى غير مذكورة من نفس الطبيعة. الآراء الواردة في هذا المنتج المعلوماتي هي آراء المؤلف ولا تعكس بالضرورة آراء أو سياسات الوكالة الألمانية للتعاون الدولي أو منظمة الأغذية والزراعة أو أي من الشركاء المؤسسين  لـ PAEGC."]
[null,null,"GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given.","GIZ, FAO and the PAEGC Founding Partners encourage the use, reproduction and dissemination of material in this information product. Except where otherwise indicated, material may be copied, downloaded and printed for private study, research and teaching purposes, or for use in non-commercial products or services, provided that appropriate acknowledgement of GIZ and FAO as the source and copyright holder is given.","La GIZ, la FAO et les partenaires fondateurs du PAEGC encouragent l’utilisation, la reproduction et la diffusion des informations contenues dans ce document. Sauf indication contraire, ces dernières peuvent être copiées, téléchargées et imprimées à des fins privées d’étude, de recherche et d’enseignement, ou pour être utilisées dans des produits ou services non commerciaux, à condition que la GIZ et la FAO soient clairement indiquées en tant que sources des informations et détentrices du droit d’auteur.","La GIZ, la FAO y los socios fundadores de la iniciativa PAEGC fomentan la utilización, la reproducción y la difusión del material presentado en este producto informativo. A menos que se indique lo contrario, el material puede ser copiado, descargado e impreso con fines de estudio privado, enseñanza e investigación científica, o para su utilización en productos o servicios no comerciales, siempre que se otorgue a la GIZ y la FAO el debido reconocimiento como fuentes y como titulares de los derechos de autor.","تشجع الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة والشركاء المؤسسين لـ PAEGC على استخدام واستنساخ ونشر المواد في هذا المنتج المعلوماتي. يمكن نسخ المواد وتنزيلها وطباعتها للدراسة الخاصة ، ولأغراض البحث والتعليم ، أو لاستخدامها في المنتجات أو الخدمات غير التجارية ، ما لم يُذكر خلاف ذلك ، شريطة تقديم إقرار مناسب من الوكالة الألمانية للتعاون الدولي ومنظمة الأغذية والزراعة كمصدر وصاحب حقوق التأليف والنشر."]
[null,null,"© GIZ and FAO, 2020","© GIZ and FAO, 2020","© GIZ et FAO, 2020","© GIZ & FAO, 2021","© GIZ و FAO, 2021"]
[]
[null,{"$f":"$C$8","v":"1. Financing models"},{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"FINANCE-Finance Deployment Tool"},"FINANCE-Finance Deployment Tool","FINANCER - Outils de Déploiement Financier","FINANZAS - Herramienta de Gestión Financiera","التمويل - أداة توظيف التمويل "]
[null,null,"Answer the following questions (1-19) choosing among YES, NO or N/A on the drop down menu. On the right side of the excel sheet the financial products most suitable for your needs will compare.","Answer the following questions (1-19) choosing among YES, NO or N/A on the drop down menu. On the right side of the excel sheet the financial products most suitable for your needs will compare.","Veuillez répondre aux questions suivantes (1-19) en sélectionnant OUI, NON ou N/A dans le menu déroulant. À droite de la feuille Excel figure un tableau comparatif des produits financiers les plus adaptés à vos besoin.","Responda a las siguientes preguntas (1-19) escogiendo SÍ, NO o N/A en las listas desplegables. Al lado derecho de la hoja de excel aparecerán los productos financieros más adecuados para sus necesidades.","الرجاء الإجابة على الأسئلة التالية (1-19) عن طريق تحديد \"نعم\" أو \"لا\" أو \"غير موجود\" من القائمة المنسدلة. يوجد على يمين الورقة جدول مقارنة للمنتجات المالية الأنسب لاحتياجاتك."]
[null,null,"Do you possess any collateral?","Do you possess any collateral?","Disposez-vous de garanties ?","¿Posee algún tipo de garantía?","هل لديكم ضمانات؟"]
[null,null,"Do you possess any soft collateral?","Do you possess any soft collateral?","Disposez-vous de garanties accomodantes ?","¿Posee algún tipo de garantía blanda?","هل لديكم ضمانات ملائمة؟"]
[null,null,"Do you have access to alternative sources of income?","Do you have access to alternative sources of income?","Disposez-vous de sources de revenus alternatives ?","¿Posee acceso a una fuente alternativa de ingresos?","هل لديك مصادر دخل بديلة؟"]
[null,null,"Can other people/companies guarantee for you?","Can other people/companies guarantee for you?","Disposez-vous de garants (individu ou société) ?","¿Existen otras personas/empresas que puedan ser su aval?","هل لديك ضامنين (فرد أم شركة)؟"]
[null,null,"Do you possess a bank account?","Do you possess a bank account?","Avez- vous un compte bancaire ?","¿Posee una cuenta bancaria?","هل لديك حساب فى البنك ؟"]
[null,null,"Do you possess a mobile device with access to the internet?","Do you possess a mobile device with access to the internet?","Avez-vous un appareil mobile avec accès à l'internet ?","¿Posee un teléfono móvil con acceso a internet?","هل لديك جهاز محمول متصل بالإنترنت؟"]
[null,null,"Are you able to pay a commercial interest rate?","Are you able to pay a commercial interest rate?","Êtes-vous en mesure de payer le taux d'intérêt commercial ?","¿Tiene la capacidad de pagar una tasa de interés comercial?","هل أنت قادر على تحمل سعر الفائدة التجارية؟"]
[null,null,"Do you possess starting capital?","Do you possess starting capital?","Possédez-vous un capital de démarrage ?","¿Posee capital inicial?","هل لديك رأس مال مبتدئ؟"]
[null,null,"Does your government subsidize your farm activity?","Does your government subsidize your farm activity?","Votre gouvernement subventionne-t-il votre activité agricole ?","¿Subenciona el gobierno de su país la actividad agrícola que desempeña?","هل تدعم حكومتك نشاطك الزراعي؟"]
[null,null,"Do you work in an established value chain with downstream and upstream players?","Do you work in an established value chain with downstream and upstream players?","Votre activité s'inscrit-elle dans une chaîne de valeur établie avec des agents situés en amont ou en aval ?","¿Trabaja en una cadena de valor establecida con actores descendentes o ascendentes?","هل نشاطك جزء من سلسلة القيمة الراسخة مع وكلاء موجودين في المراحل الأولية أو في المراحل النهائية؟"]
[null,null,"Is the private sector interested in your products (i.e. for export reasons)?","Is the private sector interested in your products (i.e. for export reasons)?","Le secteur privé s'intéresse-t-il à vos produits (par ex. en vue de l'exportation) ?","¿Existe interés por parte del sector privado en los productos ofrecidos (p. ej. por motivos de exportación?)","هل القطاع الخاص مهتم بمنتجاتك (على سبيل المثال للتصدير)؟"]
[null,null,"Are there international cooperation programs investing in your farm activities? ","Are there international cooperation programs investing in your farm activities? ","Des programmes de coopération internationale investissent-ils dans vos activités agricoles ?","¿Existen programas de cooperación internacionales que inviertan en las actividades agrícolas de su explotación?","هل برامج التعاون الدولي تستثمر في أنشطتك الزراعية؟"]
[null,null,"Can you imagine to use a SPIS without buying it?","Can you imagine to use a SPIS without buying it?","Envisageriez-vous d'utiliser un SPIS sans l'acheter ?","¿Puede imaginarse utilizar un SPIS sin comprarlo?","هل تفكر في استخدام SPIS دون شرائه؟"]
[null,null,"Do you live in a community of people with a common bond? ","Do you live in a community of people with a common bond? ","Vivez-vous dans une communauté de personnes qui ont un lien en commun ? ","¿Vive en una comunidad de personas con un vínculo común?","هل تعيش في مجتمع من الناس الذين تربطهم رابطة مشتركة؟"]
[null,null,"Can you imagine becoming a member of an organization: Deposit monthly payments, attend meetings and participate in group activities?","Can you imagine becoming a member of an organization: Deposit monthly payments, attend meetings and participate in group activities?","Envisageriez-vous de devenir membre d'une organisation avec les implications suivantes: effectuer des paiements mensuels, participer à des réunions et à des activités communes ?","¿Puede imaginarse ser miembro de una organización: pagando mensualmente ingresos, acudiendo a reuniones y participando en actividades de grupo?","هل تفكر في أن تصبح عضوًا في منظمة مع الآثار التالية: سداد مدفوعات شهرية ، والمشاركة في الاجتماعات والأنشطة المشتركة؟"]
[null,null,"Is there a reciprocal trust between you and the people of your community?","Is there a reciprocal trust between you and the people of your community?","Y a-t-il une confiance réciproque entre vous et les gens de votre communauté ?","¿Existe una confianza mutua entre usted y las personas de su comunidad?","هل هناك ثقة متبادلة بينك وبين أفراد مجتمعك؟"]
[null,null,"Can you imagine depositing your saving in local saving groups?","Can you imagine depositing your saving in local saving groups?","Envisageriez-vous de verser votre épargne à des groupes d'épargne locaux ?","¿Puede imaginarse ingresar sus ahorros en un grupo local de ahorros?","هل يمكنك تخيل إيداع مدخراتك في مجموعات الادخار المحلية؟"]
[null,null,{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Do you only have a limited and sporadic need for irrigation?"},"Do you only have a limited and sporadic need for irrigation?","Vos besoins en irrigation sont-ils limités et sporadiques ?","¿Tiene necesidad solamente limitada o esporádica de riego?","هل احتياجاتك من الري محدودة ومتفرقة؟"]
[null,null,"Are you able to depend on other people and on a predetermined schedule for the irrigation of your fields?","Are you able to depend on other people and on a predetermined schedule for the irrigation of your fields?","Seriez-vous prêt à dépendre d'autres personnes et d'un calendrier pré-établi pour l'irrigation de vos terres ?","¿Es capaz de depender de otras personas y de un horario predeterminado para el regadío de sus cultivos?","هل أنت قادر على الاعتماد على أشخاص آخرين وعلى جدول زمني محدد مسبقًا لري حقلك؟"]
[null,null,"Possible financing options:","Possible financing options:","Options financières:","Posibles opciones de financiación:","خيارات التمويل الممكنة:"]
[null,null,"COMMERCIAL BANK LOAN\nis a loan from a financial institution whose main occupations consist in giving loans and taking deposits ","COMMERCIAL BANK LOAN\nis a loan from a financial institution whose main occupations consist in giving loans and taking deposits ","PRÊT BANCAIRE COMMERCIAL\nest un prêt octroyé par un institut financier dont la principale activité consiste à délivrer des prêts et d'accepter des dépôts ","PRÉSTAMO BANCARIO COMERCIAL\nes un préstamo de una institución financiera especializada en otorgar préstamos y captar depósitos","قرض بنك تجاري\nقرض من مؤسسة مالية تتمثل وظائفها الرئيسية في منح القروض وأخذ الودائع "]
[null,null,"DEVELOPMENT BANK LOAN\nis a loan from financial institutions which provides financial services  to actors involved in the food value chain","DEVELOPMENT BANK LOAN\nis a loan from financial institutions which provides financial services  to actors involved in the food value chain","PRÊT D'UNE BANQUE DE DÉVELOPPEMENT\nest un prêt octroyé par un institut financier qui délivre des services financiers à des acteurs de la chaîne  de valeur de l'alimentation","PRÉSTAMO BANCARIO DE DESARROLLO\nes un préstamo de una institución financiera que provee servicios financieros a actores implicados en la cadena de valor agroalimentaria","قرض بنك التنمية\nهو قرض من المؤسسات المالية التي تقدم خدمات مالية للجهات الفاعلة المشاركة في سلسلة القيمة الغذائية "]
[null,null,"MFIs\nare organizations, which provide financial inclusion to the poor strata of the population","MFIs\nare organizations, which provide financial inclusion to the poor strata of the population","IMFs\nsont des organisations qui permettent l'inclusion financière des couches pauvres de la population","IFMs\nson organizaciones, que proveen inclusión financiera a las capas pobres de la población","مؤسسات التمويل الأصغر\nهي المنظمات التي توفر الشمول المالي للشرائح الفقيرة من السكان"]
[null,null,"VALUE-CHAIN LOAN\nis a loan in-between the value chain actors","VALUE-CHAIN LOAN\nis a loan in-between the value chain actors","PRÊT AU SEIN D'UNE CHAINE DE VALEUR\nest un prêt entre acteurs d'une même chaîne de valeur","CRÉDITO DE LA CADENA DE VALOR\nes un préstamo entre los distintos actores de la cadena de valor","قرض سلسلة القيمة\nهو قرض بين الفاعلين في سلسلة القيمة"]
[null,null,"LEASING\nis a financial instrument which allows the use of an equipment without the need to purchase it","LEASING\nis a financial instrument which allows the use of an equipment without the need to purchase it","CRÉDIT-BAIL\nest un outil financier qui permet l'utilisation d'équipement sans en nécessiter l'achat","ARRENDAMIENTO\nes un instrumento financiero que permite el uso del material sin necesidad de comprarlo","تأجير\nهي أداة مالية تسمح باستخدام المعدات دون الحاجة لشرائها"]
[null,null,"COOPERATIVES\nare institutions that bring farmers together enabling them financial and economic advantages","COOPERATIVES\nare institutions that bring farmers together enabling them financial and economic advantages","COOPÉRATIVES\nsont des institutions qui regroupent des agriculteurs à qui elles apportent des avantages ","COOPERATIVAS\nson instituciones que juntan a agricultores permitiendo ventajas económicas y financieras","التعاونيات\nهي مؤسسات تجمع المزارعين معًا وتمكينهم من المزايا المالية والاقتصادية"]
[null,null,"INFORMAL SAVING GROUPS\nare groups of people who save money in a common fund and borrow directly from their savings ","INFORMAL SAVING GROUPS\nare groups of people who save money in a common fund and borrow directly from their savings ","GROUPES D'ÉPARGNE INFORMELS\nregroupent des personnes qui versent leur épargne dans un fond commun dont ils obtiennent également des prêts","GRUPO INFORMAL DE AHORROS\nson grupos de personas que ahorran dinero en un fondo común y toman préstamos directamente de sus ahorros","مجموعات التوفير غير الرسمية\nهي مجموعات من الأشخاص الذين يدخرون المال في صندوق مشترك ويقترضون مباشرة من مدخراتهم"]
[null,null,"PAY-PER-USE\nis a business model offered by equipment manufacturers and dealers","PAY-PER-USE\nis a business model offered by equipment manufacturers and dealers","PAIEMENT À L'UTILISATION\nest un modèle commercial mis à disposition par les fabricants et concessionnaires d'équipement ","PAGO-POR-USO\nes un modelo empresarial ofrecido por fabricantes y distribuidores del material","الدفع مقابل الاستخدام\nهو نموذج عمل يقدمه مصنعو المعدات والتجار"]
[null,null,"MOBILE MONEY\na service that uses mobile telecommunication to offer credit to people having or not having bank accounts","MOBILE MONEY\na service that uses mobile telecommunication to offer credit to people having or not having bank accounts","ARGENT MOBILE\nun service qui utilise les télécommunications mobiles pour offrir du crédit aux personnes ayant ou non des comptes bancaires","DINERO MÓVIL\nun servicio que utiliza telecomunicaciones móviles para ofrecer crédito a personas con o sin cuentas bancarias","نقود الهاتف المحمول\nخدمة تستخدم الاتصالات المحمولة لتقديم ائتمان للأشخاص الذين لديهم حسابات بنكية أو ليس لديهم حسابات بنكية"]
[]
[null,{"$f":"$C$9","v":"How does it work"},{"$f":"HLOOKUP($C$6,$D$6:$H$135,ROW()-ROW($B$5),FALSE)","v":"Yes"},"Yes","Oui","sí","نعم"]
[null,null,"No","No","Non","No","لا"]
[null,null,"N/A","N/A","N/A","N/A","غير موجود"]
[null,null,"Commercial Bank Loan","Commercial Bank Loan","Banque commercial","Banco Comercial","قرض بنك تجاري"]
[null,null,"Development Bank Loan","Development Bank Loan","Banque de développement       ","Banco de Desarrollo","قرض بنك التنمية"]
[null,null,"MFIs ","MFIs ","IMFs ","IMFs","مؤسسات التمويل الأصغر"]
[null,null,"Value Chain Loan","Value Chain Loan","Prêt au sein d'une chaine de valeur ","Préstamo dentro de una cadena de valor","قرض سلسلة القيمة"]
[null,null,"Leasing","Leasing","Crédit-bail  ","Arrendamiento","تأجير"]
[null,null,"Cooperatives","Cooperatives","Coopératives    ","Cooperativas","التعاونيات"]
[null,null,"Informal Saving Group","Informal Saving Group","Groupes d'épargne informels","Grupos de ahorro informales","مجموعات التوفير غير الرسمية"]
[null,null,"Pay-per-Use ","Pay-per-Use ","Paiement à l'utilisation  ","Pagar para usar","الدفع مقابل الاستخدام"]
[null,null,"Mobile money","Mobile money","Argent mobile","Dinero móvil","نقود الهاتف المحمول"]
[null,null,"Selected","Selected","Sélectionné","Seleccionado","مختار"]
[null,null,"Formula for Conditional Formatting","Formula for Conditional Formatting","Formule de mise en forme conditionnelle","Fórmula de formato condicional","صيغة للتنسيق شرطي"]

{"sheet":"How does it work","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[[6,6,6,8],[11,6,11,8],[7,6,7,8],[8,6,8,8],[9,6,9,8],[10,6,10,8],[0,4,1,4],[2,6,2,9],[3,6,3,8],[4,6,4,8],[5,6,5,8]]}
[null,null,null,null,{"$f":"Translate!$C$88","v":"Selected"}]
[]
[null,null,null,1,{"$f":"'1. Financing models'!G3","v":"Yes"},null,{"$f":"Translate!$C$89","v":"Formula for Conditional Formatting"}]
[null,null,null,2,{"$f":"'1. Financing models'!G4","v":"Yes"},null,{"$f":"Translate!C79","v":"Commercial Bank Loan"},null,null,{"$f":"AND(AND(OR(E3=B5,E5=B5)),E10=B5,E7=B5,E8=B5,E9=B5)","v":true}]
[null,{"$f":"Translate!$C76","v":"Yes"},null,3,{"$f":"'1. Financing models'!G5","v":"Yes"},null,{"$f":"Translate!C80","v":"Development Bank Loan"},null,null,{"$f":"AND(AND(OR(E11=B5,E13=B5,E14=B5),E10=B5,E7=B5,E8=B5,E10=B5))","v":true}]
[null,{"$f":"Translate!$C77","v":"No"},null,4,{"$f":"'1. Financing models'!G6","v":"Yes"},null,{"$f":"Translate!C81","v":"MFIs "},null,null,{"$f":"AND(AND(OR(E3=B5,E4=B5,E6=B5),E9=B5,E7=B5,E8=B5))","v":true}]
[null,{"$f":"Translate!$C78","v":"N/A"},null,5,{"$f":"'1. Financing models'!G7","v":"Yes"},null,{"$f":"Translate!C82","v":"Value Chain Loan"},null,null,{"$f":"AND(AND(OR(E6=B5,E10=B5),E7=B5,E9=B5,E8=B5,E12=B5))","v":true}]
[null,null,null,6,{"$f":"'1. Financing models'!G8","v":"Yes"},null,{"$f":"Translate!C83","v":"Leasing"},null,null,{"$f":"AND(E7=B5,E8=B5,E15=B5)","v":true}]
[null,null,null,7,{"$f":"'1. Financing models'!G9","v":"Yes"},null,{"$f":"Translate!C84","v":"Cooperatives"},null,null,{"$f":"AND(E7=B5,E16=B5,E17=B5,E18=B5,E19=B5)","v":true}]
[null,null,null,8,{"$f":"'1. Financing models'!G10","v":"Yes"},null,{"$f":"Translate!C85","v":"Informal Saving Group"},null,null,{"$f":"AND(E18=B5,E19=B5,E16=B5,E17=B5)","v":true}]
[null,null,null,9,{"$f":"'1. Financing models'!G11","v":"Yes"},null,{"$f":"Translate!C86","v":"Pay-per-Use "},null,null,{"$f":"AND(AND(OR(E20=B5,E21=B5),E8=B5,E15=B5))","v":true}]
[null,null,null,10,{"$f":"'1. Financing models'!G12","v":"Yes"},null,{"$f":"Translate!C87","v":"Mobile money"},null,null,{"$f":"E8=B5","v":true}]
[null,null,null,11,{"$f":"'1. Financing models'!G13","v":"Yes"}]
[null,null,null,12,{"$f":"'1. Financing models'!G14","v":"Yes"}]
[null,null,null,13,{"$f":"'1. Financing models'!G15","v":"Yes"}]
[null,null,null,14,{"$f":"'1. Financing models'!G16","v":"Yes"}]
[null,null,null,15,{"$f":"'1. Financing models'!G17","v":"Yes"}]
[null,null,null,16,{"$f":"'1. Financing models'!G18","v":"Yes"}]
[null,null,null,17,{"$f":"'1. Financing models'!G19","v":"Yes"}]
[null,null,null,18,{"$f":"'1. Financing models'!G20","v":"Yes"}]
[null,null,null,19,{"$f":"'1. Financing models'!G21","v":"Yes"}]