{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["COVER","REPORTING INSTRUCTIONS","REMARKS","COLUMN","LoadedData","PrefilledData","Parameter_mapping","Parameters"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":81,"n_cols":6,"rows_kept":81,"cut":false,"hidden":false,"merged":[[7,0,7,19]]}
["MINI-QUESTIONNAIRE"]
["NATURAL GAS"]
[{"$f":"COLUMN!Q1","v":2020}]
[{"$f":"COLUMN!R1","v":"ZZZZ"}]
[]
["EDAMIS dataset:",null,null,null,null,"ENERGY_MINIGAS_A"]
[]
["Please transmit to Eurostat by 31 May 2021."]
["This reporting template is operational if and only if Visual Basic macros are operational."]
["Please click the START button to make other sheets visible."]
["If the START button does not work, please enable execution of Visual Basic macros."]
[]
[]
[]
[]
["Notes:"]
["123","- cells with white background should not be edited"]
["123","- cells in blue background can be edited (please enter new data here)"]
[{"$f":"A18+A17-A21","v":123},"- cells with bold font are formulas (and if with blue background, they can be edited)"]
["123","- cells with light green background show growth rates to pre-filled data"]
["123","- cells with dark green font are voluntary (consumption side of energy balance)"]
[]
[]
["If you have any questions or comments, please contact:"]
["Marek.Sturc@ec.europa.eu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Albania","AL"]
["Austria","AT"]
["Belgium","BE"]
["Bosnia & Herzegovina","BA"]
["Bulgaria","BG"]
["Croatia","HR"]
["Cyprus","CY"]
["Czech Republic","CZ"]
["Denmark","DK"]
["Estonia","EE"]
["Finland","FI"]
["France","FR"]
["Georgia","GE"]
["Germany","DE"]
["Greece","EL"]
["Hungary","HU"]
["Iceland","IS"]
["Ireland","IE"]
["Italy","IT"]
["Kosovo (UNSCR 1244/99)","XK"]
["Latvia","LV"]
["Lithuania","LT"]
["Luxembourg","LU"]
["Malta","MT"]
["Moldova","MD"]
["Montenegro","ME"]
["Netherlands","NL"]
["North Macedonia","MK"]
["Norway","NO"]
["Poland","PL"]
["Portugal","PT"]
["Romania","RO"]
["Serbia","RS"]
["Slovak Republic","SK"]
["Slovenia","SI"]
["Spain","ES"]
["Sweden","SE"]
["Switzerland","CH"]
["Turkey","TR"]
["Ukraine","UA"]
["United Kingdom","UK"]
["ZZZ Other (code ZZ)","ZZ"]

{"sheet":"REPORTING INSTRUCTIONS","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":true,"merged":[[7,0,7,8]]}
["REPORTING INSTRUCTIONS"]
[]
["You can enter values or formulas. Please do not enter links to outside files."]
[]
["When completed, please transmit via EDAMIS to Eurostat: dataset ENERGY_MINIGAS_A"]
[]
["All definitions and instructions as for annual natural gas questionnaire apply."]
["http://ec.europa.eu/eurostat/web/energy/methodology/annual"]
[]
["FLAGS - STATUS of data points"]
["Hierarchy of observation flags - STATUS of values provided:"]
[null,"\" \" normal value = real observation = final value; value with the highest accuracy and reliability"]
["P","\"P\" provisional value or preliminary value; default status"]
["E","\"E\" estimated value or experimental value; indicated lower accuracy and reliability than provisional/preliminary values"]
["U","\"U\" uncertain value or value with very low reliability; please limit the use of this flag as much as possible"]
["O","\"O\" missing value (omitted - not available) - the cell with value should be zero or empty"]
[]
["Notes for colours and highlighting"]
["123","- cells with white background cannot be edited"]
["123","- cells in blue background can be edited (please enter new data/information here)"]
[{"$f":"A20+A19-A23","v":123},"- cells with bold font are formulas (and if with blue background, they can be edited)"]
["123","- cells with light green background show growth rates to pre-filled data"]
["123","- cells with dark green font are voluntary (consumption side of energy balance)"]

{"sheet":"REMARKS","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["REMARKS:"]

{"sheet":"COLUMN","index":3,"n_rows":19,"n_cols":134,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[null,null,"TJ GCV","product_id_e","flow_id_e","product_id_i","flow_id_i",{"$f":"Q1-1&\" prefilled from annual data\"","v":"2019 prefilled from annual data"},{"$f":"\"Prefilled as sum of monthly data for \" &Q1","v":"Prefilled as sum of monthly data for 2020"},{"$f":"Q1","v":2020},"STATUS","Growth rates\nto previous\nyear","Growth rates to sum of monthly","Observation Comment",null,null,2020,"ZZZZ",{"$f":"LOOKUP(R1,COVER!A40:A81,COVER!B40:B81)","v":"ZZ"},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,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,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,null,null,null,null,null,null,null,"VALUE","OBS_STATUS","OBS_COMMENT","REF_AREA","ENERGY_PRODUCT","MAIN_FLOW","FLOW_BREAKDOWN","PLANT_TECH","PLANT_TYPE","STOCKS","INFRASTRUCTURE_IND","VIS_A_VIS_AREA","MEASURE_VALUE_TYPE","FACILITY_ID","UNIT_MEASURE"]
[null,"Natural gas","Indigenous production","4100","B_100100",null,"INDPROD",{"$f":"PrefilledData!B6","v":0},{"$f":"SUM(PrefilledData!B30:M30)","v":0},0,"P",{"$f":"IF(ISERROR(J2/H2),\"\",(J2/H2)-1)","v":""},{"$f":"IF(ISERROR(J2/I2),\"\",(J2/I2) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K2=\"O\",\"NaN\",ROUND(J2,3))","v":0},{"$f":"IF(K2=\"\",\"A\",K2)","v":"P"},{"$f":"LEFT(TRIM(N2),255)","v":""},{"$f":"$S$1","v":"ZZ"},"G3000","PRODUCT","INDPROD","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","From Other Sources","4100","B_100200",null,"OSOURCES",{"$f":"PrefilledData!B7","v":0},null,0,"P",{"$f":"IF(ISERROR(J3/H3),\"\",(J3/H3)-1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K3=\"O\",\"NaN\",ROUND(J3,3))","v":0},"P",{"$f":"LEFT(TRIM(N3),255)","v":""},"ZZ","G3000","SUPPLY","OSOURCES","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Total Imports","4100","B_100300",null,"TOTIMPSB",{"$f":"PrefilledData!B8","v":0},null,0,"P","",{"$f":"IF(ISERROR(J4/I4),\"\",(J4/I4) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","IMPORTS","TOTIMPSB","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Total Exports","4100","B_100500",null,"TOTEXPSB",{"$f":"PrefilledData!B9","v":0},null,0,"P","",{"$f":"IF(ISERROR(J5/I5),\"\",(J5/I5) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","EXPORTS","TOTEXPSB","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Stock Changes","4100","B_100400",null,"STCHANAT",{"$f":"PrefilledData!B10","v":0},{"$f":"-SUM(PrefilledData!B34:M34)","v":0},0,"P","",{"$f":"IF(ISERROR(J6/I6),\"\",(J6/I6) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","STOCKS","STOCKCH","_Z","_Z","NATTER","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","International Marine Bunkers","4100","B_100800",null,"BUNKERS",{"$f":"PrefilledData!B11","v":0},null,0,"P","",{"$f":"IF(ISERROR(J7/I7),\"\",(J7/I7) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","MARBUNK","_Z","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Inland consumption (Calculated)",null,null,null,null,{"$f":"H2+H3+H4-H5+H6-H7","v":0},{"$f":"SUM(PrefilledData!B30:M32)-SUM(PrefilledData!B33:M35)","v":0},{"$f":"J2+J3+J4-J5+J6-J7","v":0},"P","",{"$f":"IF(ISERROR(J8/I8),\"\",(J8/I8) - 1)","v":""},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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","SUPPLY","INLDEMC","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Statistical Difference",null,null,null,null,{"$f":"H8-H10","v":0},null,{"$f":"J8-J10","v":0},"P",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","STATDIFF","_Z","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Inland consumption (Observed)",null,null,null,null,{"$f":"SUM(H11:H14)","v":0},null,{"$f":"J11+J12+J13+J14","v":0},"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","DEMAND","INLDEMO","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Transformation sector","4100","DB_101000",null,"TOTTRANF",{"$f":"PrefilledData!B12","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","TRANSFOR","TOTRANSF","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Energy sector","4100","DB_101300",null,"TOTENGY",{"$f":"PrefilledData!B13","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","ENERGUSE","ENERSECT","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Distribution losses","4100","B_101400",null,"DISTLOSS",{"$f":"PrefilledData!B14","v":0},{"$f":"SUM(PrefilledData!B36:M36)","v":0},0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","LOSSES","DISTLOSS","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Total final consumption",null,null,null,null,{"$f":"SUM(H15:H16)","v":0},null,{"$f":"J15+J16","v":0},"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","CONSUMPT","FINCONS","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Total final non-energy consumption","4100","B_101600",null,null,{"$f":"PrefilledData!B15","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","NONENUSE","FINCONS","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Total final energy consumption",null,null,null,null,{"$f":"SUM(H17:H19)","v":0},null,{"$f":"J17+J18+J19","v":0},"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","ENERGUSE","FINCONS","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Industry sector","4100","DB_101800",null,"TOTIND",{"$f":"PrefilledData!B16","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","ENERGUSE","INDUSTRY","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Transport sector","4100","B_101900",null,"TOTTRANS",{"$f":"PrefilledData!B17","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","ENERGUSE","TRANSPOR","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]
[null,"Natural gas","Other sectors","4100","B_102000",null,"TOTOTHER",{"$f":"PrefilledData!B18","v":0},null,0,"P","",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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"P","","ZZ","G3000","ENERGUSE","OTHSECT","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ_GCV"]

{"sheet":"LoadedData","index":4,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,{"$f":"IF(A1=F1,\"OK\",\"Error\")","v":"Error"},"Terajoules (Gross calorific values)",null,null,null,"Indigenous production",{"$f":"C2","v":0}]
[null,null,null,null,{"$f":"IF(A2=F2,\"OK\",\"Error\")","v":"Error"},"Indigenous Production            ",null,null,null,"From Other Sources",{"$f":"C3","v":0}]
[null,null,null,null,"Error","From Other Sources",null,null,null,"Total Imports",{"$f":"C4","v":0}]
[null,null,null,null,"Error","Total Imports (2)",null,null,null,"Total Exports",{"$f":"C5","v":0}]
[null,null,null,null,"Error","Total Exports (3)",null,null,null,"Stock Changes",{"$f":"C7","v":0}]
[null,null,null,null,"Error","International Marine Bunkers",null,null,null,"International Marine Bunkers",{"$f":"C6","v":0}]
[null,null,null,null,"Error","Stock Change",null,null,null,"Inland consumption (Calculated)"]
[null,null,null,null,"Error","Gross Inland Consumption (Calc)",null,null,null,"Statistical Difference"]
[null,null,null,null,"Error","Statistical Difference",null,null,null,"Inland consumption (Observed)",{"$f":"C10","v":0}]
[null,null,null,null,"Error","Gross Inland Consumption (Obs)",null,null,null,"Transformation sector",{"$f":"C15","v":0}]
[null,null,null,null,"Error","      Opening Stock Level (National territory)",null,null,null,"Energy sector",{"$f":"C17","v":0}]
[null,null,null,null,"Error","      Closing Stock Level (National territory)",null,null,null,"Distribution losses",0]
[null,null,null,null,"Error","      Opening Stock Level (Held abroad)",null,null,null,"Total final consumption",0]
[null,null,null,null,"Error","      Closing Stock Level (Held abroad)",null,null,null,"Total final non-energy consumption",0]
[null,null,null,null,"Error","   Transformation sector",null,null,null,"Total final energy consumption",0]
[null,null,null,null,"Error","of which input to electricity and heat generation",null,null,null,"Industry sector",0]
[null,null,null,null,"Error","   Energy sector",null,null,null,"Transport sector",0]
[null,null,null,null,"Error","   Distribution losses",null,null,null,"Other sectors",0]
[null,null,null,null,"Error","   Total final consumption"]
[null,null,null,null,"Error","      Total final non-energy consumption"]
[null,null,null,null,"Error","      Total final energy consumption"]
[null,null,null,null,"Error","      Industry sector"]
[null,null,null,null,"Error","      Transport sector"]
[null,null,null,null,"Error","      Other sectors"]
[null,null,null,null,"Error","         Of which: Residential   "]
[null,null,null,null,"Error","         Of which: Commercial and public services   "]
[null,null,null,null,"Error","Memo: From Other Sources - Oil   "]
[null,null,null,null,"Error","Memo: From Other Sources - Coal   "]
[null,null,null,null,"Error","Memo: From Other Sources - Renewables   "]
[null,null,null,null,{"$f":"COUNTIF(E1:E29,\"Error\")","v":29},"Number of errors"]

{"sheet":"PrefilledData","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Parameter_mapping","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Data sheet","Parameter sheet"]
["COLUMN","Parameters"]

{"sheet":"Parameters","index":7,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Element","Type","PosType","Position",null,"DataStart","DP2"]
["QUEST_SOURCE","DIM","FIX","A_MINIGAS",null,"DataEnd","DP19"]
["FREQ","DIM","FIX","A",null,"SkipIncompleteKeys","true"]
["REF_AREA","DIM","COLUMN","DS"]
["ENERGY_PRODUCT","DIM","COLUMN","DT"]
["MAIN_FLOW","DIM","COLUMN","DU"]
["FLOW_BREAKDOWN","DIM","COLUMN","DV"]
["PLANT_TECH","DIM","COLUMN","DW"]
["PLANT_TYPE","DIM","COLUMN","DX"]
["STOCKS","DIM","COLUMN","DY"]
["INFRASTRUCTURE_IND","DIM","COLUMN","DZ"]
["VIS_A_VIS_AREA","DIM","COLUMN","EA"]
["MEASURE_VALUE_TYPE","DIM","COLUMN","EB"]
["TIME_PERIOD","DIM","CELL","J1"]
["FACILITY_ID","DIM","COLUMN","EC"]
["UNIT_MEASURE","DIM","COLUMN","ED"]
["OBS_STATUS","ATT","COLUMN","DQ"]
["CONF_STATUS","ATT","SKIP"]
["COMMENT_OBS","ATT","COLUMN","DR"]
["FACILITY_TYPE","ATT","SKIP"]
["FACILITY_NAME","ATT","SKIP"]