{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Admin","I_Cover","Summary","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":13,"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":"Admin","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Dropdown_list",null,null,null,null,null,null,"Restore conditional formatting"]
[null,"Yes"]
[null,"Partial",null,null,null,null,null,null,"Col","F",null,"AND($F$4>=50%,$F$4<75%)","AND($F$4>0%,$F$4<50%)"]
[null,"No",null,"● empties any input values from the tool",null,null,null,null,"Row","Cell","Rule 1","Rule 2","Rule 3","Target range"]
[null,null,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,"Guidebook name",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,"Designing an energy statistics roadmap",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,"Page numbers (PLAN, SETUP TRACK)",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,"27-36",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,"37-49",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,"50-77",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"]

{"sheet":"I_Cover","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,1,5,2],[7,1,7,2],[8,5,9,5],[0,2,0,6],[3,1,3,2]]}
[null,null,"Designing an energy statistics roadmap\nAssessment tool"]
[null,"QuestionnaireVersion 2024_09_16"]
[null,"Link to the guidebook:",null,null,null,"For any enquiries, please write to:"]
[null,"Designing an Energy Statistics Roadmap",null,null,null,"DataCapacities@iea.org"]
[null,"Tool description"]
[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"]
[null,"Use:"]
[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)"]
[null,"Filling instructions by sheet",null,null,null,"Insert country name:"]
[null,"I_Cover","This sheet."]
[null,"II_PLAN",{"$f":"\"Covers the Section 'PLAN' of the guidebook (see document, pp. \"&PLAN&\"). Please fill in blue cells.\"","v":"Covers the Section 'PLAN' of the guidebook (see document, pp. 27-36). Please fill in blue cells."}]
[null,"III_SETUP",{"$f":"\"Covers the Section 'SETUP' of the guidebook (see document, pp. \"&SETUP&\"). Please fill in blue cells.\"","v":"Covers the Section 'SETUP' of the guidebook (see document, pp. 37-49). Please fill in blue cells."},null,null,"After providing answers, click the button to generate a report of the results (PDF will appear on the user desktop)"]
[null,"IV_TRACK",{"$f":"\"Covers the Section 'TRACK' of the guidebook (see document, pp. \"&TRACK&\"). Please fill in blue cells.\"","v":"Covers the Section 'TRACK' of the guidebook (see document, pp. 50-77). Please fill in blue cells."}]
[null,"V_Country_info","Collects background information on the national context."]
[null,"VI_Enablers","Contains the user assessment of the key enablers. Please fill in blue cells."]
[null,"'VII_Data_availability'","Includes an energy data availability assessment. Please fill in the blue cells. Note that this can also be filled independently from the other sections."]

{"sheet":"Summary","index":2,"n_rows":69,"n_cols":33,"rows_kept":69,"cut":false,"hidden":true,"merged":[[50,29,50,31],[51,29,51,31],[40,29,40,31],[43,29,43,31],[45,29,45,31],[46,29,46,31],[48,29,48,31],[49,29,49,31],[33,25,33,28],[37,17,38,35],[42,29,42,31],[1,17,1,35],[3,17,4,35],[17,32,20,34],[17,19,20,21],[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]]}
[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":"Roadmap_name&\": Assessment summary\"","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":"COUNTIF($E5:$E7,J$2)","v":0},{"$f":"COUNTIF($E5:$E7,K$2)","v":0},{"$f":"COUNTIF($E5:$E7,L$2)","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) &\": Answers by topic\"","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(E5=\"Yes\",3,IF(E5=\"Partial\",2,IF(E5=\"No\",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(E6=\"Yes\",3,IF(E6=\"Partial\",2,IF(E6=\"No\",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},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":"COUNTIF($E9:$E11,J$2)","v":0},{"$f":"COUNTIF($E9:$E11,K$2)","v":0},{"$f":"COUNTIF($E9:$E11,L$2)","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},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLAN - Strategic dimension",null,null,"SETUP - Operational dimension",null,null,null,null,null,null,"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},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},0]
[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":"COUNTIF($E13:$E15,J$2)","v":0},{"$f":"COUNTIF($E13:$E15,K$2)","v":0},{"$f":"COUNTIF($E13:$E15,L$2)","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,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},0]
[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},0]
[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},0]
["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":"COUNTIF($E17:$E19,J$2)","v":0},{"$f":"COUNTIF($E17:$E19,K$2)","v":0},{"$f":"COUNTIF($E17:$E19,L$2)","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,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},0]
[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},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,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},0]
[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":"COUNTIF($E21:$E23,J$2)","v":0},{"$f":"COUNTIF($E21:$E23,K$2)","v":0},{"$f":"COUNTIF($E21:$E23,L$2)","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,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(E21=\"Yes\",3,IF(E21=\"Partial\",2,IF(E21=\"No\",1,0)))","v":0}]
[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(E22=\"Yes\",3,IF(E22=\"Partial\",2,IF(E22=\"No\",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(E23=\"Yes\",3,IF(E23=\"Partial\",2,IF(E23=\"No\",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":"COUNTIF($E25:$E27,J$2)","v":0},{"$f":"COUNTIF($E25:$E27,K$2)","v":0},{"$f":"COUNTIF($E25:$E27,L$2)","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(E25=\"Yes\",3,IF(E25=\"Partial\",2,IF(E25=\"No\",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(E26=\"Yes\",3,IF(E26=\"Partial\",2,IF(E26=\"No\",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(E27=\"Yes\",3,IF(E27=\"Partial\",2,IF(E27=\"No\",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":"COUNTIF($E29:$E31,J$2)","v":0},{"$f":"COUNTIF($E29:$E31,K$2)","v":0},{"$f":"COUNTIF($E29:$E31,L$2)","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(E29=\"Yes\",3,IF(E29=\"Partial\",2,IF(E29=\"No\",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(E30=\"Yes\",3,IF(E30=\"Partial\",2,IF(E30=\"No\",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(E31=\"Yes\",3,IF(E31=\"Partial\",2,IF(E31=\"No\",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,"Color code legend"]
[null,35,"7.F",{"$f":"INDEX(data_IV_TRACK,$B33,D$1)","v":"Does the current data collection fully capture the following? (refer to table on pp. 61-63)"},{"$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":"COUNTIF($E35:$E37,J$2)","v":0},{"$f":"COUNTIF($E35:$E37,K$2)","v":0},{"$f":"COUNTIF($E35:$E37,L$2)","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,"Significant weaknesses identified",null,null,null,null,null,"Some work needed to\nstrengthen the element",null,null,null,null,null,null,"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(E35=\"Yes\",3,IF(E35=\"Partial\",2,IF(E35=\"No\",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(E36=\"Yes\",3,IF(E36=\"Partial\",2,IF(E36=\"No\",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(E37=\"Yes\",3,IF(E37=\"Partial\",2,IF(E37=\"No\",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":"COUNTIF($E39:$E41,J$2)","v":0},{"$f":"COUNTIF($E39:$E41,K$2)","v":0},{"$f":"COUNTIF($E39:$E41,L$2)","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":"\"Available energy data support the national policy directions in \"&PROPER(country_name) & \" as follows:\"","v":"Available energy data support the national policy directions in  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(E39=\"Yes\",3,IF(E39=\"Partial\",2,IF(E39=\"No\",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(E40=\"Yes\",3,IF(E40=\"Partial\",2,IF(E40=\"No\",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(E41=\"Yes\",3,IF(E41=\"Partial\",2,IF(E41=\"No\",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,"Energy supply","Energy demand","Economic activity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sustainable development goals"]
[null,null,null,null,null,null,null,"Overall rating",null,"PLAN","SETUP","TRACK",null,null,null,null,null,null,null,null,null,"SDG 7.2",null,null,null,null,null,{"$f":"VII_Data_availability!F58","v":".."},{"$f":"VII_Data_availability!G58","v":".."},{"$f":"VII_Data_availability!H58","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,null,null,null,"SDG 7.3",null,null,null,null,null,{"$f":"VII_Data_availability!F59","v":".."},{"$f":"VII_Data_availability!G59","v":"n/a"},{"$f":"VII_Data_availability!H59","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,null,null,null,"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(E46=\"Yes\",3,IF(E46=\"Partial\",2,IF(E46=\"No\",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,null,null,null,"National greenhouse gas (GHG) emission inventory",null,null,null,null,null,{"$f":"VII_Data_availability!F61","v":".."},{"$f":"VII_Data_availability!G61","v":".."},{"$f":"VII_Data_availability!H61","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(E47=\"Yes\",3,IF(E47=\"Partial\",2,IF(E47=\"No\",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,null,null,null,"Nationally determined contributions (NDCs)",null,null,null,null,null,{"$f":"VII_Data_availability!F62","v":".."},{"$f":"VII_Data_availability!G62","v":".."},{"$f":"VII_Data_availability!H62","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},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"National sectoral energy policies"]
[null,null,null,{"$f":"IV_TRACK!C32","v":"● Energy Statistics Compiler’s Manual (ESCM)"},{"$f":"IV_TRACK!E32","v":0},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,null,null,null,"Fuel switching",null,null,null,null,null,{"$f":"VII_Data_availability!F64","v":".."},{"$f":"VII_Data_availability!G64","v":".."},{"$f":"VII_Data_availability!H64","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},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,null,null,null,"Renewable energy targets",null,null,null,null,null,{"$f":"VII_Data_availability!F65","v":".."},{"$f":"VII_Data_availability!G65","v":".."},{"$f":"VII_Data_availability!H65","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,null,null,null,"Improving energy efficiency",null,null,null,null,null,{"$f":"VII_Data_availability!F66","v":".."},{"$f":"VII_Data_availability!G66","v":".."},{"$f":"VII_Data_availability!H66","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,null,null,null,"Energy planning (modelling)",null,null,null,null,null,{"$f":"VII_Data_availability!F67","v":".."},{"$f":"VII_Data_availability!G67","v":".."},{"$f":"VII_Data_availability!H67","v":".."}]
[null,null,null,{"$f":"IV_TRACK!C42","v":"● Energy production"},{"$f":"IV_TRACK!E42","v":0},{"$f":"IF(E53=\"Yes\",3,IF(E53=\"Partial\",2,IF(E53=\"No\",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"]

{"sheet":"II_PLAN","index":3,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[10,2,13,2],[18,2,21,2],[26,2,29,2],[54,2,55,2],[66,2,67,2],[77,2,80,2],[3,4,3,6],[3,1,3,2],[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]]}
[]
[null,"II) Strengthening the national energy data system - PLAN (strategic dimension)"]
[]
[null,{"$f":"\"Notes:\n● see '\"& Roadmap_name & \"', Section 'PLAN', pp. \"&PLAN&\".\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)\"","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":"country_name","v":0}]
[]
[null,"1.","Data needs and users"]
[]
[null,"1.A","Are there relevant or high-visibility energy policies in place that require energy data for policy design and evaluation?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"1.B","Is it clear who the data users are?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"1.C","Are evolving data needs continuously identified and addressed?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2.","Strategy development"]
[]
[null,"2.A","Is there a strategy for producing and developing energy data? "]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"2.B","Does the strategy include identification of data collection priorities?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"2.C","Is it regularly updated to respond to evolving needs?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[null,"3.","Funding mechanisms"]
[]
[null,"3.A","Are core energy statistics funded by the national administration?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"3.B","Are there additional funding mechanisms besides conventional ones (i.e. public funds)? "]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"3.C","Are the funding mechanisms sufficient and sustainable for routine and additional work?"]
[]
[]
[null,null,"Additional information (optional)"]

{"sheet":"III_SETUP","index":4,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[66,2,67,2],[38,2,39,2],[46,2,47,2],[54,2,55,2],[57,2,60,2],[69,2,72,2],[77,2,80,2],[85,2,88,2],[74,2,75,2],[82,2,83,2],[3,4,3,6],[26,2,29,2],[41,2,44,2],[49,2,52,2],[23,2,24,2],[7,2,8,2],[15,2,16,2],[10,2,13,2],[18,2,21,2],[3,1,3,2]]}
[]
[null,"III) Strengthening the national energy data system - SETUP (operational dimension)"]
[]
[null,{"$f":"\"Notes:\n● see '\"& Roadmap_name & \"', Section 'SETUP', pp. \"&SETUP&\".\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)\"","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":"country_name","v":0}]
[]
[null,"4.","Legal framework"]
[]
[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”)"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"4.B","Does it require respondents to provide data (i.e. mandatory nature)?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"4.C","Is it functioning and appropriate for your work? Is it enforced?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5.","Institutional arrangements"]
[]
[null,"5.A","Is there an entity responsible for coordinating the national energy information system?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"5.B","Is the division of work clear to avoid both gaps and overlaps in data collection?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[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)?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[]
[]
[null,"6.","Human, technical, and financial resources"]
[]
[null,"6.A","Are the available technical and financial resources adequate and visible in the long-term?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"6.B","Are the available resources (human, technical and financial) relatively stable over time, without major annual fluctuations?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"6.C","Is there sufficient staff capacity? Is there continuous training of staff?"]
[]
[]
[null,null,"Additional information (optional)"]

{"sheet":"IV_TRACK","index":5,"n_rows":115,"n_cols":6,"rows_kept":115,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[null,"IV) Strengthening the national energy data system - TRACK (data processes)"]
[]
[null,{"$f":"\"Notes:\n● see '\"& Roadmap_name & \"', Section 'TRACK', pp. \"&TRACK&\".\n● the questions from the sections are modified to allow for yes/no -answers. Insert answers in the blue cells (Yes, No, Partial)\"","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":"country_name","v":0}]
[]
[null,"7.","Data collection, methodologies and quality verification"]
[]
[null,"7.A","Are there sound data collection methods in place (e.g. use of administrative sources, fuel and sectoral surveys)? "]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"7.B","Does the data collection follow documented methodologies and standards? "]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"7.C","Are there sufficient processes in place to control data quality?"]
[]
[]
[null,"7.D","Are the following references applied in the national context? (refer to table on page 58)"]
[]
[null,null,"● International Recommendations for Energy Statistics (IRES) [United Nations, 2011]",null,null,"(link)"]
[null,null,"● Standard International Energy Product Classification (SIEC) [part of IRES)]",null,null,"(link)"]
[null,null,"● The International Standard Industrial Classification of All Economic Activities (ISIC)",null,null,"(link)"]
[null,null,"● Energy Statistics Compiler’s Manual (ESCM)",null,null,"(link)"]
[null,null,"● 2006 IPCC Guidelines for National Greenhouse Gas Inventories Volume 2: Energy",null,null,"(link)"]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"7.F","Does the current data collection fully capture the following? (refer to table on pp. 61-63)"]
[]
[null,null,"● Energy production"]
[null,null,"● Energy transformation processes in iron and steel making"]
[null,null,"● Electricity produced by autoproducers - industry"]
[null,null,"● Electricity produced by autoproducers - residential"]
[null,null,"● Geographical coverage"]
[null,null,"● Non-commercial energy demand"]
[null,null,"● Fuel tourism"]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.","Data management and innovation"]
[]
[null,"8.A","Is the current data management framework adequate?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.B","Is there room for further digitisation of data collection, management and dissemination?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"8.C","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.","Data access and dissemination"]
[]
[null,"9.A","Are energy statistics easily findable and accessible? "]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"9.B","Are the final data products relevant to the users?"]
[]
[]
[null,null,"Additional information (optional)"]
[]
[]
[]
[]
[null,"9.C","Are the data transparent? Is there metadata available?"]
[]
[]
[null,null,"Consider yourself to be a generic data user. Follow the steps and record the results."]
[null,null,"1) Find the organisation website through a search engine"]
[null,null,"Does the website show up among the first results?"]
[null,null,"2) Navigate to the data section of the website"]
[null,null,"Is there an explicit data section on the website?"]
[null,null,"How many clicks does it take to reach the section (indicate the number)?"]
[null,null,"3) Navigate to energy statistics"]
[null,null,"Is ‘energy’ a separate category?"]
[null,null,"How many clicks does it take to reach the section (indicate the number)?"]
[null,null,"4) Extract the desired information"]
[null,null,"Is the information available for download?"]
[null,null,"Is the information available in user-friendly formats (spreadsheets, database)? "]
[]
[null,null,"Additional information (optional)"]

{"sheet":"V_Country_info","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[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,"V) Strengthening national statistics capacity to track energy transitions: Country info"]
[]
[null,{"$f":"\"Notes:\n● see '\"& Roadmap_name & \"', Annex \n● information in this section is collected to better understand the national context\"","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":"country_name","v":0}]
[]
[null,"National institution(s) involved: ","Additional information (optional)"]
[]
[null,"Key enablers: ","Additional information (optional)"]
[]
[null,"Success story: ","Additional information (optional)"]
[]
[null,"Main challenges: ","Additional information (optional)"]
[]
[null,"Lesson learned: ","Additional information (optional)"]

{"sheet":"VI_Enablers","index":7,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,11],[3,13,3,15],[4,1,4,13],[6,4,6,6],[6,8,6,10],[6,12,6,14],[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]]}
[]
[null,"VI) Strengthening national statistics capacity to track energy transitions: Long-term enablers"]
[]
[null,{"$f":"\"Notes:\n● see '\" & Roadmap_name & \"', Section 'Enhancing national data capacities', pp. 20-23\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.\"","v":"Notes:\n● see 'Designing an energy statistics roadmap', Section 'Enhancing national data capacities', pp. 20-23\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":"country_name","v":0}]
[null,"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,"A - Political will and awareness",null,null,null,"B - Staff capacity and stability",null,null,null,"C - Multilateral collaboration both at national and international level"]
[]
[null,null,3,null,"Energy data are recognized as an integral part and is systematically used in energy policy-making.",null,null,null,"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,"Continuous cooperation with key stakeholders. Data are systematically shared with all relevant national and international counterparts."]
[]
[]
[null,null,2,null,"Energy data are partially recognized as a part but is not systematically used in energy policy-making.",null,null,null,"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,"Ad-hoc cooperation both at national and international level."]
[]
[]
[null,null,1,null,"Energy data not considered to be part of energy planning or policymaking",null,null,null,"There is no dedicated or trained staff to work on energy data.",null,null,null,"No cooperation at the national or international level around energy statistics."]
[]
[]
[]
[null,null,null,"Insert values (1-3)!"]

{"sheet":"VII_Data_availability","index":8,"n_rows":67,"n_cols":18,"rows_kept":67,"cut":false,"hidden":false,"merged":[[3,1,3,6],[3,8,3,9],[52,2,52,9],[5,11,5,14],[5,3,5,9],[45,3,50,9],[7,1,36,1],[45,2,46,2]]}
[]
[null,"VII) Data availability assessment",null,null,null,null,null,null,null,null,null,"These columns should be hidden in the final version!"]
[]
[null,{"$f":"\"Notes:\n● see '\" & Roadmap_name & \"', 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 'Yes'.\"","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 'Yes'."},null,null,null,null,null,null,{"$f":"country_name","v":0}]
[]
[null,null,null,"Main energy products",null,null,null,null,null,null,null,"Count of answers"]
[null,null,null,"Coal","Oil & oil products","Natural gas","Solid biofuels","Electricity","Heat","Total",null,"Yes","Partial","No","Empty",null,"Assessment of total supply"]
[null,"Main energy flows","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,\"Fully\",\"Partially\"),\"..\")","v":".."}]
[null,null,"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,"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,"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,"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,"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,\"Fully\",\"Partially\"),\"..\")","v":".."}]
[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,"Inputs: other transformation",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Industry",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Iron and steel",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Chemical and petrochemical",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Non-ferrous metals",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Non-metallic minerals (cement)",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Transport",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Road transport",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Aviation",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Maritime ",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Rail",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Residential/households",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Space heating",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Space cooling",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Cooking",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Lighting and appliances",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Other final consumption sectors",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Commercial and public services",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Agriculture",null,null,null,null,null,null,"..",null,{"$f":"COUNTIF($D35:$I35,L$7)","v":0},0,0,6]
[null,null,"Forestry",null,null,null,null,null,null,"..",null,0,0,0,6]
[null,null,"Other",null,null,null,null,null,null,"..",null,0,0,0,6,null,"Assessment of economic activity"]
[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,\"Fully\",\"Partially\"),\"..\")","v":".."}]
[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,"Value added by economic activities",null,null,null,null,null,null,null,null,0,0,0,1]
[null,null,"Population",null,null,null,null,null,null,null,null,0,0,0,1]
[null,null,"Building floor area",null,null,null,null,null,null,null,null,0,0,0,1]
[null,null,"Electricity access rate",null,null,null,null,null,null,null,null,0,0,0,1]
[null,null,"Access to clean cooking",null,null,null,null,null,null,null,null,0,0,0,1]
[]
[null,null,"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,null,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,null,null,null,null,null,null,null,null,null,null,null,"Notification for the cover-sheet",{"$f":"IF(O47=0,\"\",IF(O46=0,\"All questions answered!\",O12 &\" unanswered questions\"))","v":""}]
[]
[]
[]
[]
[null,null,"The available energy data support the national policy directions as follows:"]
[null,null,{"$f":"IF(OR(O46=0,O47=0),\"\",\"Note: Results are shown only when all fields are filled (there are currently \" &O46& \" empty fields).\")","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,null,"Energy supply","Energy demand","Economic activity",null,null,null,"Supply","Demand","Activity",null,"Supply","Demand","Activity"]
[null,null,"Sustainable development goals"]
[null,null,"SDG 7.2",null,null,{"$f":"IF(L58=\"x\",P58,\"n/a\")","v":".."},"..","..",null,null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"SDG 7.3",null,null,"..","n/a","..",null,null,null,"x",null,"x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"International climate reporting"]
[null,null,"National greenhouse gas (GHG) emission inventory",null,null,{"$f":"IF(L61=\"x\",P61,\"n/a\")","v":".."},"..","n/a",null,null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"Nationally determined contributions (NDCs)",null,null,"..","..","..",null,null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"National sectoral energy policies"]
[null,null,"Fuel switching",null,null,{"$f":"IF(L64=\"x\",P64,\"n/a\")","v":".."},"..","n/a",null,null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"Renewable energy targets",null,null,"..","..","n/a",null,null,null,"x","x",null,null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"Improving energy efficiency",null,null,"..","..","..",null,null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]
[null,null,"Energy planning (modelling)",null,null,"..","..","..",null,null,null,"x","x","x",null,{"$f":"$Q$8","v":".."},{"$f":"$Q$13","v":".."},{"$f":"$Q$38","v":".."}]