{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["How to use","1.Prefill","2.Decompose indicators","Dropdowns","3.Concept Scheme","Concept Scheme bakup","XML_Fragments","4.DSD-Concept Matrix","5.DSDs","6.template","6.Dataflows","7.Generate SDMX","ConstraintsSummary","XML_Output","CL_FREQ","CL_AREA_NRG","CL_COMMODITY_NRG","CL_TRANSACTION_NRG","CL_UNIT_MEASURE_NRG","CL_UNIT_MULT","CL_OBS_STATUS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":45,"comments":10,"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":"How to use","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Use this tool with the ",null,null,"Guidelines on Modelling Statistical Domains in SDMX",null,null,null,null,null,"and other guidelines on SDMX.org"]
[]
["Step-by-step guide"]
[]
[]
[2,"Decompose existing indicators in the Indicator-Concept Matrix worksheet"]
[null,null,"If starting from an existing set of indicators, use the Indicator-Concept Matrix worksheet to list them in the \"Original indicators\" column"]
[null,null,"Examine each indicator and decompose it into its atomic Concepts by adding them in the \"Concepts->\" row"]
[null,null,null,"Mark how the concept(s) are used for the indicator using the legend"]
[null,null,null,"After decomposition, include any extra breakdowns that are required for the indicators"]
[3,"Create the Concept Scheme worksheet"]
[null,null,"Include the Concepts that were in the previous step by using the action \"Update Concept Scheme from Indicator matrix\" to prefill the concepts"]
[null,null,"Align the concept IDs and definitions with the SDMX Glossary"]
[null,null,"Commonly used concepts are already included, remove those that are not relevant.  "]
[null,null,"Complete the version, maintenance agency, and other details"]
[null,null,"To include several languages for the Concepts, add Concept Name:<language> and Concept Description:<language> columns to the Concepts table. Follow the same convention as used for Name and Descrption:en"]
[null,null,"Note: the numeric \"position\" of the concepts in the DSDs follow the top-to-bottom order that they appear in the Concept Scheme worksheet"]
[4,"Add Codelist worksheets"]
[null,null,"This may be done quickly by using the action \"Update DSD matrix and Code Lists from Concept Scheme\" on the Generate SDMX… worksheet"]
[null,null,"Use the Cross Domain Code Lists, Global Registry and other registries to reuse existing code lists"]
[null,null,"Ensure that the Agency, Version and isFinal state are set correctly. Set isFinal to false while experimenting/drafting the Codelist"]
[null,null,"Ensure that the name and description is for the codelist itself, they may be different from the concept name and description"]
[null,null,"Use the \"Guidelines for the creation and Management of SDMX Code Lists” to build codes"]
[null,null,"Cross Domain Code lists may need to be extended.  In this case the maintenance agency must change from SDMX"]
[null,null,"Annotation notation is JSON based and supports all annotation attributes and multiple annotations. Examples:"]
[null,null,null,"[{\"Id\":\"id1\",\"Title\":\"title1\",\"Type\":\"type1\",\"URL\":\"http://1.org\",\"Text\":[{\"Locale\":\"en\",\"Label\":\"textEn\"}]}]"]
[null,null,null,"Example of multiple annotations with multiple text languages:"]
[null,null,null,"[{\"Id\":\"id1\",\"Title\":\"title1\",\"Type\":\"type1\",\"URL\":\"http://1.org\",\"Text\":[{\"Locale\":\"en\",\"Label\":\"textEn\"},{\"Locale\":\"fr\",\"Label\":\"textFr\"}]},{\"Id\":\"id2\",\"Title\":\"title2\",\"Type\":\"type2\",\"URL\":\"http://2.org\",\"Text\":[{\"Locale\":\"en\",\"Label\":\"textEn2\"},{\"Locale\":\"fr\",\"Label\":\"textFr2\"}]}]"]
[1,"Add Dataflows to the Dataflows worksheet"]
[null,null,"To include several languages for the Dataflow name and description, add language, Name and Description values in the \"Multilingual labels\" section."]
[null,null,"The columns LAYOUT_ROW, LAYOUT_COLUMN, LAYOUT_ROW_SECTION, and NOT_DISPLAYED are for displaying Concepts on various areas of a presentation by default (if supported by the platform). Multiple concepts are comma-separated"]
[null,null,null,"In each column put one or more Concept(s) as relevant. For example, to display FREQ in a table's columns put FREQ underneath LAYOUT_COLUMN. To display REF_AREA and MEASURE in a table's rows put REF_AREA,MEASURE underneath LAYOUT_ROW"]
[5,"Complete the DSD-Concept Matrix worksheet"]
[null,null,"Select the Dataflow from the drop-down list from the Dataflows worksheet"]
[null,null,"For each dataflow, indicate which Concepts choose which ones are used and how"]
[null,null,null,"Use the legend symbols to indicate if all codes can be used (#), a subset (%), only one code (<the code>), or if the concept doesn't apply to the DSD (<blank>)"]
[null,null,"Group the concepts into logical DSDs using criteria such as which data needs to travel together in the same message/DSD, which Datafows are closely related conceptually, which Dataflows share similar dimensionality"]
[null,null,null,"Follow the section on \"Optimisation of the model\" part of the guideline on Modelling Statistical Domains in SDMX"]
[null,null,null,"Use the dimension count column to determine if the number of dimensions in the DSD are acceptable"]
[6,"Add the DSDs and their details to the DSDs worksheet"]
[null,null,"To include several languages for the DSD name and description, add Name:<language> and Description:<language> header cells. Follow the same convention as used for Name and Descrption:en"]
[null,null,"The columns LAYOUT_ROW, LAYOUT_COLUMN, LAYOUT_ROW_SECTION, and NOT_DISPLAYED are for displaying Concepts on various areas of a presentation by default (if supported by the platform). Multiple concepts are comma-separated"]
[null,null,null,"In each column put one or more Concept(s) as relevant. For example, to display FREQ in a table's columns put FREQ underneath LAYOUT_COLUMN. To display REF_AREA and MEASURE in a table's rows put REF_AREA,MEASURE underneath LAYOUT_ROW"]
[7,"Create the constraints on each Codelist worksheet"]
[null,null,"Use the \"Update Constraints from DSD Matrix\" action on the \"Generate SDMX & Params\" worksheet to prefill the Constraint information in each Codelist worksheet"]
[null,null,"Look at each Dataflow in the DSD-Concept Matrix. For each cell that has a subset (with the % symbol):"]
[null,null,null,"Go to the Concept's corresponding Code List. Find the Dataflow ID on the \"Dataflows\" row and the Concept ID underneath that cell (on the same line as \"Concepts\")"]
[null,null,null,"Enter 1 for all codes that are valid (in the constraint) for this Dataflow/Concept"]
[8,"Generate  the SDMX-ML "]
[null,null,"Check and change the Parameters section on the \"Generate SDMX-ML\" worksheet"]
[null,null,null,"It is possible to output structures directly to a SDMX webservice by setting Output folder... to the URL (http…)"]
[null,null,"Batch generate SDMX-ML for artefacts:"]
[null,null,null," Choose which artefacts to generate by changing the column: Generate? 0=No, 1=Yes. Enter 1 to generate the type of artefact"]

{"sheet":"1.Prefill","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Prefill Matrix Generator (Optional)",null,"Open User Guide"]
[]
[null,null,null,"File path:"]
[]
[null,null,null,"REST API URL:"]
[]
["Output"]

{"sheet":"2.Decompose indicators","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["MATRIX LEGEND\n#\n%\n<value>\n<blank>","\nAny value\nSeveral values allowed\nSingle value\nUnused","CONCEPTS\n|\nV"]
[null,"Source","Existing indicators"]

{"sheet":"Dropdowns","index":3,"n_rows":185,"n_cols":9,"rows_kept":185,"cut":false,"hidden":true,"merged":[]}
["drpDimAttrMeas","drpBoolean","drpSenderReceiver","drpConceptRoles","SimpleDataType","TimeDataType","drpLanguageCodes"]
["D (Frequency)",true,"S","VARIABLE","String","ObservationalTimePeriod","aa","Afar","Afaraf"]
["D (Time)",false,"R","FREQ","Alpha","StandardTimePeriod","ab","Abkhazian","аҧсуа бызшәа, аҧсшәа"]
["D",null,"S/R","OPERATION","AlphaNumeric","BasicTimePeriod","ae","Avestan","avesta"]
["M",null,null,"COMMENT","Numeric","GregorianTimePeriod","af","Afrikaans","Afrikaans"]
["A (obs, optional)",null,null,"GEO","BigInteger","GregorianYear","ak","Akan","Akan"]
["A (obs, mandatory)",null,null,"FLAG","Integer","GregorianYearMonth","am","Amharic","አማርኛ"]
["A (series, optional)",null,null,"ENTITY","Long","GregorianDay","an","Aragonese","aragonés"]
["A (series, mandatory)",null,null,null,"Short","ReportingTimePeriod","ar","Arabic","العربية"]
["A (dataset, optional)",null,null,null,"Decimal","ReportingYear","as","Assamese","অসমীয়া"]
["A (dataset, mandatory)",null,null,null,"Float","ReportingSemester","av","Avaric","авар мацӀ, магӀарул мацӀ"]
[null,null,null,null,"Double","ReportingTrimester","ay","Aymara","aymar aru"]
[null,null,null,null,"Boolean","ReportingQuarter","az","Azerbaijani","azərbaycan dili"]
[null,null,null,null,"URI","ReportingMonth","ba","Bashkir","башҡорт теле"]
[null,null,null,null,"Count","ReportingWeek","be","Belarusian","беларуская мова"]
[null,null,null,null,"InclusiveValueRange","ReportingDay","bg","Bulgarian","български език"]
[null,null,null,null,"ExclusiveValueRange","DateTime","bh","Bihari languages","भोजपुरी"]
[null,null,null,null,"Incremental","TimeRange","bi","Bislama","Bislama"]
[null,null,null,null,"ObservationalTimePeriod",null,"bm","Bambara","bamanankan"]
[null,null,null,null,"StandardTimePeriod",null,"bn","Bengali","বাংলা"]
[null,null,null,null,"BasicTimePeriod",null,"bo","Tibetan","བོད་ཡིག"]
[null,null,null,null,"GregorianTimePeriod",null,"br","Breton","brezhoneg"]
[null,null,null,null,"GregorianYear",null,"bs","Bosnian","bosanski jezik"]
[null,null,null,null,"GregorianYearMonth",null,"ca","Catalan, Valencian","català, valencià"]
[null,null,null,null,"GregorianDay",null,"ce","Chechen","нохчийн мотт"]
[null,null,null,null,"ReportingTimePeriod",null,"ch","Chamorro","Chamoru"]
[null,null,null,null,"ReportingYear",null,"co","Corsican","corsu, lingua corsa"]
[null,null,null,null,"ReportingSemester",null,"cr","Cree","ᓀᐦᐃᔭᐍᐏᐣ"]
[null,null,null,null,"ReportingTrimester",null,"cs","Czech","čeština, český jazyk"]
[null,null,null,null,"ReportingQuarter",null,"cu","Church Slavic, Old Slavonic, Church Slavonic, Old Bulgarian, Old Church Slavonic","ѩзыкъ словѣньскъ"]
[null,null,null,null,"ReportingMonth",null,"cv","Chuvash","чӑваш чӗлхи"]
[null,null,null,null,"ReportingWeek",null,"cy","Welsh","Cymraeg"]
[null,null,null,null,"ReportingDay",null,"da","Danish","dansk"]
[null,null,null,null,"DateTime",null,"de","German","Deutsch"]
[null,null,null,null,"TimeRange",null,"dv","Divehi, Dhivehi, Maldivian","ދިވެހި"]
[null,null,null,null,"Month",null,"dz","Dzongkha","རྫོང་ཁ"]
[null,null,null,null,"MonthDay",null,"ee","Ewe","Eʋegbe"]
[null,null,null,null,"Day",null,"el","Greek, Modern (1453-)","ελληνικά"]
[null,null,null,null,"Time",null,"en","English","English"]
[null,null,null,null,"Duration",null,"eo","Esperanto","Esperanto"]
[null,null,null,null,null,null,"es","Spanish, Castilian","Español"]
[null,null,null,null,null,null,"et","Estonian","eesti, eesti keel"]
[null,null,null,null,null,null,"eu","Basque","euskara, euskera"]
[null,null,null,null,null,null,"fa","Persian","فارسی"]
[null,null,null,null,null,null,"ff","Fulah","Fulfulde, Pulaar, Pular"]
[null,null,null,null,null,null,"fi","Finnish","suomi, suomen kieli"]
[null,null,null,null,null,null,"fj","Fijian","vosa Vakaviti"]
[null,null,null,null,null,null,"fo","Faroese","føroyskt"]
[null,null,null,null,null,null,"fr","French","français, langue française"]
[null,null,null,null,null,null,"fy","Western Frisian","Frysk"]
[null,null,null,null,null,null,"ga","Irish","Gaeilge"]
[null,null,null,null,null,null,"gd","Gaelic, Scottish Gaelic","Gàidhlig"]
[null,null,null,null,null,null,"gl","Galician","Galego"]
[null,null,null,null,null,null,"gn","Guarani","Avañe'ẽ"]
[null,null,null,null,null,null,"gu","Gujarati","ગુજરાતી"]
[null,null,null,null,null,null,"gv","Manx","Gaelg, Gailck"]
[null,null,null,null,null,null,"ha","Hausa","(Hausa) هَوُسَ"]
[null,null,null,null,null,null,"he","Hebrew","עברית"]
[null,null,null,null,null,null,"hi","Hindi","हिन्दी, हिंदी"]
[null,null,null,null,null,null,"ho","Hiri Motu","Hiri Motu"]
[null,null,null,null,null,null,"hr","Croatian","hrvatski jezik"]
[null,null,null,null,null,null,"ht","Haitian, Haitian Creole","Kreyòl ayisyen"]
[null,null,null,null,null,null,"hu","Hungarian","magyar"]
[null,null,null,null,null,null,"hy","Armenian","Հայերեն"]
[null,null,null,null,null,null,"hz","Herero","Otjiherero"]
[null,null,null,null,null,null,"ia","Interlingua (International Auxiliary Language Association)","Interlingua"]
[null,null,null,null,null,null,"id","Indonesian","Bahasa Indonesia"]
[null,null,null,null,null,null,"ie","Interlingue, Occidental","(originally:) Occidental, (after WWII:) Interlingue"]
[null,null,null,null,null,null,"ig","Igbo","Asụsụ Igbo"]
[null,null,null,null,null,null,"ii","Sichuan Yi, Nuosu","ꆈꌠ꒿ Nuosuhxop"]
[null,null,null,null,null,null,"ik","Inupiaq","Iñupiaq, Iñupiatun"]
[null,null,null,null,null,null,"io","Ido","Ido"]
[null,null,null,null,null,null,"is","Icelandic","Íslenska"]
[null,null,null,null,null,null,"it","Italian","Italiano"]
[null,null,null,null,null,null,"iu","Inuktitut","ᐃᓄᒃᑎᑐᑦ"]
[null,null,null,null,null,null,"ja","Japanese","日本語 (にほんご)"]
[null,null,null,null,null,null,"jv","Javanese","ꦧꦱꦗꦮ, Basa Jawa"]
[null,null,null,null,null,null,"ka","Georgian","ქართული"]
[null,null,null,null,null,null,"kg","Kongo","Kikongo"]
[null,null,null,null,null,null,"ki","Kikuyu, Gikuyu","Gĩkũyũ"]
[null,null,null,null,null,null,"kj","Kuanyama, Kwanyama","Kuanyama"]
[null,null,null,null,null,null,"kk","Kazakh","қазақ тілі"]
[null,null,null,null,null,null,"kl","Kalaallisut, Greenlandic","kalaallisut, kalaallit oqaasii"]
[null,null,null,null,null,null,"km","Central Khmer","ខ្មែរ, ខេមរភាសា, ភាសាខ្មែរ"]
[null,null,null,null,null,null,"kn","Kannada","ಕನ್ನಡ"]
[null,null,null,null,null,null,"ko","Korean","한국어"]
[null,null,null,null,null,null,"kr","Kanuri","Kanuri"]
[null,null,null,null,null,null,"ks","Kashmiri","कश्मीरी, كشميري‎"]
[null,null,null,null,null,null,"ku","Kurdish","Kurdî, کوردی‎"]
[null,null,null,null,null,null,"kv","Komi","коми кыв"]
[null,null,null,null,null,null,"kw","Cornish","Kernewek"]
[null,null,null,null,null,null,"ky","Kirghiz, Kyrgyz","Кыргызча, Кыргыз тили"]
[null,null,null,null,null,null,"la","Latin","latine, lingua latina"]
[null,null,null,null,null,null,"lb","Luxembourgish, Letzeburgesch","Lëtzebuergesch"]
[null,null,null,null,null,null,"lg","Ganda","Luganda"]
[null,null,null,null,null,null,"li","Limburgan, Limburger, Limburgish","Limburgs"]
[null,null,null,null,null,null,"ln","Lingala","Lingála"]
[null,null,null,null,null,null,"lo","Lao","ພາສາລາວ"]
[null,null,null,null,null,null,"lt","Lithuanian","lietuvių kalba"]
[null,null,null,null,null,null,"lu","Luba-Katanga","Kiluba"]
[null,null,null,null,null,null,"lv","Latvian","latviešu valoda"]
[null,null,null,null,null,null,"mg","Malagasy","fiteny malagasy"]
[null,null,null,null,null,null,"mh","Marshallese","Kajin M̧ajeļ"]
[null,null,null,null,null,null,"mi","Maori","te reo Māori"]
[null,null,null,null,null,null,"mk","Macedonian","македонски јазик"]
[null,null,null,null,null,null,"ml","Malayalam","മലയാളം"]
[null,null,null,null,null,null,"mn","Mongolian","Монгол хэл"]
[null,null,null,null,null,null,"mr","Marathi","मराठी"]
[null,null,null,null,null,null,"ms","Malay","Bahasa Melayu, بهاس ملايو‎"]
[null,null,null,null,null,null,"mt","Maltese","Malti"]
[null,null,null,null,null,null,"my","Burmese","ဗမာစာ"]
[null,null,null,null,null,null,"na","Nauru","Dorerin Naoero"]
[null,null,null,null,null,null,"nb","Norwegian Bokmål","Norsk Bokmål"]
[null,null,null,null,null,null,"nd","North Ndebele","isiNdebele"]
[null,null,null,null,null,null,"ne","Nepali","नेपाली"]
[null,null,null,null,null,null,"ng","Ndonga","Owambo"]
[null,null,null,null,null,null,"nl","Dutch, Flemish","Nederlands, Vlaams"]
[null,null,null,null,null,null,"nn","Norwegian Nynorsk","Norsk Nynorsk"]
[null,null,null,null,null,null,"no","Norwegian","Norsk"]
[null,null,null,null,null,null,"nr","South Ndebele","isiNdebele"]
[null,null,null,null,null,null,"nv","Navajo, Navaho","Diné bizaad"]
[null,null,null,null,null,null,"ny","Chichewa, Chewa, Nyanja","chiCheŵa, chinyanja"]
[null,null,null,null,null,null,"oc","Occitan","occitan, lenga d'òc"]
[null,null,null,null,null,null,"oj","Ojibwa","ᐊᓂᔑᓈᐯᒧᐎᓐ"]
[null,null,null,null,null,null,"om","Oromo","Afaan Oromoo"]
[null,null,null,null,null,null,"or","Oriya","ଓଡ଼ିଆ"]
[null,null,null,null,null,null,"os","Ossetian, Ossetic","ирон æвзаг"]
[null,null,null,null,null,null,"pa","Punjabi, Panjabi","ਪੰਜਾਬੀ, پنجابی‎"]
[null,null,null,null,null,null,"pi","Pali","पालि, पाळि"]
[null,null,null,null,null,null,"pl","Polish","język polski, polszczyzna"]
[null,null,null,null,null,null,"ps","Pashto, Pushto","پښتو"]
[null,null,null,null,null,null,"pt","Portuguese","Português"]
[null,null,null,null,null,null,"qu","Quechua","Runa Simi, Kichwa"]
[null,null,null,null,null,null,"rm","Romansh","Rumantsch Grischun"]
[null,null,null,null,null,null,"rn","Rundi","Ikirundi"]
[null,null,null,null,null,null,"ro","Romanian, Moldavian, Moldovan","Română"]
[null,null,null,null,null,null,"ru","Russian","русский"]
[null,null,null,null,null,null,"rw","Kinyarwanda","Ikinyarwanda"]
[null,null,null,null,null,null,"sa","Sanskrit","संस्कृतम्"]
[null,null,null,null,null,null,"sc","Sardinian","sardu"]
[null,null,null,null,null,null,"sd","Sindhi","सिन्धी, سنڌي، سندھی‎"]
[null,null,null,null,null,null,"se","Northern Sami","Davvisámegiella"]
[null,null,null,null,null,null,"sg","Sango","yângâ tî sängö"]
[null,null,null,null,null,null,"si","Sinhala, Sinhalese","සිංහල"]
[null,null,null,null,null,null,"sk","Slovak","Slovenčina, Slovenský Jazyk"]
[null,null,null,null,null,null,"sl","Slovenian","Slovenski Jezik, Slovenščina"]
[null,null,null,null,null,null,"sm","Samoan","gagana fa'a Samoa"]
[null,null,null,null,null,null,"sn","Shona","chiShona"]
[null,null,null,null,null,null,"so","Somali","Soomaaliga, af Soomaali"]
[null,null,null,null,null,null,"sq","Albanian","Shqip"]
[null,null,null,null,null,null,"sr","Serbian","српски језик"]
[null,null,null,null,null,null,"ss","Swati","SiSwati"]
[null,null,null,null,null,null,"st","Southern Sotho","Sesotho"]
[null,null,null,null,null,null,"su","Sundanese","Basa Sunda"]
[null,null,null,null,null,null,"sv","Swedish","Svenska"]
[null,null,null,null,null,null,"sw","Swahili","Kiswahili"]
[null,null,null,null,null,null,"ta","Tamil","தமிழ்"]
[null,null,null,null,null,null,"te","Telugu","తెలుగు"]
[null,null,null,null,null,null,"tg","Tajik","тоҷикӣ, toçikī, تاجیکی‎"]
[null,null,null,null,null,null,"th","Thai","ไทย"]
[null,null,null,null,null,null,"ti","Tigrinya","ትግርኛ"]
[null,null,null,null,null,null,"tk","Turkmen","Türkmen, Түркмен"]
[null,null,null,null,null,null,"tl","Tagalog","Wikang Tagalog"]
[null,null,null,null,null,null,"tn","Tswana","Setswana"]
[null,null,null,null,null,null,"to","Tonga (Tonga Islands)","Faka Tonga"]
[null,null,null,null,null,null,"tr","Turkish","Türkçe"]
[null,null,null,null,null,null,"ts","Tsonga","Xitsonga"]
[null,null,null,null,null,null,"tt","Tatar","татар теле, tatar tele"]
[null,null,null,null,null,null,"tw","Twi","Twi"]
[null,null,null,null,null,null,"ty","Tahitian","Reo Tahiti"]
[null,null,null,null,null,null,"ug","Uighur, Uyghur","ئۇيغۇرچە‎, Uyghurche"]
[null,null,null,null,null,null,"uk","Ukrainian","Українська"]
[null,null,null,null,null,null,"ur","Urdu","اردو"]
[null,null,null,null,null,null,"uz","Uzbek","Oʻzbek, Ўзбек, أۇزبېك‎"]
[null,null,null,null,null,null,"ve","Venda","Tshivenḓa"]
[null,null,null,null,null,null,"vi","Vietnamese","Tiếng Việt"]
[null,null,null,null,null,null,"vo","Volapük","Volapük"]
[null,null,null,null,null,null,"wa","Walloon","Walon"]
[null,null,null,null,null,null,"wo","Wolof","Wollof"]
[null,null,null,null,null,null,"xh","Xhosa","isiXhosa"]
[null,null,null,null,null,null,"yi","Yiddish","ייִדיש"]
[null,null,null,null,null,null,"yo","Yoruba","Yorùbá"]
[null,null,null,null,null,null,"za","Zhuang, Chuang","Saɯ cueŋƅ, Saw cuengh"]
[null,null,null,null,null,null,"zh","Chinese","中文 (Zhōngwén), 汉语, 漢語"]
[null,null,null,null,null,null,"zu","Zulu","isiZulu"]

{"sheet":"3.Concept Scheme","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["CONCEPT SCHEME ARTEFACT INFORMATION"]
["Agency Id*","UNSD"]
["Version*","1.0"]
["Id*","CS_ENERGY"]
["Is final?*",true]
["Multilingual labels"]
["Language*","en"]
["Name*","Energy concept scheme"]
["Description"]
["CONCEPTS"]
["Dimension (D)\nAttribute (A)\nMeasure (M)","Concept ID","Code List or Uncoded","Type (for Uncoded Concepts)","Min length","Max length","Concept Role","Concept Name:en","Concept Description:en"]
["D","FREQ","CL_FREQ",null,null,null,null,"Frequency"]
["D","REF_AREA","CL_AREA_NRG",null,null,null,null,"Reference Area"]
["D","COMMODITY","CL_COMMODITY_NRG",null,null,null,null,"Commodity"]
["D","TRANSACTION","CL_TRANSACTION_NRG",null,null,null,null,"Transaction"]
["D (Time)","TIME_PERIOD","Uncoded","ObservationalTimePeriod",null,null,null,"Time period"]
["M","OBS_VALUE","Uncoded",null,null,null,null,"Observation value"]
["A (obs, mandatory)","UNIT_MULT","CL_UNIT_MULT",null,null,null,null,"Unit Multiplier"]
["A (series, mandatory)","UNIT_MEASURE","CL_UNIT_MEASURE_NRG",null,null,null,null,"Unit of Measure"]
["A (obs, mandatory)","OBS_STATUS","CL_OBS_STATUS",null,null,null,null,"Observation status"]

{"sheet":"Concept Scheme bakup","index":5,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["CONCEPT SCHEME ARTEFACT INFORMATION"]
["Agency Id","AGENCY"]
["Version","1.0"]
["Id","CS_TEST"]
["Is final?",false]
["Multilingual labels"]
["Language","en"]
["Name","Test Concept Scheme"]
["Description"]
["CONCEPTS"]
["Dimension (D)\nAttribute (A)\nMeasure (M)","Concept ID","Code List and \nRegistry Link","Type","Min length","Max length","Concept Role","Concept Name:en","Concept Definition:en"]
["D (Frequency)","FREQ","CL_FREQ",null,null,null,null,"Frequency","Time interval at which observations occur over a given time period"]
["D","REF_AREA","CL_AREA",null,null,null,null,"Reference area ","Country or geographic area to which the measured statistical phenomenon relates."]
["D","UNIT_MEASURE","CL_UNIT_MEASURE",null,null,null,null,"Unit of measure","Unit in which the data values are expressed."]
["D","MEASURE","CL_MEASURE",null,null,null,null,"Measure","Data element that represents a simple aggregation and which takes one or more vectors as arguments and returns a scalar."]
["D (Time)","TIME_PERIOD","Uncoded","DateTime",null,null,null,"Time period","Time span or point in time to which the observation actually refers"]
["M","OBS_VALUE","Uncoded","Double",1,25,null,"Observation value","Observation value"]
["A (dataset, mandatory)","UNIT_MULT","CL_UNIT_MULT",null,null,null,null,"Unit multiplier","Exponent in base 10 specified so that multiplying the observation numeric values by 10^UNIT_MULT gives a value expressed in the unit of measure"]
["A (obs, optional)","OBS_STATUS","CL_OBS_STATUS",null,null,null,null,"Observation status","Information on the quality of a value or an unusual or missing value"]
["A (obs, optional)","CONF_STATUS","CL_CONF_STATUS",null,null,null,null,"Confidentiality status","Information about the confidentiality status of the object to which this attribute is attached"]
["A (obs, optional)","TEST_ATTR","Uncoded","String",1,250,null,"edwed","weweef"]

{"sheet":"XML_Fragments","index":6,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Codelist","Header fields. Attribute separator is \"|\". Key/Value separator is \":\" Blank values are defaulted"]
["<str:Codelist xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" id=\"\" urn=\"\" agencyID=\"\" isFinal=\"\" version=\"\"></str:Codelist>"]
["ConceptScheme"]
["<str:ConceptScheme xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" id=\"\" urn=\"\" isExternalReference=\"false\" agencyID=\"\" isFinal=\"\" version=\"\"></str:ConceptScheme>"]
["DSDOuter"]
["<?xml version='1.0' encoding='UTF-8'?><mes:Structure xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xsi:schemaLocation=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message https://registry.sdmx.org/schemas/v2_1/SDMXMessage.xsd\"><mes:Header><mes:ID/><mes:Test>false</mes:Test><mes:Prepared/><mes:Sender id=\"not_supplied\"/><mes:Receiver id=\"not_supplied\"/></mes:Header><mes:Structures><str:DataStructures/></mes:Structures></mes:Structure>"]
["DSDMain"]
["<str:DataStructure xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" id=\"\" urn=\"\" isExternalReference=\"false\" agencyID=\"\" isFinal=\"\" version=\"\"><str:DataStructureComponents><str:DimensionList id=\"DimensionDescriptor\" urn=\"\"/><str:AttributeList id=\"AttributeDescriptor\" urn=\"\"/><str:MeasureList id=\"MeasureDescriptor\" urn=\"\"/></str:DataStructureComponents></str:DataStructure>"]
["DSDTime"]
["<str:TimeDimension xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" position=\"\" id=\"\" urn=\"\"><str:ConceptIdentity><Ref id=\"\" maintainableParentID=\"\" package=\"conceptscheme\" class=\"Concept\" agencyID=\"\" maintainableParentVersion=\"\"/></str:ConceptIdentity><str:LocalRepresentation><str:TextFormat textType=\"\"/></str:LocalRepresentation></str:TimeDimension>"]
["DSDDimension"]
["<str:Dimension xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" position=\"\" id=\"\" urn=\"\"><str:ConceptIdentity><Ref id=\"\" maintainableParentID=\"\" package=\"conceptscheme\" class=\"Concept\" agencyID=\"\" maintainableParentVersion=\"\"/></str:ConceptIdentity><str:LocalRepresentation><str:Enumeration><Ref id=\"\" package=\"codelist\" class=\"Codelist\" agencyID=\"\" version=\"\"/></str:Enumeration><str:EnumerationFormat maxLength=\"\" minLength=\"\" textType=\"\"/></str:LocalRepresentation></str:Dimension>"]
["DSDAttribute"]
["<str:Attribute xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" id=\"\" urn=\"\" assignmentStatus=\"\"><str:ConceptIdentity><Ref id=\"\" maintainableParentID=\"\" package=\"conceptscheme\" class=\"Concept\" agencyID=\"\" maintainableParentVersion=\"\"/></str:ConceptIdentity><str:LocalRepresentation><str:Enumeration><Ref id=\"\" package=\"codelist\" class=\"Codelist\" agencyID=\"\" version=\"\"/></str:Enumeration><str:EnumerationFormat maxLength=\"\" minLength=\"\" textType=\"\"/></str:LocalRepresentation></str:Attribute>"]
["DSDMeasure"]
["<str:PrimaryMeasure xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" id=\"\" urn=\"\"><str:ConceptIdentity><Ref id=\"\" maintainableParentID=\"\" package=\"conceptscheme\" class=\"Concept\" agencyID=\"\" maintainableParentVersion=\"\"/></str:ConceptIdentity><str:LocalRepresentation><str:TextFormat maxLength=\"\" textType=\"\"/></str:LocalRepresentation></str:PrimaryMeasure>"]
["DataflowOuter"]
["<?xml version='1.0' encoding='UTF-8'?><mes:Structure xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xsi:schemaLocation=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message https://registry.sdmx.org/schemas/v2_1/SDMXMessage.xsd\"><mes:Header><mes:ID/><mes:Test>false</mes:Test><mes:Prepared/><mes:Sender id=\"not_supplied\"/><mes:Receiver id=\"not_supplied\"/></mes:Header><mes:Structures><str:Dataflows/></mes:Structures></mes:Structure>"]
["DataflowMain"]
["<str:Dataflow xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" id=\"\" urn=\"\" isExternalReference=\"false\" agencyID=\"\" isFinal=\"\" version=\"\"><str:Structure><Ref id=\"\" package=\"datastructure\" class=\"DataStructure\" agencyID=\"\" version=\"\"/></str:Structure></str:Dataflow>"]
["AgencySchemeOuter"]
["<?xml version='1.0' encoding='UTF-8'?><mes:Structure xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xsi:schemaLocation=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message https://registry.sdmx.org/schemas/v2_1/SDMXMessage.xsd\"><mes:Structures><str:OrganisationSchemes><str:AgencyScheme id=\"\" urn=\"\" isExternalReference=\"false\" agencyID=\"\" isFinal=\"\" version=\"\"><com:Name xml:lang=\"en\"></com:Name></str:AgencyScheme></str:OrganisationSchemes></mes:Structures></mes:Structure>"]
["ConstraintMain"]
["<str:ContentConstraint xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" id=\"\" urn=\"\" isExternalReference=\"\" agencyID=\"\" type=\"\" isFinal=\"\" version=\"\"><com:Name xml:lang=\"en\"></com:Name><com:Description xml:lang=\"en\"></com:Description><str:ConstraintAttachment><str:Dataflow><Ref id=\"\" package=\"datastructure\" class=\"Dataflow\" agencyID=\"\" version=\"\"/></str:Dataflow></str:ConstraintAttachment><str:CubeRegion include=\"\" /></str:ContentConstraint> "]
["StructureOuter"]
["<?xml version='1.0' encoding='UTF-8'?><mes:Structure xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xsi:schemaLocation=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message https://registry.sdmx.org/schemas/v2_1/SDMXMessage.xsd\"><mes:Header><mes:ID></mes:ID><mes:Test></mes:Test><mes:Prepared></mes:Prepared><mes:Sender id=\"\"/><mes:Receiver id=\"\"/></mes:Header><mes:Structures><str:Dataflows></str:Dataflows><str:Categorisations></str:Categorisations><str:Codelists></str:Codelists><str:Concepts></str:Concepts><str:DataStructures></str:DataStructures><str:Constraints></str:Constraints></mes:Structures></mes:Structure>","ID:|Test:|Prepared:|Sender:Undefined|Receiver:Undefined"]
["CategorisationMain"]
["<str:Categorisation xmlns:str=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/structure\" xmlns:com=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" id=\"\" urn=\"\" agencyID=\"\" version=\"\" isFinal=\"\"><com:Name xml:lang=\"en\"></com:Name><str:Source><Ref id=\"\" version=\"\" agencyID=\"\" package=\"\" class=\"\" /></str:Source><str:Target><Ref id=\"\" maintainableParentID=\"\" maintainableParentVersion=\"\" agencyID=\"\" package=\"categoryscheme\" class=\"Category\" /></str:Target></str:Categorisation>"]
["AgencySchemeMain"]
["<str:Agency id=\"\" urn=\"\"><com:Name xml:lang=\"en\"></com:Name><com:Description xml:lang=\"en\"></com:Description><str:Contact><com:Name xml:lang=\"en\"></com:Name><str:Department xml:lang=\"en\"></str:Department><str:Role xml:lang=\"en\"></str:Role><str:Telephone></str:Telephone><str:URI></str:URI><str:Email></str:Email></str:Contact></str:Agency>"]
["DataMain"]
["<?xml version='1.0' encoding='UTF-8'?><mes:StructureSpecificData xmlns:ss=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/data/structurespecific\" xmlns:footer=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message/footer\" xmlns:ns1=\"urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=?:?(?.?):ObsLevelDim:TIME_PERIOD\" xmlns:mes=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message\" xmlns:common=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/common\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.sdmx.org/resources/sdmxml/schemas/v2_1/message https://registry.sdmx.org/schemas/v2_1/SDMXMessage.xsd\"><mes:Header><mes:ID/><mes:Test/><mes:Prepared/><mes:Sender id=\"?\"><common:Name xml:lang=\"fr\"/></mes:Sender><mes:Structure structureID=\"?\" namespace=\"urn:sdmx:org.sdmx.infomodel.datastructure.Dataflow=?:?(?.?):ObsLevelDim:TIME_PERIOD\" dimensionAtObservation=\"TIME_PERIOD\"><common:StructureUsage><Ref agencyID=\"?\" id=\"?\" version=\"?.?\"/></common:StructureUsage></mes:Structure><mes:Source xml:lang=\"en\">?</mes:Source></mes:Header><mes:DataSet ss:dataScope=\"DataStructure\" xsi:type=\"ns1:DataSetType\" ss:structureRef=\"?\"/></mes:StructureSpecificData>"]

{"sheet":"4.DSD-Concept Matrix","index":7,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"MATRIX LEGEND\n#\n%\n<code>\n<blank>","\nAny code\nSeveral codes allowed\nSingle code\nUnused","CONCEPTS\n|\nV","FREQ","REF_AREA","COMMODITY","TRANSACTION","TIME_PERIOD","OBS_VALUE","UNIT_MULT","UNIT_MEASURE","OBS_STATUS"]
["Agency","Public",null,"DSD Id","Data flow Id"]
[null,null,null,"DSD_ENERGY","DF_UNDATA_ENERGY","A","#","#","#","#","#","#","#","#"]

{"sheet":"5.DSDs","index":8,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null," "]
["ID*","Agency*","Version*","IsFinal*","Name:en","Description:en"]
["DSD_ENERGY","UNSD","1.0",true,"Dissemination DSD for Energy Statistics"]

{"sheet":"6.template","index":9,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
["ID*","Agency*","Version*","IsFinal*","Cat.Scheme Agency","Cat.Scheme ID","Cat.Scheme Version","Category","Constraint ID","LAYOUT_ROW","LAYOUT_COLUMN","LAYOUT_ROW_SECTION","MICRODATA","MICRODATA_CONCEPTS","NOT_DISPLAYED","DEFAULT","UNIT_MEASURE_CONCEPTS"]

{"sheet":"6.Dataflows","index":10,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ID*","Agency*","Version*","IsFinal*","Name:en","Description:en","Cat.Scheme Agency","Cat.Scheme ID","Cat.Scheme Version","Category","Constraint ID","LAYOUT_ROW","LAYOUT_COLUMN","LAYOUT_ROW_SECTION","MICRODATA","MICRODATA_CONCEPTS","NOT_DISPLAYED","DEFAULT","UNIT_MEASURE_CONCEPTS"]
["DF_UNDATA_ENERGY","UNSD","1.0",true,"Energy statistics dataflow",null,null,null,null,null,"CR_DF_UNDATA_ENERGY","COMMODITY,TRANSACTION","TIME_PERIOD","REF_AREA",null,null,"FREQ,OBS_STATUS=A,UNIT_MULT=0"]

{"sheet":"7.Generate SDMX","index":11,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,4,2,5]]}
["Generate SDMX","Open User Guide"]
[]
["Generate? 0=No, 1=Yes","Artefact","Prerequisites",null,"Parameters"]
[1,"Concept Scheme","Step 3",null,"Output folder:","c:\\temp\\"]
[1,"Codelists","CL_ Codelists",null,"Webservice endpoint:"]
[1,"DSDs","Step 3,4,5,CL_worksheets",null,"Output to folder:1, Webservice:2, or both:3",1]
[1,"Dataflows","Step 3,4,5,6,CL_worksheets",null,"Create separate files? 0=No, 1=Yes:",0]
[0,"Categorisations","Step 6 Dataflows with Category fields",null,"Filename prefix:","DSD_ENERGY"]
[0,"Constraints","Step 3,4,5,6,CL_ Codelists with Constraints",null,"XML app for opening file:","C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome.exe"]
[null,null,null,null,"Log file (full path):","c:\\temp\\MatrixGen.txt "]
[]
["Generate Dataset Stub"]
[]
[null,null,null,null,"Dataflow Id for Dataset stub:"]
["Other actions"]
[null,null,null,null,"Final status:",true]
[null,null,null,null,"Agency:","AGENCY"]
["Output"]
["\r\r\nSDMX generated to c:\\temp\\DSD_ENERGY_Multiple.xml"]

{"sheet":"ConstraintsSummary","index":12,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ConstraintID","Dataflow","Concepts",null,"Note: This worksheet is only updated when constraints are prefilled, generated or with the \"Remove all Constraints\" action"]
[null,null,"FREQ"]
["UNSD:CR_DF_UNDATA_ENERGY(1.0)","UNSD:DF_UNDATA_ENERGY(1.0)","A"]

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

{"sheet":"CL_FREQ","index":14,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","SDMX"]
["Version*","2.0"]
["Id*","CL_FREQ"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Frequency"]
["Description"]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->","DF_UNDATA_ENERGY"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->","FREQ"]
["A",null,null,null,"Annual","To be used for data collected or disseminated every year.",null,"1"]
["S",null,null,null,"Half-yearly, semester","To be used for data collected or disseminated every semester."]
["Q",null,null,null,"Quarterly","To be used for data collected or disseminated every quarter."]
["M",null,null,null,"Monthly","To be used for data collected or disseminated every month."]
["W",null,null,null,"Weekly","To be used for data collected or disseminated every week."]
["D",null,null,null,"Daily","To be used for data collected or disseminated every day."]
["H",null,null,null,"Hourly","To be used for data collected or disseminated every hour."]
["B",null,null,null,"Daily – businessweek","Similar to \"daily\", however there are no observations for Saturdays and Sundays (so, neither \"missing values\" nor \"numeric values\" should be provided for Saturday and Sunday). This treatment  (\"business\") is one way to deal with such cases, but it is not the only option. Such a time series could alternatively be considered daily (\"D\"), thus, with missing values in the weekend."]
["N",null,null,null,"Minutely","While N denotes \"minutely\", usually, there may be no observations every minute (for several series the frequency is usually \"irregular\" within a day/days). And though observations may be sparse (not collected or disseminated every minute), missing values do not need to be given for the minutes when no observations exist: in any case the time stamp determines when an observation is observed."]

{"sheet":"CL_AREA_NRG","index":15,"n_rows":262,"n_cols":7,"rows_kept":262,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","UNSD"]
["Version*","1.0"]
["Id*","CL_AREA_NRG"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Reference area code list"]
["Description"]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["004",null,"10",null,"Afghanistan"]
["008",null,"20",null,"Albania"]
["012",null,"30",null,"Algeria"]
["016",null,"40",null,"American Samoa"]
["020",null,"50",null,"Andorra"]
["024",null,"60",null,"Angola"]
["028",null,"90",null,"Antigua and Barbuda"]
["031",null,"150",null,"Azerbaijan"]
["032",null,"100",null,"Argentina"]
["036",null,"130",null,"Australia"]
["040",null,"140",null,"Austria"]
["044",null,"160",null,"Bahamas"]
["048",null,"170",null,"Bahrain"]
["050",null,"180",null,"Bangladesh"]
["051",null,"110",null,"Armenia"]
["052",null,"190",null,"Barbados"]
["056",null,"210",null,"Belgium"]
["060",null,"240",null,"Bermuda"]
["064",null,"250",null,"Bhutan"]
["068",null,"260",null,"Bolivia"]
["070",null,"280",null,"Bosnia and Herzegovina"]
["072",null,"290",null,"Botswana"]
["076",null,"300",null,"Brazil"]
["081",null,"80",null,"Antarctic Fisheries"]
["084",null,"220",null,"Belize"]
["090",null,"2070",null,"Solomon Islands"]
["092",null,"310",null,"British Virgin Islands"]
["096",null,"320",null,"Brunei Darussalam"]
["100",null,"330",null,"Bulgaria"]
["104",null,"1540",null,"Myanmar"]
["108",null,"350",null,"Burundi"]
["112",null,"200",null,"Belarus"]
["116",null,"370",null,"Cambodia"]
["120",null,"380",null,"Cameroon"]
["124",null,"390",null,"Canada"]
["132",null,"360",null,"Cabo Verde"]
["136",null,"400",null,"Cayman Islands"]
["140",null,"410",null,"Central African Republic"]
["144",null,"2120",null,"Sri Lanka"]
["148",null,"420",null,"Chad"]
["152",null,"430",null,"Chile"]
["156",null,"440",null,"China"]
["158",null,"1700",null,"Other Asia"]
["170",null,"470",null,"Colombia"]
["172",null,"480",null,"Commonwealth of Independent States (CIS)"]
["174",null,"490",null,"Comoros"]
["175",null,"1450",null,"Mayotte"]
["176",null,"1460",null,"Mayotte (up to 2010)"]
["178",null,"500",null,"Congo"]
["180",null,"610",null,"Democratic Republic of the Congo"]
["184",null,"510",null,"Cook Islands"]
["188",null,"520",null,"Costa Rica"]
["191",null,"540",null,"Croatia"]
["192",null,"550",null,"Cuba"]
["196",null,"570",null,"Cyprus"]
["200",null,"590",null,"Czechoslovakia [former]"]
["203",null,"580",null,"Czech Republic"]
["204",null,"230",null,"Benin"]
["208",null,"630",null,"Denmark"]
["212",null,"650",null,"Dominica"]
["214",null,"660",null,"Dominican Republic"]
["218",null,"670",null,"Ecuador"]
["222",null,"690",null,"El Salvador"]
["226",null,"700",null,"Equatorial Guinea"]
["230",null,"750",null,"Ethiopia [up to 1993]"]
["231",null,"740",null,"Ethiopia [from 1993]"]
["232",null,"710",null,"Eritrea"]
["233",null,"720",null,"Estonia"]
["234",null,"760",null,"Faeroe Islands"]
["238",null,"770",null,"Falkland Islands (Malvinas)"]
["242",null,"780",null,"Fiji"]
["246",null,"790",null,"Finland"]
["251",null,"800",null,"France incl. Monaco"]
["254",null,"810",null,"French Guiana"]
["255",null,"820",null,"French Guiana (up to 2010)"]
["258",null,"830",null,"French Polynesia"]
["262",null,"640",null,"Djibouti"]
["266",null,"840",null,"Gabon"]
["268",null,"860",null,"Georgia"]
["270",null,"850",null,"Gambia"]
["275",null,"2130",null,"State of Palestine"]
["276",null,"880",null,"Germany"]
["278",null,"870",null,"German Democratic Republic [former]"]
["280",null,"890",null,"Germany, Federal Republic of"]
["288",null,"900",null,"Ghana"]
["292",null,"910",null,"Gibraltar"]
["296",null,"1210",null,"Kiribati"]
["300",null,"920",null,"Greece"]
["304",null,"930",null,"Greenland"]
["308",null,"940",null,"Grenada"]
["312",null,"950",null,"Guadeloupe"]
["313",null,"960",null,"Guadeloupe (up to 2010)"]
["316",null,"970",null,"Guam"]
["320",null,"980",null,"Guatemala"]
["324",null,"1000",null,"Guinea"]
["328",null,"1020",null,"Guyana"]
["332",null,"1030",null,"Haiti"]
["340",null,"1040",null,"Honduras"]
["344",null,"450",null,"China, Hong Kong Special Administrative Region"]
["348",null,"1050",null,"Hungary"]
["352",null,"1060",null,"Iceland"]
["356",null,"1070",null,"India"]
["360",null,"1080",null,"Indonesia"]
["364",null,"1090",null,"Iran (Islamic Republic of)"]
["368",null,"1100",null,"Iraq"]
["372",null,"1110",null,"Ireland"]
["376",null,"1130",null,"Israel"]
["382",null,"1140",null,"Italy and San Marino"]
["384",null,"530",null,"Cote d'Ivoire"]
["388",null,"1150",null,"Jamaica"]
["392",null,"1160",null,"Japan"]
["398",null,"1190",null,"Kazakhstan"]
["400",null,"1180",null,"Jordan"]
["404",null,"1200",null,"Kenya"]
["408",null,"600",null,"Democratic People's Republic of Korea"]
["410",null,"1830",null,"Republic of Korea"]
["412",null,"1220",null,"Kosovo"]
["414",null,"1230",null,"Kuwait"]
["417",null,"1240",null,"Kyrgyzstan"]
["418",null,"1250",null,"Lao People's Democratic Republic"]
["422",null,"1270",null,"Lebanon"]
["426",null,"1280",null,"Lesotho"]
["428",null,"1260",null,"Latvia"]
["430",null,"1290",null,"Liberia"]
["434",null,"1300",null,"Libya"]
["438",null,"1310",null,"Liechtenstein"]
["440",null,"1320",null,"Lithuania"]
["442",null,"1330",null,"Luxembourg"]
["446",null,"460",null,"China, Macao Special Administrative Region"]
["450",null,"1340",null,"Madagascar"]
["454",null,"1350",null,"Malawi"]
["458",null,"1360",null,"Malaysia"]
["462",null,"1370",null,"Maldives"]
["466",null,"1380",null,"Mali"]
["470",null,"1390",null,"Malta"]
["474",null,"1410",null,"Martinique"]
["475",null,"1420",null,"Martinique (up to 2010)"]
["478",null,"1430",null,"Mauritania"]
["480",null,"1440",null,"Mauritius"]
["484",null,"1470",null,"Mexico"]
["496",null,"1490",null,"Mongolia"]
["498",null,"1840",null,"Republic of Moldova"]
["499",null,"1500",null,"Montenegro"]
["500",null,"1510",null,"Montserrat"]
["504",null,"1520",null,"Morocco"]
["508",null,"1530",null,"Mozambique"]
["512",null,"1690",null,"Oman"]
["516",null,"1550",null,"Namibia"]
["520",null,"1560",null,"Nauru"]
["524",null,"1570",null,"Nepal"]
["528",null,"1580",null,"Netherlands"]
["530",null,"1590",null,"Netherlands Antilles"]
["531",null,"560",null,"Curaçao"]
["533",null,"120",null,"Aruba"]
["534",null,"2040",null,"Sint Maarten (Dutch part)"]
["535",null,"270",null,"Bonaire, Sint Eustatius and Saba"]
["540",null,"1600",null,"New Caledonia"]
["548",null,"2410",null,"Vanuatu"]
["554",null,"1610",null,"New Zealand"]
["558",null,"1620",null,"Nicaragua"]
["562",null,"1630",null,"Niger"]
["566",null,"1640",null,"Nigeria"]
["570",null,"1650",null,"Niue"]
["579",null,"1680",null,"Norway including Svalbard and Jan Mayen Islands"]
["580",null,"1670",null,"Northern Mariana Islands"]
["582",null,"1710",null,"Pacific Islands (Trust Territory)"]
["583",null,"1480",null,"Micronesia, Federated States of"]
["584",null,"1400",null,"Marshall Islands"]
["585",null,"1730",null,"Palau"]
["586",null,"1720",null,"Pakistan"]
["591",null,"1740",null,"Panama"]
["598",null,"1750",null,"Papua New Guinea"]
["600",null,"1760",null,"Paraguay"]
["604",null,"1770",null,"Peru"]
["608",null,"1780",null,"Philippines"]
["616",null,"1790",null,"Poland"]
["620",null,"1800",null,"Portugal"]
["624",null,"1010",null,"Guinea-Bissau"]
["626",null,"2220",null,"Timor-Leste"]
["630",null,"1810",null,"Puerto Rico"]
["634",null,"1820",null,"Qatar"]
["638",null,"1850",null,"Reunion"]
["639",null,"1860",null,"Reunion (up to 2010)"]
["642",null,"1870",null,"Romania"]
["643",null,"1880",null,"Russian Federation"]
["646",null,"1890",null,"Rwanda"]
["654",null,"1900",null,"Saint Helena"]
["659",null,"1910",null,"Saint Kitts and Nevis"]
["660",null,"70",null,"Anguilla"]
["662",null,"1920",null,"Saint Lucia"]
["666",null,"1930",null,"Saint Pierre and Miquelon"]
["670",null,"1940",null,"Saint Vincent and the Grenadines"]
["678",null,"1960",null,"Sao Tome and Principe"]
["682",null,"1970",null,"Saudi Arabia"]
["686",null,"1980",null,"Senegal"]
["688",null,"1990",null,"Serbia"]
["690",null,"2010",null,"Seychelles"]
["694",null,"2020",null,"Sierra Leone"]
["702",null,"2030",null,"Singapore"]
["703",null,"2050",null,"Slovakia"]
["704",null,"2430",null,"Viet Nam"]
["705",null,"2060",null,"Slovenia"]
["706",null,"2080",null,"Somalia"]
["710",null,"2090",null,"South Africa"]
["716",null,"2490",null,"Zimbabwe"]
["720",null,"620",null,"Democratic Yemen [former]"]
["724",null,"2110",null,"Spain"]
["728",null,"2100",null,"South Sudan"]
["729",null,"2140",null,"Sudan"]
["736",null,"2150",null,"Sudan [up to 2011]"]
["740",null,"2160",null,"Suriname"]
["748",null,"730",null,"Eswatini"]
["752",null,"2170",null,"Sweden"]
["757",null,"2180",null,"Switzerland-Liechtenstein"]
["760",null,"2190",null,"Syrian Arab Republic"]
["762",null,"2200",null,"Tajikistan"]
["764",null,"2210",null,"Thailand"]
["768",null,"2230",null,"Togo"]
["776",null,"2240",null,"Tonga"]
["780",null,"2250",null,"Trinidad and Tobago"]
["784",null,"2340",null,"United Arab Emirates"]
["788",null,"2260",null,"Tunisia"]
["792",null,"2270",null,"Turkey"]
["795",null,"2280",null,"Turkmenistan"]
["796",null,"2290",null,"Turks and Caicos Islands"]
["798",null,"2300",null,"Tuvalu"]
["800",null,"2310",null,"Uganda"]
["804",null,"2320",null,"Ukraine"]
["807",null,"1660",null,"North Macedonia"]
["810",null,"2330",null,"Union of Soviet Socialist Republics [former]"]
["818",null,"680",null,"Egypt"]
["826",null,"2350",null,"United Kingdom"]
["831",null,"990",null,"Guernsey"]
["832",null,"1170",null,"Jersey"]
["833",null,"1120",null,"Isle of Man"]
["834",null,"2360",null,"United Republic of Tanzania"]
["840",null,"2370",null,"United States"]
["850",null,"2380",null,"United States Virgin Islands"]
["854",null,"340",null,"Burkina Faso"]
["858",null,"2390",null,"Uruguay"]
["860",null,"2400",null,"Uzbekistan"]
["862",null,"2420",null,"Venezuela"]
["876",null,"2440",null,"Wallis and Futuna Islands"]
["882",null,"1950",null,"Samoa"]
["886",null,"2460",null,"Yemen Arab Republic [former]"]
["887",null,"2450",null,"Yemen"]
["890",null,"2470",null,"Yugoslavia [former Socialist Federal Republic]"]
["891",null,"2000",null,"Serbia and Montenegro"]
["894",null,"2480",null,"Zambia"]

{"sheet":"CL_COMMODITY_NRG","index":16,"n_rows":88,"n_cols":7,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","UNSD"]
["Version*","1.0"]
["Id*","CL_COMMODITY_NRG"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Commodity code list"]
["Description"]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["0100",null,null,null,"Hard Coal"]
["0110","0100",null,null,"Anthracite"]
["0121","0100",null,null,"Coking coal"]
["0129","0100",null,null,"Other bituminous coal"]
["0200",null,null,null,"Brown Coal"]
["0210","0200",null,null,"Sub-bituminous coal"]
["0220","0200",null,null,"Lignite"]
["0311",null,null,null,"Coke Oven Coke"]
["0312",null,null,null,"Gas Coke"]
["0320",null,null,null,"Patent fuel"]
["0330",null,null,null,"Brown Coal Briquettes"]
["0340",null,null,null,"Coal Tar"]
["0350",null,null,null,"Coke Oven Gas"]
["0360",null,null,null,"Gasworks Gas"]
["0371",null,null,null,"Blast Furnace Gas"]
["0379",null,null,null,"Other recovered gases"]
["0390",null,null,null,"Other coal products"]
["1100",null,null,null,"Peat"]
["1200",null,null,null,"Peat Products"]
["2000",null,null,null,"Oil Shale / Oil Sands"]
["3000",null,null,null,"Natural Gas (including LNG)"]
["4100",null,null,null,"Conventional crude oil"]
["4200",null,null,null,"Natural Gas Liquids"]
["4300",null,null,null,"Refinery Feedstocks"]
["4400",null,null,null,"Additives and Oxygenates"]
["4500",null,null,null,"Other hydrocarbons"]
["4610",null,null,null,"Refinery Gas"]
["4620",null,null,null,"Ethane"]
["4630",null,null,null,"Liquified Petroleum Gas"]
["4640",null,null,null,"Naphtha"]
["4651",null,null,null,"Aviation Gasoline"]
["4652",null,null,null,"Motor Gasoline"]
["4653",null,null,null,"Gasoline-type jet fuel"]
["4661",null,null,null,"Kerosene-type Jet Fuel"]
["4669",null,null,null,"Other kerosene"]
["4670",null,null,null,"Gas Oil/ Diesel Oil"]
["4680",null,null,null,"Fuel Oil"]
["4691",null,null,null,"White spirit and special boiling point industrial spirits"]
["4692",null,null,null,"Lubricants"]
["4693",null,null,null,"Paraffin waxes"]
["4694",null,null,null,"Petroleum Coke"]
["4695",null,null,null,"Bitumen"]
["4699",null,null,null,"Other oil products n.e.c."]
["5110",null,null,null,"Fuelwood"]
["5120",null,null,null,"Bagasse"]
["5130",null,null,null,"Animal waste"]
["5140",null,null,null,"Black liquor"]
["5150",null,null,null,"Other Vegetal Material and Residues"]
["5160",null,null,null,"Charcoal"]
["5210",null,null,null,"Biogasoline"]
["5212","4652",null,null,"Of which: biogasoline"]
["5220",null,null,null,"Biodiesel"]
["5222","4670",null,null,"Of which: biodiesel"]
["5230",null,null,null,"Bio jet kerosene"]
["5232","4661",null,null,"Of which: bio jet kerosene"]
["5290",null,null,null,"Other liquid biofuels"]
["5300",null,null,null,"Biogases"]
["6100",null,null,null,"Industrial Waste"]
["6200",null,null,null,"Municipal Wastes"]
["7000",null,null,null,"Total Electricity"]
["7000G","7000",null,null,"Geothermal"]
["7000H","7000",null,null,"Hydro"]
["7000N","7000",null,null,"Nuclear Electricity"]
["7000O","7000",null,null,"Tide, wave and ocean electricity"]
["7000S","7000",null,null,"Solar Electricity"]
["7000T","7000",null,null,"Thermal Electricity"]
["7000W","7000",null,null,"Wind Electricity"]
["8000",null,null,null,"Heat"]
["8000T","8000",null,null,"Heat from combustible fuels"]
["9101",null,null,null,"Uranium"]
["DG",null,null,null,"Direct use of geothermal heat"]
["DS",null,null,null,"Direct use of solar thermal heat"]
["EC",null,null,null,"Electricity, net installed capacity of electric power plants"]
["GR",null,null,null,"Total Refinery Output"]
["WF",null,null,null,"Falling Water"]

{"sheet":"CL_TRANSACTION_NRG","index":17,"n_rows":226,"n_cols":7,"rows_kept":226,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","UNSD"]
["Version*","1.0"]
["Id*","CL_TRANSACTION_NRG"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Energy transaction code list"]
["Description"]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["01","","","","Production"]
["010","01","","","Production from off-shore"]
["013","01","","","Production from refineries"]
["014","01","","","Production from plants"]
["015C","EP","","","Production from combustible fuels – Main activity"]
["015CC","015C","","","Production from combustible fuels – Main activity – CHP plants"]
["015CE","015C","","","Production from combustible fuels – Main activity – Electricity plants"]
["015CH","015C","","","Production from combustible fuels – Main activity – Heat plants"]
["015EB","EP","","","Production from electric boilers - Main activity"]
["015G","EP","","","Production from Geothermal – Main activity"]
["015GC","015G","","","Production from Geothermal – Main activity - CHP plants"]
["015GE","015G","","","Production from Geothermal – Main activity - Electricity plants"]
["015GH","015G","","","Production from Geothermal – Main activity – Heat plants"]
["015H","EP","","","Production from chemical heat/sources – Main activity"]
["015HC","015H","","","Production from chemical heat/sources – Main activity – CHP plants"]
["015HE","015H","","","Production from chemical heat/sources – Main activity – Electricity plants"]
["015HP","EP","","","Production from heat pumps - Main activity"]
["015HY","EP","","","Production from Hydro – Main activity"]
["015N","EP","","","Production from Nuclear – Main activity"]
["015NC","015N","","","Production from Nuclear – Main activity - CHP plants"]
["015NE","015N","","","Production from Nuclear – Main activity - Electricity plants"]
["015O","EP","","","Production from other sources – Main activity"]
["015OC","015O","","","Production from other sources – Main activity – CHP plants"]
["015OE","015O","","","Production from other sources – Main activity – Electricity plants"]
["015OH","015O","","","Production from other sources – Main activity – Heat plants"]
["015PH","015HY","","","Of which production from pumped hydro – Main activity"]
["015S","EP","","","Production from Solar – Main activity"]
["015SP","015S","","","Production from Solar PV – Main activity"]
["015ST","015S","","","Production from Solar thermal – Main activity"]
["015T","EP","","","Production from Tide, wave and marine – Main activity"]
["015W","EP","","","Production from Wind – Main activity"]
["016C","SP","","","Production from combustible fuels – Autoproducer"]
["016CC","016C","","","Production from combustible fuels – Autoproducer – CHP plants"]
["016CE","016C","","","Production from combustible fuels – Autoproducer – Electricity plants"]
["016CH","016C","","","Production from combustible fuels – Autoproducer – Heat plants"]
["016G","SP","","","Production from Geothermal – Autoproducer"]
["016GC","016G","","","Production from Geothermal – Autoproducer – CHP plants"]
["016GE","016G","","","Production from Geothermal – Autoproducer – Electricity plants"]
["016GH","016G","","","Production from Geothermal – Autoproducer – Heat plants"]
["016H","SP","","","Production from chemical heat/sources – Autoproducer"]
["016HC","016H","","","Production from chemical heat/sources – Autoproducer – CHP plants"]
["016HE","016H","","","Production from chemical heat/sources – Autoproducer – Electricity plants"]
["016HH","016H","","","Production from chemical heat/sources – Autoproducer – Heat plants"]
["016HY","SP","","","Production from Hydro – Autoproducer"]
["016N","SP","","","Production from Nuclear – Autoproducer"]
["016NC","016N","","","Production from Nuclear – Autoproducer – CHP plants"]
["016NE","016N","","","Production from Nuclear – Autoproducer – Electricity plants"]
["016O","SP","","","Production from other sources – Autoproducer"]
["016OC","016O","","","Production from other sources – Autoproducer – CHP plants"]
["016OE","016O","","","Production from other sources – Autoproducer – Electricity plants"]
["016OH","016O","","","Production from other sources – Autoproducer – Heat plants"]
["016PH","016HY","","","Of which production from pumped hydro – Autoproducer"]
["016S","SP","","","Production from Solar – Autoproducer"]
["016SP","016S","","","Production from Solar PV – Autoproducer"]
["016ST","016S","","","Production from Solar thermal – Autoproducer"]
["016T","016S","","","Production from Tide, wave and marine – Autoproducer"]
["016W","SP","","","Production from Wind – Autoproducer"]
["018","","","","Gross production"]
["019","","","","Net Production"]
["01BI","01","","","Production from biogases"]
["01BS","01SBF","","","Production from bagasse"]
["01CL","01","","","Production from hard coal"]
["01CP","01","","","Production from solid coal products"]
["01CR","01","","","Production from crude oil"]
["01DL","01","","","Production from gas oil/diesel oil"]
["01LB","01","","","Production from brown coal"]
["01LBF","01","","","Production from liquid biofuels"]
["01MG","01","","","Production from manufactured gases"]
["01NG","01","","","Production from natural gas"]
["01NRW","01","","","Production from non-renewable waste"]
["01OS","01","","","Production from oil shale"]
["01PP","01","","","Production from other oil products"]
["01PT","01","","","Production from peat"]
["01RF","01","","","Production from fuel oil"]
["01RW","01","","","Production from renewable municipal waste"]
["01SBF","01","","","Production from solid biofuels"]
["022","","","","Receipts from other sources"]
["022H","022","","","Of which: Hydrogen"]
["03","","","","Imports"]
["04","","","","Exports"]
["051","","","","International marine bunkers"]
["052","","","","International aviation bunkers"]
["06","","","","Stock changes"]
["07","","","","Transfers and recycled products"]
["08","","","","Transformation"]
["081","08","","","Transformation in coke ovens"]
["082","08","","","Transformation in gas works"]
["083","08","","","Transformation in briquetting plants"]
["084","08","","","Transformation in blast furnaces"]
["085CH","08","","","Transformation in charcoal plants"]
["085EP","08","","","Used for electricity production"]
["085GL","08","","","Transformation in gas-to-liquid (GTL) plants"]
["085LP","08","","","Transformation in coal liquefaction plants"]
["085PP","08","","","Transformation in petrochemical plants"]
["086","08","","","Transformation in oil refineries"]
["087","08","","","Transformation in natural gas blending plants"]
["088","08","","","Transformation in electricity, CHP and heat plants"]
["08811","088","","","Transformation in electricity plants - main activity producers"]
["08812","088","","","Transformation in electricity plants - autoproducers"]
["08821","088","","","Transformation in CHP plants - main activity producers"]
["08822","088","","","Transformation in CHP plants - autoproducers"]
["08831","088","","","Transformation in heat plants - main activity producers"]
["08832","088","","","Transformation in heat plants - autoproducers"]
["0889E","","","","Used for electric boilers"]
["0889H","","","","Used for heat pumps"]
["089","08","","","Other transformation"]
["09","","","","Energy industries own use"]
["0911","09","","","Own use by coal mines"]
["0912","09","","","Own use by oil and gas extraction"]
["0914","09","","","Own use by biogas production plants"]
["0915","09","","","Own use by nuclear fuel extraction and processing"]
["0921","09","","","Own use by coke ovens"]
["0922","09","","","Own use by gas works"]
["0923","09","","","Own use by briquetting plants"]
["0924","09","","","Own use by blast furnaces"]
["0925","09","","","Own use by oil refineries"]
["0926","09","","","Own use by pump-storage plants"]
["0927","09","","","Own use by electricity, CHP and heat plants"]
["0928","09","","","Other energy industry own use"]
["0930","09","","","Own use by coal liquefaction plants"]
["0931","09","","","Own use by natural gas separation plants"]
["0932","09","","","Own use by gas-to-liquid (GTL) plants"]
["0933","09","","","Own use by charcoal plants"]
["0934","09","","","Own use by LNG/regasification plants"]
["101","","","","Losses"]
["103","","","","Re-injected"]
["104","","","","Flared and vented"]
["104A","104","","","Flared"]
["104B","104","","","Vented"]
["105","","","","Extraction loss shrinkage"]
["11","NA","","","Non-energy uses"]
["12","NA","","","Final energy consumption"]
["121","12","","","Consumption by manufacturing, construction and non-fuel industry"]
["1211","121","","","Consumption by iron and steel"]
["1213","121","","","Consumption by chemical and petrochemical"]
["1214","121","","","Consumption by other manuf., const. and non-fuel ind."]
["1214A","1214","","","Consumption by non-ferrous metals"]
["1214B","1214","","","Consumption by non-metallic minerals"]
["1214C","1214","","","Consumption by transport equipment"]
["1214D","1214","","","Consumption by machinery"]
["1214E","1214","","","Consumption by mining and quarrying"]
["1214F","1214","","","Consumption by food and tobacco"]
["1214G","1214","","","Consumption by paper, pulp and print"]
["1214H","1214","","","Consumption by wood and wood products"]
["1214I","1214","","","Consumption by construction"]
["1214J","1214","","","Consumption by textile and leather"]
["1214O","1214","","","Consumption not elsewhere specified (industry)"]
["122","12","","","Consumption by transport"]
["1221","122","","","Consumption by road"]
["1222","122","","","Consumption by rail"]
["1223","122","","","Consumption by domestic aviation"]
["1224","122","","","Consumption by domestic navigation"]
["1225","122","","","Consumption not elsewhere specified (transport)"]
["1226","122","","","Consumption by pipeline transport"]
["123","12","","","Consumption by other"]
["1231","123","","","Consumption by households"]
["1232","123","","","Consumption by agriculture, forestry and fishing"]
["1234","123","","","Consumption not elsewhere specified (other)"]
["1235","123","","","Consumption by commerce and public services"]
["131","","","","Refinery capacity"]
["133","","","","Total Capacity: Main activity producers and Autoproducers"]
["1331","133","","","Nuclear, total"]
["13311","1331","","","Nuclear, Main activity producers"]
["13312","1331","","","Nuclear, Autoproducers"]
["1332","133","","","Hydro, total"]
["13321","1332","","","Hydro, Main activity producers"]
["13322","1332","","","Hydro, Autoproducers"]
["1333","133","","","Geothermal, total"]
["13331","1333","","","Geothermal, Main activity producers"]
["13332","1333","","","Geothermal, Autoproducers"]
["1334","133","","","Combustible Fuels, total "]
["13341","1334","","","Combustible Fuels, Main activity producers"]
["13342","1334","","","Combustible Fuels, Autoproducers"]
["1335","133","","","Wind, total"]
["13351","1335","","","Wind, Main activity producers"]
["13352","1335","","","Wind, Autoproducers"]
["1336","133","","","Solar, total"]
["13361","1336","","","Solar, Main activity producers"]
["13362","1336","","","Solar, Autoproducers"]
["1337","133","","","Tide, wave, marine, total"]
["13371","1337","","","Tide, wave, marine, Main activity producers"]
["13372","1337","","","Tide, wave, marine, Autoproducers"]
["1339","133","","","Electricity generating capacity - From other sources"]
["13391","1339","","","Electricity generating capacity - From other sources - Main activity producers"]
["13392","1339","","","Electricity generating capacity - From other sources - Autoproducers"]
["13PH1","13321","","","Electricity generating capacity - Pumped hydro - Main activity producers"]
["13PH2","13322","","","Electricity generating capacity - Pumped hydro - Autoproducers"]
["13PV1","13361","","","Electricity generating capacity - Solar PV - Main activity producers"]
["13PV2","13362","","","Electricity generating capacity - Solar PV - Autoproducers"]
["13ST1","13361","","","Electricity generating capacity - Solar Thermal - Main activity producers"]
["13ST2","13362","","","Electricity generating capacity - Solar Thermal - Autoproducers"]
["15","","","","Total resources in place"]
["151","15","","","Total known resources"]
["1511","151","","","Total known resources, Recoverable"]
["152","15","","","Additional resources"]
["161","","","","Reserves from crude petroleum"]
["162","","","","Reserves from oil shale and tar sands"]
["1621","162","","","Reserves from oil shale"]
["1622","162","","","Reserves from tar sands"]
["163","","","","Other reserves"]
["17","","","","Total resources of gases"]
["181","","","","Reserves of nuclear resources, Reasonably assured"]
["182","","","","Reserves of nuclear resources, Estimated additional"]
["19","","","","Total hydraulic resources"]
["21","","","","Opening stock level held on national territory"]
["22","","","","Closing stock level held on national territory"]
["CP","133","","","Total capacity, Main activity producers"]
["CS","133","","","Total capacity, Autoproducers"]
["EP","01","","","Production, Main activity producers total"]
["GA","","","","Total energy supply"]
["NA","","","","Final consumption"]
["O","","","","Gross refinery output"]
["SP","01","","","Production, Autoproducers total"]

{"sheet":"CL_UNIT_MEASURE_NRG","index":18,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","UNSD"]
["Version*","1.0"]
["Id*","CL_UNIT_MEASURE_NRG"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Unit of Measure code list"]
["Description"]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["M3",null,null,null,"Cubic metres"]
["MW",null,null,null,"Megawatts"]
["TJ",null,null,null,"Terajoules"]
["GWHR",null,null,null,"Gigawatt-hours"]
["TN",null,null,null,"Metric Tons"]

{"sheet":"CL_UNIT_MULT","index":19,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","SDMX"]
["Version*","1.1"]
["Id*","CL_UNIT_MULT"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Unit Multiplier"]
["Description","This code list provides code values for indicating the magnitude in the units of measurement. More information about this code list and SDMX code lists in general (e.g. list of generic codes for expressing general concepts like \"Total\", \"Unknown\", etc.; syntaxes for the creation of further codes; general guidelines for the creation of SDMX code lists) can be found at this address: https://sdmx.org/?page_id=4345."]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["0",null,null,null,"Units","In scientific notation, expressed as ten raised to the power of zero (10^0)","To add Code to Constraint enter 1 ->"]
["1",null,null,null,"Tens","In scientific notation, expressed as ten raised to the power of one (10^1)"]
["2",null,null,null,"Hundreds","In scientific notation, expressed as ten raised to the power of two (10^2)"]
["3",null,null,null,"Thousands","In scientific notation, expressed as ten raised to the power of three (10^3)"]
["4",null,null,null,"Tens of thousands","In scientific notation, expressed as ten raised to the power of four (10^4)"]
["5",null,null,null,"Hundreds of thousands","In scientific notation, expressed as ten raised to the power of five(10^5)"]
["6",null,null,null,"Millions","In scientific notation, expressed as ten raised to the power of six (10^6)"]
["7",null,null,null,"Tens of millions","In scientific notation, expressed as ten raised to the power of seven (10^7)"]
["8",null,null,null,"Hundreds of millions","In scientific notation, expressed as ten raised to the power of eight (10^8)"]
["9",null,null,null,"Billions","In scientific notation, expressed as ten raised to the power of nine (10^9)"]
["10",null,null,null,"Tens of billions","In scientific notation, expressed as ten raised to the power of ten (10^10)"]
["11",null,null,null,"Hundreds of billions","In scientific notation, expressed as ten raised to the power of eleven (10^11)"]
["12",null,null,null,"Trillions","In scientific notation, expressed as ten raised to the power of twelve (10^12)"]
["13",null,null,null,"Tens of trillions","In scientific notation, expressed as ten raised to the power of thirteen (10^13)"]
["14",null,null,null,"Hundreds of trillions","In scientific notation, expressed as ten raised to the power of fourteen (10^14)"]
["15",null,null,null,"Quadrillions","In scientific notation, expressed as ten raised to the power of fifteen (10^15)"]
["-1",null,null,null,"Tenths","In scientific notation, expressed as ten raised to the power of minus one (10^-1)"]
["-2",null,null,null,"Hundredths","In scientific notation, expressed as ten raised to the power of minus two (10^-2)"]
["-3",null,null,null,"Thousandths","In scientific notation, expressed as ten raised to the power of minus three (10^-3)"]
["-4",null,null,null,"Ten-thousandths","In scientific notation, expressed as ten raised to the power of minus four (10^-4)"]
["-5",null,null,null,"Hundred-thousandths","In scientific notation, expressed as ten raised to the power of minus five (10^-5)"]
["-6",null,null,null,"Millionths","In scientific notation, expressed as ten raised to the power of minus six (10^-6)"]
["-7",null,null,null,"Ten-millionths","In scientific notation, expressed as ten raised to the power of minus seven (10^-7)"]
["-8",null,null,null,"Hundred-millionths","In scientific notation, expressed as ten raised to the power of minus eight (10^-8)"]
["-9",null,null,null,"Billionths","In scientific notation, expressed as ten raised to the power of minus nine (10^-9)"]
["-10",null,null,null,"Ten-billionths","In scientific notation, expressed as ten raised to the power of minus ten (10^-10)"]
["-11",null,null,null,"Hundred-billionths","In scientific notation, expressed as ten raised to the power of minus eleven (10^-11)"]
["-12",null,null,null,"Trillionths","In scientific notation, expressed as ten raised to the power of minus twelve (10^-12)"]
["-13",null,null,null,"Ten-trillionths","In scientific notation, expressed as ten raised to the power of minus thirteen (10^-13)"]
["-14",null,null,null,"Hundred-trillionths","In scientific notation, expressed as ten raised to the power of minus fourteen (10^-14)"]
["-15",null,null,null,"Quadrillionths","In scientific notation, expressed as ten raised to the power of minus fifteen (10^-15)"]

{"sheet":"CL_OBS_STATUS","index":20,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["CODELIST ARTEFACT INFORMATION"]
["Agency Id*","SDMX"]
["Version*","2.1"]
["Id*","CL_OBS_STATUS"]
["Is final?*","TRUE"]
["Multilingual labels"]
["Language*","en"]
["Name*","Observation Status"]
["Description","This code list provides coded information on 1) the quality of a value or 2) unusual or missing values. It was formally adopted on 15 September 2016. More information about this code list and SDMX code lists in general (e.g. list of generic codes for expressing general concepts like \"Total\", \"Unknown\", etc.; syntaxes for the creation of further codes; general guidelines for the creation of SDMX code lists) can be found at this address: https://sdmx.org/?page_id=4345."]
["CODELIST ITEMS",null,null,null,null,null,"CONSTRAINTS"]
[null,null,null,null,null,null,"Dataflows->"]
["Code*","ParentCode","Order:en","Annotations\nJSON array notation","Name:en","Description:en","Concepts->"]
["A",null,null,null,"Normal value","To be used as default value if no value is provided or when no special coded qualification is assumed. Usually, it can be assumed that the source agency assigns sufficient confidence to the provided observation and/or the value is not expected to be dramatically revised."]
["B",null,null,null,"Time series break","Observations are characterised as such when different content exists or a different methodology has been applied to this observation as compared with the preceding one (the one given for the previous period)."]
["D",null,null,null,"Definition differs","Used to indicate slight deviations from the established methodology (footnote-type information); these divergences do not imply a break in time series."]
["E",null,null,null,"Estimated value","Observation obtained through an estimation methodology (e.g. to produce back-casts) or based on the use of a limited amount of data or ad hoc sampling and through additional calculations (e.g. to produce a value at an early stage of the production stage while not all data are available). It may also be used in case of experimental data (e.g. in the context of a pilot ahead of a full scale production process) or in case of data of (anticipated/assessed) low quality. If needed, additional information can be provided through free text using the COMMENT_OBS attribute at the observation level or at a higher level."]
["F",null,null,null,"Forecast value","Value deemed to assess the magnitude which a quantity will assume at some future point of time (as distinct from \"estimated value\" which attempts to assess the magnitude of an already existent quantity)."]
["G",null,null,null,"Experimental value","Data collected on the basis of definitions or (alternative) collection methods under development. Data not of guaranteed quality as normally expected from provider."]
["H",null,null,null,"Missing value; holiday or weekend","Used in some daily data flows."]
["I",null,null,null,"Imputed value (CCSA definition)","Observation imputed by international organisations to replace or fill gaps in national data series, in line with the recommendations of the United Nations Committee for the Coordination of Statistical Activities (CCSA)."]
["J",null,null,null,"Derogation","Clause in an agreement (e.g. legal act, gentlemen's agreement) stating that some provisions in the agreement are not to be implemented by designated parties; these derogations may affect the observation or cause a missing value. In general, derogations are limited in time."]
["K",null,null,null,"Data included in another category","This code is used when data for a given category are missing and are included in another category, sub-total or total. Generally where code \"K\" is used there should be a corresponding code \"W - Includes data from another category\" assigned to the over-covered category. Implementers and data reporters should use the COMMENT_OBS observation-level attribute to specify under which category the data are included."]
["L",null,null,null,"Missing value; data exist but were not collected","Used, for example, when some data are not reported/disseminated because they are below a certain threshold."]
["M",null,null,null,"Missing value; data cannot exist","Used to denote empty cells resulting from the impossibility to collect a statistical value (e.g. a particular education level or type of institution may be not applicable to a given country's education system)."]
["N",null,null,null,"Not significant","Used to indicate a value which is not a \"real\" zero (e.g. a result of 0.0004 rounded to zero)."]
["O",null,null,null,"Missing value","This code is to be used when no breakdown is made between the reasons why data are missing. Data can be missing due to many reasons: data cannot exist, data exist but are not collected (e.g. because they are below a certain threshold or subject to a derogation clause), data are unreliable, etc."]
["P",null,null,null,"Provisional value","An observation is characterised as \"provisional\" when the source agency - while it bases its calculations on its standard production methodology - considers that the data, almost certainly, are expected to be revised."]
["Q",null,null,null,"Missing value; suppressed","Used, for example, when data are suppressed due to statistical confidentiality considerations."]
["S",null,null,null,"Strike and other special events","Special circumstances (e.g. strike) affecting the observation or causing a missing value."]
["U",null,null,null,"Low reliability","This indicates existing observations, but for which the user should also be aware of the low quality assigned."]
["V",null,null,null,"Unvalidated value","Observation as received from the respondent without further evaluation of data quality."]
["W",null,null,null,"Includes data from another category","This code is used when data include another category, or go beyond the scope of the data collection and are therefore over-covered. Generally, where code \"W\" is used there should be a corresponding code \"K - Data included in another category\" assigned to the category which is under-covered. Implementers and data reporters should use the COMMENT_OBS observation-level attribute to specify which additional data are included."]