{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","DATA","Remarks","1000T to 1000m3","TJ to 1000m3","Info","versionhistory","Parameters","Parameter_mapping","ValRules","MDT mapping"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":52,"comments":4,"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":1056,"n_cols":4,"rows_kept":1056,"cut":false,"hidden":false,"merged":[[34,1,35,15],[20,1,22,15],[31,1,32,15],[7,1,7,15],[14,1,14,2],[17,1,17,2],[9,2,11,14],[24,1,28,15]]}
[]
[]
[]
[]
[]
[]
[]
[null,"BIOMASS REPORTING UNDER ANNEX IX, PART 1 (m)"]
[]
[null,null,"Regulation (EU) 2018/1999 of the European Parliament and of the Council of 11 December 2018 on the Governance of the Energy Union and Climate Action"]
[]
[]
[]
[null,"Please select your country below:"]
[]
[]
[null,"Please select the reference year below:"]
[]
[]
[]
[null,"The objective of this questionnaire is to collect the solid biomass additional reporting obligations stemming from Annex IX Part 1 (m) of Regulation (EU) 2018/1999 of the European Parliament and of the Council of 11 December 2018 on the Governance of the Energy Union and Climate Action"]
[]
[]
[]
[null,"Only solid biomass flows used for meaningful energy purposes (electricity and heat production) should be reported in this questionnaire. Liquid and gaseous biofuels should not be included.\n\n\n‘Biomass’ means the biodegradable fraction of products, waste and residues from biological origin from agriculture, including vegetal and animal substances, from forestry and related industries, including fisheries and aquaculture, as well as the biodegradable fraction of waste, including industrial and municipal waste of biological origin"]
[]
[]
[]
[]
[]
[]
[null,"The completed questionnaire shall be transmitted to Eurostat\nfollowing the eDAMIS implementing procedures (dataset name: ENERGY_BIOMASS_2)."]
[]
[]
[null,"For any questions or comments on the use of this tool,\nplease contact ESTAT-ENERGY@EC.EUROPA.EU or Rajmund Laczkó (rajmund.laczko@ec.europa.eu)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Albania","ALBANIA","AL",2015]
["Armenia","ARMENIA","AM",2016]
["Australia","AUSTRALI","AU",2017]
["Austria","AUSTRIA","AT",2018]
["Belarus","BELARUS","BY",2019]
["Belgium","BELGIUM","BE",2020]
["Bosnia and Herzegovina","BOSNIAHERZ","BA",2021]
["Bulgaria","BULGARIA","BG",2022]
["Canada","CANADA","CA",2023]
["Chile","CHILE","CL",2024]
["Colombia","COLOMBIA","CO"]
["Costa Rica","COSTARICA","CR"]
["Croatia","CROATIA","HR"]
["Cyprus","CYPRUS","CY"]
["Czech Republic","CZECH","CZ"]
["Denmark","DENMARK","DK"]
["Estonia","ESTONIA","EE"]
["Finland","FINLAND","FI"]
["France","FRANCE","FR"]
["Georgia","GEORGIA","GE"]
["Germany","GERMANY","DE"]
["Greece","GREECE","GR"]
["Hungary","HUNGARY","HU"]
["Iceland","ICELAND","IS"]
["Ireland","IRELAND","IE"]
["Israel","ISRAEL","IL"]
["Italy","ITALY","IT"]
["Japan","JAPAN","JP"]
["Korea","KOREA","KR"]
["Kosovo* (under UNSCR 1244/99)","KOSOVO","XK"]
["Latvia","LATVIA","LV"]
["Liechtenstein","LIECHTEN","LI"]
["Lithuania","LITHUANIA","LT"]
["Luxembourg","LUXEMBOU","LU"]
["Malta","MALTA","MT"]
["Mexico","MEXICO","MX"]
["Moldova","MOLDOVA","MD"]
["Montenegro","MONTENEGRO","ME"]
["Netherlands","NETHLAND","NL"]
["New Zealand","NZ","NZ"]
["North Macedonia","NORTHMACED","MK"]
["Norway","NORWAY","NO"]
["Poland","POLAND","PL"]
["Portugal","PORTUGAL","PT"]
["Romania","ROMANIA","RO"]
["Russia","RUSSIA","RU"]
["Serbia","SERBIA","RS"]
["Slovak Republic","SLOVAKIA","SK"]
["Slovenia","SLOVENIA","SI"]
["Spain","SPAIN","ES"]
["Sweden","SWEDEN","SE"]
["Switzerland","SWITLAND","CH"]
["Turkey","TURKEY","TR"]
["Ukraine","UKRAINE","UA"]
["United Kingdom","UK","GB"]
["United States","USA","US"]
["United States (Barrels)","USABBL","T4"]

