{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","Admin","I_Cover","II_PLAN","III_SETUP","IV_TRACK","V_Country_info","VI_Enablers","VII_Data_availability"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":64,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":73,"n_cols":43,"rows_kept":73,"cut":false,"hidden":true,"merged":[[3,0,14,0],[33,32,33,34],[27,0,40,0],[15,0,26,0],[33,19,33,21],[8,24,9,29],[8,31,9,35],[8,21,9,22],[8,18,9,19],[11,25,14,28],[17,25,20,28],[23,32,26,34],[23,19,26,21],[23,25,26,28],[11,19,14,21],[11,32,14,34],[33,25,33,28],[37,17,38,35],[1,17,1,35],[3,17,4,35],[17,32,20,34],[17,19,20,21],[31,18,31,35],[40,29,40,33],[42,29,42,33],[43,29,43,33],[45,29,45,33],[46,29,46,33],[40,27,40,28],[42,27,42,28],[43,27,43,28],[45,27,45,28],[46,27,46,28],[48,27,48,28],[49,27,49,28],[50,27,50,28],[51,27,51,28],[51,29,51,33],[48,29,48,33],[49,29,49,33],[50,29,50,33]]}
[null,null,"ColIndex",3,5,null,null,null,null,null,null,"Ratings:","Green","Yellow","Red"]
[null,"RowIndex",null,"Title","Answer","Numeric evaluation",null,"Questions","Unanswered questions","Yes","Partial","No",3,2,1,"Rating",null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"TITLE\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"Designing an energy statistics roadmap: Assessment summary"}]
[]
["Named range \"data_II\"",{"$f":"MATCH(C4,INDEX(data_II_PLAN,,2),0)","v":1},"1.",{"$f":"INDEX(data_II_PLAN,$B4,D$1)","v":"Data needs and users"},null,{"$f":"SUM(F5:F7)/(COUNTA(E5:E7)*3)","v":0},null,{"$f":"COUNTA($E5:$E7)","v":3},{"$f":"COUNTA($E5:$E7)-SUM($J4:$L4)","v":3},{"$f":"SUM(COUNTIF($E5:$E7,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E5:$E7,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E5:$E7,Answers_No))","v":0},{"$f":"J4=H4","v":false},{"$f":"IF(M4=FALSE,(J4/2+K4>=L4),FALSE)","v":true},{"$f":"IF(M4=FALSE,(J4/2+K4<L4),FALSE)","v":false},{"$f":"IF(I4=0,SUMPRODUCT($M$2:$O$2*M4:O4),0)","v":0},null,{"$f":"UPPER(country_name)&\": \"&INDEX(lang_SUMMARY,MATCH(\"ANSWERS\",INDEX(lang_SUMMARY,,1),0),col_language)","v":": Answers by topic"}]
[null,3,"1.A",{"$f":"INDEX(data_II_PLAN,$B5,D$1)","v":"Are there relevant or high-visibility energy policies in place that require energy data for policy design and evaluation?"},{"$f":"INDEX(data_II_PLAN,$B5,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E5) > 0, 3, IF(COUNTIF(Answers_Partial, E5) > 0, 2, IF(COUNTIF(Answers_No, E5) > 0, 1, 0)))","v":0}]
[null,11,"1.B",{"$f":"INDEX(data_II_PLAN,$B6,D$1)","v":"Is it clear who the data users are?"},{"$f":"INDEX(data_II_PLAN,$B6,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E6) > 0, 3, IF(COUNTIF(Answers_Partial, E6) > 0, 2, IF(COUNTIF(Answers_No, E6) > 0, 1, 0)))","v":0}]
[null,19,"1.C",{"$f":"INDEX(data_II_PLAN,$B7,D$1)","v":"Are evolving data needs continuously identified and addressed?"},{"$f":"INDEX(data_II_PLAN,$B7,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E7) > 0, 3, IF(COUNTIF(Answers_Partial, E7) > 0, 2, IF(COUNTIF(Answers_No, E7) > 0, 1, 0)))","v":0}]
[null,32,"2.",{"$f":"INDEX(data_II_PLAN,$B8,D$1)","v":"Strategy development"},null,{"$f":"SUM(F9:F11)/(COUNTA(E9:E11)*3)","v":0},null,{"$f":"COUNTA($E9:$E11)","v":3},{"$f":"COUNTA($E9:$E11)-SUM($J8:$L8)","v":3},{"$f":"SUM(COUNTIF($E9:$E11,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E9:$E11,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E9:$E11,Answers_No))","v":0},{"$f":"J8=H8","v":false},{"$f":"IF(M8=FALSE,(J8/2+K8>=L8),FALSE)","v":true},{"$f":"IF(M8=FALSE,(J8/2+K8<L8),FALSE)","v":false},{"$f":"IF(I8=0,SUMPRODUCT($M$2:$O$2*M8:O8),0)","v":0}]
[null,34,"2.A",{"$f":"INDEX(data_II_PLAN,$B9,D$1)","v":"Is there a strategy for producing and developing energy data? "},{"$f":"INDEX(data_II_PLAN,$B9,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E9) > 0, 3, IF(COUNTIF(Answers_Partial, E9) > 0, 2, IF(COUNTIF(Answers_No, E9) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"HEADING_PLAN\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"PLAN - Strategic dimension"},null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"HEADING_SETUP\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"SETUP - Operational dimension"},null,null,null,null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"HEADING_TRACK\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"TRACK - Data processes"}]
[null,42,"2.B",{"$f":"INDEX(data_II_PLAN,$B10,D$1)","v":"Does the strategy include identification of data collection priorities?"},{"$f":"INDEX(data_II_PLAN,$B10,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E10) > 0, 3, IF(COUNTIF(Answers_Partial, E10) > 0, 2, IF(COUNTIF(Answers_No, E10) > 0, 1, 0)))","v":0}]
[null,50,"2.C",{"$f":"INDEX(data_II_PLAN,$B11,D$1)","v":"Is it regularly updated to respond to evolving needs?"},{"$f":"INDEX(data_II_PLAN,$B11,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E11) > 0, 3, IF(COUNTIF(Answers_Partial, E11) > 0, 2, IF(COUNTIF(Answers_No, E11) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"col_language","v":2}]
[null,60,"3.",{"$f":"INDEX(data_II_PLAN,$B12,D$1)","v":"Funding mechanisms"},null,{"$f":"SUM(F13:F15)/(COUNTA(E13:E15)*3)","v":0},null,{"$f":"COUNTA($E13:$E15)","v":3},{"$f":"COUNTA($E13:$E15)-SUM($J12:$L12)","v":3},{"$f":"SUM(COUNTIF($E13:$E15,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E13:$E15,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E13:$E15,Answers_No))","v":0},{"$f":"J12=H12","v":false},{"$f":"IF(M12=FALSE,(J12/2+K12>=L12),FALSE)","v":true},{"$f":"IF(M12=FALSE,(J12/2+K12<L12),FALSE)","v":false},{"$f":"IF(I12=0,SUMPRODUCT($M$2:$O$2*M12:O12),0)","v":0},null,null,null,{"$f":"$D4","v":"Data needs and users"},null,null,null,null,null,{"$f":"$D16","v":"Legal framework"},null,null,null,null,null,null,{"$f":"$D28","v":"Data collection, methodologies and quality verification"},null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,62,"3.A",{"$f":"INDEX(data_II_PLAN,$B13,D$1)","v":"Are core energy statistics funded by the national administration?"},{"$f":"INDEX(data_II_PLAN,$B13,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E13) > 0, 3, IF(COUNTIF(Answers_Partial, E13) > 0, 2, IF(COUNTIF(Answers_No, E13) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE","Designing an energy statistics roadmap: Assessment summary","Concevoir une feuille de route pour les statistiques énergétiques","Diseño de una hoja de ruta de estadísticas energéticas: Resumen de la evaluación","Разработка дорожной карты в области энергетической статистики: итоги оценки","تصميم خارطة طريق لإحصاءات الطاقة: ملخص التقييم"]
[null,70,"3.B",{"$f":"INDEX(data_II_PLAN,$B14,D$1)","v":"Are there additional funding mechanisms besides conventional ones (i.e. public funds)? "},{"$f":"INDEX(data_II_PLAN,$B14,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E14) > 0, 3, IF(COUNTIF(Answers_Partial, E14) > 0, 2, IF(COUNTIF(Answers_No, E14) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANSWERS","Answers by topic","Réponses par élément","Repuestas por tema","Ответы по темам","الإجابات حسب الموضوع"]
[null,78,"3.C",{"$f":"INDEX(data_II_PLAN,$B15,D$1)","v":"Are the funding mechanisms sufficient and sustainable for routine and additional work?"},{"$f":"INDEX(data_II_PLAN,$B15,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E15) > 0, 3, IF(COUNTIF(Answers_Partial, E15) > 0, 2, IF(COUNTIF(Answers_No, E15) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADING_PLAN","PLAN - Strategic dimension","PLANIFIER - dimension stratégique","PLANIFICACIÓN (dimensión estratégica)","ПЛАНИРОВАНИЕ (стратегический аспект)"," الخطة - البعد الاستراتيجي"]
["Named range \"data_III\"",{"$f":"MATCH(C16,INDEX(data_III_SETUP,,2),0)","v":1},"4.",{"$f":"INDEX(data_III_SETUP,$B16,D$1)","v":"Legal framework"},null,{"$f":"SUM(F17:F19)/(COUNTA(E17:E19)*3)","v":0},null,{"$f":"COUNTA($E17:$E19)","v":3},{"$f":"COUNTA($E17:$E19)-SUM($J16:$L16)","v":3},{"$f":"SUM(COUNTIF($E17:$E19,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E17:$E19,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E17:$E19,Answers_No))","v":0},{"$f":"J16=H16","v":false},{"$f":"IF(M16=FALSE,(J16/2+K16>=L16),FALSE)","v":true},{"$f":"IF(M16=FALSE,(J16/2+K16<L16),FALSE)","v":false},{"$f":"IF(I16=0,SUMPRODUCT($M$2:$O$2*M16:O16),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADING_SETUP","SETUP - Operational dimension","ORGANISER - dimension\nopérationnelle","IMPLEMENTACIÓN (dimensión operativa)","ОРГАНИЗАЦИЯ (операционный аспект)","الإعداد - البعد التشغيلي"]
[null,3,"4.A",{"$f":"INDEX(data_III_SETUP,$B17,D$1)","v":"Is there a regulatory framework for energy statistics (e.g. Energy Statistics Act or Law)? (if there is one for general statistics please answer “Partial”)"},{"$f":"INDEX(data_III_SETUP,$B17,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E17) > 0, 3, IF(COUNTIF(Answers_Partial, E17) > 0, 2, IF(COUNTIF(Answers_No, E17) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADING_TRACK","TRACK - Data processes","SUIVRE - traitement des données","SEGUIMIENTO (procesamiento de datos)","ОТСЛЕЖИВАНИЕ (процессы работы с данными)","المسار- عمليات البيانات"]
[null,11,"4.B",{"$f":"INDEX(data_III_SETUP,$B18,D$1)","v":"Does it require respondents to provide data (i.e. mandatory nature)?"},{"$f":"INDEX(data_III_SETUP,$B18,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E18) > 0, 3, IF(COUNTIF(Answers_Partial, E18) > 0, 2, IF(COUNTIF(Answers_No, E18) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D8","v":"Strategy development"},null,null,null,null,null,{"$f":"$D20","v":"Institutional arrangements"},null,null,null,null,null,null,{"$f":"$D34","v":"Data management and innovation"},null,null,null,null,"LEGEND","Color code legend","Légende des couleurs","Código de color","Цветовые обозначения","مفتاح ترميز الألوان "]
[null,19,"4.C",{"$f":"INDEX(data_III_SETUP,$B19,D$1)","v":"Is it functioning and appropriate for your work? Is it enforced?"},{"$f":"INDEX(data_III_SETUP,$B19,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E19) > 0, 3, IF(COUNTIF(Answers_Partial, E19) > 0, 2, IF(COUNTIF(Answers_No, E19) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED","Significant weaknesses identified","Faiblesses importantes identifiées","Debilidades significativas identificadas","Выявлены значительные недостатки","وجود نقاط ضعف كبيرة"]
[null,{"$f":"MATCH(C20,INDEX(data_III_SETUP,,2),0)","v":32},"5.",{"$f":"INDEX(data_III_SETUP,$B20,D$1)","v":"Institutional arrangements"},null,{"$f":"SUM(F21:F23)/(COUNTA(E21:E23)*3)","v":0},null,{"$f":"COUNTA($E21:$E23)","v":3},{"$f":"COUNTA($E21:$E23)-SUM($J20:$L20)","v":3},{"$f":"SUM(COUNTIF($E21:$E23,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E21:$E23,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E21:$E23,Answers_No))","v":0},{"$f":"J20=H20","v":false},{"$f":"IF(M20=FALSE,(J20/2+K20>=L20),FALSE)","v":true},{"$f":"IF(M20=FALSE,(J20/2+K20<L20),FALSE)","v":false},{"$f":"IF(I20=0,SUMPRODUCT($M$2:$O$2*M20:O20),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YELLOW","Some work needed to strengthen the element","Quelques travaux sont nécessaires pour\nrenforcer l'élément","Se necesita algo de trabajo para fortalecer el elemento","Требуется некоторое улучшение","هناك الحاجة لبعض العمل لتعزيز العنصر"]
[null,34,"5.A",{"$f":"INDEX(data_III_SETUP,$B21,D$1)","v":"Is there an entity responsible for coordinating the national energy information system?"},{"$f":"INDEX(data_III_SETUP,$B21,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E21) > 0, 3, IF(COUNTIF(Answers_Partial, E21) > 0, 2, IF(COUNTIF(Answers_No, E21) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREEN","On track to support policies","En bonne voie pour soutenir les politiques","Al corriente para apoyar las políticas","Должным образом содействует политике","على المسار الصحيح لدعم السياسات"]
[null,42,"5.B",{"$f":"INDEX(data_III_SETUP,$B22,D$1)","v":"Is the division of work clear to avoid both gaps and overlaps in data collection?"},{"$f":"INDEX(data_III_SETUP,$B22,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E22) > 0, 3, IF(COUNTIF(Answers_Partial, E22) > 0, 2, IF(COUNTIF(Answers_No, E22) > 0, 1, 0)))","v":0}]
[null,50,"5.C",{"$f":"INDEX(data_III_SETUP,$B23,D$1)","v":"Are there any mechanisms to foster institutional collaboration and data sharing at the national level (e.g. Memoranda of Understanding [MoUs], agreements, working groups)?"},{"$f":"INDEX(data_III_SETUP,$B23,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E23) > 0, 3, IF(COUNTIF(Answers_Partial, E23) > 0, 2, IF(COUNTIF(Answers_No, E23) > 0, 1, 0)))","v":0}]
[null,{"$f":"MATCH(C24,INDEX(data_III_SETUP,,2),0)","v":60},"6.",{"$f":"INDEX(data_III_SETUP,$B24,D$1)","v":"Human, technical, and financial resources"},null,{"$f":"SUM(F25:F27)/(COUNTA(E25:E27)*3)","v":0},null,{"$f":"COUNTA($E25:$E27)","v":3},{"$f":"COUNTA($E25:$E27)-SUM($J24:$L24)","v":3},{"$f":"SUM(COUNTIF($E25:$E27,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E25:$E27,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E25:$E27,Answers_No))","v":0},{"$f":"J24=H24","v":false},{"$f":"IF(M24=FALSE,(J24/2+K24>=L24),FALSE)","v":true},{"$f":"IF(M24=FALSE,(J24/2+K24<L24),FALSE)","v":false},{"$f":"IF(I24=0,SUMPRODUCT($M$2:$O$2*M24:O24),0)","v":0},null,null,null,{"$f":"$D12","v":"Funding mechanisms"},null,null,null,null,null,{"$f":"$D24","v":"Human, technical, and financial resources"},null,null,null,null,null,null,{"$f":"$D38","v":"Data access and dissemination"}]
[null,{"$f":"MATCH(C25,INDEX(data_III_SETUP,,2),0)","v":62},"6.A",{"$f":"INDEX(data_III_SETUP,$B25,D$1)","v":"Are the available technical and financial resources adequate and visible in the long-term?"},{"$f":"INDEX(data_III_SETUP,$B25,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E25) > 0, 3, IF(COUNTIF(Answers_Partial, E25) > 0, 2, IF(COUNTIF(Answers_No, E25) > 0, 1, 0)))","v":0}]
[null,{"$f":"MATCH(C26,INDEX(data_III_SETUP,,2),0)","v":70},"6.B",{"$f":"INDEX(data_III_SETUP,$B26,D$1)","v":"Are the available resources (human, technical and financial) relatively stable over time, without major annual fluctuations?"},{"$f":"INDEX(data_III_SETUP,$B26,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E26) > 0, 3, IF(COUNTIF(Answers_Partial, E26) > 0, 2, IF(COUNTIF(Answers_No, E26) > 0, 1, 0)))","v":0}]
[null,{"$f":"MATCH(C27,INDEX(data_III_SETUP,,2),0)","v":78},"6.C",{"$f":"INDEX(data_III_SETUP,$B27,D$1)","v":"Is there sufficient staff capacity? Is there continuous training of staff?"},{"$f":"INDEX(data_III_SETUP,$B27,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E27) > 0, 3, IF(COUNTIF(Answers_Partial, E27) > 0, 2, IF(COUNTIF(Answers_No, E27) > 0, 1, 0)))","v":0}]
["Named range \"data_IV\"",{"$f":"MATCH(C28,INDEX(data_IV_TRACK,,2),0)","v":1},"7.",{"$f":"INDEX(data_IV_TRACK,$B28,D$1)","v":"Data collection, methodologies and quality verification"},null,{"$f":"SUM(F29:F33)/(COUNTA(E29:E33)*3)","v":0},null,{"$f":"COUNTA($E29:$E31)","v":3},{"$f":"COUNTA($E29:$E31)-SUM($J28:$L28)","v":3},{"$f":"SUM(COUNTIF($E29:$E31,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E29:$E31,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E29:$E31,Answers_No))","v":0},{"$f":"J28=H28","v":false},{"$f":"IF(M28=FALSE,(J28/2+K28>=L28),FALSE)","v":true},{"$f":"IF(M28=FALSE,(J28/2+K28<L28),FALSE)","v":false},{"$f":"IF(I28=0,SUMPRODUCT($M$2:$O$2*M28:O28),0)","v":0}]
[null,3,"7.A",{"$f":"INDEX(data_IV_TRACK,$B29,D$1)","v":"Are there sound data collection methods in place (e.g. use of administrative sources, fuel and sectoral surveys)? "},{"$f":"INDEX(data_IV_TRACK,$B29,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E29) > 0, 3, IF(COUNTIF(Answers_Partial, E29) > 0, 2, IF(COUNTIF(Answers_No, E29) > 0, 1, 0)))","v":0}]
[null,{"$f":"MATCH(C30,INDEX(data_IV_TRACK,,2),0)","v":11},"7.B",{"$f":"INDEX(data_IV_TRACK,$B30,D$1)","v":"Does the data collection follow documented methodologies and standards? "},{"$f":"INDEX(data_IV_TRACK,$B30,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E30) > 0, 3, IF(COUNTIF(Answers_Partial, E30) > 0, 2, IF(COUNTIF(Answers_No, E30) > 0, 1, 0)))","v":0}]
[null,19,"7.C",{"$f":"INDEX(data_IV_TRACK,$B31,D$1)","v":"Are there sufficient processes in place to control data quality?"},{"$f":"INDEX(data_IV_TRACK,$B31,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E31) > 0, 3, IF(COUNTIF(Answers_Partial, E31) > 0, 2, IF(COUNTIF(Answers_No, E31) > 0, 1, 0)))","v":0}]
[null,22,"7.D",{"$f":"INDEX(data_IV_TRACK,$B32,D$1)","v":"Are the following references applied in the national context? (refer to table on page 58)"},{"$f":"F32","v":0},{"$f":"IFERROR(F45,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"LEGEND\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"Color code legend"}]
[null,{"$error":"#N/A"},"7.F",{"$f":"INDEX(data_IV_TRACK,$B33,D$1)","v":{"$error":"#N/A"}},{"$f":"F33","v":0},{"$f":"IFERROR(F52,0)","v":0}]
[null,{"$f":"MATCH(C34,INDEX(data_IV_TRACK,,2),0)","v":50},"8.",{"$f":"INDEX(data_IV_TRACK,$B34,D$1)","v":"Data management and innovation"},null,{"$f":"SUM(F35:F37)/(COUNTA(E35:E37)*3)","v":0},null,{"$f":"COUNTA($E35:$E37)","v":3},{"$f":"COUNTA($E35:$E37)-SUM($J34:$L34)","v":3},{"$f":"SUM(COUNTIF($E35:$E37,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E35:$E37,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E35:$E37,Answers_No))","v":0},{"$f":"J34=H34","v":false},{"$f":"IF(M34=FALSE,(J34/2+K34>=L34),FALSE)","v":true},{"$f":"IF(M34=FALSE,(J34/2+K34<L34),FALSE)","v":false},{"$f":"IF(I34=0,SUMPRODUCT($M$2:$O$2*M34:O34),0)","v":0},null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"RED\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"Significant weaknesses identified"},null,null,null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"YELLOW\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"Some work needed to strengthen the element"},null,null,null,null,null,null,{"$f":"INDEX(lang_SUMMARY,MATCH(\"GREEN\",INDEX(lang_SUMMARY,,1),0),col_language)","v":"On track to support policies"}]
[null,52,"8.A",{"$f":"INDEX(data_IV_TRACK,$B35,D$1)","v":"Is the current data management framework adequate?"},{"$f":"INDEX(data_IV_TRACK,$B35,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E35) > 0, 3, IF(COUNTIF(Answers_Partial, E35) > 0, 2, IF(COUNTIF(Answers_No, E35) > 0, 1, 0)))","v":0}]
[null,60,"8.B",{"$f":"INDEX(data_IV_TRACK,$B36,D$1)","v":"Is there room for further digitisation of data collection, management and dissemination?"},{"$f":"INDEX(data_IV_TRACK,$B36,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E36) > 0, 3, IF(COUNTIF(Answers_Partial, E36) > 0, 2, IF(COUNTIF(Answers_No, E36) > 0, 1, 0)))","v":0}]
[null,68,"8.C",{"$f":"INDEX(data_IV_TRACK,$B37,D$1)","v":"Is there any plan or pilot programme for innovative methods or approaches in the national energy information system?"},{"$f":"INDEX(data_IV_TRACK,$B37,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E37) > 0, 3, IF(COUNTIF(Answers_Partial, E37) > 0, 2, IF(COUNTIF(Answers_No, E37) > 0, 1, 0)))","v":0}]
[null,76,"9.",{"$f":"INDEX(data_IV_TRACK,$B38,D$1)","v":"Data access and dissemination"},null,{"$f":"SUM(F39:F41)/(COUNTA(E39:E41)*3)","v":0},null,{"$f":"COUNTA($E39:$E41)","v":3},{"$f":"COUNTA($E39:$E41)-SUM($J38:$L38)","v":3},{"$f":"SUM(COUNTIF($E39:$E41,Answers_Yes))","v":0},{"$f":"SUM(COUNTIF($E39:$E41,Answers_Partial))","v":0},{"$f":"SUM(COUNTIF($E39:$E41,Answers_No))","v":0},{"$f":"J38=H38","v":false},{"$f":"IF(M38=FALSE,(J38/2+K38>=L38),FALSE)","v":true},{"$f":"IF(M38=FALSE,(J38/2+K38<L38),FALSE)","v":false},{"$f":"IF(I38=0,SUMPRODUCT($M$2:$O$2*M38:O38),0)","v":0},null,{"$f":"VII_Data_availability!C53","v":"The available energy data support the national policy directions as follows:"}]
[null,78,"9.A",{"$f":"INDEX(data_IV_TRACK,$B39,D$1)","v":"Are energy statistics easily findable and accessible? "},{"$f":"INDEX(data_IV_TRACK,$B39,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E39) > 0, 3, IF(COUNTIF(Answers_Partial, E39) > 0, 2, IF(COUNTIF(Answers_No, E39) > 0, 1, 0)))","v":0}]
[null,86,"9.B",{"$f":"INDEX(data_IV_TRACK,$B40,D$1)","v":"Are the final data products relevant to the users?"},{"$f":"INDEX(data_IV_TRACK,$B40,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E40) > 0, 3, IF(COUNTIF(Answers_Partial, E40) > 0, 2, IF(COUNTIF(Answers_No, E40) > 0, 1, 0)))","v":0}]
[null,94,"9.C",{"$f":"INDEX(data_IV_TRACK,$B41,D$1)","v":"Are the data transparent? Is there metadata available?"},{"$f":"INDEX(data_IV_TRACK,$B41,E$1)","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E41) > 0, 3, IF(COUNTIF(Answers_Partial, E41) > 0, 2, IF(COUNTIF(Answers_No, E41) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E56","v":"Energy supply"},null,{"$f":"VII_Data_availability!G56","v":"Energy demand"},null,null,null,null,{"$f":"VII_Data_availability!I56","v":"Economic activity"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!C57","v":"Sustainable development goals"}]
[null,null,null,null,null,null,null,"Overall rating",null,"PLAN","SETUP","TRACK",null,null,null,null,null,null,{"$f":"VII_Data_availability!C58","v":"SDG 7.2"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E58","v":".."},null,{"$f":"VII_Data_availability!G58","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I58","v":".."}]
[null,null,null,null,null,null,null,null,"Blanks?",{"$f":"COUNTIF(J45:J47,0)>0=TRUE","v":true},{"$f":"COUNTIF(K45:K47,0)>0=TRUE","v":true},true,null,null,null,null,null,null,{"$f":"VII_Data_availability!C59","v":"SDG 7.3"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E59","v":".."},null,{"$f":"VII_Data_availability!G59","v":"n/a"},null,null,null,null,{"$f":"VII_Data_availability!I59","v":".."}]
[null,null,null,"Table 4",null,{"$f":"ROUND(AVERAGEIF(F46:F50,\">0\",F46:F50),1)","v":{"$error":"#DIV/0!"}},null,null,"Q1",{"$f":"P4","v":0},{"$f":"P16","v":0},{"$f":"P28","v":0},null,null,null,null,null,null,{"$f":"VII_Data_availability!C60","v":"International climate reporting"}]
[null,null,null,{"$f":"IV_TRACK!C29","v":"● International Recommendations for Energy Statistics (IRES) [United Nations, 2011]"},{"$f":"IV_TRACK!E29","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E46) > 0, 3, IF(COUNTIF(Answers_Partial, E46) > 0, 2, IF(COUNTIF(Answers_No, E46) > 0, 1, 0)))","v":0},null,null,"Q2",{"$f":"P8","v":0},{"$f":"P20","v":0},{"$f":"P34","v":0},null,null,null,null,null,null,{"$f":"VII_Data_availability!C61","v":"National greenhouse gas (GHG) emission inventory"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E61","v":".."},null,{"$f":"VII_Data_availability!G61","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I61","v":"n/a"}]
[null,null,null,{"$f":"IV_TRACK!C30","v":"● Standard International Energy Product Classification (SIEC) [part of IRES)]"},{"$f":"IV_TRACK!E30","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E47) > 0, 3, IF(COUNTIF(Answers_Partial, E47) > 0, 2, IF(COUNTIF(Answers_No, E47) > 0, 1, 0)))","v":0},null,null,"Q3",{"$f":"P12","v":0},{"$f":"P24","v":0},{"$f":"P38","v":0},null,null,null,null,null,null,{"$f":"VII_Data_availability!C62","v":"Nationally determined contributions (NDCs)"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E62","v":".."},null,{"$f":"VII_Data_availability!G62","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I62","v":".."}]
[null,null,null,{"$f":"IV_TRACK!C31","v":"● The International Standard Industrial Classification of All Economic Activities (ISIC)"},{"$f":"IV_TRACK!E31","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E48) > 0, 3, IF(COUNTIF(Answers_Partial, E48) > 0, 2, IF(COUNTIF(Answers_No, E48) > 0, 1, 0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!C63","v":"National sectoral energy policies"}]
[null,null,null,{"$f":"IV_TRACK!C32","v":"● Energy Statistics Compiler’s Manual (ESCM)"},{"$f":"IV_TRACK!E32","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E49) > 0, 3, IF(COUNTIF(Answers_Partial, E49) > 0, 2, IF(COUNTIF(Answers_No, E49) > 0, 1, 0)))","v":0},null,"Green",3,{"$f":"COUNTIF(J45:J47,3)=3","v":false},{"$f":"COUNTIF(K45:K47,3)=3","v":false},{"$f":"COUNTIF(L45:L47,3)=3","v":false},null,null,null,null,null,null,{"$f":"VII_Data_availability!C64","v":"Fuel switching"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E64","v":".."},null,{"$f":"VII_Data_availability!G64","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I64","v":"n/a"}]
[null,null,null,{"$f":"IV_TRACK!C33","v":"● 2006 IPCC Guidelines for National Greenhouse Gas Inventories Volume 2: Energy"},{"$f":"IV_TRACK!E33","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E50) > 0, 3, IF(COUNTIF(Answers_Partial, E50) > 0, 2, IF(COUNTIF(Answers_No, E50) > 0, 1, 0)))","v":0},null,"Yellow",2,{"$f":"IF(J49=FALSE,(J45/2+J46>=J47),FALSE)","v":true},{"$f":"IF(K49=FALSE,(K45/2+K46>=K47),FALSE)","v":true},{"$f":"IF(L49=FALSE,(L45/2+L46>=L47),FALSE)","v":true},null,null,null,null,null,null,{"$f":"VII_Data_availability!C65","v":"Renewable energy targets"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E65","v":".."},null,{"$f":"VII_Data_availability!G65","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I65","v":"n/a"}]
[null,null,null,null,null,null,null,"Red",1,{"$f":"IF(J49=FALSE,(J45/2+J46<J47),FALSE)","v":false},{"$f":"IF(K49=FALSE,(K45/2+K46<K47),FALSE)","v":false},{"$f":"IF(L49=FALSE,(L45/2+L46<L47),FALSE)","v":false},null,null,null,null,null,null,{"$f":"VII_Data_availability!C66","v":"Improving energy efficiency"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E66","v":".."},null,{"$f":"VII_Data_availability!G66","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I66","v":".."}]
[null,null,null,"Table 5",null,{"$f":"ROUND(AVERAGEIF(F53:F59,\">0\",F53:F59),1)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(J44=FALSE,SUMPRODUCT($I$49:$I$51*J49:J51),0)","v":0},{"$f":"IF(K44=FALSE,SUMPRODUCT($I$49:$I$51*K49:K51),0)","v":0},{"$f":"MIN(L55:L56)","v":0},"<-- main group ratings!",null,null,null,null,null,{"$f":"VII_Data_availability!C67","v":"Energy planning (modelling)"},null,null,null,null,null,null,null,null,{"$f":"VII_Data_availability!E67","v":".."},null,{"$f":"VII_Data_availability!G67","v":".."},null,null,null,null,{"$f":"VII_Data_availability!I67","v":".."}]
[null,null,null,{"$f":"IV_TRACK!C42","v":"● Energy production"},{"$f":"IV_TRACK!E42","v":0},{"$f":"IF(COUNTIF(Answers_Yes, E53) > 0, 3, IF(COUNTIF(Answers_Partial, E53) > 0, 2, IF(COUNTIF(Answers_No, E53) > 0, 1, 0)))","v":0}]
[null,null,null,{"$f":"IV_TRACK!C43","v":"● Energy transformation processes in iron and steel making"},{"$f":"IV_TRACK!E43","v":0},0,null,null,"Special case: TRACK"]
[null,null,null,{"$f":"IV_TRACK!C44","v":"● Electricity produced by autoproducers - industry"},{"$f":"IV_TRACK!E44","v":0},0,null,null,null,null,"Default rating condition",{"$f":"IF(L44=FALSE,SUMPRODUCT($I$49:$I$51*L49:L51),0)","v":0}]
[null,null,null,{"$f":"IV_TRACK!C45","v":"● Electricity produced by autoproducers - residential"},{"$f":"IV_TRACK!E45","v":0},0,null,null,null,null,"Test for 'penalty'",{"$f":"IF(L55=3,IF(OR(J52<3,P46<3)=TRUE,L55-1,L55),L55)","v":0}]
[null,null,null,{"$f":"IV_TRACK!C46","v":"● Geographical coverage"},{"$f":"IV_TRACK!E46","v":0},0]
[null,null,null,{"$f":"IV_TRACK!C47","v":"● Non-commercial energy demand"},{"$f":"IV_TRACK!E47","v":0},0,null,null,"Rating logic"]
[null,null,null,{"$f":"IV_TRACK!C48","v":"● Fuel tourism"},{"$f":"IV_TRACK!E48","v":0},0,null,null,"Individual answers",null,null,"Aggregate"]
[null,null,null,null,null,null,null,null,"YES","YES","YES","YES"]
[null,null,null,null,null,null,null,null,"YES","YES","PARTIAL","PARTIAL"]
[null,null,null,null,null,null,null,null,"YES","YES","NO","PARTIAL"]
[null,null,null,null,null,null,null,null,"YES","NO","NO","NO"]
[null,null,null,null,null,null,null,null,"YES","PARTIAL","PARTIAL","PARTIAL"]
[null,null,null,null,null,null,null,null,"YES","PARTIAL","NO","PARTIAL"]
[null,null,null,null,null,null,null,null,"PARTIAL","PARTIAL","PARTIAL","PARTIAL"]
[null,null,null,null,null,null,null,null,"PARTIAL","PARTIAL","NO","PARTIAL"]
[null,null,null,null,null,null,null,null,"PARTIAL","NO","NO","NO"]
[null,null,null,null,null,null,null,null,"NO","NO","NO","NO"]
[]
[null,null,null,null,null,null,null,null,"Answers_No"]
[null,null,null,null,null,null,null,null,"No","Non","Нет","لا"]
[null,null,null,null,null,null,null,null,"Need one where \"No\" does not repeat in Spanish and English"]

{"sheet":"Admin","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Dropdown_list",null,null,null,null,null,null,"Restore conditional formatting",null,null,null,null,null,null,null,null,"X"]
["YES",{"$f":"INDEX($C$21:$H$24,MATCH($A3,$C$21:$C$24,0),$C$19)","v":"Yes"}]
["NO",{"$f":"INDEX($C$21:$H$24,MATCH($A4,$C$21:$C$24,0),$C$19)","v":"No"},null,null,null,null,null,null,"Col","F",null,"AND($F$4>=50%,$F$4<75%)","AND($F$4>0%,$F$4<50%)"]
["PARTIAL",{"$f":"INDEX($C$21:$H$24,MATCH($A5,$C$21:$C$24,0),$C$19)","v":"Partial"},null,"● empties any input values from the tool",null,null,null,null,"Row","Cell","Rule 1","Rule 2","Rule 3","Target range"]
["N/A",{"$f":"INDEX($C$21:$H$24,MATCH($A6,$C$21:$C$24,0),$C$19)","v":"N/A"},null,"● hides certain sheets",null,null,null,null,4,{"$f":"\"$\"&$J$4&\"$\"&I6","v":"$F$4"},{"$f":"\"AND(\"&$J6&\">=75%,\"&$J6&\"<=100%)\"","v":"AND($F$4>=75%,$F$4<=100%)"},{"$f":"\"AND(\"&$J6&\">=50%,\"&$J6&\"<75%)\"","v":"AND($F$4>=50%,$F$4<75%)"},{"$f":"\"AND(\"&$J6&\">0%,\"&$J6&\"<50%)\"","v":"AND($F$4>0%,$F$4<50%)"},"$H$29:$J$32"]
[null,null,null,"● protects certain sheets",null,null,null,null,9,"$F$9","AND($F$9>=75%,$F$9<=100%)","AND($F$9>=50%,$F$9<75%)","AND($F$9>0%,$F$9<50%)","$H$35:$J$38"]
[null,null,null,"● sets the view",null,null,null,null,14,"$F$14","AND($F$14>=75%,$F$14<=100%)","AND($F$14>=50%,$F$14<75%)","AND($F$14>0%,$F$14<50%)","$H$41:$J$44"]
[null,null,null,null,null,null,null,null,19,"$F$19","AND($F$19>=75%,$F$19<=100%)","AND($F$19>=50%,$F$19<75%)","AND($F$19>0%,$F$19<50%)","$L$29:$N$32"]
[null,null,null,null,null,null,null,null,24,"$F$24","AND($F$24>=75%,$F$24<=100%)","AND($F$24>=50%,$F$24<75%)","AND($F$24>0%,$F$24<50%)","$L$35:$N$38"]
[null,null,null,null,null,null,null,null,29,"$F$29","AND($F$29>=75%,$F$29<=100%)","AND($F$29>=50%,$F$29<75%)","AND($F$29>0%,$F$29<50%)","$L$41:$L$44"]
[null,null,null,null,null,null,null,null,34,"$F$34","AND($F$34>=75%,$F$34<=100%)","AND($F$34>=50%,$F$34<75%)","AND($F$34>0%,$F$34<50%)","$P$29:$R$32"]
[null,null,null,"● shows and unprotects all sheets",null,null,null,null,42,"$F$42","AND($F$42>=75%,$F$42<=100%)","AND($F$42>=50%,$F$42<75%)","AND($F$42>0%,$F$42<50%)","$P$35:$R$38"]
[null,null,null,"● shows headings",null,null,null,null,46,"$F$46","AND($F$46>=75%,$F$46<=100%)","AND($F$46>=50%,$F$46<75%)","AND($F$46>0%,$F$46<50%)","$P$41:$R$44"]
[]
[]
[]
[null,null,"col_language"]
[null,null,{"$f":"col_language","v":2}]
[null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,"YES","Yes","Oui","Sí","Да","نعم"]
[null,null,"NO","No","Non","No","Нет","لا"]
[null,null,"PARTIAL","Partial","En partie","Parcial","Частично","جزئي"]
[null,null,"N/A","N/A","N/A","NA","-","غير منطبق"]
[null,null,"VBA_labels"]
[null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,"SUMMARY","Summary","Résumé","Resumen","Сводка","الملخص"]
[null,null,"FULL","Full report","Complet","Informe completo","Полный отчет","التقرير الكامل"]
[null,null,"EXIT","Exit","Quitter","Salir","Выход","خروج"]
[null,null,"ACTION","Choose the result report type. ","Choisissez le type de rapport de résultats.","Seleccione el tipo de informe de resultados.","Выберите тип отчета о результате.","اختر نوع ملف تقرير النتيجة."]
[null,null,"ACTION_NOTE","NOTE: the output report will be saved on the user desktop!","REMARQUE : le rapport de sortie sera enregistré sur le bureau de l'utilisateur !","NOTA: El informe de resultados se guardará en el escritorio del usuario.","ПРИМЕЧАНИЕ: отчет о выходе будет сохранен на рабочем столе пользователя!","ملاحظة: سيتم حفظ تقرير النتائج على سطح مكتب المستخدم"]
[null,null,"REPORT_NAME_S","National energy statistics assessment_SUMMARY","Évaluation des statistiques nationales de l'énergie_RÉSUMÉ","Evaluación de estadísticas energéticas nacionales_RESUMEN","Оценка национальной энергетической статистики_СВОДКА","تقييم الإحصاءات الوطنية للطاقة الملخص"]
[null,null,"REPORT_NAME_L","National energy statistics assessment","Évaluation des statistiques nationales de l'énergie","Evaluación de estadísticas energéticas nacionales","Оценка национальной энергетической статистики","تقييم الإحصاءات الوطنية للطاقة "]
[null,null,"TIMESTAMP","Report created","Rapport créé","Informe creado","Отчет создан","م إنشاء التقرير"]
[null,null,"ERROR_COUNTRY","Country name is not valid. Please remove bad characters and retry!","Le nom du pays n'est pas valide. Veuillez supprimer les caractères incorrects et réessayer !","El nombre del país no es válido. Elimine los caracteres incorrectos y vuelva a intentarlo.","Название страны недопустимо. Удалите недопустимые символы и повторите попытку!","اسم الدولة غير صحيح. يُرجى إزالة الأحرف غير الصحيحة وإعادة المحاولة!"]
[null,null,"ERROR_FILEOPEN","Please close the report before trying to re-create it.","Veuillez fermer le rapport avant de le recréer.","Cierre el informe antes de volver a crearlo.","Закройте отчет перед попыткой его повторного создания.","يرجى إغلاق التقرير قبل محاولة إعادة إنشائه."]
[]
[]
[]
[null,null,"sheet_names"]
[null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,"Sheet01","I_Cover","I_Couverture","I_Portada","I_Крышка","I_الواجهة"]
[null,null,"Sheet02","II_PLAN","II_PLANIFIER","II_PLANIFICACIÓN","II_ПЛАНИРОВАНИЕ","II_الخطة"]
[null,null,"Sheet03","III_SETUP","III_ORGANISER","III_IMPLEMENTACIÓN","III_ОРГАНИЗАЦИЯ","III_الإعداد"]
[null,null,"Sheet04","IV_TRACK","IV_SUIVRE","IV_SEGUIMIENTO","IV_ОТСЛЕЖИВАНИЕ","VI_المسار"]
[null,null,"Sheet05","V_Country_info","V_Informations_sur_le_pays","V_Información_del_país","V_Информация_о_стране","V_معلومات البلد"]
[null,null,"Sheet06","VI_Enablers","VI_Catalyseurs","VI_Facilitadores","VI_факторы","IV_عوامل التمكين"]
[null,null,"Sheet07","VII_Data_availability","VII_Disponibilité_des_données","VII_Disponibilidad_de_datos","VII_Наличие_данных","IIV_توفر البيانات"]
[null,null,"Sheet08","Summary","Summary","Summary","Summary","Summary"]

{"sheet":"I_Cover","index":2,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,2,0,4],[2,4,4,4],[8,1,8,2],[8,4,10,4],[1,7,1,9],[5,1,5,2],[7,1,7,2],[3,1,3,2],[4,1,4,2],[2,1,2,2],[6,1,6,2]]}
[null,null,{"$f":"INDEX(lang_I_COVER,MATCH(H2,INDEX(lang_I_COVER,,1),0),col_language)","v":"Designing an energy statistics roadmap:\nAssessment tool"},null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_I_COVER,MATCH(G3,INDEX(lang_I_COVER,,1),0),col_language)&\": \"&H3","v":"QuestionnaireVersion: 2026_03"},null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,null,null,{"$f":"str_language","v":0},{"$f":"L22","v":"العربية"}]
[null,{"$f":"INDEX(lang_I_COVER,MATCH(G4,INDEX(lang_I_COVER,,1),0),col_language)","v":"Link to the guidebook:"},null,null,{"$f":"H40 &\"  /  \" & I40 &\"  /  \" & J40 &\"  /  \"& K40 & \"  /  \"& L40 &\" :\"","v":"Select language  /  Sélectionnez la langue  /  Seleccionar idioma  /  Выберите язык  /  اختر اللغة :"},null,"VERSION","2026_03"]
[null,{"$f":"INDEX(lang_I_COVER,MATCH(G5,INDEX(lang_I_COVER,,1),0),col_language)","v":"Designing an Energy Statistics Roadmap"},{"$f":"INDEX(lang_I_COVER,MATCH(H5,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,"HEADING_1"]
[null,"Tool description",null,null,null,null,"LINK_TEXT"]
[null,"This tool is designed based on the IEA's ''Designing an energy statistics roadmap: A guide to strengthening national capacities for tracking energy transitions''. It allows the national stakeholders responsible for the development of energy statistics to document and quantify the status of the current capacities to produce energy information.\n\n",{"$f":"INDEX(lang_I_COVER,MATCH(H7,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,"HEADING_2",null,null,"SELECT_LANG"]
[null,"Use:",null,null,{"$f":"INDEX(lang_I_COVER,MATCH(J8,INDEX(lang_I_COVER,,1),0),col_language)","v":"Insert country name:"},null,"INSTRUCTION_1"]
[null,"The user should first carefully read the guide before answering the questionnaire sections. The questionnaire can be used independently, or it can be filled together with external experts (e.g. IEA energy data experts) through computer-assisted phone interview (CAPI). The results can be extracted in a PDF-format using the in-built feature button (printed to the user desktop)",{"$f":"INDEX(lang_I_COVER,MATCH(H9,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,"HEADING_3",null,null,"INSERT_COUNTRY"]
[null,"Filling instructions by sheet",{"$f":"INDEX(lang_I_COVER,MATCH(H10,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,{"$f":"INDEX(lang_I_COVER,MATCH(J10,INDEX(lang_I_COVER,,1),0),col_language)","v":"After providing answers, click the button to generate a report of the results (PDF will appear on the user desktop)"},null,"INSTRUCTION_2"]
[null,{"$f":"INDEX(lang_I_COVER,MATCH(G11,INDEX(lang_I_COVER,,1),0),col_language)","v":"I_Cover"},{"$f":"INDEX(lang_I_COVER,MATCH(H11,INDEX(lang_I_COVER,,1),0),col_language)","v":"This sheet."},null,{"$f":"INDEX(lang_I_COVER,MATCH(J11,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,"HEADING_4",null,null,"REPORT_INSTR"]
[null,"II_PLAN",{"$f":"SUBSTITUTE(INDEX(lang_I_COVER,MATCH(H12,INDEX(lang_I_COVER,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(G58,INDEX(page_numbers,,1),0),col_language))","v":"Covers the Section 'PLAN' of the guidebook (see document, pp. 27-36). Please fill in blue cells."},null,{"$f":"INDEX(lang_I_COVER,MATCH(J12,INDEX(lang_I_COVER,,1),0),col_language)","v":{"$error":"#N/A"}},null,"SHEET_HEADING_1","SHEET_NOTE_1"]
[null,"III_SETUP",{"$f":"SUBSTITUTE(INDEX(lang_I_COVER,MATCH(H13,INDEX(lang_I_COVER,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(G59,INDEX(page_numbers,,1),0),col_language))","v":"Covers the Section 'SETUP' of the guidebook (see document, pp. 37-49). Please fill in blue cells."},null,{"$f":"INDEX(lang_I_COVER,MATCH(J13,INDEX(lang_I_COVER,,1),0),col_language)","v":"Generate report!"},null,"SHEET_HEADING_2","SHEET_NOTE_2"]
[null,"IV_TRACK",{"$f":"SUBSTITUTE(INDEX(lang_I_COVER,MATCH(H14,INDEX(lang_I_COVER,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(G60,INDEX(page_numbers,,1),0),col_language))","v":"Covers the Section 'TRACK' of the guidebook (see document, pp. 50-77). Please fill in blue cells."},null,null,null,"SHEET_HEADING_3","SHEET_NOTE_3",null,"BUTTON_TEXT"]
[null,"V_Country_info",{"$f":"INDEX(lang_I_COVER,MATCH(H15,INDEX(lang_I_COVER,,1),0),col_language)","v":"Collects background information on the national context."},null,null,null,"SHEET_HEADING_4","SHEET_NOTE_4"]
[null,"VI_Enablers",{"$f":"INDEX(lang_I_COVER,MATCH(H16,INDEX(lang_I_COVER,,1),0),col_language)","v":"Contains the user assessment of the key enablers. Please fill in blue cells."},null,{"$f":"INDEX(lang_I_COVER,MATCH(J16,INDEX(lang_I_COVER,,1),0),col_language)","v":"For any enquiries, please write to:"},null,"SHEET_HEADING_5","SHEET_NOTE_5",null,"PRINT_DATE"]
[null,"VII_Data_availability",{"$f":"INDEX(lang_I_COVER,MATCH(H17,INDEX(lang_I_COVER,,1),0),col_language)","v":"Includes an energy data availability assessment. Please fill in the blue cells. Note that this can also be filled independently from the other sections."},null,"DataCapacities@iea.org",null,"SHEET_HEADING_6","SHEET_NOTE_6",null,"EMAIL_NOTE"]
[null,null,null,null,null,null,"SHEET_HEADING_7","SHEET_NOTE_7"]
[]
[]
[]
[null,null,null,null,null,null,"col_language"]
[null,null,null,null,null,null,{"$f":"IFERROR(MATCH(E6,lang_options,0)+1,2)","v":2},"English","Français","Español","Русский","العربية"]
[null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,null,null,null,null,"TITLE","Designing an energy statistics roadmap:\nAssessment tool","Concevoir une feuille de route pour les statistiques énergétiques:\nOutil d’évaluation","Diseño de una hoja de ruta de estadísticas sobre energía:\nHerramienta de evaluación","Разработка дорожной карты в области энергетической статистики:\nИнструмент оценки","تصميم خريطة طريق لإحصاءات الطاقة\nأداة التقييم"]
[null,null,null,null,null,null,"VERSION","QuestionnaireVersion","Version questionnaire","Versión del cuestionario","Версия вопросника","إصدار الاستبيان"]
[null,null,null,null,null,null,"HEADING_1","Link to the guidebook:","Lien vers le guide :","Enlace a la guía:","Ссылка на руководство:",":رابط الدليل"]
[null,null,null,null,null,null,"LINK_TEXT","Designing an Energy Statistics Roadmap","Concevoir une feuille de route pour les statistiques énergétiques","Diseño de una hoja de ruta de estadísticas energéticas","Разработка дорожной карты в области энергетической статистики","تصميم خريطة طريق لإحصاءات الطاقة"]
[null,null,null,null,null,null,"HEADING_2","Tool description","Description de l’outil","Descripción de la herramienta:","Описание инструмента","وصف الأداة"]
[null,null,null,null,null,null,"INSTRUCTION_1","This tool is designed based on the IEA's ''Designing an energy statistics roadmap: A guide to strengthening national capacities for tracking energy transitions''. It allows the national stakeholders responsible for the development of energy statistics to document and quantify the status of the current capacities to produce energy information.\n\n","Cet outil est conçu sur la base du document de l’AIE intitulé « Concevoir une feuille de route pour les statistiques énergétiques : Comment améliorer les capacités de suivi des transitions énergétiques au niveau national ». Il permet aux acteurs nationaux responsables de l’élaboration des statistiques énergétiques de documenter et de quantifier l’état des capacités actuelles de production d’informations sur l’énergie.\n\n","Esta herramienta se basa en el documento «Diseño de una hoja de ruta de estadísticas energéticas: Guía para fortalecer las capacidades nacionales para el seguimiento de las transiciones energéticas» de la AIE. Permite a las partes interesadas a nivel nacional responsables del desarrollo de estadísticas energéticas documentar y cuantificar el estado de las capacidades actuales para elaborar información energética.","Данный инструмент создан на основе пособия МЭА «Разработка дорожной карты в области энергетической статистики. Руководство по укреплению способности стран к отслеживанию энергетического перехода». С его помощью национальные учреждения, ответственные за развитие энергетической статистики, смогут задокументировать и измерить текущий уровень способности к подготовке энергетической информации.\n\n","تم تطوير هذه الأداة استنادًا إلى \"خريطة طريق إحصاءات الطاقة: هو دليل لتعزيز القدرات الوطنية لتتبع التحولات في قطاع الطاقة\" الذي أصدرته وكالة الطاقة الدولية. وتتيح للأطراف المعنية الوطنية المسؤولة عن تطوير إحصاءات الطاقة توثيق وتقييم الوضع الحالي للقدرات المتاحة لإنتاج بيانات الطاقة."]
[null,null,null,null,null,null,"HEADING_3","Use:","Utilisation de l’outil","Uso:","Как использовать:",":الاستخدام"]
[null,null,null,null,null,null,"INSTRUCTION_2","The user should first carefully read the guide before answering the questionnaire sections. The questionnaire can be used independently, or it can be filled together with external experts (e.g. IEA energy data experts) through computer-assisted phone interview (CAPI). The results can be extracted in a PDF-format using the in-built feature button (printed to the user desktop)","Il est important que l’utilisateur lise d’abord attentivement le guide avant de répondre aux différentes sections du questionnaire. Le questionnaire peut être utilisé de façon autonome ou avec l’aide d’experts externes (par exemple des experts en données énergétiques de l’AIE) par le biais d’un entretien téléphonique assisté par ordinateur (CAPI). Les résultats peuvent être extraits au format PDF à l’aide du bouton de fonction intégré (sauvegarde sur le bureau de l’utilisateur)","Lea detenidamente la guía antes de responder las secciones del cuestionario. El cuestionario se puede utilizar de forma independiente o rellenar con ayuda de personal experto externo (por ejemplo, especialistas en datos energéticos de la AIE) mediante una entrevista telefónica asistida por ordenador (CAPI). Los resultados se pueden exportar en formato PDF utilizando el botón integrado (se guarda en el escritorio).","Прежде чем отвечать на вопросы, приведенные в данном инструменте, внимательно прочитайте руководство. На вопросы настоящего инструмента можно отвечать как самостоятельно, так и с помощью внешних экспертов (например, экспертов МЭА по энергетическим данным) путем телефонного интервью с использованием компьютеризованной системы (CAPI). Результаты можно извлечь в формате PDF при помощи встроенной кнопки (печать в файл на компьютере пользователя).","يجب على المستخدم قراءة الدليل بعناية أولاً قبل الإجابة على أقسام الاستبيان. يمكن استخدام الاستبيان بشكل مستقل، أو تعبئته بالتعاون مع خبراء خارجيين (مثل خبراء بيانات الطاقة في وكالة الطاقة الدولية) من خلال المقابلات الهاتفية المدعومة بالحاسوب (CAPI). يمكن استخراج النتائج بتنسيق PDF باستخدام زر الميزة المدمج،  (يتم طباعتها على سطح مكتب المستخدم.)"]
[null,null,null,null,null,null,"HEADING_4","Filling instructions by sheet","Instructions pour chaque onglet","Instrucciones de cumplimentación para cada hoja:","Инструкции по заполнению листов","تعليمات التعبئة حسب الورقة"]
[null,null,null,null,null,null,"SHEET_NOTE_1","This sheet.","Le présent onglet.","Esta hoja.","Этот лист.","الصفحة الحالية"]
[null,null,null,null,null,null,"SHEET_NOTE_2","Covers the Section 'PLAN' of the guidebook (see document, pp. xx-yy). Please fill in blue cells.","Couvre la section « PLANIFIER » du guide (voir rapport p. xx-yy). Veuillez remplir les cellules bleues.","Corresponde a la sección «PLANIFICACIÓN» de la guía (consulte el documento, páginas xx-yy). Rellene las celdas azules.","Охватывает раздел \"ПЛАНИРОВАНИЕ\" руководства (см. стр. xx-yy документа). Заполните ячейки голубого цвета.","يغطي قسم \"الخطة\" من الدليل (انظر المستند، ص xx-yy) يرجى ملء الخانات باللون الأزرق"]
[null,null,null,null,null,null,"SHEET_NOTE_3","Covers the Section 'SETUP' of the guidebook (see document, pp. xx-yy). Please fill in blue cells.","Couvre la section « ORGANISER » du guide (voir rapport p. xx-yy). Veuillez remplir les cellules bleues.","Corresponde a la sección «IMPLEMENTACIÓN» de la guía (consulte el documento, páginas xx-yy). Rellene las celdas azules.","Охватывает раздел \"ОРГАНИЗАЦИЯ\" руководства (см. стр. xx-yy документа). Заполните ячейки голубого цвета.","يغطي القسم \"الإعداد\" من الدليل (انظر المستند، ص xx-yy). يرجى ملء الخانات باللون الأزرق."]
[null,null,null,null,null,null,"SHEET_NOTE_4","Covers the Section 'TRACK' of the guidebook (see document, pp. xx-yy). Please fill in blue cells.","Couvre la section « SUIVRE » du guide (voir rapport p. xx-yy). Veuillez remplir les cellules bleues.","Corresponde a la sección «SEGUIMIENTO» de la guía (consulte el documento, páginas xx-yy). Rellene las celdas azules.","Охватывает раздел \"ОТСЛЕЖИВАНИЕ\" руководства (см. стр. xx-yy документа). Заполните ячейки голубого цвета.","يغطي القسم \"المسار\" من الدليل (انظر المستند، ص xx-yy). يرجى ملء الخانات باللون الأزرق."]
[null,null,null,null,null,null,"SHEET_NOTE_5","Collects background information on the national context.","Pour collecter les informations essentielles sur le contexte national.","Recopila información general del contexto nacional.","Собирает общую информацию о национальном контексте.","جمع المعلومات الأساسية حول السياق الوطني."]
[null,null,null,null,null,null,"SHEET_NOTE_6","Contains the user assessment of the key enablers. Please fill in blue cells.","Contient l’évaluation par l’utilisateur des catalyseurs clés. Veuillez remplir les cellules bleues.","Contiene la evaluación de los facilitadores clave. Rellene las celdas azules.","Содержит оценку пользователем ключевых содействующих факторов. Заполните ячейки голубого цвета.","يحتوي على تقييم المستخدم للممكّنات الرئيسية. يرجى ملء الخانات باللون الازرق."]
[null,null,null,null,null,null,"SHEET_NOTE_7","Includes an energy data availability assessment. Please fill in the blue cells. Note that this can also be filled independently from the other sections.","Comprend une évaluation des données existantes. Veuillez remplir les cellules bleues. Notez que cette section peut également être remplie indépendamment des autres sections.","Incluye la evaluación de la disponibilidad de datos energéticos. Rellene las celdas azules. Tenga en cuenta que se puede rellenar también independientemente de las otras secciones.","Включает оценку доступности энергетических данных. Заполните ячейки голубого цвета. Обратите внимание, что этот лист можно также заполнять независимо от других разделов.","يتضمن تقييمًا لتوافر بيانات الطاقة. يُرجى ملء الخانات باللون الأزرق. لاحظ أنه يمكن أيضًا ملء هذه الخانات بشكل مستقل عن الأقسام الأخرى."]
[null,null,null,null,null,null,"SELECT_LANG","Select language","Sélectionnez la langue","Seleccionar idioma","Выберите язык","اختر اللغة"]
[null,null,null,null,null,null,"EMAIL_NOTE","For any enquiries, please write to:","Pour toute demande, veuillez écrire à :","Para cualquier consulta, contacte a través de:","По любым вопросам просим писать на электронный адрес:","لأي استفسارات اخرى، ارسل بريد الكتروني إلى:"]
[null,null,null,null,null,null,"INSERT_COUNTRY","Insert country name:","Insérer le nom du pays :","Indique el nombre del país:","Вставить название страны:","ادخل اسم البلد:"]
[null,null,null,null,null,null,"REPORT_INSTR","After providing answers, click the button to generate a report of the results (PDF will appear on the user desktop)","Après avoir fourni les réponses, cliquez sur le bouton pour générer un rapport des résultats (le fichier PDF apparaîtra sur le bureau de l’utilisateur)","Después de responder, haga clic en el botón para crear un informe de los resultados (el PDF aparecerá en el escritorio)","После заполнения вопросника кликните эту кнопку, чтобы сгенерировать отчет с результатами\n(PDF-файл будет сохранен на ваш рабочий стол).","بعد تقديم الإجابات، انقر فوق الزر لإنشاء تقرير بالنتائج (سيظهر ملف PDF على سطح مكتب المستخدم)"]
[null,null,null,null,null,null,"BUTTON_TEXT","Generate report!","Générer le rapport","Generar informe","Сгенерировать отчет!","!أنشئ التقرير"]
[null,null,null,null,null,null,"SHEET_HEADING_1","I_Cover","I_Couverture","I_Portada","I_Крышка","I_الواجهة"]
[null,null,null,null,null,null,"SHEET_HEADING_2","II_PLAN","II_PLANIFIER","II_PLANIFICACIÓN","II_ПЛАНИРОВАНИЕ","II_الخطة"]
[null,null,null,null,null,null,"SHEET_HEADING_3","III_SETUP","III_ORGANISER","III_IMPLEMENTACIÓN","III_ОРГАНИЗАЦИЯ","III_الإعداد"]
[null,null,null,null,null,null,"SHEET_HEADING_4","IV_TRACK","IV_SUIVRE","IV_SEGUIMIENTO","IV_ОТСЛЕЖИВАНИЕ","VI_المسار"]
[null,null,null,null,null,null,"SHEET_HEADING_5","V_Country_info","V_Informations_sur_le_pays","V_Información_del_país","V_Информация_о_стране","V_معلومات البلد"]
[null,null,null,null,null,null,"SHEET_HEADING_6","VI_Enablers","VI_Catalyseurs","VI_Facilitadores","VI_факторы","IV_عوامل التمكين"]
[null,null,null,null,null,null,"SHEET_HEADING_7","VII_Data_availability","VII_Disponibilité_des_données","VII_Disponibilidad_de_datos","VII_Наличие_данных","IIV_توفر البيانات"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"page_numbers"]
[null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,null,null,null,null,"II_PLAN","27-36","30-40","30-39","31-42","24-30"]
[null,null,null,null,null,null,"III_SETUP","37-49","41-54","40-54","43-58","31-40"]
[null,null,null,null,null,null,"IV_TRACK","50-77","55-86","55-85","59-92","41-64"]

{"sheet":"II_PLAN","index":3,"n_rows":89,"n_cols":19,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,2,21,2],[26,2,29,2],[54,2,55,2],[66,2,67,2],[3,1,3,2],[8,13,8,14],[77,2,80,2],[3,4,3,6],[85,2,88,2],[57,2,60,2],[7,2,8,2],[15,2,16,2],[23,2,24,2],[41,2,44,2],[49,2,52,2],[69,2,72,2],[74,2,75,2],[82,2,83,2],[38,2,39,2],[46,2,47,2],[10,2,13,2]]}
[null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TITLE\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"(II) Strengthening the national energy data system - PLAN (strategic dimension)"},null,null,null,null,null,null,null,null,null,null,null,"Do not delete text (it is used for a Macro):",null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"}]
[]
[null,{"$f":"SUBSTITUTE(INDEX(lang_II_PLAN,MATCH(\"INSTRUCTION\",INDEX(lang_II_PLAN,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(\"II_PLAN\",INDEX(page_numbers,,1),0),col_language))","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'PLAN', pp. 27-36.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)"},null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."}]
[]
[null,"1.",{"$f":"INDEX(lang_II_PLAN,MATCH(B6,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Data needs and users"},null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,"1.A",{"$f":"INDEX(lang_II_PLAN,MATCH(B8,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Are there relevant or high-visibility energy policies in place that require energy data for policy design and evaluation?"},null,null,null,null,null,"TITLE","(II) Strengthening the national energy data system - PLAN (strategic dimension)","(II) Renforcer le système national de données énergétiques – PLANIFIER (dimension stratégique)","(II) Mejora del sistema nacional de datos energéticos: PLANIFICACIÓN (dimensión estratégica)","(II) Укрепление национальной системы энерг. данных — ПЛАНИРОВАНИЕ (стратегический аспект)","II) تعزيز نظام بيانات الطاقة الوطنية - الخطة (البعد الاستراتيجي)"]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B9,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"INSTRUCTION","Notes:\n● see 'Designing an energy statistics roadmap', Section 'PLAN', pp. xx-yy.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », section « PLANIFIER », p. xx-yy.\n- Les questions des sections sont modifiées pour permettre des réponses de type oui/non. Insérer les réponses dans les cellules bleues (Oui, Non, En partie)","Notas:\n● Consulte la sección «PLANIFICACIÓN» en las páginas xx-yy de la hoja de ruta.\n● Las preguntas de las secciones se han modificado para permitir responder sí/no. Introduzca las respuestas en las celdas azules (Sí, Parcial, No).","Примечания:\n● см. руководство \"Разработка дорожрой карты в области энергетической статистики\", раздел \"ПЛАНИРОВАНИЕ\", стр. xx-yy.\n● вопросы из разделов адаптированы так, чтобы на них можно было ответить \"да\" или \"нет\". Введите свои ответы в ячейки голубого цвета (Да, Нет, Частично);","\"ملاحظات:\n● راجع \"تصميم خريطة طريق لإحصاءات الطاقة\"، القسم \"الخطة\"، ص xx-yy.\n● تم تعديل الأسئلة للسماح بالاجابة بنعم/لا. أدخل الإجابات في الخانات الزرقاء (نعم، لا، جزئياً)\""]
[null,null,null,null,null,null,null,null,"1.","Data needs and users","Besoins en données et utilisateurs des données","Necesidades de datos y usuarios/as","Потребности в данных и пользователи","احتياجات البيانات والمستخدمين"]
[null,null,"Additional information (optional)",null,null,null,null,null,"1.A","Are there relevant or high-visibility energy policies in place that require energy data for policy design and evaluation?","Existe-t-il des politiques pertinentes ou à forte visibilité en matière d’énergie qui nécessitent des données énergétiques pour la conception et l’évaluation des politiques ?","¿Existen políticas energéticas relevantes que requieran datos de energía para su diseño y evaluación?","Существуют ли актуальные или широко освещаемые политики в области энергетики, для разработки или оценки которых требуются энергетические данные?","هل توجد سياسات طاقة واضحة أو ذات صلة تتطلب بيانات الطاقة من أجل تصميم السياسات وتقييمها؟"]
[null,null,null,null,null,null,null,null,"1.B","Is it clear who the data users are?","Qui sont les utilisateurs des données ?","¿Se sabe quiénes utilizarán los datos?","Понятно ли, кто является пользователями данных?","هل الجهات التي تستخدم البيانات محددة وواضحة؟"]
[null,null,null,null,null,null,null,null,"1.C","Are evolving data needs continuously identified and addressed?","Les besoins en matière de données sont-ils identifiés et prend-on en compte leur constante évolution de façon continue ?","¿Se identifican y abordan de forma periódica las necesidades cambiantes de datos?","Осуществляется ли постоянное выявление и отработка потребностей в данных?","هل يتم تحديد احتياجات البيانات المتزايدة ومعالجتها باستمرار؟"]
[null,null,null,null,null,null,null,null,"2.","Strategy development","Élaboration de la stratégie","Desarrollo de la estrategia","Разработка стратегии","تطوير الاستراتيجية"]
[null,null,null,null,null,null,null,null,"2.A","Is there a strategy for producing and developing energy data? ","Existe-t-il une stratégie de production des données énergétiques ? ","¿Existe una estrategia para la generación y el desarrollo de datos energéticos? ","Существует ли стратегия подготовки и развития энергетических данных? ","هل هناك استراتيجية لإنتاج وتطوير بيانات الطاقة؟"]
[null,"1.B",{"$f":"INDEX(lang_II_PLAN,MATCH(B16,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Is it clear who the data users are?"},null,null,null,null,null,"2.B","Does the strategy include identification of data collection priorities?","La stratégie prévoit-elle l’identification des priorités en matière de collecte de données ?","¿Incluye la estrategia la identificación de las prioridades en la recopilación de datos?","Включает ли эта стратегия определение приоритетов в области сбора данных?","هل تتضمن الإستراتيجية تحديد أولويات جمع البيانات؟"]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B17,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"2.C","Is it regularly updated to respond to evolving needs?","Est-elle régulièrement mise à jour pour répondre à l’évolution des besoins ?","¿Se actualiza con regularidad para responder a la evolución de las necesidades?","Регулярно ли она обновляется с целью реагирования на меняющиеся потребности?","هل يتم تحديثه بانتظام للاستجابة للاحتياجات الناشئة؟"]
[null,null,null,null,null,null,null,null,"3.","Funding mechanisms","Mécanismes de financement","Mecanismos de financiación","Механизмы финансирования","آليات التمويل"]
[null,null,"Additional information (optional)",null,null,null,null,null,"3.A","Are core energy statistics funded by the national administration?","Les statistiques énergétiques de base sont-elles financées par l’administration nationale ?","¿Financia la administración nacional las principales estadísticas energéticas?","Финансируется ли основная энергетическая статистика национальной администрацией?","هل يتم تمويل إحصاءات الطاقة الأساسية من قبل الإدارة الوطنية؟"]
[null,null,null,null,null,null,null,null,"3.B","Are there additional funding mechanisms besides conventional ones (i.e. public funds)? ","Existe-t-il d’autres mécanismes de financement que les mécanismes conventionnels (c’est-à-dire les fonds publics) ? ","¿Existen otros mecanismos de financiación además de los convencionales (es decir, fondos públicos)? ","Существуют ли дополнительные механизмы финансирования, помимо традиционных (т. е. государственных средств)? ","هل هناك آليات تمويل إضافية إلى جانب الآليات التقليدية (على سبيل المثال، الأموال العامة)؟"]
[null,null,null,null,null,null,null,null,"3.C","Are the funding mechanisms sufficient and sustainable for routine and additional work?","Les mécanismes de financement sont-ils suffisants et durables pour les travaux courants et supplémentaires ?","¿Los mecanismos de financiación son suficientes y sostenibles para el trabajo rutinario y complementario?","Являются ли механизмы финансирования достаточными и постоянными для выполнения рутинной и дополнительной работы?","هل آليات التمويل كافية ومستدامة للأعمال الروتينية والإضافية؟"]
[null,null,null,null,null,null,null,null,"TEXT_PLACEHOLDER","Additional information (optional)","Informations complémentaires (facultatif)","Información adicional (opcional)","Дополнительная информация (необязательно)","معلومات إضافية (اختياري)"]
[]
[null,"1.C",{"$f":"INDEX(lang_II_PLAN,MATCH(B24,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Are evolving data needs continuously identified and addressed?"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B25,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.",{"$f":"INDEX(lang_II_PLAN,MATCH(B37,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Strategy development"}]
[]
[null,"2.A",{"$f":"INDEX(lang_II_PLAN,MATCH(B39,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Is there a strategy for producing and developing energy data? "}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B40,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"2.B",{"$f":"INDEX(lang_II_PLAN,MATCH(B47,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Does the strategy include identification of data collection priorities?"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B48,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"2.C",{"$f":"INDEX(lang_II_PLAN,MATCH(B55,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Is it regularly updated to respond to evolving needs?"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B56,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[null,"3.",{"$f":"INDEX(lang_II_PLAN,MATCH(B65,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Funding mechanisms"}]
[]
[null,"3.A",{"$f":"INDEX(lang_II_PLAN,MATCH(B67,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Are core energy statistics funded by the national administration?"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B68,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"3.B",{"$f":"INDEX(lang_II_PLAN,MATCH(B75,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Are there additional funding mechanisms besides conventional ones (i.e. public funds)? "}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B76,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"3.C",{"$f":"INDEX(lang_II_PLAN,MATCH(B83,INDEX(lang_II_PLAN,,1),0),col_language)","v":"Are the funding mechanisms sufficient and sustainable for routine and additional work?"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(B84,INDEX(lang_II_PLAN,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]

{"sheet":"III_SETUP","index":4,"n_rows":89,"n_cols":19,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,1,1,6],[8,13,8,14],[3,4,3,6],[26,2,29,2],[41,2,44,2],[3,1,3,2],[23,2,24,2],[7,2,8,2],[15,2,16,2],[10,2,13,2],[18,2,21,2],[69,2,72,2],[77,2,80,2],[85,2,88,2],[74,2,75,2],[82,2,83,2],[66,2,67,2],[38,2,39,2],[46,2,47,2],[54,2,55,2],[57,2,60,2],[49,2,52,2]]}
[null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_III_SETUP,MATCH(\"TITLE\",INDEX(lang_III_SETUP,,1),0),col_language)","v":"(III) Strengthening the national energy data system - SETUP (operational dimension)"},null,null,null,null,null,null,null,null,null,null,null,"Do not delete text (it is used for a Macro):",null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"}]
[]
[null,{"$f":"SUBSTITUTE(INDEX(lang_III_SETUP,MATCH(\"INSTRUCTION\",INDEX(lang_III_SETUP,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(\"III_SETUP\",INDEX(page_numbers,,1),0),col_language))","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'SETUP', pp. 37-49.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)"},null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."}]
[]
[null,"4.",{"$f":"INDEX(lang_III_SETUP,MATCH(B6,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Legal framework"},null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,"4.A",{"$f":"INDEX(lang_III_SETUP,MATCH(B8,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Is there a regulatory framework for energy statistics (e.g. Energy Statistics Act or Law)? (if there is one for general statistics please answer “Partial”)"},null,null,null,null,null,"TITLE","(III) Strengthening the national energy data system - SETUP (operational dimension)","(III) Renforcer le système national de données énergétiques – ORGANISER (dimension opérationnelle)","(III) Mejora del sistema nacional de datos energéticos: IMPLEMENTACIÓN (dimensión operativa)","(III) Укрепление национальной системы энерг. данных — ОРГАНИЗАЦИЯ (операционный аспект)","III) تعزيز نظام بيانات الطاقة الوطني - الإعداد (البعد التشغيلي)"]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B9,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"INSTRUCTION","Notes:\n● see 'Designing an energy statistics roadmap', Section 'SETUP', pp. xx-yy.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », section « ORGANISER », p. xx-yy.\n- Les questions des sections sont modifiées pour permettre des réponses de type oui/non. Insérer les réponses dans les cellules bleues (Oui, Non, En partie)","Notas:\n● Consulte la sección «IMPLEMENTACIÓN» en las páginas xx-yy de la hoja de ruta.\n● Las preguntas de las secciones se han modificado para permitir responder sí/no. Introduzca las respuestas en las celdas azules (Sí, Parcial, No).","Примечания:\n● см. руководство \"Разработка дорожрой карты в области энергетической статистики\", раздел \"ОРГАНИЗАЦИЯ\", стр. xx-yy.\n● вопросы из разделов адаптированы так, чтобы на них можно было ответить \"да\" или \"нет\". Введите свои ответы в ячейки голубого цвета (Да, Нет, Частично)","\"ملاحظات:\n● راجع \"تصميم خريطة طريق لإحصاءات الطاقة\"، القسم \"الإعداد\"، الصفحات xx-yy.\n● تم تعديل الأسئلة للسماح بالإجابة بنعم/لا. أدخل الإجابات في الخانات الزرقاء (نعم، لا، جزئي)\""]
[null,null,null,null,null,null,null,null,"4.","Legal framework","Cadre juridique","Marco jurídico","Правовая база","الإطار القانوني"]
[null,null,"Additional information (optional)",null,null,null,null,null,"4.A","Is there a regulatory framework for energy statistics (e.g. Energy Statistics Act or Law)? (if there is one for general statistics please answer “Partial”)","Existe-t-il un cadre réglementaire pour les statistiques énergétiques (comme une loi sur les statistiques énergétiques) ? (S’il en existe un pour les statistiques au sens large, veuillez répondre « En partie »)","¿Existe un marco normativo para las estadísticas energéticas (por ejemplo, una ley de estadísticas energéticas)? (Si hay uno para las estadísticas en general, responda «Parcial»)","Существует ли нормативная база для энергетической статистики (например, закон или акт об энергетической статистике) (если имеется нормативная база для общей статистики, напишите «Частично»)","هل يوجد إطار تنظيمي لإحصاءات الطاقة (على سبيل المثال قانون أو قانون إحصاءات الطاقة)؟ (إذا كان هناك إطار للإحصاءات العامة، يرجى الإجابة بـ \"جزئي\")"]
[null,null,null,null,null,null,null,null,"4.B","Does it require respondents to provide data (i.e. mandatory nature)?","Exige-t-il des sondés qu’ils fournissent des données (caractère obligatoire) ?","¿Requiere que quienes responden las encuestas proporcionen datos (es decir, tiene carácter obligatorio)?","Требует ли она предоставления данных от респондентов (т. е. носит ли обязательный характер)?","هل يُطلب من المستجيبين تقديم البيانات (أي الطبيعة الإلزامية)؟"]
[null,null,null,null,null,null,null,null,"4.C","Is it functioning and appropriate for your work? Is it enforced?","Est-il fonctionnel et adapté à votre travail ? Est-il appliqué ?","¿Funciona y es adecuado para el trabajo? ¿Se asegura su cumplimiento?","Работает ли она и соответствует ли требованиям вашей работы? Обеспечивается ли ее соблюдение?","هل هو فعال ومناسب لعملك؟ هل يتم تنفيذه؟"]
[null,null,null,null,null,null,null,null,"5.","Institutional arrangements","Accords institutionnels","Acuerdos institucionales","Институциональные механизмы","الترتيبات المؤسسية"]
[null,null,null,null,null,null,null,null,"5.A","Is there an entity responsible for coordinating the national energy information system?","Existe-t-il une entité chargée de coordonner le système national d’information sur l’énergie ?","¿Existe una entidad responsable de coordinar el sistema nacional de información energética?","Существует ли учреждение, ответственное за координацию национальной энергетической информационной системы?","هل هناك جهة مسؤولة عن تنسيق نظام معلومات الطاقة الوطني؟"]
[null,"4.B",{"$f":"INDEX(lang_III_SETUP,MATCH(B16,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Does it require respondents to provide data (i.e. mandatory nature)?"},null,null,null,null,null,"5.B","Is the division of work clear to avoid both gaps and overlaps in data collection?","La répartition des tâches est-elle claire afin d’éviter les lacunes et les redondances dans la collecte des données ?","¿La distribución de tareas es lo suficientemente clara para evitar tanto las carencias como los solapamientos en la recopilación de datos?","Достаточно ли четко распределена работа, чтобы избежать пробелов и дублирования в сборе данных?","هل تقسيم العمل واضح لتجنب الفجوات والتداخلات في جمع البيانات؟"]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B17,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"5.C","Are there any mechanisms to foster institutional collaboration and data sharing at the national level (e.g. Memoranda of Understanding [MoUs], agreements, working groups)?","Existe-t-il des mécanismes pour favoriser la collaboration institutionnelle et le partage des données au niveau national (par exemple des protocoles d’accord, des accords, des groupes de travail) ?","¿Se han establecido mecanismos para fomentar la colaboración institucional y el intercambio de datos a nivel nacional (por ejemplo, memorandos de entendimiento, convenios o grupos de trabajo)?","Существуют ли механизмы, способствующие институциональному сотрудничеству и обмену данными на национальном уровне (например, меморандумы о взаимопонимании, соглашения, рабочие группы)?","هل هناك أي آليات لتعزيز التعاون المؤسسي وتبادل البيانات على المستوى الوطني (على سبيل المثال مذكرات التفاهم والاتفاقيات ومجموعات العمل)؟"]
[null,null,null,null,null,null,null,null,"6.","Human, technical, and financial resources","Ressources humaines, techniques et financières","Recursos humanos, técnicos y financieros","Человеческие, технические и финансовые ресурсы","الموارد البشرية والفنية والمالية"]
[null,null,"Additional information (optional)",null,null,null,null,null,"6.A","Are the available technical and financial resources adequate and visible in the long-term?","Les ressources techniques et financières disponibles sont-elles suffisantes et a-t-on de la visibilité à long terme ?","¿Los recursos técnicos y financieros disponibles son adecuados y tangibles a largo plazo?","Являются ли имеющиеся технические и финансовые ресурсы достаточными и видимыми в долгосрочной перспективе?","هل الموارد الفنية والمالية المتاحة كافية وواضحة على المدى البعيد؟"]
[null,null,null,null,null,null,null,null,"6.B","Are the available resources (human, technical and financial) relatively stable over time, without major annual fluctuations?","Les ressources disponibles (humaines, techniques et financières) sont-elles relativement stables dans le temps, sans fluctuations annuelles majeures ?","¿Sufren los recursos disponibles (humanos, técnicos y financieros) grandes fluctuaciones anuales o son relativamente estables a lo largo del tiempo?","Являются ли имеющиеся ресурсы (человеческие, технические и финансовые) относительно стабильными с течением времени, без значительных ежегодных колебаний?","هل الموارد المتاحة (البشرية، الفنية، والمالية) مستقرة نسبيًا بمرور الوقت، دون حدوث تقلبات كبيرة من عام لآخر؟\n\n"]
[null,null,null,null,null,null,null,null,"6.C","Is there sufficient staff capacity? Is there continuous training of staff?","Les capacités en matière de personnel sont-elles suffisantes ? Le personnel bénéficie-t-il d’une formation continue ?","¿Existe suficiente capacidad de personal? ¿Recibe formación continua el personal?","Существует ли достаточный кадровый потенциал? Проводится ли постоянное обучение персонала?","هل يتوفر عدد كافٍ من الموظفين؟ وهل يتم توفير تدريب مستمر لهم؟"]
[null,null,null,null,null,null,null,null,"TEXT_PLACEHOLDER","Additional information (optional)","Informations complémentaires (facultatif)","Información adicional (opcional)","Дополнительная информация (необязательно)","معلومات إضافية (اختياري)"]
[]
[null,"4.C",{"$f":"INDEX(lang_III_SETUP,MATCH(B24,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Is it functioning and appropriate for your work? Is it enforced?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B25,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.",{"$f":"INDEX(lang_III_SETUP,MATCH(B37,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Institutional arrangements"}]
[]
[null,"5.A",{"$f":"INDEX(lang_III_SETUP,MATCH(B39,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Is there an entity responsible for coordinating the national energy information system?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B40,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"5.B",{"$f":"INDEX(lang_III_SETUP,MATCH(B47,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Is the division of work clear to avoid both gaps and overlaps in data collection?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B48,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"5.C",{"$f":"INDEX(lang_III_SETUP,MATCH(B55,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Are there any mechanisms to foster institutional collaboration and data sharing at the national level (e.g. Memoranda of Understanding [MoUs], agreements, working groups)?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B56,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[null,"6.",{"$f":"INDEX(lang_III_SETUP,MATCH(B65,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Human, technical, and financial resources"}]
[]
[null,"6.A",{"$f":"INDEX(lang_III_SETUP,MATCH(B67,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Are the available technical and financial resources adequate and visible in the long-term?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B68,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"6.B",{"$f":"INDEX(lang_III_SETUP,MATCH(B75,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Are the available resources (human, technical and financial) relatively stable over time, without major annual fluctuations?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B76,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"6.C",{"$f":"INDEX(lang_III_SETUP,MATCH(B83,INDEX(lang_III_SETUP,,1),0),col_language)","v":"Is there sufficient staff capacity? Is there continuous training of staff?"}]
[null,null,{"$f":"INDEX(lang_III_SETUP,MATCH(B84,INDEX(lang_III_SETUP,,1),0),col_language)","v":{"$error":"#N/A"}}]
[]
[null,null,"Additional information (optional)"]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]

{"sheet":"IV_TRACK","index":5,"n_rows":118,"n_cols":19,"rows_kept":118,"cut":false,"hidden":false,"merged":[[1,1,1,6],[8,13,8,14],[3,4,3,6],[56,2,57,2],[64,2,65,2],[7,2,8,2],[15,2,16,2],[23,2,24,2],[10,2,13,2],[18,2,21,2],[34,2,37,2],[49,2,52,2],[3,1,3,2],[26,2,27,2],[39,2,40,2],[93,2,96,2],[114,2,117,2],[59,2,62,2],[67,2,70,2],[75,2,78,2],[85,2,88,2],[82,2,83,2],[90,2,91,2],[98,2,99,2],[72,2,73,2]]}
[null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"TITLE\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(IV) Strengthening the national energy data system - TRACK (data processes)"},null,null,null,null,null,null,null,null,null,null,null,"Do not delete text (it is used for a Macro):",null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"}]
[]
[null,{"$f":"SUBSTITUTE(INDEX(lang_IV_TRACK,MATCH(\"INSTRUCTION\",INDEX(lang_IV_TRACK,,1),0),col_language),\"xx-yy\",INDEX(page_numbers,MATCH(\"IV_TRACK\",INDEX(page_numbers,,1),0),col_language))","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'TRACK', pp. 50-77.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)"},null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."}]
[]
[null,"7.",{"$f":"INDEX(lang_IV_TRACK,MATCH(B6,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Data collection, methodologies and quality verification"},null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,"7.A",{"$f":"INDEX(lang_IV_TRACK,MATCH(B8,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are there sound data collection methods in place (e.g. use of administrative sources, fuel and sectoral surveys)? "},null,null,null,null,null,"TITLE","(IV) Strengthening the national energy data system - TRACK (data processes)","(IV) Renforcer le système national de données énergétiques – SUIVRE (traitement des données)","(IV) Mejora del sistema nacional de datos energéticos: SEGUIMIENTO (procesamiento de datos)","(IV) Укрепление нац. системы энерг. данных — ОТСЛЕЖИВАНИЕ (процессы работы с данными)","VI) تعزيز نظام بيانات الطاقة الوطنية - المسار (عمليات البيانات)"]
[null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(B9,INDEX(lang_IV_TRACK,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"INSTRUCTION","Notes:\n● see 'Designing an energy statistics roadmap', Section 'TRACK', pp. xx-yy.\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », section « SUIVRE », p. xx-yy.\n- Les questions des sections sont modifiées pour permettre des réponses de type oui/non. Insérer les réponses dans les cellules bleues (Oui, Non, En partie)","Notas:\n● Consulte la sección «SEGUIMIENTO» en las páginas xx-yy de la hoja de ruta.\n● Las preguntas de las secciones se han modificado para permitir responder sí/no. Introduzca las respuestas en las celdas azules (Sí, Parcial, No).","Примечания:\n● см. руководство \"Разработка дорожрой карты в области энергетической статистики\", раздел \"ОТСЛЕЖИВАНИЕ\", стр. xx-yy.\n● вопросы из разделов адаптированы так, чтобы на них можно было ответить \"да\" или \"нет\". Введите свои ответы в ячейки голубого цвета (Да, Нет, Частично)","\"ملاحظات:\n● انظر \"تصميم خريطة طريق لإحصاءات الطاقة\"، القسم \"المسار\"، ص xx-yy.\n● تم تعديل الأسئلة للسماح بالإجابة بنعم/لا. أدخل الإجابات في الخانات الزرقاء (نعم، لا، جزئي)\""]
[null,null,null,null,null,null,null,null,"7.","Data collection, methodologies and quality verification","Collecte des données, méthodes et vérification de la qualité","Recopilación de datos, metodologías y verificación de la calidad","Сбор данных, методологии и верификация качества","جمع البيانات والمنهجيات والتحقق من الجودة"]
[null,null,"Additional information (optional)",null,null,null,null,null,"7.A","Are there sound data collection methods in place (e.g. use of administrative sources, fuel and sectoral surveys)? ","Existe-t-il de bonnes méthodes de collecte des données (par exemple l’utilisation de sources administratives, les enquêtes sur les combustibles et les enquêtes sectorielles) ? ","¿Se cuenta con métodos adecuados de recopilación de datos (por ejemplo, uso de fuentes administrativas y encuestas sectoriales y sobre combustible)? ","Налажены ли надежные методы сбора данных (например, использование административных источников, топливных и секторальных обследований)? ","هل توجد أساليب موثوقة لجمع البيانات، مثل الاستفادة من المصادر الإدارية أو إجراء مسوحات للوقود والقطاعات المختلفة؟"]
[null,null,null,null,null,null,null,null,"7.B","Does the data collection follow documented methodologies and standards? ","La collecte des données se fait-elle selon des méthodologies et des normes documentées ? ","¿La recopilación de datos sigue metodologías y estándares documentados? ","Собираются ли данные в соответствии с задокументированными методологиями и стандартами? ","هل يتم جمع البيانات بناءً على منهجيات ومعايير موثقة؟"]
[null,null,null,null,null,null,null,null,"7.C","Are there sufficient processes in place to control data quality?","Existe-t-il des processus suffisants pour contrôler la qualité des données ?","¿Existen procesos eficaces para controlar la calidad de los datos?","Налажены ли соответствующие процессы для контроля качества данных?","هل توجد عمليات كافية لضمان جودة البيانات؟"]
[null,null,null,null,null,null,null,null,"7.D","Are the following references applied in the national context? (refer to table on page 58)","Les références suivantes sont-elles appliquées dans le contexte national ? (voir tableau p. 64-65)","¿Se aplican las siguientes referencias al contexto nacional? (Consulte la tabla de la página 63-64)","Применяются ли следующие справочные документы в национальном контексте (см. таблицу на странице 69-70)","هل يتم تطبيق المراجع التالية في السياق الوطني؟ (راجع الجدول في الصفحة 47-48)"]
[null,null,null,null,null,null,null,null,"IRES","● International Recommendations for Energy Statistics (IRES) [United Nations, 2011]","● Recommandations internationales pour les statistiques énergétiques (RISE) [ONU 2011]","● Recomendaciones Internacionales para las Estadísticas de Energía (IRES) [Naciones Unidas, 2011]","● Международные рекомендации по энергетической статистике (МРЭС), [ООН 2011]","● التوصيات الدولية لإحصاءات الطاقة (IRES) [الأمم المتحدة، 2011]"]
[null,"7.B",{"$f":"INDEX(lang_IV_TRACK,MATCH(B16,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Does the data collection follow documented methodologies and standards? "},null,null,null,null,null,"SIEC","● Standard International Energy Product Classification (SIEC) [part of IRES)]","● Classification internationale type des produits énergétiques (SIEC) [fait partie des RISE]","● Clasificación Internacional Uniforme de Productos Energéticos (SIEC) [parte de las IRES]","● Стандартная международная классификация энергетических продуктов (СМКЭП), [часть МРЭС]","● التصنيف الدولي القياسي لمنتجات الطاقة (SIEC) [جزء من IRES)]"]
[null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(B17,INDEX(lang_IV_TRACK,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"ISIC","● The International Standard Industrial Classification of All Economic Activities (ISIC)","● Classification internationale type, par industrie, de toutes les branches d’activité économique (CITI)","● Clasificación Industrial Internacional Uniforme de todas las actividades económicas (CIIU)","● Международная стандартная отраслевая классификация всех видов экономической деятельности (МСОК)","● التصنيف الصناعي الدولي الموحد لجميع الأنشطة الاقتصادية (ISIC)"]
[null,null,null,null,null,null,null,null,"ESCM","● Energy Statistics Compiler’s Manual (ESCM)","● Manuel de compilation des statistiques de l’énergie (Energy Statistics Compiler’s Manual, ESCM)","● Manual de Compiladores de Estadísticas Energéticas (ESCM)","● Руководство для составителей статистики энергетики (РССЭ)","● دليل تجميع إحصاءات الطاقة (ESCM)"]
[null,null,"Additional information (optional)",null,null,null,null,null,"IPCC","● 2006 IPCC Guidelines for National Greenhouse Gas Inventories Volume 2: Energy","● Lignes directrices 2006 du GIEC pour les inventaires nationaux de gaz à effet de serre, Volume 2 : Énergie","● Directrices del IPCC de 2006 para los inventarios nacionales de gases de efecto invernadero, volumen 2: Energía","● Руководящие принципы для национальных кадастров парниковых газов 2006 года, том 2: Энергетика","● المبادئ التوجيهية الصادرة عن الهيئة الحكومية الدولية المعنية بتغير المناخ لعام 2006 بشأن جرد الغازات المسببة للاحتباس الحراري، المجلد 2: الطاقة"]
[null,null,null,null,null,null,null,null,"LINK","(link)","(lien)","(enlace)","(ссылка)","(رابط)"]
[null,null,null,null,null,null,null,null,"7.E","Does the current data collection fully capture the following? (refer to table on pp. 61-63)","La collecte de données actuelle permet-elle d’appréhender pleinement les éléments suivants ? (voir tableau p. 68-70)","¿La recopilación de datos actual refleja plenamente lo siguiente? (Consulte la tabla de las páginas 66-69)","В полной ли мере в нынешнем сборе данных отражены следующие аспекты? (см. таблицу на стр. 72–75)","هل تغطي عملية جمع البيانات الحالية جميع العناصر المذكورة؟ (يرجى الرجوع إلى الجدول في الصفحات 50-52)"]
[null,null,null,null,null,null,null,null,"INDPROD","● Energy production","● Production d’énergie","● Producción de energía","● Производство энергии","● إنتاج الطاقة"]
[null,null,null,null,null,null,null,null,"TOTTRANF","● Energy transformation processes in iron and steel making","● Procédés de transformation de l’énergie dans l’élaboration du fer et de l’acier","● Procesos de transformación energética en la industria siderúrgica","● Процессы преобразования энергии при производстве чугуна и стали","● عمليات تحويل الطاقة في صناعة الحديد والصلب"]
[null,"7.C",{"$f":"INDEX(lang_IV_TRACK,MATCH(B24,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are there sufficient processes in place to control data quality?"},null,null,null,null,null,"AUTOELEC_I","● Electricity produced by autoproducers - industry","● Électricité produite par les autoproducteurs – Industrie","● Electricidad generada por autoproductores: industrial","● Электроэнергия, произведенная для собственных нужд — промышленность","● الكهرباء المنتجة بواسطة شركات صناعة السيارات - الصناعة"]
[null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(B25,INDEX(lang_IV_TRACK,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"AUTOELEC_R","● Electricity produced by autoproducers - residential","● Électricité produite par les autoproducteurs – Résidentiel","● Electricidad generada por autoproductores: residencial","● Электроэнергия, произведенная для собственных нужд — жилищный сектор","● الكهرباء المنتجة بواسطة شركات إنتاج السيارات - السكنية"]
[null,null,null,null,null,null,null,null,"COVERAGE","● Geographical coverage","● Couverture géographique","● Ámbito geográfico","● Географический охват","● التغطية الجغرافية"]
[null,"7.D",{"$f":"INDEX(lang_IV_TRACK,MATCH(B27,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are the following references applied in the national context? (refer to table on page 58)"},null,null,null,null,null,"RESIDENTIAL","● Non-commercial energy demand","● Demande d’énergie non commerciale","● Demanda de energía no comercial","● Спрос на энергопродукты для некоммерческого использования","● الطلب على الطاقة غير التجارية"]
[null,null,{"$error":"#N/A"},null,null,null,null,null,"F_TOURISM","● Fuel tourism","● Tourisme à la pompe","● Turismo de combustible","● Топливный туризм","● السياحة الوقود"]
[null,"IRES",{"$f":"INDEX(lang_IV_TRACK,MATCH(B29,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● International Recommendations for Energy Statistics (IRES) [United Nations, 2011]"},null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"LINK\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(link)"},null,null,"8.","Data management and innovation","Gestion des données et innovation","Gestión de datos e innovación","Управление данными и инновации","إدارة البيانات والابتكار"]
[null,"SIEC",{"$f":"INDEX(lang_IV_TRACK,MATCH(B30,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● Standard International Energy Product Classification (SIEC) [part of IRES)]"},null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"LINK\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(link)"},null,null,"8.A","Is the current data management framework adequate?","Le cadre actuel de gestion des données est-il adéquat ?","¿Es adecuado el marco actual de gestión de datos?","Является ли текущая система управления данными адекватной?","هل إطار إدارة البيانات الحالي ملائم؟"]
[null,"ISIC",{"$f":"INDEX(lang_IV_TRACK,MATCH(B31,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● The International Standard Industrial Classification of All Economic Activities (ISIC)"},null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"LINK\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(link)"},null,null,"8.B","Is there room for further digitisation of data collection, management and dissemination?","Est-il possible d’informatiser davantage la collecte, la gestion et la diffusion des données ?","¿Se puede aumentar la digitalización en los procesos de recopilación, gestión y difusión de datos?","Есть ли возможности для дальнейшей цифровизации процессов сбора, управления и распространения данных?","هل توجد فرصة لتعزيز رقمنة عمليات جمع البيانات وإدارتها ونشرها؟"]
[null,"ESCM",{"$f":"INDEX(lang_IV_TRACK,MATCH(B32,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● Energy Statistics Compiler’s Manual (ESCM)"},null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"LINK\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(link)"},null,null,"8.C","Is there any plan or pilot programme for innovative methods or approaches in the national energy information system?","Existe-t-il un plan ou un programme pilote pour des méthodes ou des approches innovantes dans le système national d’information sur l’énergie ?","¿Existe algún plan o programa piloto para implantar métodos o enfoques innovadores en el sistema nacional de información energética?","Существует ли какой-либо план или пилотная программа по внедрению инновационных методов или подходов в национальную энергетическую информационную систему?","هل توجد خطة أو برنامج تجريبي لتجربة أساليب أو مناهج مبتكرة في نظام معلومات الطاقة الوطني؟"]
[null,"IPCC",{"$f":"INDEX(lang_IV_TRACK,MATCH(B33,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● 2006 IPCC Guidelines for National Greenhouse Gas Inventories Volume 2: Energy"},null,null,{"$f":"INDEX(lang_IV_TRACK,MATCH(\"LINK\",INDEX(lang_IV_TRACK,,1),0),col_language)","v":"(link)"},null,null,"9.","Data access and dissemination","Accès aux données et diffusion des données","Acceso a los datos y su difusión","Доступ к данным и их распространение","الوصول إلى البيانات ونشرها"]
[null,null,null,null,null,null,null,null,"9.A","Are energy statistics easily findable and accessible? ","Les statistiques énergétiques sont-elles facilement trouvables et accessibles ? ","¿Son las estadísticas energéticas fácilmente localizables y accesibles? ","Легко ли найти энергетическую статистику и получить к ней доступ? ","هل يمكن العثور على إحصائيات الطاقة والوصول إليها بسهولة؟"]
[null,null,"Additional information (optional)",null,null,null,null,null,"9.B","Are the final data products relevant to the users?","Les produits finaux en termes de données sont-ils pertinents pour les utilisateurs ?","¿Los productos finales de datos son relevantes para quienes los van a utilizar?","Являются ли конечные информационные данные актуальными для пользователей?","هل المنتجات النهائية للبيانات تتناسب مع احتياجات المستخدمين؟"]
[null,null,null,null,null,null,null,null,"9.C","Are the data transparent? Is there metadata available?","Les données sont-elles transparentes ? Des métadonnées sont-elles disponibles ?","¿Son transparentes los datos? ¿Hay metadatos disponibles?","Являются ли данные прозрачными? Имеются ли метаданные?","هل البيانات شفافة؟ وهل تتوفر البيانات الوصفية؟"]
[null,null,null,null,null,null,null,null,"INSTRUC_1","Consider yourself to be a generic data user. Follow the steps and record the results.","Vous êtes un utilisateur de données génériques. Suivez les étapes et notez les résultats.","Considere que es un usuario general de datos. Siga los pasos y registre los resultados.","Представьте, что вы — типичный пользователь данных. Выполните приведенные ниже шаги и запишите свои выводы.","تخيل أنك مستخدم عام للبيانات. قم باتباع الخطوات ووثق النتائج."]
[null,null,null,null,null,null,null,null,"INSTRUC_2","1) Find the organisation website through a search engine","1) Trouver le site web de l’organisation à l’aide d’un moteur de recherche","1) Encontrar la web de la organización a través de un buscador","1) Найдите сайт организации через поисковую систему","1) ابحث عن موقع المنظمة عبر محرك بحث"]
[null,null,null,null,null,null,null,null,"INSTRUC_3","Does the website show up among the first results?","Le site web apparaît-il parmi les premiers résultats ?","¿Aparece la web entre los primeros resultados?","Выдается ли сайт в числе первых результатов на странице поиска?","هل يظهر الموقع ضمن النتائج البحث الأولى؟"]
[null,"7.E",{"$f":"INDEX(lang_IV_TRACK,MATCH(B40,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Does the current data collection fully capture the following? (refer to table on pp. 61-63)"},null,null,null,null,null,"INSTRUC_4","2) Navigate to the data section of the website","2) Naviguer vers la section du site web où se trouvent les données","2) Navegar hasta la sección de datos de la web","2) Перейдите к разделу с данными на сайте","2) انتقل إلى قسم البيانات بالموقع"]
[null,null,null,null,null,null,null,null,"INSTRUC_5","Is there an explicit data section on the website?","Le site web comporte-t-il une section explicitement consacrée aux données ?","¿Existe una sección de datos específica?","Есть ли на сайте явный раздел данных?","هل يوجد قسم بيانات صريح على الموقع؟"]
[null,"INDPROD",{"$f":"INDEX(lang_IV_TRACK,MATCH(B42,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"● Energy production"},null,null,null,null,null,"INSTRUC_6","How many clicks does it take to reach the section (indicate the number)?","Combien de clics faut-il pour l’atteindre (saisissez le chiffre) ?","¿Cuántos clics se necesitan para llegar a esta sección (indique el número)?","Сколько кликов требуется, чтобы попасть в этот раздел?","كم عدد النقرات اللازمة للوصول إلى القسم (اكتب إلى الرقم)؟"]
[null,"TOTTRANF","● Energy transformation processes in iron and steel making",null,null,null,null,null,"INSTRUC_7","3) Navigate to energy statistics","3) Naviguer vers les statistiques énergétiques","3) Navegar hasta las estadísticas energéticas","3) Перейдите к энергетической статистике","3) انتقل إلى إحصائيات الطاقة"]
[null,"AUTOELEC_I","● Electricity produced by autoproducers - industry",null,null,null,null,null,"INSTRUC_8","Is ‘energy’ a separate category?","Y a-t-il une catégorie distincte sur l’énergie ?","¿Es «energía» una categoría independiente?","Является ли «энергетика» отдельной категорией?","هل تعد \"الطاقة\" فئة منفصلة في الموقع؟"]
[null,"AUTOELEC_R","● Electricity produced by autoproducers - residential",null,null,null,null,null,"INSTRUC_9","How many clicks does it take to reach the section (indicate the number)?","Combien de clics faut-il pour l’atteindre (saisissez le chiffre) ?","¿Cuántos clics se necesitan para llegar a esta sección (indique el número)?","Сколько кликов требуется, чтобы попасть в этот раздел?","كم عدد النقرات اللازمة للوصول إلى القسم (اكتب إلى الرقم)؟"]
[null,"COVERAGE","● Geographical coverage",null,null,null,null,null,"INSTRUC_10","4) Extract the desired information","4) Extraire les informations souhaitées","4) Exportar la información deseada","4) Извлеките нужную информацию","4) استخرج المعلومات المطلوبة"]
[null,"RESIDENTIAL","● Non-commercial energy demand",null,null,null,null,null,"INSTRUC_11","Is the information available for download?","Les informations peuvent-elles être téléchargées ?","¿Se puede descargar la información?","Доступна ли информация для скачивания?","هل المعلومات متاحة للتحميل؟"]
[null,"F_TOURISM","● Fuel tourism",null,null,null,null,null,"INSTRUC_12","Is the information available in user-friendly formats (spreadsheets, database)? ","Les informations sont-elles disponibles dans des formats faciles à utiliser (feuilles de calcul, base de données) ? ","¿La información está disponible en formatos fácilmente manejables (hojas de cálculo o base de datos)? ","Доступна ли информация в удобных для пользователя форматах (электронные таблицы, базы данных)? ","هل المعلومات متاحة بتنسيقات سهلة الاستخدام (جداول بيانات، قواعد بيانات)؟"]
[null,null,null,null,null,null,null,null,"TEXT_PLACEHOLDER","Additional information (optional)","Informations complémentaires (facultatif)","Información adicional (opcional)","Дополнительная информация (необязательно)","معلومات إضافية (اختياري)"]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.",{"$f":"INDEX(lang_IV_TRACK,MATCH(B55,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Data management and innovation"}]
[]
[null,"8.A",{"$f":"INDEX(lang_IV_TRACK,MATCH(B57,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Is the current data management framework adequate?"}]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.B",{"$f":"INDEX(lang_IV_TRACK,MATCH(B65,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Is there room for further digitisation of data collection, management and dissemination?"}]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.C",{"$f":"INDEX(lang_IV_TRACK,MATCH(B73,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Is there any plan or pilot programme for innovative methods or approaches in the national energy information system?"}]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"9.",{"$f":"INDEX(lang_IV_TRACK,MATCH(B81,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Data access and dissemination"}]
[]
[null,"9.A",{"$f":"INDEX(lang_IV_TRACK,MATCH(B83,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are energy statistics easily findable and accessible? "}]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"9.B",{"$f":"INDEX(lang_IV_TRACK,MATCH(B91,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are the final data products relevant to the users?"}]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"9.C",{"$f":"INDEX(lang_IV_TRACK,MATCH(B99,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Are the data transparent? Is there metadata available?"}]
[]
[]
[null,"INSTRUC_1",{"$f":"INDEX(lang_IV_TRACK,MATCH(B102,INDEX(lang_IV_TRACK,,1),0),col_language)","v":"Consider yourself to be a generic data user. Follow the steps and record the results."}]
[null,"INSTRUC_2","1) Find the organisation website through a search engine"]
[null,"INSTRUC_3","Does the website show up among the first results?"]
[null,"INSTRUC_4","2) Navigate to the data section of the website"]
[null,"INSTRUC_5","Is there an explicit data section on the website?"]
[null,"INSTRUC_6","How many clicks does it take to reach the section (indicate the number)?"]
[null,"INSTRUC_7","3) Navigate to energy statistics"]
[null,"INSTRUC_8","Is ‘energy’ a separate category?"]
[null,"INSTRUC_9","How many clicks does it take to reach the section (indicate the number)?"]
[null,"INSTRUC_10","4) Extract the desired information"]
[null,"INSTRUC_11","Is the information available for download?"]
[null,"INSTRUC_12","Is the information available in user-friendly formats (spreadsheets, database)? "]
[]
[null,null,"Additional information (optional)"]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]
[null,null,{"$f":"INDEX(lang_II_PLAN,MATCH(\"TEXT_PLACEHOLDER\",INDEX(lang_II_PLAN,,1),0),col_language)","v":"Additional information (optional)"}]

{"sheet":"V_Country_info","index":6,"n_rows":25,"n_cols":19,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,13,18,14],[3,4,3,6],[3,1,3,2],[13,2,13,4],[5,2,5,4],[7,2,7,4],[9,2,9,4],[11,2,11,4]]}
[null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_V_Cinfo,MATCH(\"TITLE\",INDEX(lang_V_Cinfo,,1),0),col_language)","v":"(V) Strengthening national statistics capacity to track energy transitions: Country info"},null,null,null,null,null,null,null,null,null,null,null,"Do not delete text (it is used for a Macro):",null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"}]
[]
[null,{"$f":"INDEX(lang_V_Cinfo,MATCH(\"INSTRUCTION\",INDEX(lang_V_Cinfo,,1),0),col_language)","v":"Notes:\n● see 'Designing an energy statistics roadmap', Annex \n● information in this section is collected to better understand the national context"},null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."}]
[]
["DET_1",{"$f":"INDEX(lang_V_Cinfo,MATCH(A6,INDEX(lang_V_Cinfo,,1),0),col_language)","v":"National institution(s) involved: "},"Additional information (optional)"]
[]
["DET_2",{"$f":"INDEX(lang_V_Cinfo,MATCH(A8,INDEX(lang_V_Cinfo,,1),0),col_language)","v":"Key enablers: "},"Additional information (optional)"]
[]
["DET_3",{"$f":"INDEX(lang_V_Cinfo,MATCH(A10,INDEX(lang_V_Cinfo,,1),0),col_language)","v":"Success story: "},"Additional information (optional)"]
[]
["DET_4",{"$f":"INDEX(lang_V_Cinfo,MATCH(A12,INDEX(lang_V_Cinfo,,1),0),col_language)","v":"Main challenges: "},"Additional information (optional)"]
[]
["DET_5",{"$f":"INDEX(lang_V_Cinfo,MATCH(A14,INDEX(lang_V_Cinfo,,1),0),col_language)","v":"Lesson learned: "},"Additional information (optional)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,null,null,null,null,null,null,"TITLE","(V) Strengthening national statistics capacity to track energy transitions: Country info","(V) Améliorer les capacités de suivi des transitions énergétiques au niveau national : Informations nationales","(V) Mejora de la capacidad estadística nacional para el seguimiento de las transiciones energéticas: Información nacional","(V) Укрепление способности к отслеживанию энерг. переходов в нац. статистике: Информ. о стране","V) تعزيز القدرة الإحصائية الوطنية لتتبع التحولات في مجال الطاقة: معلومات عن الدولة"]
[null,null,null,null,null,null,null,null,"INSTRUCTION","Notes:\n● see 'Designing an energy statistics roadmap', Annex \n● information in this section is collected to better understand the national context","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », Annexe\n- Les informations de cette section sont collectées pour mieux comprendre le contexte national","Notas:\n● Consulte el anexo de la hoja de ruta.\n● La información de esta sección se ha recopilado para entender mejor el contexto nacional.","Примечания:\n● см. приложение к руководству \"Разработка дорожной карты в области энергетической статистики \n● Информация в этом разделе собирается для лучшего понимания контекста страны","\"ملاحظات:\n● انظر \"تصميم خريطة طريق لإحصاءات الطاقة\"، الملحق\n● يتم جمع المعلومات في هذا القسم لفهم السياق الوطني بشكل أفضل\""]
[null,null,null,null,null,null,null,null,"DET_1","National institution(s) involved: ","Institutions nationales concernées : ","Institución/es nacional/es implicada/s: ","Задействованные нац. учреждения: ","المؤسسة (المؤسسات) الوطنية المعنية:"]
[null,null,null,null,null,null,null,null,"DET_2","Key enablers: ","Catalyseurs clés : ","Facilitadores clave: ","Основные содействующие факторы: ","عوامل التمكين الرئيسية:"]
[null,null,null,null,null,null,null,null,"DET_3","Success story: ","Réussite : ","Caso de éxito: ","История успеха: ","قصة نجاح"]
[null,null,null,null,null,null,null,null,"DET_4","Main challenges: ","Principales difficultés : ","Principales retos: ","Главные трудности: ","التحديات الرئيسية"]
[null,null,null,null,null,null,null,null,"DET_5","Lesson learned: ","Enseigne-ments tirés : ","Aprendizajes: ","Накопленный опыт: ","الدروس المستفادة"]
[null,null,null,null,null,null,null,null,"TEXT_PLACEHOLDER","Additional information (optional)","Informations complémentaires (facultatif)","Información adicional (opcional)","Дополнительная информация (необязательно)","معلومات إضافية (اختياري)"]

{"sheet":"VI_Enablers","index":7,"n_rows":39,"n_cols":35,"rows_kept":39,"cut":false,"hidden":false,"merged":[[24,22,24,32],[14,4,15,6],[14,8,15,10],[14,12,15,14],[8,4,9,6],[8,8,9,10],[8,12,9,14],[11,4,12,6],[11,8,12,10],[11,12,12,14],[1,1,1,15],[3,1,3,11],[3,13,3,15],[6,4,6,6],[6,8,6,10],[6,12,6,14],[4,1,4,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(\"TITLE\",INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"(VI) Strengthening national statistics capacity to track energy transitions:\nLong-term enablers"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"},"Do not delete text (it is used for a Macro):"]
[]
[null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(\"INSTRUCTION_1\",INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'Enhancing national data capacities', pp. 20-24\n● Long-term enablers underline all activities, and as key pillars support the whole framework. It is useful to assess them before evaluating the specific dimensions."},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."}]
[null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(\"INSTRUCTION_2\",INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Please read carefully the descriptions of the ratings. Then choose the rating that best describes your current situation from the perspective of supporting the development of national energy statistics (1 = lowest, 3 = highest):"}]
[]
[null,null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S7,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"A - Political will and awareness"},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(T7,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"B - Staff capacity and stability"},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(U7,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"C - Multilateral collaboration both at national and international level"},null,null,null,null,null,"TITLE_A","TITLE_B","TITLE_C"]
[]
[null,null,3,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data are recognized as an integral part and is systematically used in energy policy-making."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(T10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"There is a dedicated team specializing on energy statistics. Staff is trained on international methodology and shares their knowledge within the team."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(U10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Continuous cooperation with key stakeholders. Data are systematically shared with all relevant national and international counterparts."}]
[null,null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data are recognized as an integral part and is systematically used in energy policy-making."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(W10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(AA10,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"A3","B3","C3"]
[]
[null,null,2,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data are partially recognized as a part but is not systematically used in energy policy-making."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(T13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"There is a dedicated team specializing on energy statistics; however, staff is not trained on international methodology and there is minimal knowledge exchange within the team."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(U13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Ad-hoc cooperation both at national and international level."}]
[null,null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data are partially recognized as a part but is not systematically used in energy policy-making."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(W13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(AA13,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"A2","B2","C2"]
[]
[null,null,1,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data not considered to be part of energy planning or policymaking"},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(T16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"There is no dedicated or trained staff to work on energy data."},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(U16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"No cooperation at the national or international level around energy statistics."}]
[null,null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(S16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Energy data not considered to be part of energy planning or policymaking"},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(W16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(AA16,INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,"A1","B1","C1"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(\"INSTRUCTION_3\",INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Insert values (1-3)!"},null,null,null,{"$f":"INDEX(lang_VI_ENABLERS,MATCH(\"INSTRUCTION_3\",INDEX(lang_VI_ENABLERS,,1),0),col_language)","v":"Insert values (1-3)!"},null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE","(VI) Strengthening national statistics capacity to track energy transitions:\nLong-term enablers","(VI) Améliorer les capacités de suivi des transitions énergétiques au niveau national :\nCatalyseurs à long terme","(VI) Mejora de la capacidad estadística nacional para el seguimiento de las transiciones energéticas:\nFacilitadores a largo plazo","(VI) Укрепление способности к отслеживанию энерг. переходов в нац. статистике:\nдолгосрочные содейств. Факторы","IV) تعزيز قدرة الإحصاء الوطني على متابعة التحولات في قطاع الطاقة: عوامل تمكين على المدى البعيد"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTION_1","Notes:\n● see 'Designing an energy statistics roadmap', Section 'Enhancing national data capacities', pp. 20-24\n● Long-term enablers underline all activities, and as key pillars support the whole framework. It is useful to assess them before evaluating the specific dimensions.","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », section « Consolider les capacités nationales en matière de données », p. 22-26.\n- Les catalyseurs à long terme sous-tendent toutes les activités et, en tant que piliers, soutiennent l’ensemble du cadre. Il est préférable de les évaluer avant d’évaluer les dimensions spécifiques.","Notas:\n● Consulte la sección «Mejora de las capacidades nacionales en materia de datos» en las páginas 22-26 de la hoja de ruta.\n● Los facilitadores a largo plazo refuerzan todas las actividades y como pilares clave, respaldan todo el marco. Es útil evaluarlos antes de analizar las dimensiones específicas.","Примечания:\n● см. руководство \"Разработка дорожной карты в области энергетической статистики\", раздел \"Укрепление национального потенциала в области данных\", стр. 23–27\n● Долгосрочные содействующие факторы способствуют всем видам деятельности и поддерживают всю структуру как ключевые факторы. Их полезно оценить, прежде чем перейти к оценке  конкретных разделов.  ","\"ملاحظات:\n● انظر \"تصميم خارطة طريق إحصاءات الطاقة\"، القسم \"تعزيز قدرات البيانات الوطنية\"، ص 18-21\n● تشكل العوامل الممكنة طويلة الأجل الأساس لجميع الأنشطة، وتعمل كركائز أساسية لدعم الإطار بأكمله. ومن المفيد تقييمها قبل تقييم الأبعاد المحددة.\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTION_2","Please read carefully the descriptions of the ratings. Then choose the rating that best describes your current situation from the perspective of supporting the development of national energy statistics (1 = lowest, 3 = highest):","Veuillez lire attentivement les descriptions des notes. Choisissez ensuite la note qui décrit le mieux votre situation actuelle du point de vue du soutien à l’élaboration de statistiques énergétiques nationales (1 = la plus faible, 3 = la plus élevée) :","Lea atentamente las descripciones de las calificaciones. A continuación, elija la calificación que mejor describa la situación actual desde la perspectiva del apoyo al desarrollo de estadísticas energéticas nacionales (1 = la más baja, 3 = la más alta):","Внимательно прочитайте описания категорий рейтинга. Затем выберите категорию рейтинга, которая наилучшим образом описывает вашу текущую ситуацию с точки зрения поддержки развития национальной энергетической статистики (1 = низшая оценка; 3 = высшая оценка):","يرجى قراءة أوصاف التصنيفات بعناية. ثم اختر التصنيف الذي يعكس وضعك الحالي بأفضل طريقة من حيث دعم تطوير إحصاءات الطاقة الوطنية (1 = الأدنى، 3 = الأعلى)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTION_3","Insert values (1-3)!","Insérer les valeurs (1-3) !","Indique los valores (1- 3)","Укажите значения от 1 до 3","ادخل القيم (1-3)!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE_A","A - Political will and awareness","A – Sensibilisation et volonté politique","A: Concienciación y voluntad política","А — Политическая воля и осведомленность","أ- الإرادة السياسية والوعي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE_B","B - Staff capacity and stability","B – Capacité et stabilité du personnel","B: Capacidad y estabilidad del personal","В — Кадровый и институциональный потенциал и стабильность","ب- أعداد الموظفين واستقرارهم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE_C","C - Multilateral collaboration both at national and international level","C – Collaboration multilatérale au niveau national et international","C: Colaboración multilateral a nivel nacional e internacional","С — Многостороннее сотрудничество на национальном и международном уровне","ج - التعاون المتعدد الأطراف على المستوى الوطني والدولي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3","Energy data are recognized as an integral part and is systematically used in energy policy-making.","Les données énergétiques sont reconnues comme faisant partie intégrante de l’élaboration des politiques énergétiques et sont systématiquement utilisées à cette fin.","Los datos de energía se consideran parte integral y se utilizan de forma sistemática en la formulación de políticas energéticas.","Энергетические данные признаются неотъемлемой составляющей и систематически используются в разработке энергетической политики.","تعد بيانات الطاقة عنصرًا أساسيًا في عملية صنع السياسات المتعلقة بالطاقة، ويتم استخدامها بشكل منهجي."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2","Energy data are partially recognized as a part but is not systematically used in energy policy-making.","Les données énergétiques sont partiellement reconnues comme faisant partie intégrante de l’élaboration des politiques énergétiques mais ne sont pas systématiquement utilisées à cette fin.","Los datos de energía se consideran parcialmente, pero no se utilizan de forma sistemática en la formulación de políticas energéticas.","Энергетические данные частично признаются составляющим элементом энергетической политики, но не используются систематически в ее разработке.","يتم التعرف على بيانات الطاقة جزئيًا كجزء من عملية صنع السياسات، ولكنها لا تُستخدم بشكل منهجي في هذا السياق."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","Energy data not considered to be part of energy planning or policymaking","Les données énergétiques ne sont pas considérées comme faisant partie de la planification ou de l’élaboration des politiques énergétiques.","Los datos de energía no se consideran parte de la planificación o la formulación de políticas energéticas.","Энергетические данные не считаются частью энергетического планирования и разработки политики.","لا تعد بيانات الطاقة جزءًا من تخطيط الطاقة أو عملية صنع السياسات."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B3","There is a dedicated team specializing on energy statistics. Staff is trained on international methodology and shares their knowledge within the team.","Il existe une équipe spécialisée dans les statistiques énergétiques. Le personnel est formé à la méthodologie internationale et partage ses connaissances au sein de l’équipe.","Existe un equipo especializado en estadísticas energéticas. El personal recibe formación sobre metodología internacional y comparte sus conocimientos dentro del equipo.","Есть отдельная команда, работающая с энергетическими данными. Сотрудники обучены международной методологии и делятся своими знаниями внутри команды.","يوجد فريق متخصص في إحصاءات الطاقة، حيث يتم تدريب الموظفين على المنهجية الدولية ويشاركون معارفهم داخل الفريق."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B2","There is a dedicated team specializing on energy statistics; however, staff is not trained on international methodology and there is minimal knowledge exchange within the team.","Il existe une équipe spécialisée dans les statistiques sur l’énergie, mais le personnel n’est pas formé à la méthodologie internationale et il y a peu d’échange de connaissances au sein de l’équipe.","Existe un equipo especializado en estadísticas energéticas; sin embargo, el personal no recibe formación sobre metodología internacional y el intercambio de conocimientos dentro del equipo es mínimo.","Есть отдельная команда, специализирующаяся на энергетической статистике, однако сотрудники не обучены международной методологии, а обмен знаниями внутри команды минимальный.","يوجد فريق متخصص في إحصاءات الطاقة، ومع ذلك، لا يتم تدريب الموظفين على المنهجيات الدولية، كما أن تبادل المعرفة داخل الفريق محدود جدًا."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1","There is no dedicated or trained staff to work on energy data.","Il n’y a pas de personnel dédié ou formé pour travailler sur les données énergétiques.","No hay personal especializado o formado para trabajar con datos energéticos.","Нет отдельных, или обученных сотрудников, работающих с энергетическими данными.","لا يوجد موظفون متخصصون أو مدربون للعمل على بيانات الطاقة."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C3","Continuous cooperation with key stakeholders. Data are systematically shared with all relevant national and international counterparts.","Coopération continue avec les principales parties prenantes. Les données sont systématiquement partagées avec tous les homologues nationaux et internationaux concernés.","Cooperación continua con las principales partes interesadas. Los datos se comparten sistemáticamente con otros organismos nacionales e internacionales.","Постоянное взаимодействие с заинтересованными сторонами. Данные систематически предоставляются всем соответствующим национальным и международным партнерам.","هناك التعاون مستمر مع أصحاب المصلحة الرئيسيين، حيث تُشارك البيانات بشكل منهجي مع جميع الأطراف الوطنية والدولية المعنية."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C2","Ad-hoc cooperation both at national and international level.","Collaboration ponctuelle au niveau national et international.","Cooperación puntual tanto a nivel nacional como internacional.","Взаимодействие на национальном и международном уровне происходит от случая к случаю.","هناك تعاون مخصص على المستوى الوطني والدولي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C1","No cooperation at the national or international level around energy statistics.","Absence de coopération au niveau national ou international en matière de statistiques énergétiques.","No se coopera a nivel nacional o internacional en el ámbito de las estadísticas energéticas.","Взаимодействия в области энергетической статистики на национальном и международном уровне отсутствует.","لا يوجد تعاون على المستوى الوطني أو الدولي فيما يتعلق بإحصاءات الطاقة."]

{"sheet":"VII_Data_availability","index":8,"n_rows":140,"n_cols":33,"rows_kept":140,"cut":false,"hidden":false,"merged":[[1,1,1,9],[58,6,58,7],[60,6,60,7],[61,6,61,7],[63,6,63,7],[58,8,58,9],[60,8,60,9],[55,4,55,5],[57,4,57,5],[58,4,58,5],[60,4,60,5],[3,1,3,6],[7,1,36,1],[55,8,55,9],[57,8,57,9],[55,6,55,7],[64,6,64,7],[61,4,61,5],[72,25,72,30],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[66,4,66,5],[65,6,65,7],[66,6,66,7],[65,4,65,5],[61,8,61,9],[63,4,63,5],[64,4,64,5],[57,6,57,7],[3,8,3,9],[5,20,5,26],[5,11,5,14],[52,2,52,9],[5,3,5,9],[45,3,50,9],[45,2,46,2],[53,2,53,9]]}
[null,null,null,null,null,null,null,null,null,null,null,"~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE","~HIDE"]
[null,{"$f":"INDEX(lang_VII_DATA,MATCH(\"TITLE\",INDEX(lang_VII_DATA,,1),0),col_language)","v":"(VII) Data availability assessment"},null,null,null,null,null,null,null,null,null,null,null,"Do not delete text (it is used for a Macro):",null,null,null,{"$f":"str_language","v":0},{"$f":"I_Cover!L22","v":"العربية"}]
[]
[null,{"$f":"INDEX(lang_VII_DATA,MATCH(\"INSTRUCTION\",INDEX(lang_VII_DATA,,1),0),col_language)","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'Key energy data', pp. 12-14.\n● indicate the data availability in the blue cells: Yes = Available, No = Not available ('Partial' is also an option)\n● if a product/flow is not relevant in the national context, insert 'N/A'."},null,null,null,null,null,null,{"$f":"IF(country_name=\"\",\"..\",country_name)","v":".."},null,null,null,null,null,null,null,null,null,null,null,"(this table is used for easier translation referencing)"]
[]
[null,null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(U6,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Main energy products"},null,null,null,null,null,null,null,"Count of answers",null,null,null,null,null,null,null,null,"PRODUCTS"]
[null,null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(U7,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Coal"},{"$f":"INDEX(lang_VII_DATA,MATCH(V7,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Oil & oil products"},"Natural gas","Solid biofuels","Electricity","Heat","Total",null,{"$f":"INDEX(answers,1,1)","v":"Yes"},{"$f":"INDEX(answers,3,1)","v":"Partial"},{"$f":"INDEX(answers,2,1)","v":"No"},"Empty",null,"Assessment of total supply",null,null,null,"COAL","OIL","GAS","BIOFUELS","ELECTR","HEAT","TOTAL"]
[null,{"$f":"INDEX(lang_VII_DATA,MATCH(S8,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Main energy flows"},{"$f":"INDEX(lang_VII_DATA,MATCH(T8,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Energy supply"},null,null,null,null,null,null,null,null,{"$f":"SUM(L9:L12)","v":0},{"$f":"SUM(M9:M12)","v":0},0,22,null,{"$f":"IF(O8=0,IF(SUM(M8:N8)=0,$T$137,$T$138),\"..\")","v":".."},null,"FLOWS","SUPPLY"]
[null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(T9,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Production"},null,null,null,null,null,null,{"$f":"IF(O9=0,IF(OR(M9,N9),$M$7,$L$7),\"..\")","v":".."},null,{"$f":"COUNTIF($D9:$I9,L$7)","v":0},0,0,{"$f":"COUNTBLANK($D9:$I9)","v":6},null,null,null,null,"INDPROD"]
[null,null,"Trade",null,null,null,null,null,null,{"$f":"IF(O10=0,IF(OR(M10,N10),$M$7,$L$7),\"..\")","v":".."},null,0,0,0,{"$f":"COUNTBLANK($D10:$I10)","v":6},null,null,null,null,"TRADE"]
[null,null,"Stocks",null,null,null,null,"x","x",{"$f":"IF(O11=0,IF(OR(M11,N11),$M$7,$L$7),\"..\")","v":".."},null,0,0,0,{"$f":"COUNTBLANK($D11:$I11)","v":4},null,null,null,null,"STOCKS"]
[null,null,"Domestic supply",null,null,null,null,null,null,{"$f":"IF(O12=0,IF(OR(M12,N12),$M$7,$L$7),\"..\")","v":".."},null,0,0,0,{"$f":"COUNTBLANK($D12:$I12)","v":6},null,"Assessment of total demand",null,null,"DOMSUP"]
[null,null,"Energy demand",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L37)","v":0},{"$f":"SUM(M14:M37)","v":0},0,{"$f":"SUM(O14:O37)","v":144},null,{"$f":"IF(O13=0,IF(SUM(M13:N13)=0,$T$137,$T$138),\"..\")","v":".."},null,null,"FINCONS"]
[null,null,"Inputs: electricity/heat",null,null,null,null,null,null,{"$f":"IF(O14=0,IF(OR(M14,N14),$M$7,$L$7),\"..\")","v":".."},null,{"$f":"COUNTIF($D14:$I14,L$7)","v":0},0,0,{"$f":"COUNTBLANK($D14:$I14)","v":6},null,null,null,null,"ELEHEAT"]
[null,null,"Inputs: other transformation",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"TRANSF_OTHER"]
[null,null,"Industry",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"TOTIND"]
[null,null,"Iron and steel",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"IRONSTEEL"]
[null,null,"Chemical and petrochemical",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"PETCHEM"]
[null,null,"Non-ferrous metals",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"NONFERR"]
[null,null,"Non-metallic minerals (cement)",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"NONMET"]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"IND_OTHER"]
[null,null,"Transport",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"TOTTRANS"]
[null,null,"Road transport",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"ROAD"]
[null,null,"Aviation",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"AVIATION"]
[null,null,"Maritime ",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"MARITIME"]
[null,null,"Rail",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"RAIL"]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"TRANS_OTHER"]
[null,null,"Residential/households",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"RESIDENT"]
[null,null,"Space heating",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"SPACE_HEAT"]
[null,null,"Space cooling",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"SPACE_COOL"]
[null,null,"Cooking",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"COOKING"]
[null,null,"Lighting and appliances",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"LIGHTING"]
[null,null,"Other final consumption sectors",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"FINCONS_OTHER"]
[null,null,"Commercial and public services",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"COMMPUB"]
[null,null,"Agriculture",null,null,null,null,null,null,"..",null,{"$f":"COUNTIF($D35:$I35,L$7)","v":0},0,0,6,null,null,null,null,"AGRICULT"]
[null,null,"Forestry",null,null,null,null,null,null,"..",null,0,0,0,6,null,null,null,null,"FORESTRY"]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6,null,"Assessment of economic activity",null,null,"OTHER"]
[null,null,"Economic activity",null,null,null,null,null,null,null,null,{"$f":"SUM(L39:L44)","v":0},{"$f":"SUM(M39:M44)","v":0},{"$f":"SUM(N39:N44)","v":0},{"$f":"SUM(O39:O44)","v":6},null,{"$f":"IF(O38=0,IF(SUM(M38:N38)=0,$T$137,$T$138),\"..\")","v":".."},null,null,"ECON_ACTIVITY"]
[null,null,"Gross domestic product",null,null,null,null,null,null,null,null,{"$f":"COUNTIF($J39,L$7)","v":0},0,0,{"$f":"COUNTBLANK($J39)","v":1},null,null,null,null,"GDP"]
[null,null,"Value added by economic activities",null,null,null,null,null,null,null,null,0,0,0,1,null,null,null,null,"VALUE_ADDED"]
[null,null,"Population",null,null,null,null,null,null,null,null,0,0,0,1,null,null,null,null,"POP"]
[null,null,"Building floor area",null,null,null,null,null,null,null,null,0,0,0,1,null,null,null,null,"FLOOR_AREA"]
[null,null,"Electricity access rate",null,null,null,null,null,null,null,null,0,0,0,1,null,null,null,null,"ELE_ACCESS"]
[null,null,"Access to clean cooking",null,null,null,null,null,null,null,null,0,0,0,1,null,null,null,null,"CLEAN_COOKING"]
[]
[null,"NOTE",{"$f":"INDEX(lang_VII_DATA,MATCH(\"NOTE\",INDEX(lang_VII_DATA,,1),0),col_language)","v":"Notes on data:"},"Additional information (optional)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O8,O13,O38)","v":172},"Empty cells"]
[null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(T47,INDEX(lang_VII_DATA,,1),0),col_language)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D9:I12,D14:I37,J39:J44)-2","v":0},"Answers"]
[]
[]
[]
[]
[]
[null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(\"TABLE_HEADER\",INDEX(lang_VII_DATA,,1),0),col_language)","v":"The available energy data support the national policy directions as follows:"}]
[null,null,{"$f":"IF(OR(O46=0,O47=0),\"\",SUBSTITUTE(T139,\"x\",O46))","v":""},null,null,null,null,null,null,null,null,"Data requirements as per the roadmap",null,null,null,"Data available as per the answers"]
[null,null,null,null,"SUPPLY",null,"DEMAND",null,"ACTIVITY"]
[null,null,null,null,{"$f":"INDEX(lang_VII_DATA,MATCH(E55,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Energy supply"},null,{"$f":"INDEX(lang_VII_DATA,MATCH(G55,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Energy demand"},null,{"$f":"INDEX(lang_VII_DATA,MATCH(I55,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Economic activity"},null,null,"Supply","Demand","Activity",null,"Supply","Demand","Activity"]
[null,"SDG",{"$f":"INDEX(lang_VII_DATA,MATCH(B57,INDEX(lang_VII_DATA,,1),0),col_language)","v":"Sustainable development goals"}]
[null,"SDG7.2","SDG 7.2",null,{"$f":"IF(L58=\"x\",P58,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M58=\"x\",Q58,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N58=\"x\",R58,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"SDG7.3","SDG 7.3",null,{"$f":"IF(L59=\"x\",P59,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M59=\"x\",Q59,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":"n/a"},null,{"$f":"IF(N59=\"x\",R59,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,null,"x",null,"x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"CLIM","International climate reporting"]
[null,"CLIM_GHG","National greenhouse gas (GHG) emission inventory",null,{"$f":"IF(L61=\"x\",P61,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M61=\"x\",Q61,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N61=\"x\",R61,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":"n/a"},null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"CLIM_NDC","Nationally determined contributions (NDCs)",null,{"$f":"IF(L62=\"x\",P62,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M62=\"x\",Q62,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N62=\"x\",R62,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"POL","National sectoral energy policies"]
[null,"POL_SWITCH","Fuel switching",null,{"$f":"IF(L64=\"x\",P64,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M64=\"x\",Q64,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N64=\"x\",R64,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":"n/a"},null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"POL_RES","Renewable energy targets",null,{"$f":"IF(L65=\"x\",P65,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M65=\"x\",Q65,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N65=\"x\",R65,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":"n/a"},null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"POL_EE","Improving energy efficiency",null,{"$f":"IF(L66=\"x\",P66,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M66=\"x\",Q66,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N66=\"x\",R66,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,"POL_PLAN","Energy planning (modelling)",null,{"$f":"IF(L67=\"x\",P67,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(M67=\"x\",Q67,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,{"$f":"IF(N67=\"x\",R67,INDEX(lang_VII_DATA,MATCH(\"n_a\",INDEX(lang_VII_DATA,,1),0),col_language))","v":".."},null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"col_language","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIELD_CODE","ENG","FRA","SPA","RUS","ARA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE","(VII) Data availability assessment","(VII) Évaluation de la disponibilité des données","(VII) Evaluación de la disponibilidad de datos","(VII) Оценка наличия данных","IIV) تقييم مدى توفر البيانات "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSTRUCTION","Notes:\n● see 'Designing an energy statistics roadmap', Section 'Key energy data', pp. 12-14.\n● indicate the data availability in the blue cells: Yes = Available, No = Not available ('Partial' is also an option)\n● if a product/flow is not relevant in the national context, insert 'N/A'.","Remarques : \n- Voir « Concevoir une feuille de route pour les statistiques énergétiques », section « Données énergétiques essentielles », p. 12-16.\n- Indiquer la disponibilité des données dans les cellules bleues : Oui = disponible, Non = non disponible (il est également possible d’indiquer « En partie »)\n- Si un produit/flux n’est pas pertinent dans le contexte national, indiquer « N/A ».","Notas:\n● Consulte la seción «Datos energéticos clave» en las páginas 12-15 de la hoja de ruta.\n● Indique la disponibilidad de datos en las celdas azules: Sí = disponible, No = no disponible, («Parcial» también es una opción).\n● Si un producto o flujo no es relevante en el contexto nacional, introduzca «NA».","Примечания:\n● см. руководство \"Разработка дорожной карты в области энергетической статистики\", раздел \"Ключевые энергетические данные\", стр. 12–16 \n●   Укажите в голубых ячейках наличие данных: Да = данные есть; Нет = данных нет (также можно указать \"Частично\")\n●   Если продукт или поток нерелевантен в контексте страны, вставте \"-\".","**ملاحظات:**\n● راجع \"تصميم خريطة طريق إحصاءات الطاقة\"، القسم \"بيانات الطاقة الرئيسية\"، الصفحات -10-13.\n● حدد مدى توفر البيانات في الخانات الزرقاء: نعم = متوفرة، لا = غير متوفرة (ويمكن أيضًا اختيار \"جزئيًا\").\n● إذا كان المنتج/التدفق غير ذي صلة بالسياق الوطني، يرجى إدخال \"نعم\"."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRODUCTS","Main energy products","Principaux produits énergétiques","Principales productos energéticos","Главные энергетические продукты","منتجات الطاقة الرئيسية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COAL","Coal","Charbon","Carbón","Уголь","الفحم"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OIL","Oil & oil products","Pétrole et produits pétroliers","Petróleo y derivados del petróleo","Нефть и нефте-продукты","النفط والمنتجات النفطية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS","Natural gas","Gaz naturel","Gas natural","Природный газ","الغاز الطبيعي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIOFUELS","Solid biofuels","Bio-carburants solides","Biocombus-tibles sólidos","Твердые виды биотоплива","الوقود الحيوي الصلب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELECTR","Electricity","Électricité","Electricidad","Электри-чество","الكهرباء"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEAT","Heat","Chaleur","Calor","Тепло","التدفئة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","Total","Total","Total","Итого","المجموع"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLOWS","Main energy flows","Principaux flux énergétiques","Principales flujos de energía","Основные потоки энергии","تدفقات الطاقة الرئيسية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLY","Energy supply","Offre en énergie","Suministro energético","Поставки энергии","إمدادات الطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDPROD","Production","Production","Producción","Производство","الإنتاج"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRADE","Trade","Échanges","Comercio","Торговля","التجارة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STOCKS","Stocks","Stocks","Reservas","Запасы","المخزون"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOMSUP","Domestic supply","Approvisionnement national","Suministro nacional","Внутренние поставки","العرض المحلي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINCONS","Energy demand","Demande d’énergie","Demanda de energía","Спрос на энергопродукты","الطلب على الطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELEHEAT","Inputs: electricity/heat","Intrants : électricité/chaleur","Entradas: electricidad/calor","Исходные материалы: электрическая/тепловая энергия","المدخلات: الكهرباء/الحرارة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSF_OTHER","Inputs: other transformation","Intrants : autres transformations","Entradas: otra transformación","Исходные материалы: другие преобразования","المدخلات: التحويلات الأخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTIND","Industry","Industrie","Industria","Промышленность","الصناعة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRONSTEEL","Iron and steel","Sidérurgie","Fundición, hierro y acero","Черная металлургия","الحديد والصلب"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PETCHEM","Chemical and petrochemical","Chimie et pétrochimie","Química y petroquímica","Химическая и нефтехимическая промышленность","الكيميائيات والبتروكيماويات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NONFERR","Non-ferrous metals","Métaux non ferreux","Metales no ferrosos","Цветные металлы","المعادن غير الحديدية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NONMET","Non-metallic minerals (cement)","Minéraux non métalliques (ciment)","Minerales no metálicos (cemento)","Неметаллические минеральные продукты (цемент)","المعادن غير المعدنية (الأسمنت)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IND_OTHER","Other","Autres","Otra","Иное","أخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTTRANS","Transport","Transport","Transporte","Транспорт","النقل"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROAD","Road transport","Transport routier","Por carretera","Автомобильный транспорт","النقل البري"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVIATION","Aviation","Transport aérien","Aéreo","Авиационный","النقل الجوي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MARITIME","Maritime ","Transport maritime ","Marítimo ","Морской ","النقل البحري"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RAIL","Rail","Transport ferroviaire","Ferroviario","Железнодорожный","السكك الحديدية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANS_OTHER","Other","Autres","Otro","Иное","أخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESIDENT","Residential/households","Résidentiel/ménages","Residencial/hogares","Жилищный сектор / домохозяйства","السكنية/الأسرية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPACE_HEAT","Space heating","Chauffage","Calefacción de espacios","Отопление помещений","تدفئة المساحات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPACE_COOL","Space cooling","Climatisation","Refrigeración de espacios","Охлаждение помещений","تبريد المساحات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COOKING","Cooking","Cuisine","Cocina","Приготовление пищи","الطهي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIGHTING","Lighting and appliances","Éclairage et appareils","Iluminación y electrodomésticos","Освещение и бытовые приборы","الإضاءة والأجهزة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FINCONS_OTHER","Other final consumption sectors","Autres secteurs de la consommation finale","Otros sectores de consumo final","Иные секторы окончательного потребления","قطاعات الاستهلاك النهائي الأخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMMPUB","Commercial and public services","Commerce et services publics","Comercio y servicios públicos","Коммерческие и государственные услуги","الخدمات التجارية والعامة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGRICULT","Agriculture","Agriculture","Agricultura","Сельское хозяйство","الزراعة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORESTRY","Forestry","Sylviculture","Silvicultura","Лесное хозяйство","الغابات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER","Other","Autres","Otro","Иное","أخرى"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ECON_ACTIVITY","Economic activity","Activité économique","Actividad económica","Экономическая деятельность","النشاط الاقتصادي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GDP","Gross domestic product","Produit intérieur brut","Producto interior bruto","Валовой внутренний продукт","الناتج المحلي الإجمالي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALUE_ADDED","Value added by economic activities","Valeur ajoutée par les activités économiques","Valor añadido por actividades económicas","Добавленная стоимость по видам экономической деятельности","القيمة المضافة حسب الأنشطة الاقتصادية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POP","Population","Population","Población","Население","عدد السكان"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLOOR_AREA","Building floor area","Surface au sol bâtie","Superficie edificada","Площадь зданий","مساحة البناء"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELE_ACCESS","Electricity access rate","Taux d’accès à l’électricité","Tasa de acceso a la electricidad","Степень доступа к электроснабжению","معدل الوصول إلى الكهرباء"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLEAN_COOKING","Access to clean cooking","Accès à des modes de cuisson propres","Acceso a energía limpia para cocinar","Доступ к чистому приготовлению пищи","الوصول إلى الطهي النظيف"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE","Notes on data:","Notes sur les données :","Notas sobre los datos:","Примечания к данным:","ملاحظات حول البيانات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEXT_PLACEHOLDER","Additional information (optional)","Informations complémentaires (facultatif)","Información adicional (opcional)","Дополнительная информация (необязательно)","معلومات إضافية (اختياري)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLE_HEADER","The available energy data support the national policy directions as follows:","Les données énergétiques disponibles appuient les orientations des politiques nationales de la manière suivante :","Los datos energéticos disponibles permiten respaldar las políticas nacionales del siguiente modo:","Имеющиеся энергетические данные помогают в следующих направлениях национальной политики:","تدعم بيانات الطاقة المتاحة اتجاهات السياسة الوطنية على النحو التالي:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLY","Energy supply","Approvisionnement en énergie","Suministro energético","Поставки энергии","امدادات الطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEMAND","Energy demand","Demande d’énergie","Demanda de energía","Спрос на энергопродукты","الطلب على الطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACTIVITY","Economic activity","Activité économique","Actividad económica","Экономическая деятельность","النشاط الاقتصادي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG","Sustainable development goals","Objectifs de développement durable","Objetivos de desarrollo sostenible","Цели в области устойчивого развития","أهداف التنمية المستدامة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG7.2","SDG 7.2","ODD 7.2","ODS 7.2","ЦУР 7.2","أهداف التنمية المستدامة 7.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SDG7.3","SDG 7.3","ODD 7.3","ODS 7.3","ЦУР 7.3","أهداف التنمية المستدامة 7.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLIM","International climate reporting","Rapport international sur le climat","Informes climáticos internacionales","Международная отчетность в области изменения климата","التقارير المناخية الدولية"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLIM_GHG","National greenhouse gas (GHG) emission inventory","Inventaire national des émissions de gaz à effet de serre (GES)","Inventario nacional de emisiones de gases de efecto invernadero (GEI)","Национальный кадастр выбросов парниковых газов","جرد انبعاثات الغازات المسببة للانحباس الحراري العالمي"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CLIM_NDC","Nationally determined contributions (NDCs)","Contributions déterminées au niveau national (CDN)","Contribuciones determinadas a nivel nacional (CDN)","Определяемые на национальном уровне вклады (ОНУВ)","المساهمات المحددة وطنيا"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POL","National sectoral energy policies","Politiques énergétiques sectorielles nationales","Políticas energéticas sectoriales nacionales","Национальная отраслевая энергетическая политика","السياسات القطاعية الوطنية للطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POL_SWITCH","Fuel switching","Substitution de combustible (\"Fuel switch\")","Sustitución de combustibles","Переход на другие виды топлива","التحول في استخدام الوقود"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POL_RES","Renewable energy targets","Objectifs d’énergie renouvelable","Objetivos de energía renovable","Возобновляемые источники энергии","أهداف الطاقة المتجددة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POL_EE","Improving energy efficiency","Améliorer l’efficacité énergétique","Mejora de la eficiencia energética","Повышение энергоэффективности","تحسين كفاءة الطاقة"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"assessment labels","POL_PLAN","Energy planning (modelling)","Planification énergétique (modélisation)","Planificación energética (modelización)","Энергетическое планирование (моделирование)","تخطيط الطاقة (النمذجة)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(U137:Z137,,$U$70)","v":"Fully"},"FULLY","Fully","Pleinement","Plenamente","Полностью","بالكامل"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(U138:Z138,,$U$70)","v":"Partially"},"PARTIALLY","Partially","Partiellement","Parcialmente","Частично","جزئيا"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(U139:Z139,,$U$70)","v":"Note: Results are shown only when all fields are filled (there are currently x empty fields)."},"NOTE_ASSESSMENT","Note: Results are shown only when all fields are filled (there are currently x empty fields).","Remarque : les résultats ne s'affichent que lorsque tous les champs sont remplis (il y a actuellement x champs vides).","Nota: Los resultados se muestran solo cuando todos los campos están completos (actualmente hay x campos vacíos).","Примечание: результаты отображаются только в том случае, если заполнены все поля (в настоящее время имеется x пустых полей).","ملاحظة: لا تظهر النتائج إلا عند ملء جميع الحقول (يوجد حاليًا عدد x من الحقول الفارغة)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n_a","n/a","n/a","NA","-","غير منطبق"]