{"sheet":"DATA","index":1,"n_rows":1019,"n_cols":136,"rows_kept":1019,"cut":false,"hidden":false,"merged":[]}
["Mandatory reporting","Country",{"$f":"IF(Cover!B15=\"\",\"\",VLOOKUP(Cover!B15,Cover!A1000:C1056,3,FALSE))","v":""}]
["Voluntary reporting, only required if data are available","Year",{"$f":"IF(Cover!B18=\"\",\"\",Cover!B18)","v":""}]
["Not applicable combinations (DO NOT FILL)"]
["Calculated cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*** DSD codes ***",null,null,null,null,null,null,null,null,null,null,null,null,"For Eurobase"]
[null,"Indigenous production\n in 1000 m3*","Imports\n in 1000 m3*","Exports \n  in 1000 m3*","Stock changes\n  in 1000 m3*","Average net calorific value \n(TJ/1000 m3)**","Indigenous production\n (TJ)","Imports \n(TJ)","Exports\n (TJ)","Stock changes \n(TJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGY_PRODUCT",null,null,null,null,null,null,null,null,null,null,null,null,"SIEC"]
["(1) Forest biomass used for energy production",null,null,null,null,null,{"$f":"IF(OR(B6=\"\",$F6=\"\"),\"\",B6*$F6)","v":""},{"$f":"IF(OR(C6=\"\",$F6=\"\"),\"\",C6*$F6)","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,null,null,null,null,null,"R5100",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS6","v":"R5100"}]
["     (a)  Primary biomass from forest",null,null,null,null,null,{"$f":"IF(OR(B7=\"\",$F7=\"\"),\"\",B7*$F7)","v":""},{"$f":"IF(OR(C7=\"\",$F7=\"\"),\"\",C7*$F7)","v":""},{"$f":"IF(OR(D7=\"\",$F7=\"\"),\"\",D7*$F7)","v":""},{"$f":"IF(OR(E7=\"\",$F7=\"\"),\"\",E7*$F7)","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,null,null,null,null,null,"R5101",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS7","v":"R5101"}]
["          (i)           Branches and tree tops",null,null,null,null,null,{"$f":"IF(OR(B8=\"\",$F8=\"\"),\"\",B8*$F8)","v":""},{"$f":"IF(OR(C8=\"\",$F8=\"\"),\"\",C8*$F8)","v":""},{"$f":"IF(OR(D8=\"\",$F8=\"\"),\"\",D8*$F8)","v":""},{"$f":"IF(OR(E8=\"\",$F8=\"\"),\"\",E8*$F8)","v":""},null,"update IT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5102",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS8","v":"R5102"}]
["          (ii)          Stumps",null,null,null,null,null,"","","","",null,"add extra definitions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5103",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS9","v":"R5103"}]
["          (iii)         Roundwood",null,null,null,null,null,"","","","",null,"add instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5104",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS10","v":"R5104"}]
["               (I)         Industrial roundwood",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5105",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS11","v":"R5105"}]
["               (II)         Fuelwood",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5106",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS12","v":"R5106"}]
["     (b)  Forest-based industry co-products",{"$f":"IF(E32=\"YES\",B14+B15+((B16*E33)/1000),B14+B15+((B17*$C$32)/1000)+((B18*C33)/1000))","v":0},null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5107",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS13","v":"R5107"}]
["          (i)           Bark",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5108",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS14","v":"R5108"}]
["          (ii)          Chips, sawdust and other wood particles",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5109",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS15","v":"R5109"}]
["          (iii)   Black liquor and crude tall oil (tonnes)",{"$f":"B17+B18","v":0},null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5140_5141",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS16","v":"R5140_5141"}]
["               (I) Black liquor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5140",null,null,null,null,null,null,null,null,null,null,null,null,"R5140"]
["               (II) Crude tall oil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5141",null,null,null,null,null,null,null,null,null,null,null,null,"R5141"]
["     (c)  Post-consumer wood",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5112",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS19","v":"R5112"}]
["     (d)  Processed wood-based fuel, produced from feedstocks not accounted under point (1)(a), (b) or (c):",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5113",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS20","v":"R5113"}]
["          (i)           Wood charcoal",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5160",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS21","v":"R5160"}]
["          (ii)          Wood pellets and wood briquettes",null,null,null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5111",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS22","v":"R5111"}]
["(2) Agricultural biomass",null,null,null,null,null,{"$f":"IF(OR(B23=\"\",$F23=\"\"),\"\",B23*$F23)","v":""},{"$f":"IF(OR(C23=\"\",$F23=\"\"),\"\",C23*$F23)","v":""},{"$f":"IF(OR(D23=\"\",$F23=\"\"),\"\",D23*$F23)","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,null,null,null,null,null,null,"R5151",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS23","v":"R5151"}]
["      (a)  Energy crops for electricity or heat (including short rotation coppice)",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5152",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS24","v":"R5152"}]
["          (i) Of which: From food and feed feedstocks  ",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5153",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS25","v":"R5153"}]
["      (b)  Agricultural crop residues for electricity or heat",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5154",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS26","v":"R5154"}]
["      (c)  Other agricultural biomass",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R5159",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS27","v":"R5159"}]
["(3) Organic waste biomass",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W6205",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS28","v":"W6205"}]
["      (a)  Organic fraction of industrial waste",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W6000RI",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS29","v":"W6000RI"}]
["      (b)  Organic fraction of municipal waste",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W6210",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS30","v":"W6210"}]
["      (c)  Waste sludges",null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W6230",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DS31","v":"W6230"}]
["*except 1b(iii) in tonne","1(b)iii(I) density (t/m3)",1,"use average density"]
["**except 1b(iii) in TJ/tonne","1(b)iii(II) density (t/m3)",1,"average density",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MAIN_FLOW","PRODUCT","IMPORTS","EXPORTS","STOCKS","_Z","PRODUCT","IMPORTS","EXPORTS","STOCKS"]
["FLOW_BREAKDOWN","INDPROD","TOTIMPSB","TOTEXPSB","STOCKCH","_Z","INDPROD","TOTIMPSB","TOTEXPSB","STOCKCH"]
["STOCKS","_Z","_Z","_Z","NATTER","_Z","_Z","_Z","_Z","NATTER"]
["MEASURE_VALUE_TYPE","VOLUME","VOLUME","VOLUME","VOLUME","NCV","ENERGY","ENERGY","ENERGY","ENERGY"]
["UNIT_MEASURE","THS_M3","THS_M3","THS_M3","THS_M3","TJ_NCV","TJ","TJ","TJ","TJ"]
[]
[]
[]
[]
[]
[]
[]
["For dissemination in Eurobase"]
["Dataset","nrg_cb_bm","nrg_cb_bm","nrg_cb_bm","nrg_cb_bm","nrg_bal_cv","nrg_cb_bm","nrg_cb_bm","nrg_cb_bm","nrg_cb_bm"]
["NRG_BAL","IPRD","IMP","EXP","STK_CHG","_Z","IPRD","IMP","EXP","STK_CHG"]
["CALVAL","_Z","_Z","_Z","_Z","NCV","_Z","_Z","_Z","_Z"]
["UNIT","THS_M3","THS_M3","THS_M3","THS_M3","GJ_M3_NCV","TJ","TJ","TJ","TJ"]

{"sheet":"Remarks","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Remarks Biomass"]

{"sheet":"1000T to 1000m3","index":3,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,10,3,13]]}
[null,"1. Enter data and conversion factors. Please note that the formulas in the grey cells are set for multiplication - depending on your conversion factor you might have to change it to division."]
[null,"2. Copy-paste the conversion factors and data from columns G to J to columns B to E on the worksheet DATA or select one of the two buttons to let the macro do that for you (macros do NOT copy conversion factors!)."]
[null,"3. The safe option checks whether there is already data on the DATA worksheet and you can opt to keep or overwrite data. The unsafe option overwrites all cells without warning."]
[null,"This is not a mandatory worksheet! It's for convenience to convert data from one unit to another!",null,null,null,null,null,null,null,null,"Internal consistency checks"]
[null,"Indigenous production\n in 1000T","Imports\n in 1000T","Exports \n  in 1000T","Stock changes\n  in 1000T","Conversion factor\n (1000T to 1000M3)","Indigenous production\n in 1000 m3","Imports\n in 1000 m3","Exports \n  in 1000 m3","Stock changes\n  in 1000 m3","Indigenous production","Imports","Exports","Stock changes"]
["(1) Forest biomass used for energy production",null,null,null,null,null,{"$f":"IF(OR(B6=\"\",$F6=\"\"),\"\",B6*$F6)","v":""},{"$f":"IF(OR(C6=\"\",$F6=\"\"),\"\",C6*$F6)","v":""},"","",{"$f":"IF(B19=\"\",IF(B7+B13+B19+B20>B6,\"Error\",\"OK\"),IF(B7+B13+B19+B20=B6,\"OK\",\"Error\"))","v":"OK"},{"$f":"IF(C19=\"\",IF(C7+C13+C19+C20>C6,\"Error\",\"OK\"),IF(C7+C13+C19+C20=C6,\"OK\",\"Error\"))","v":"OK"},"OK","OK"]
["     (a)  Primary biomass from forest",null,null,null,null,null,{"$f":"IF(OR(B7=\"\",$F7=\"\"),\"\",B7*$F7)","v":""},"","","",{"$f":"IF(COUNTA(B8:B9)=2,IF(B8+B9+B10=B7,\"OK\",\"Error\"),IF(B8+B9+B10>B7,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF(COUNTA(C8:C9)=2,IF(C8+C9+C10=C7,\"OK\",\"Error\"),IF(C8+C9+C10>C7,\"Error\",\"OK\"))","v":"OK"},"OK","OK"]
["          (i)           Branches and tree tops",null,null,null,null,null,{"$f":"IF(OR(B8=\"\",$F8=\"\"),\"\",B8*$F8)","v":""},"","",""]
["          (ii)          Stumps",null,null,null,null,null,"","","",""]
["          (iii)         Roundwood",null,null,null,null,null,"","","","",{"$f":"IF(B10=B11+B12,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C10=C11+C12,\"OK\",\"Error\")","v":"OK"},"OK","OK"]
["               (I)         Industrial roundwood",null,null,null,null,null,"","","",""]
["               (II)         Fuelwood",null,null,null,null,null,"","","",""]
["     (b)  Forest-based industry co-products",null,null,null,null,null,"","","","",{"$f":"IF(B14+B15+B16>B13,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C14+C15+C16>C13,\"Error\",\"OK\")","v":"OK"},"OK","OK"]
["          (i)           Bark",null,null,null,null,null,"","","",""]
["          (ii)          Chips, sawdust and other wood particles",null,null,null,null,null,"","","",""]
["          (iii)   Black liquor and crude tall oil (tonnes)",null,null,null,null,null,"","","","",{"$f":"IF(B16=B17+B18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C16=C17+C18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(D16=D17+D18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(E16=E17+E18,\"OK\",\"Error\")","v":"OK"}]
["               (I) Black liquor",null,null,null,null,null,"","","",""]
["               (II) Crude tall oil",null,null,null,null,null,"","","",""]
["     (c)  Post-consumer wood",null,null,null,null,null,"","","",""]
["     (d)  Processed wood-based fuel, produced from feedstocks not accounted under point (1)(a), (b) or (c):",null,null,null,null,null,"","","","",{"$f":"IF(B20=B21+B22,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C20=C21+C22,\"OK\",\"Error\")","v":"OK"},"OK","OK"]
["          (i)           Wood charcoal",null,null,null,null,null,"","","",""]
["          (ii)          Wood pellets and wood briquettes",null,null,null,null,null,"","","",""]
["(2) Agricultural biomass",null,null,null,null,null,"","","",null,{"$f":"IF(B24+B26+B27>B23,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C24+C26+C27>C23,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(D24+D26+D27>D23,\"Error\",\"OK\")","v":"OK"}]
["      (a)  Energy crops for electricity or heat (including short rotation coppice)",null,null,null,null,null,"","","",null,{"$f":"IF(B25>B24,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C25>C24,\"Error\",\"OK\")","v":"OK"},"OK"]
["          (i) Of which: From food and feed feedstocks  ",null,null,null,null,null,"","",""]
["      (b)  Agricultural crop residues for electricity or heat",null,null,null,null,null,{"$f":"IF(OR(B26=\"\",$F26=\"\"),\"\",B26*$F26)","v":""},"",""]
["      (c)  Other agricultural biomass",null,null,null,null,null,"","",""]
["(3) Organic waste biomass",null,null,null,null,null,"","","",null,{"$f":"IF(B29+B30+B31>B28,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C29+C30+C31>C28,\"Error\",\"OK\")","v":"OK"},"OK"]
["      (a)  Organic fraction of industrial waste",null,null,null,null,null,"","",""]
["      (b)  Organic fraction of municipal waste",null,null,null,null,null,"","",""]
["      (c)  Waste sludges",null,null,null,null,null,"","",""]

{"sheet":"TJ to 1000m3","index":4,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[3,10,3,13]]}
[null,"1. Enter data and conversion factors. Please note that the formulas in the grey cells are set for multiplication - depending on your conversion factor you might have to change it to division."]
[null,"2. Copy-paste the conversion factors and data from columns G to J to columns B to E on the worksheet DATA or select one of the two buttons to let the macro do that for you (macros do NOT copy conversion factors!)."]
[null,"3. The safe option checks whether there is already data on the DATA worksheet and you can opt to keep or overwrite data. The unsafe option overwrites all cells without warning."]
[null,"This is not a mandatory worksheet! It's for convenience to convert data from one unit to another!",null,null,null,null,null,null,null,null,"Internal consistency checks"]
[null,"Indigenous production\n (TJ)","Imports \n(TJ)","Exports\n (TJ)","Stock changes \n(TJ)","Conversion factor\n (TJ to 1000M3)","Indigenous production\n in 1000 m3","Imports\n in 1000 m3","Exports \n  in 1000 m3","Stock changes\n  in 1000 m3","Indigenous production","Imports","Exports","Stock changes"]
["(1) Forest biomass used for energy production",null,null,null,null,null,{"$f":"IF(OR(B6=\"\",$F6=\"\"),\"\",B6*$F6)","v":""},{"$f":"IF(OR(C6=\"\",$F6=\"\"),\"\",C6*$F6)","v":""},"","",{"$f":"IF(B19=\"\",IF(B7+B13+B19+B20>B6,\"Error\",\"OK\"),IF(B7+B13+B19+B20=B6,\"OK\",\"Error\"))","v":"OK"},{"$f":"IF(C19=\"\",IF(C7+C13+C19+C20>C6,\"Error\",\"OK\"),IF(C7+C13+C19+C20=C6,\"OK\",\"Error\"))","v":"OK"},"OK","OK"]
["     (a)  Primary biomass from forest",null,null,null,null,null,{"$f":"IF(OR(B7=\"\",$F7=\"\"),\"\",B7*$F7)","v":""},"","","",{"$f":"IF(COUNTA(B8:B9)=2,IF(B8+B9+B10=B7,\"OK\",\"Error\"),IF(B8+B9+B10>B7,\"Error\",\"OK\"))","v":"OK"},{"$f":"IF(COUNTA(C8:C9)=2,IF(C8+C9+C10=C7,\"OK\",\"Error\"),IF(C8+C9+C10>C7,\"Error\",\"OK\"))","v":"OK"},"OK","OK"]
["          (i)           Branches and tree tops",null,null,null,null,null,{"$f":"IF(OR(B8=\"\",$F8=\"\"),\"\",B8*$F8)","v":""},"","",""]
["          (ii)          Stumps",null,null,null,null,null,"","","",""]
["          (iii)         Roundwood",null,null,null,null,null,"","","","",{"$f":"IF(B10=B11+B12,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C10=C11+C12,\"OK\",\"Error\")","v":"OK"},"OK","OK"]
["               (I)         Industrial roundwood",null,null,null,null,null,"","","",""]
["               (II)         Fuelwood",null,null,null,null,null,"","","",""]
["     (b)  Forest-based industry co-products",null,null,null,null,null,"","","","",{"$f":"IF(B14+B15+B16>B13,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C14+C15+C16>C13,\"Error\",\"OK\")","v":"OK"},"OK","OK"]
["          (i)           Bark",null,null,null,null,null,"","","",""]
["          (ii)          Chips, sawdust and other wood particles",null,null,null,null,null,"","","",""]
["          (iii)   Black liquor and crude tall oil (tonnes)",null,null,null,null,null,"","","","",{"$f":"IF(B16=B17+B18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C16=C17+C18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(D16=D17+D18,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(E16=E17+E18,\"OK\",\"Error\")","v":"OK"}]
["               (I) Black liquor",null,null,null,null,null,"","","",""]
["               (II) Crude tall oil",null,null,null,null,null,"","","",""]
["     (c)  Post-consumer wood",null,null,null,null,null,"","","",""]
["     (d)  Processed wood-based fuel, produced from feedstocks not accounted under point (1)(a), (b) or (c):",null,null,null,null,null,"","","","",{"$f":"IF(B20=B21+B22,\"OK\",\"Error\")","v":"OK"},{"$f":"IF(C20=C21+C22,\"OK\",\"Error\")","v":"OK"},"OK","OK"]
["          (i)           Wood charcoal",null,null,null,null,null,"","","",""]
["          (ii)          Wood pellets and wood briquettes",null,null,null,null,null,"","","",""]
["(2) Agricultural biomass",null,null,null,null,null,"","","",null,{"$f":"IF(B24+B26+B27>B23,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C24+C26+C27>C23,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(D24+D26+D27>D23,\"Error\",\"OK\")","v":"OK"}]
["      (a)  Energy crops for electricity or heat (including short rotation coppice)",null,null,null,null,null,"","","",null,{"$f":"IF(B25>B24,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C25>C24,\"Error\",\"OK\")","v":"OK"},"OK"]
["          (i) Of which: From food and feed feedstocks  ",null,null,null,null,null,"","",""]
["      (b)  Agricultural crop residues for electricity or heat",null,null,null,null,null,{"$f":"IF(OR(B26=\"\",$F26=\"\"),\"\",B26*$F26)","v":""},"",""]
["      (c)  Other agricultural biomass",null,null,null,null,null,"","",""]
["(3) Organic waste biomass",null,null,null,null,null,"","","",null,{"$f":"IF(B29+B30+B31>B28,\"Error\",\"OK\")","v":"OK"},{"$f":"IF(C29+C30+C31>C28,\"Error\",\"OK\")","v":"OK"},"OK"]
["      (a)  Organic fraction of industrial waste",null,null,null,null,null,"","",""]
["      (b)  Organic fraction of municipal waste",null,null,null,null,null,"","",""]
["      (c)  Waste sludges",null,null,null,null,null,"","",""]

{"sheet":"Info","index":5,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Weight/volume conversion factors for wood products"]
["UNECE project on conversion factors – 2009"]
["https://unece.org/fileadmin/DAM/timber/meetings/forest-products-conversion-factors.pdf"]
["FAO Forest product conversion factors – 2020"]
["https://www.fao.org/3/ca7952en/CA7952EN.pdf"]
["Joint Forest Sector Questionnaire (JFSQ - including general volume-to-weight conversion factors)"]
["https://unece.org/forests/jfsq"]
["Other sources"]
["https://unece.org/fileadmin/DAM/timber/meetings/forest-products-conversion-factors.pdf"]
["https://www.fao.org/3/ca7952en/CA7952EN.pdf"]
["https://unece.org/DAM/timber/publications/DP-49.pdf"]
[]
["Energy content of forest and agriculture biomass"]
["https://cfnielsen.com/wp-content/uploads/2021/02/Calorific-value-biomass.pdf"]
["Energy content by weight/volume"]
["DIRECTIVE (EU) 2018/2001 OF THE EUROPEAN PARLIAMENT AND OF THE COUNCIL, ANNEX III"]
["https://eur-lex.europa.eu/legal-content/EN/TXT/PDF/?uri=CELEX:32018L2001&from=EN"]
[]
["Black liquor density"]
["https://www.researchgate.net/publication/289426544_Eucalyptus_black_liquor_-_Density_viscosity_solids_and_sodium_sulfate_contents_revisited"]
["https://www.tappi.org/content/events/08kros/manuscripts/3-1.pdf"]
["Crude tall oil density"]
["https://digital.library.unt.edu/ark:/67531/metadc706977/m2/1/high_res_d/656611.pdf"]
["https://echa.europa.eu/registration-dossier/-/registered-dossier/14967/4/5"]

{"sheet":"versionhistory","index":6,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Version history"]
["v1-1","Added remarks sheet, corrected dataset on coverpage"]
["v1-2","Added extra lines for liquids and for non-crop agricultural biomass and separate density indicators for liquids (27-June-2023)"]

{"sheet":"Parameters","index":7,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Element","Type","PosType","Position",null,"DataStart","B6"]
["QUEST_SOURCE","DIM","FIX","A_BIOMASS",null,"DataEnd","J28"]
["FREQ","DIM","FIX","A",null,"SkipIncompleteKeys","true"]
["REF_AREA","DIM","CELL","C1"]
["ENERGY_PRODUCT","DIM","COLUMN","DS"]
["MAIN_FLOW","DIM","ROW",1000]
["FLOW_BREAKDOWN","DIM","ROW",1001]
["PLANT_TECH","DIM","FIX","_Z"]
["PLANT_TYPE","DIM","FIX","_Z"]
["STOCKS","DIM","ROW",1002]
["INFRASTRUCTURE_IND","DIM","FIX","_Z"]
["VIS_A_VIS_AREA","DIM","FIX","_Z"]
["MEASURE_VALUE_TYPE","DIM","ROW",1003]
["TIME_PERIOD","DIM","CELL","C2"]
["FACILITY_ID","DIM","FIX","_Z"]
["UNIT_MEASURE","ATT","ROW",1004]
["OBS_STATUS","ATT","SKIP"]
["CONF_STATUS","ATT","SKIP"]
["COMMENT_OBS","ATT","SKIP"]
["FACILITY_TYPE","ATT","SKIP"]
["FACILITY_NAME","ATT","SKIP"]

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

{"sheet":"ValRules","index":9,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["(1) Forest biomass used for energy production","R5100","R5100=R5101+R5107+R5112+R5113",5112,"if/else or >="]
["     (a)  Primary biomass from forest","R5101","R5151=R5152+R5154+R5159","all vol",">="]
["          (i)           Branches and tree tops","R5102","W6205=W6000RI+W6210+W6230","all vol",">="]
["          (ii)          Stumps","R5103","R5101=R5102+R5103+R5104","5102, 5103","if/else or >="]
["          (iii)         Roundwood","R5104","R5107=R5108+R5109+R5140","strict","="]
["               (I)         Industrial roundwood","R5105","R5113=R5160+R5111","strict","="]
["               (II)         Fuelwood","R5106","R5152>=R5153","as is",">="]
["     (b)  Forest-based industry co-products","R5107","R5104=R5105+5106","strict","="]
["          (i)           Bark","R5108","R5140_5141=R5140+R5141"]
["          (ii)          Chips, sawdust and other wood particles","R5109"]
["          (iii)   Black liquor and crude tall oil (tonnes)","R5140_5141"]
["               (I) Black liquor","R5140"]
["               (II) Crude tall oil","R5141"]
["     (c)  Post-consumer wood","R5112"]
["    (d)  Processed wood-based fuel, produced from feedstocks not accounted under point (1)(a), (b) or (c):","R5113"]
["          (i)           Wood charcoal","R5160"]
["          (ii)          Wood pellets and wood briquettes","R5111"]
["(2) Agricultural biomass","R5151"]
["      (a)  Energy crops for electricity or heat (including short rotation coppice)","R5152"]
["          (i) Of which: From food and feed feedstocks  ","R5153"]
["      (b)  Agricultural crop residues for electricity or heat","R5154"]
["      (c)  Other agricultural biomass","R5159"]
["(3) Organic waste biomass","W6205"]
["      (a)  Organic fraction of industrial waste","W6000RI"]
["      (b)  Organic fraction of municipal waste","W6210"]
["      (c)  Waste sludges","W6230"]
[null,"green=voluntary"]

{"sheet":"MDT mapping","index":10,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["QUEST_SOURCE","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,"QUEST","TABLE","PRODUCT","FLOW","PARTNER","INDICATOR","FACILITY_ID","UNIT"]
["A_BIOMASS","*","PRODUCT","INDPROD","_Z","_Z","_Z","_Z","_Z","VOLUME","_Z","THS_M3",null,"A_BIOMASS","TIMESERIES","*","IPRD","_Z","_Z","_Z","THS_M3"]
["A_BIOMASS","*","IMPORTS","TOTIMPSB","_Z","_Z","_Z","_Z","_Z","VOLUME","_Z","THS_M3",null,"A_BIOMASS","TIMESERIES","*","IMP","_Z","_Z","_Z","THS_M3"]
["A_BIOMASS","*","EXPORTS","TOTEXPSB","_Z","_Z","_Z","_Z","_Z","VOLUME","_Z","THS_M3",null,"A_BIOMASS","TIMESERIES","*","EXP","_Z","_Z","_Z","THS_M3"]
["A_BIOMASS","*","STOCKS","STOCKCH","_Z","_Z","NATTER","_Z","_Z","VOLUME","_Z","THS_M3",null,"A_BIOMASS","TIMESERIES","*","STK_CHG","_Z","_Z","_Z","THS_M3"]
["A_BIOMASS","*","_Z","_Z","_Z","_Z","_Z","_Z","_Z","NCV","_Z","TJ_NCV",null,"A_BIOMASS","TIMESERIES","*","NCV_AVG","_Z","_Z","_Z","TJ_THS_M3_NCV"]
["A_BIOMASS","*","PRODUCT","INDPROD","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ",null,"A_BIOMASS","TIMESERIES","*","IPRD","_Z","_Z","_Z","TJ"]
["A_BIOMASS","*","IMPORTS","TOTIMPSB","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ",null,"A_BIOMASS","TIMESERIES","*","IMP","_Z","_Z","_Z","TJ"]
["A_BIOMASS","*","EXPORTS","TOTEXPSB","_Z","_Z","_Z","_Z","_Z","ENERGY","_Z","TJ",null,"A_BIOMASS","TIMESERIES","*","EXP","_Z","_Z","_Z","TJ"]
["A_BIOMASS","*","STOCKS","STOCKCH","_Z","_Z","NATTER","_Z","_Z","ENERGY","_Z","TJ",null,"A_BIOMASS","TIMESERIES","*","STK_CHG","_Z","_Z","_Z","TJ"]
[]
[]
[]
[null,"ENERGY_PRODUCT = MDT PRODUCT = Eurobase"]
[null,"R5100"]
[null,"R5101"]
[null,"R5102"]
[null,"R5103"]
[null,"R5104"]
[null,"R5105"]
[null,"R5106"]
[null,"R5107"]
[null,"R5108"]
[null,"R5109"]
[null,"R5140"]
[null,"R5112"]
[null,"R5113"]
[null,"R5160"]
[null,"R5111"]
[null,"R5151"]
[null,"R5152"]
[null,"R5153"]
[null,"R5154"]
[null,"W6200"]
[null,"W6000RI"]
[null,"W6210"]
[null,"W6220"]