{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["COVER","Index","Basic instructions","Methodology","Metadata","Footnotes list","Table_1","Table_1a","Table_2","Table_3","ErrorLog","Lists","Locks","CountryName","Summations","Mandatory","MustNotBeNegative","Thresholds","IsFormula","FootnoteContent","IsNumeric","Validation rules","Quality_report >>>","Overview & Waste Gen.","Waste Management","Data Accuracy","Reusable & Traceability","Confidentiality & References","Any further detailed data..."],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":31,"comments":2,"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":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,1,8,3],[18,1,23,3],[16,1,16,3],[1,1,1,3],[9,1,9,3],[10,1,11,3],[13,1,13,3]]}
[]
[null,"Statistical Office of the European Union"]
[]
[]
[]
[]
[]
[]
[]
[null,"Directorate E: Sectoral and regional statistics"]
[null,"Unit E-2: Environmental statistics and accounts; sustainable development"]
[]
[]
[null,"2020-05-20"]
[]
[null,null,"QUESTIONNAIRE"]
[null,"ANNUAL REPORTING OF PACKAGING AND PACKAGING WASTE\n2020 DATA COLLECTION\n\n"]

{"sheet":"Index","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,3],[4,1,4,4],[5,1,5,4],[13,1,13,4],[9,1,9,2],[7,1,7,4],[6,1,6,2],[8,1,8,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[14,1,14,2],[20,3,20,4],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,4],[19,1,19,2]]}
[]
[]
[]
[]
[null,"ANNUAL REPORTING OF PACKAGING AND PACKAGING WASTE\n2020 DATA COLLECTION"]
[null,"STRUCTURE OF THE QUESTIONNAIRE"]
[null,"TITLE",null,"DESCRIPTION","TYPE"]
[null,"I. Yellow tabbed sheets in the questionnaire"]
[null,"Index",null,"Structure of the questionnaire","for information"]
[null,"Basic instructions ",null,"Basic instructions","for reading before filling in the questionnaire"]
[null,"Methodology",null,"Explanatory notes and methodology","for reading before filling in the questionnaire"]
[null,"Metadata ",null,"Information on the methodology used for gathering the data reported in this questionnaire","for filling in"]
[null,"Footnotes list",null,"List of country-specific explanatory footnotes","for filling in"]
[null,"II. Green tabbed sheets in the questionnaire"]
[null,"Table 1",null,"Generation and recycling of packaging waste as established by Commission Decision 2005/270/EC as last amended by Commission Implementing Decision 2019/665","for filling in. This table must be used in all cases"]
[null,"Table 1a",null,"Generation and recycling of packaging waste calculated according Article 3, Article 4 and 5 of Decision 2005/270/EC","for filling in (only if you want to use the old calculation rules for the old targets)"]
[null,"Table 2",null,"Format to attain an adjusted level of the targets in accordance with Article 5(2) of Directive 94/62/EC ","For filling in until 2023. From 2023 onwards, this will be calculated automatically using data from Table 3."]
[null,"Table 3",null,"Format for reporting on reusable packaging as established by Commission Decision 2005/270/EC as last amended by Commission Implementing Decision 2019/665 ","for filling in"]
[null,"III. Orange tabbed sheets in the questionnaire"]
[null,"Quality report",null,"Quality report (According to Annex IV of Commission Decision 2005/270/EC)","for filling in"]

{"sheet":"Basic instructions","index":2,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[13,2,13,15],[15,3,15,15],[17,3,17,15],[19,3,19,15],[10,6,10,8],[10,2,10,4],[29,2,29,15],[30,3,30,4],[30,5,30,11],[31,3,31,4],[31,5,31,11],[21,3,21,15],[23,3,23,15],[24,2,24,15],[26,2,26,15],[28,2,28,15],[27,2,27,15],[81,1,81,16],[71,2,71,15],[72,2,72,15],[73,2,73,15],[79,2,79,15],[80,2,80,15],[75,2,75,15],[76,2,76,15],[77,2,77,15],[78,2,78,15],[2,2,2,15],[3,2,3,15],[5,2,5,15],[53,2,53,15],[47,2,47,13],[46,2,46,15],[50,2,50,15],[40,2,40,14],[6,2,6,15],[8,2,8,15],[48,2,48,15],[49,2,49,15],[51,2,51,15],[52,2,52,15],[36,2,36,3],[37,2,37,3],[70,2,70,15],[54,2,54,15],[60,2,60,15],[67,1,67,16],[57,2,57,14],[64,2,64,15],[66,2,66,15],[65,2,65,15],[61,2,61,15],[55,2,55,15],[63,2,63,15],[62,2,62,15],[58,2,58,15],[32,5,32,11],[33,2,33,4],[33,5,33,11],[68,2,68,15],[69,2,69,15],[41,2,41,14],[42,2,42,15],[43,2,43,15],[35,2,35,15],[38,2,38,3],[32,3,32,4]]}
[]
[]
[null,null,"ANNUAL REPORTING OF PACKAGING AND PACKAGING WASTE\n2020 DATA COLLECTION"]
[null,null,"Basic instructions"]
[]
[null,null,"Before filling in the questionnaire please read carefully the instructions below. This EXCEL workbook is the questionnaire. Please do not  delete or add rows in the questionnaire (except where instructed in the quality report tab)."]
[null,null,"Please note that this questionnaire only includes tables 1 to 3. Tables 4 to 7 to report on plastic carrier bags according to Commission Implementing Decision 2018/896 are included in a different questionnaire."]
[]
[null,null,"1. Getting started "]
[null,null,"Enter the data without changing the format of the questionnaire (i.e. do not add/delete rows or columns) since Eurostat uses automated routines for data validation.\n"]
[null,null,"Please select your country (click on the white cell):    ",null,null,null,"Luxembourg",null,null,{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,Lists!A2:B40,2,FALSE))","v":"LU"}]
[null,null,"Reference year:    ",null,null,null,2018,null," "]
[null,null,"The due date for reporting is 30 June 2020                                        ",null,null,null," "]
[null,null,"Who is the primary contact point for annual reporting of packaging and packaging waste in your country?"]
[]
[null,null,"Name:","Tim Mirgain"]
[]
[null,null,"Institution:","Administration de l'environnement"]
[]
[null,null,"Unit:","Unité statistiques et évaluation de l'environnement"]
[]
[null,null,"Telephone:","+352 40 56 56 322"]
[]
[null,null,"Email adress:","tim.mirgain@aev.etat.lu"]
[null,null,"Eurostat would be grateful if you could send us the completed questionnaire ahead of the deadline. "]
[]
[null,null,"2. Data transmission:"]
[null,null,"The standard tool for the transmission of statistical data is the eDAMIS system. The system creates a secure environment for the transmission of data, it records all data submissions and acknowledges the data delivery. The eDAMIS system has been installed in the National Statistical Institutes.\n   "]
[null,null,"Please submit this questionnaire to Eurostat using the eDAMIS reporting system. Use the following details: \nDomain name: WASTE\nData set name: WASTE_PACKDAT_A"]
[null,null,"Should you have any questions regarding data transmission do not hesitate to contact your local eDAMIS coordinator or the Eurostat eDAMIS helpdesk at: "]
[null,null,null,"web page",null,"https://webgate.ec.europa.eu/edamis/helpcenter/website/index.htm"]
[null,null,null,"this e-mail address:",null,"estat-support-edamis@ec.europa.eu"]
[null,null,null,"or call:",null,"(+352) 4301 33213"]
[null,null,"For methodological questions please contact:",null,null,"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
[null,null," "]
[null,null,"3. Reporting conventions\n\n"]
[null,null,"Description",null,"Symbol"]
[null,null,"Real zero",null,0]
[null,null,"Not available",null," ","(empty cell)"]
[]
[null,null,"1. White shaded (uncoloured) boxes: Provision of data is mandatory"]
[null,null,"2. Light blue shaded boxes: Provision of data is voluntary"]
[null,null,"3. Light purple shaded boxes: Reporting is mandatory only to Member States that include those amounts in the recycling rates (see detailed instructions in Table 1)"]
[null,null,"4. Black shaded boxes: reporting is not applicable"]
[null,null,"5. Grey shaded boxes: calculation is automatic; do not input any data into these cells"]
[]
[null,null,"4. Metadata:\nIn the yellow sheet named 'Metadata', please provide information on the sources available and methodology used to produce the statistics on packaging and packaging waste. Please also declare which recycling target the Member State is reporting against.\nThe metadata consists of background information to provide a national context for understanding the data reported in tables 1-3, whereas the quality report consists of technical information about how the data was collected and calculated."]
[]
[null,null,"5. Footnotes: \nYou are asked to report data that follow as closely as possible packaging waste definitions and reporting rules (see paragraphs below). Please report problems with the coverage or data quality in 'Metadata' worksheet."]
[null,null,"Flags (footnote symbols) should be entered in the reporting tables in the footnote columns, next to the value cell. There are two types of footnotes: \n- Letters for standard footnotes (as defined by Eurostat) and \n- Numbers for country-specific footnotes (to be defined by the data compilers). "]
[null,null,"Standard footnotes"]
[null,null,"The following footnotes will be used for the automatic data processing and data dissemination. Hence, they cannot be changed:"]
[null,null,"B) break in series. Please use this flag when the reported figure cannot be compared to the data reported for the previous year, e.g. because of new methods or sources being used or when you move from the old calculation rules to the new calculation rules. Please use this flag only when the change in methods, sources or calculation rules has a substantial impact."]
[null,null,"E) estimated data"]
[null,null,"P) provisional"]
[null,null,"To include standard footnotes use the drop-down menu. "]
[]
[null,null,"Country-specific explanatory footnotes"]
[null,null,"The country-specific footnotes can be used for any meaning beyond the pre-defined footnotes.\nTo include a country-specific footnote, please first insert the text in the “Footnote list” sheet starting from number 1. Then in the data table please select the corresponding footnote reference number from the drop-down menu in the footnote column next to the value cell. The text you entered in the “Footnote list” sheet will then appear automatically next to the footnote reference number. The same explanatory footnote can be chosen for all the values for which the same explanation applies. If by mistake a number is chosen from the drop-down menu, it is sufficient to press the key delete to clean the cell.\nPlease do not report footnotes that elaborate on e.g. source data and compilation methods; these are to be described in the quality report and the metadata sheets. \n"]
[]
[null,null,"6. Methodology and questions:\n    The guidelines to report on packaging and packaging waste are available on Eurostat website:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/methodology"]
[null,null,"The guidelines contain definitions, examples and recommendations to ensure that data are compiled and maintained on a consistent basis. They explain the scope and the reasoning behind the terms of the tables, and provide extra information necessary to allow a consistent collection and interpretation of the data to be reported by countries. A great deal of effort has been put into increasing coherence and providing users of the guidelines with practical recommendations. Full implementation of these recommendations should help to ensure that the data are compiled and maintained on a consistent basis. "]
[null,null,"A summary methodology is presented in this questionnaire, in the sheet named 'Methodology'. It is essential to read this sheet before filling in the questionnaire as it contains, beside the summary methodology, important information on priorities for filling in the tables, data sources and hints for establishing a methodology at national level."]
[null,null,"Packaging and packaging waste may be reported against either the new targets in the amending Directive (EU) 2018/852, or against the old targets in Article 6 of Directive 94/62/EC."]
[null,null,"If you have questions, please send them to the following email addresses:"]
[null,null,"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
[null,"Annex: How to fill in the data sheets of the questionnaire"]
[null,null,"You are kindly requested to:"]
[null,null,"a) Explain the methodology and targets you have selected for reporting (yellow sheet named \"Metadata\")."]
[null,null,"b) Fill in Table 1. Table 1 is the new format for reporting on packaging and packaging waste. Therefore, Table 1 must be used in all cases. Table 1a is only to be used if Table 1 contains data according to the new rules but a Member State wants to prove compliance with the old targets until 2025 (and beyond in case of a derogation) using the old rules. Member States are encouraged to use the methodology to report according the new rules for reference years 2018 and 2019. However, if this is not possible and only data according to the old rules can be provided for these two years, Table 1 must still be used  (not Table 1a). In this case, provision of separate data for aluminium and steel packaging would be voluntary (in line with the old rules). Also, for reference years 2018 and 2019, the three different recycling columns should be filled in as best possible, but it might not be possible to fill all in as the split was not required under the old rules. Finally, when reporting in line with the old rules, the ‘Energy Recovery (R1)’ column shall include the R 1 recovery operations as mentioned in Annex II of the Waste Framework Directive 2008/98/EC as last amended."]
[null,null,"c) Table 1a. If you are reporting against the old and new recycling targets according to the new calculation rules, you do not need to complete this table. If you have already used Table 1 to report data according to the old calculations rules, there is no need to complete Table 1a either. Table 1a is only to be completed if Table 1 contains data according to the new rules but you want to prove compliance with the old targets until 2025 (and beyond in case of a derogation) using the old rules."]
[null,null,"d) Table 2 needs to be completed if a Member State wants to make use – in accordance with Article 5(2) of Directive 94/62 - of the adjusted level for the recycling targets in Article 6(1)(f) to (i) of Directive 94/62. These targets apply from reference years 2025 respectively 2030. In principle, Table 3 contains the necessary information for completing Table 2. Then, from reference year 2023 onwards, the necessary information to complete Table 2 for three previous years can be derived from Table 3 as reported for the previous reference years. If a Member State wishes to see their distance to target for the 2025 targets already before, it is possible that the Member States complete the data for Table 2 for the three previous reference years (2017, 2016, 2015) if such data are available. Filling in these earlier years is voluntary. "]
[null,null,"e) Filling in Table 3 is obligatory for the reference year 2020 onwards, and the first report is due by 30 June 2022. "]
[null,null,"Tables 1 to 3"]
[null,null,"1)     All the cells that include mandatory data should be filled in with a value. In the questionnaire all these cells are uncoloured. For light purple cells see Table 1."]
[null,null,"2)     All the cells that include voluntary data can be filled in with a value, a real zero or remain empty if data are not available. In the questionnaire all these cells are coloured in light blue."]
[null,null,"3)     Flags (footnote symbols) can be entered in the reporting tables in the footnote columns."]
[null,null,"4)     To include standard footnotes use the drop-down menu."]
[null,null,"5)     The text of specific footnotes can be entered in the worksheet 'Footnotes list'."]
[null,null,"6)     Complete the quality report, providing as much information as possible."]

{"sheet":"Methodology","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,1,13,2],[1,1,1,2],[9,1,9,2],[11,1,11,2],[10,1,10,2],[4,1,4,2],[5,1,5,2],[7,1,7,2],[6,1,6,2],[8,1,8,2],[14,1,14,2],[17,1,17,2],[18,1,18,2],[16,1,16,2],[15,1,15,2]]}
[]
[null,"EXPLANATORY NOTES AND METHODOLOGY"]
[]
[]
[null,"Table of contents"]
[null,"1. Background"]
[null,"2. Legal acts"]
[null,"3. Data reporting - questionnaire"]
[]
[null,"1. Background"]
[null,"The European Parliament and the Council adopted Directive 94/62/EC to prevent or reduce the impact of packaging and packaging waste on the environment. \n\nThis reporting template allows Member States to report packaging waste pursuant to the requirements in the implementing Decision (EU) 2019/665 of 17 April 2019, amending Decision 2005/270/EC establishing formats relating to the database system pursuant to European Parliament and Council Directive 94/62/EC on packaging and packaging waste \n\nThe guidelines are available here:\n"]
[null,"https://ec.europa.eu/eurostat/web/waste/methodology"]
[]
[null,"2. Legal acts"]
[null,"European Parliament and Council Directive 94/62/EC of 20 December 1994 on packaging and packaging waste as last amended.\n\nCommission Decision 2005/270/EC of 22 March 2005 establishing the formats relating to the database system pursuant to Directive 94/62/EC of the European Parliament and of the Council on packaging and packaging waste as last amended.\n\nDirective (EU) 2018/852 of the European Parliament and of the Council of 30 May 2018 amending Directive 94/62/EC on packaging and packaging waste.\n\nCommission Implementing Decision (EU) 2019/665 of 17 April 2019 amending Decision 2005/270/EC establishing the formats relating to the database system pursuant to European Parliament and Council Directive 94/62/EC on packaging and packaging waste (notified under document C(2019) 2805.\n\nThe legislation is available here:"]
[null,"https://ec.europa.eu/eurostat/web/waste/legislation"]
[]
[null,"3. Data reporting - questionnaire"]
[null,"This document assists Member States to report high quality, harmonised and efficient statistics on packaging and packaging waste in accordance to the Commission Decision 2005/270/EC. Detailed instructions can be found in the guidance document referred to above.\n\nThe reporting shall cover a full calendar year.\n\nThe basic instructions sheet consists of some information necessary for filling in this questionnaire correctly, like country codes, reference years, unit of measure, allowed symbols, metadata, footnotes, and transmission to Eurostat.\n\nThe metadata sheet asks some questions on methodology and coverage that should be answered and returned to Eurostat. \n\nThe Commission Decision, Article 9.4, establishes a quality report and sets out the format in its Annex IV, that needs to be completed, see sheet 'Quality report'. These questions are necessary to understand the data collection methodology used by the country and the coverage of the data transmitted which in turn will allow for better comparison of data across countries."]

{"sheet":"Metadata","index":4,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,1,18,3],[19,2,19,3],[21,2,21,3],[20,1,20,3],[7,2,7,3],[12,1,12,3],[13,2,13,3],[10,1,10,3],[11,2,11,3],[14,1,14,3],[15,2,15,3],[16,1,16,3],[17,2,17,3],[1,1,1,3],[2,1,2,3],[6,1,6,3],[8,1,8,3],[9,2,9,3]]}
[]
[null,"ANNUAL REPORTING OF PACKAGING AND PACKAGING WASTE\nQUESTIONS ON METHODOLOGY"]
[null," 1. Please enter the name and email address of the person that filled in this questionnaire"]
[null,null,"Name:","Tim Mirgain"]
[]
[null,null,"E-mail:","tim.mirgain@aev.etat.lu"]
[null,"2. Please describe your data source(s) "]
[null,null,"The analysis is based on the annual data submission of waste handlers in Luxembourg."]
[null,"3. Please indicate if you are reporting in accordance with the new calculation rules (as set out in Articles 6a to 6d of Commission Decision 2005/270 as last amended) in Table 1. Please also indicate if you intend to report compliance with the old recycling targets according to the old calculation rules (as set out in Articles 3 to 5 of Commission Decision 2005/270 as last amended)."]
[null,null,"LU is reporting according to the old calculation rules in Table 1 and also whishes to report compliance with the old recycling targets."]
[null,"4. Please indicate if you wish to take into account the amount of wooden packaging that is repaired for reuse in the calculation of the targets laid down in point (f), point (g) (ii), point (h) and point (i) (ii) of Article 6(1) of Directive 94/62/EC.  If yes, please indicate the adjusted recycling rates in the box below and fill in the purple shaded cells in Table 1 for the column \"Repair\". Please do not add the amount of repaired wooden packaging to the amount recycled and to the amount of waste generated in Table 1! "]
[null,null,"No"]
[null,"5. Please indicate if you wish to take into account the amount of metals in incineration bottom ash (IBA) for the calculation of the targets."]
[null,null,"Yes"]
[null,"6. Please indicate whether the derogation to make use of the delegated act on average loss rates has been applied."]
[null,null,"Not applicable for 2020 data collection as legal act not yet in force"]
[null,"7. Please provide details on the types of reuse system in place for each main material type."]
[null,null,"The Hospitality and food sector uses a considerable part of reusable glass beverage bottles.\nPlastic reusable bags > 50 microns are used by 74% of the consumers when they shop; half of these bags are the “Ecosac”, a national bag (EU best practice) which is implemented by a major part of the supermarkets and distributors and sold to consumers. Also, for vegetables, a national meshbag, the “Superbag” has been developed and is proposed to consumers in the same selling places.\nThere are currently no other major mainstreams of reusable packaging known by our administration."]
[null,"8. Regarding the revision of data series when changing sources and methods.\n     Did you correct backwards data series when you changed sources and methods? \n     Could you send the revised data for previous years?"]
[null,null,"Yes. Revised data for previous years will be send via e-mail"]
[null,"9. Any other comments?"]

{"sheet":"Footnotes list","index":5,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"ANNUAL REPORTING OF PACKAGING AND PACKAGING WASTE\nFOOTNOTES LIST"]
[null,"Country:",{"$f":"IF('Basic instructions'!G11=\"\",\"\",'Basic instructions'!G11)","v":"Luxembourg"}]
[null,"Number","Country-specific footnotes"]
[null,1,"The main sorting facility for municipal plastic packaging waste was upgraded in 2018. This  has led to reduced amount of plastic packaging being recycled, compared to 2017, as packaging waste was not recycled or carried over into 2019. "]
[null,2,"Data on aluminium packaging is used from the EPR scheme. Currently the EPR scheme does only cover residential packaging. For aluminium packaging it can however be assumed that there is no commercial packaging."]
[null,3,"In previous submission the category \"other packaging\" was used for composite materials. As this is not in line with the calculation method LU has taken the assumption that 50% of composite packaging is cardboard and 50% is plastic. LU will carry out more analysis in order to fully comply with the calculation method in futur reports.  "]
[null,4,"In 2018 a major wood panel producer started using wood waste in its panel production. This has lead to a higher demand for high quality wood (like pallets) which in turn led to a better sorting. The improved sorting process led to a better identification of wood packaging."]
[null,5,"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"Table_1","index":6,"n_rows":35,"n_cols":38,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,26,4,29],[4,30,4,37],[1,5,1,37],[25,5,25,21],[4,5,5,5],[5,8,5,9],[5,12,5,13],[5,16,5,17],[5,20,5,21],[5,24,5,25],[5,28,5,29],[5,32,5,33],[5,36,5,37],[4,6,4,9],[4,10,4,25],[31,5,31,36],[34,5,34,36],[33,5,33,36],[28,5,28,34],[27,5,27,34]]}
[]
[null,null,null,null,null,"TABLE 1. Generation and recycling of packaging waste as established by Commission Decision 2005/270/EC\n as last amended by Commission Implementing Decision 2019/665(1) ( in tonnes)"]
[null,null,null,null,null,"Country:",{"$f":"'Basic instructions'!J11","v":"LU"},{"$f":"IF('Basic instructions'!G11=\"\",\"\",'Basic instructions'!G11)","v":"Luxembourg"}]
[null,null,null,null,null,"Reference year:",{"$f":"IF('Basic instructions'!G12=\"\",\"\",'Basic instructions'!G12)","v":2018}]
[null,null,null,null,null,"Packaging waste material"," Generation",null,null,null,"Recycling\n(The total weight of waste of each material type, at the relevant calculation points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Repair",null,null,null,"Recovery"]
[null,null,null,null,null,null,"Waste generation (a)","Standard footnotes","Explanatory\nfootnote",null,"Recycling in the Member State ","Standard footnotes","Explanatory\nfootnote",null,"Recycling in other Member States ","Standard footnotes","Explanatory\nfootnote",null,"Recycling outside the EU ","Standard footnotes","Explanatory\nfootnote",null,"Recycling (Total )","Standard footnotes","Explanatory\nfootnote",null,"Repair of wooden packaging ","Standard footnotes","Explanatory\nfootnote",null,"Energy recovery(2) (R1)","Standard footnotes","Explanatory\nfootnote",null,"Other recovery (3)","Standard footnotes","Explanatory\nfootnote"]
[null,null,"unit","waste",null,"wst_oper ==>","GEN",null,null,null,"RCY_NAT",null,null,null,"RCY_EU_FOR",null,null,null,"RCY_NEU",null,null,null,"RCY",null,null,null,"RPR",null,null,null,"RCV_E",null,null,null,"RCV_OTH"]
[null,null,"T","W150102",null,"Plastic",25902,null,null,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},8379,null,1,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"The main sorting facility for municipal plastic packaging waste was upgraded in 2018. This  has led to reduced amount of plastic packaging being recycled, compared to 2017, as packaging waste was not recycled or carried over into 2019. "},0,"E",5,{"$f":"IF(TRIM(U8)=\"\", \"\", IF(VLOOKUP(U8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O8+S8","v":8379},null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,13653,null,null,{"$f":"IF(TRIM(AG8)=\"\", \"\", IF(VLOOKUP(AG8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK8)=\"\", \"\", IF(VLOOKUP(AK8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W150103",null,"Wood",14623,null,4,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"In 2018 a major wood panel producer started using wood waste in its panel production. This has lead to a higher demand for high quality wood (like pallets) which in turn led to a better sorting. The improved sorting process led to a better identification of wood packaging."},0,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},4622,null,4,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"In 2018 a major wood panel producer started using wood waste in its panel production. This has lead to a higher demand for high quality wood (like pallets) which in turn led to a better sorting. The improved sorting process led to a better identification of wood packaging."},0,"E",5,{"$f":"IF(TRIM(U9)=\"\", \"\", IF(VLOOKUP(U9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O9+S9","v":4622},null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC9)=\"\", \"\", IF(VLOOKUP(AC9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},9951,null,null,{"$f":"IF(TRIM(AG9)=\"\", \"\", IF(VLOOKUP(AG9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK9)=\"\", \"\", IF(VLOOKUP(AK9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W150104",null,"Metal (total) (5)",{"$f":"IF(TRIM(CONCATENATE(G11,G12))=\"\",\"\",SUM(G11,G12))","v":5176},null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K11,K12))=\"\",\"\",SUM(K11,K12))","v":29},null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(O11,O12))=\"\",\"\",SUM(O11,O12))","v":4779},null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(S11,S12))=\"\",\"\",SUM(S11,S12))","v":0},null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W11,W12))=\"\",\"\",SUM(W11,W12))","v":4808},null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(CONCATENATE(AE11,AE12))=\"\",\"\",SUM(AE11,AE12))","v":0},null,null,{"$f":"IF(TRIM(AG10)=\"\", \"\", IF(VLOOKUP(AG10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AI11,AI12))=\"\",\"\",SUM(AI11,AI12))","v":0},null,null,{"$f":"IF(TRIM(AK10)=\"\", \"\", IF(VLOOKUP(AK10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W15010402",null,"   Ferrous metal",{"$f":"5176-G12","v":3132},null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},29,"E",null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"4808-K11-O12","v":2880},null,1,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"The main sorting facility for municipal plastic packaging waste was upgraded in 2018. This  has led to reduced amount of plastic packaging being recycled, compared to 2017, as packaging waste was not recycled or carried over into 2019. "},0,"E",5,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O11+S11+K11","v":2909},null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(TRIM(AK11)=\"\", \"\", IF(VLOOKUP(AK11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W15010401",null,"   Aluminium",2044,"E",2,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Data on aluminium packaging is used from the EPR scheme. Currently the EPR scheme does only cover residential packaging. For aluminium packaging it can however be assumed that there is no commercial packaging."},0,"E",null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"ROUND(4808*(G12/(G12+G11)),0)","v":1899},null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,"E",5,{"$f":"IF(TRIM(U12)=\"\", \"\", IF(VLOOKUP(U12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O12+S12","v":1899},null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,0,"E",2,{"$f":"IF(TRIM(AG12)=\"\", \"\", IF(VLOOKUP(AG12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Data on aluminium packaging is used from the EPR scheme. Currently the EPR scheme does only cover residential packaging. For aluminium packaging it can however be assumed that there is no commercial packaging."},0,null,null,{"$f":"IF(TRIM(AK12)=\"\", \"\", IF(VLOOKUP(AK12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W15010402_IBA",null,"   Ferrous metal from IBA (6) ",null,null,null,null,null,null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U13)=\"\", \"\", IF(VLOOKUP(U13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W15010401_IBA",null,"   Aluminium from IBA (7)",null,null,null,null,null,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U14)=\"\", \"\", IF(VLOOKUP(U14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W150107",null,"Glass",34600,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},33999,null,null,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,"E",5,{"$f":"IF(TRIM(U15)=\"\", \"\", IF(VLOOKUP(U15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O15+S15","v":33999},null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(TRIM(AK15)=\"\", \"\", IF(VLOOKUP(AK15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W150101",null,"Paper and cardboard",55903,null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},44826,null,null,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,"E",5,{"$f":"IF(TRIM(U16)=\"\", \"\", IF(VLOOKUP(U16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"O16+S16","v":44826},null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,7944,null,null,{"$f":"IF(TRIM(AG16)=\"\", \"\", IF(VLOOKUP(AG16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK16)=\"\", \"\", IF(VLOOKUP(AK16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W150199",null,"Other",1,null,3,{"$f":"IF(TRIM(I17)=\"\", \"\", IF(VLOOKUP(I17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"In previous submission the category \"other packaging\" was used for composite materials. As this is not in line with the calculation method LU has taken the assumption that 50% of composite packaging is cardboard and 50% is plastic. LU will carry out more analysis in order to fully comply with the calculation method in futur reports.  "},0,null,null,{"$f":"IF(TRIM(M17)=\"\", \"\", IF(VLOOKUP(M17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,"E",5,{"$f":"IF(TRIM(U17)=\"\", \"\", IF(VLOOKUP(U17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},0,null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,null,0,null,null,{"$f":"IF(TRIM(AG17)=\"\", \"\", IF(VLOOKUP(AG17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK17)=\"\", \"\", IF(VLOOKUP(AK17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,"T","W1501",null,"Total (4)",{"$f":"IF(TRIM(CONCATENATE(G8,G9,G10,G15,G16,G17))=\"\",\"\",SUM(G8,G9,G10,G15,G16,G17))","v":136205},null,null,{"$f":"IF(TRIM(I18)=\"\", \"\", IF(VLOOKUP(I18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K8,K9,K10,K15,K16,K17))=\"\",\"\",SUM(K8,K9,K10,K15,K16,K17))","v":29},null,null,{"$f":"IF(TRIM(M18)=\"\", \"\", IF(VLOOKUP(M18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(O8,O9,O10,O15,O16,O17))=\"\",\"\",SUM(O8,O9,O10,O15,O16,O17))","v":96605},null,null,{"$f":"IF(TRIM(Q18)=\"\", \"\", IF(VLOOKUP(Q18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(S8,S9,S10,S15,S16,S17))=\"\",\"\",SUM(S8,S9,S10,S15,S16,S17))","v":0},"E",5,{"$f":"IF(TRIM(U18)=\"\", \"\", IF(VLOOKUP(U18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":"Luxembourg does not export waste directly outside the EU. For all packaging waste collected via the official household packaging scheme (valorlux) LU knows that the end user of those waste streams are all located in the EU. LU can however not exclude that some of the packaging waste collected by other waste handlers does not transit via neighbouring countries outside the EU.  "},{"$f":"IF(TRIM(CONCATENATE(W8,W9,W10,W15,W16,W17))=\"\",\"\",SUM(W8,W9,W10,W15,W16,W17))","v":96634},null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(AA9)=\"\",\"\",AA9)","v":""},null,null,{"$f":"IF(TRIM(AC18)=\"\", \"\", IF(VLOOKUP(AC18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AE8,AE9,AE10,AE15,AE16,AE17))=\"\",\"\",SUM(AE8,AE9,AE10,AE15,AE16,AE17))","v":31548},null,null,{"$f":"IF(TRIM(AG18)=\"\", \"\", IF(VLOOKUP(AG18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AI8,AI9,AI10,AI15,AI16,AI17))=\"\",\"\",SUM(AI8,AI9,AI10,AI15,AI16,AI17))","v":0},null,null,{"$f":"IF(TRIM(AK18)=\"\", \"\", IF(VLOOKUP(AK18,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK18,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,null,"Light grey: The calculation of data is automatic. They can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[null,null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,null,"Black: Not applicable."]
[null,null,null,null,null,"Light purple shaded boxes: reporting is mandatory only to Member States that include those amounts in the recycling rates. Member States that report on repair of wooden packaging shall not include these amounts in total recycling or in total waste generated or in any other white box!  Instead, please indicate in the sheet Metadata if you wish to include the amounts in your recycling rates. The calculation of the adjusted recycling rates will be conducted by the Commission according to the method set out in the guidance document."]
[]
[null,null,null,null,null,"(a) The amounts reported shall exclude the amount of wooden packaging repaired and of metals from IBA. For repair of wooden pallets, the Commission will calculate the adjusted recycling rates separately."]
[null,null,null,null,null,"(1) Commission Decision 2005/270/EC establishing the formats relating to Directive 94/62/EC on packaging and packaging waste as last amended by Commission Implementing Decision  2019/665"]
[null,null,null,null,null,"(2) This includes incineration with energy recovery and the reprocessing of waste to be used as fuel or other means to generate energy."]
[null,null,null,null,null,"(3) This excludes repair of wooden packaging, recycling and energy recovery and includes backfilling."]
[null,null,null,null,null,"(4) The 'Total' row should be a sum of all the amounts given in the separate rows within the table (except only one of either the 'Metal (total)' or 'Ferrous metal' and 'Aluminium' rows should be included, to ensure there is no double counting)."]
[null,null,null,null,null,"(5) The 'Metal (total)' row should be equal to the sum of the 'Ferrous metal' and 'Aluminium' rows."]
[null,null,null,null,null,"(6) Ferrous metals recycled after their separation from incineration bottom ash shall be reported separately here and shall be included in the row for reporting ferrous metals."]
[null,null,null,null,null,"(7) Aluminium recycled after separation from incineration bottom ash shall be reported separately here and shall be included in the row for reporting aluminium."]

{"sheet":"Table_1a","index":7,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,1,13],[20,4,20,10],[18,4,18,12],[14,4,14,5],[15,4,15,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,12,4],[13,4,13,5],[27,4,27,12],[25,4,25,12],[26,4,26,12],[24,4,24,12],[6,4,6,5],[6,12,6,13],[6,8,6,9]]}
[]
[null,null,null,null,"TABLE 1a. Generation and recycling of packaging waste calculated according to the old rules as set out in Articles 3, 4 and 5 of Decision 2005/270/EC (1) for proving compliance with the old recycling targets in Article 6 (1) of Directive 94/62/EC ( in tonnes) - to be filled in only by the Member States wanting to prove compliance with the old targets until 2025 (and beyond) using the old rules."]
[null,null,null,null,"Country:",{"$f":"'Basic instructions'!J11","v":"LU"},{"$f":"IF('Basic instructions'!G11=\"\",\"\",'Basic instructions'!G11)","v":"Luxembourg"}]
[null,null,null,null,"Reference year:",{"$f":"IF('Basic instructions'!G12=\"\",\"\",'Basic instructions'!G12)","v":2018}]
[]
[null,null,null,null,"wst_oper ==>",null,"GEN_ORT",null,null,null,"RCY_ORT"]
[null,null,null,null,"Material",null,"Packaging waste generated according to the old calculation rules","Standard footnotes","Explanatory\nfootnote",null,"Packaging waste recycled according to the old calculation rules","Standard footnotes","Explanatory\nfootnote"]
["T","W150107",null,null,"Glass",null,null,null,null,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W150102",null,null,"Plastic",null,null,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W150101",null,null,"Paper and board",null,null,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W15010401",null,null,"\n\nMetal","Aluminium",null,null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W15010402",null,null,null,"Steel",null,null,null,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W150104",null,null,null,"Total",null,null,null,{"$f":"IF(TRIM(I13)=\"\", \"\", IF(VLOOKUP(I13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W150103",null,null,"Wood",null,null,null,null,{"$f":"IF(TRIM(I14)=\"\", \"\", IF(VLOOKUP(I14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W150199",null,null,"Other",null,null,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
["T","W1501",null,null,"Total",null,{"$f":"IF(TRIM(CONCATENATE(G8,G9,G10,G13,G14,G15))=\"\",\"\",SUM(G8,G9,G10,G13,G14,G15))","v":""},null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K8,K9,K10,K13,K14,K15))=\"\",\"\",SUM(K8,K9,K10,K13,K14,K15))","v":""},null,null,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,"Notes:"]
[null,null,null,null,"This table is only for those Member States wishing to report against the old recycling targets in Article 6 of Directive 94/62/EC using the old calculation rules. If you have already used Table 1 to report data according the old calculations rules, there is no need to complete Table 1a.\nThose Member States reporting against the old and new recycling targets according to the new calculation rules, do not need to complete this table."]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory for those Member States wishing to report against the old recycling targets in Article 6 of Directive 94/62/EC using the old calculation rules (only if they have reported data according the new calculation rules in Table 1)"]
[null,null,null,null,"Light grey: The calculation of data is automatic. Can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[null,null,null,null,"Light blue: provision of data is voluntary."]
[null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[]
[]
[null,null,null,null,"(1) Commission Decision 2005/270/EC establishing the formats relating to Directive 94/62/EC on packaging and packaging waste"]
[null,null,null,null,"Recycling rate (%) for the purpose of Article 6(1) of Directive 94/62/EC will be calculated as packaging waste recycled divided by packaging waste generated x 100"]

{"sheet":"Table_2","index":8,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,5,22,9],[0,5,0,9],[16,5,16,9]]}
[null,null,null,null,null,"Table 2. Adjusted level of the targets in accordance with Article 5(2) of Directive 94/62/EC (1)"]
[null,null,null,null,null,"Country:",{"$f":"'Basic instructions'!J11","v":"LU"},{"$f":"IF('Basic instructions'!G11=\"\",\"\",'Basic instructions'!G11)","v":"Luxembourg"}]
[null,null,null,null,null,"Reference year:",{"$f":"IF('Basic instructions'!G12=\"\",\"\",'Basic instructions'!G12)","v":2018}]
[null,null,null,null,null,"wst_oper ==>","FMKT_RE_S","FMKT_RE_S","FMKT_RE_S","FMKT_RE_S"]
[null,null,null,null,null,"time ==>",{"$f":"$G$3 -3","v":2015},{"$f":"$G$3 -2","v":2016},{"$f":"$G$3 -1","v":2017},{"$f":"G3","v":2018}]
[null,null,null,null,null,1,2,3,4,5]
["unit","waste",null,null,null,"Packaging waste material ",{"$f":"CONCATENATE(\"Share of reusable sales packaging in all sales packaging year \",$G$3-3,\" (%)\")","v":"Share of reusable sales packaging in all sales packaging year 2015 (%)"},{"$f":"CONCATENATE(\"Share of reusable sales packaging in all sales packaging year \", $G$3 -2,\" (%)\")","v":"Share of reusable sales packaging in all sales packaging year 2016 (%)"},{"$f":"CONCATENATE(\"Share of reusable sales packaging in all sales packaging year \", $G$3 -1,\" (%)\")","v":"Share of reusable sales packaging in all sales packaging year 2017 (%)"},{"$f":"CONCATENATE(\"Average share of reusable sales packaging in the three years preceding year \", G3)","v":"Average share of reusable sales packaging in the three years preceding year 2018"}]
["PC","W150102",null,null,null,"Plastic",null,null,null,{"$f":"IF(G8+H8+I8=0, \"\",AVERAGE(G8,H8,I8))","v":""}]
["PC","W150103",null,null,null,"Wood",null,null,null,{"$f":"IF(G9+H9+I9=0, \"\",AVERAGE(G9,H9,I9))","v":""}]
["PC","W15010402",null,null,null,"Ferrous metal",null,null,null,""]
["PC","W15010401",null,null,null,"Aluminium",null,null,null,""]
["PC","W150107",null,null,null,"Glass",null,null,null,""]
["PC","W150101",null,null,null,"Paper and cardboard",null,null,null,""]
["PC","W1501",null,null,null,"Total",null,null,null,""]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"This table can be completed if you want to make use – in accordance with Article 5(2) of Directive 94/62 - of the adjusted level for the recycling targets in Article 6(1)(f) to (i) of Directive 94/62. These targets apply from reference years 2025 respectively 2030. In principle, Table 3 contains the necessary information for completing Table 2. Then, from reference year 2023 onwards, the necessary information to complete Table 2 for three previous years can be derived from Table 3 as reported for the previous reference years. If a Member State wishes to see the distance to target for the 2025 targets already before, it is possible to complete the data for Table 2 for the three previous reference years (2017, 2016, 2015) if such data are available. Filling in these earlier years is voluntary. "]
[]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"Light grey: the calculation of data is automatic and represents the simple average of columns 2, 3 and 4. "]
[null,null,null,null,null,"Light blue: data is mandatory only for the material for which the Member State has decided to achieve an adjusted target."]
[]
[null,null,null,null,null," (1) Directive 94/62/EC on packaging and packaging waste as last amended by Directive 2018/852."]

{"sheet":"Table_3","index":9,"n_rows":30,"n_cols":46,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,44,8,45],[8,16,8,17],[8,32,8,33],[8,40,8,41],[8,8,8,9],[8,12,8,13],[8,20,8,21],[8,24,8,25],[8,28,8,29],[0,5,0,45],[7,14,7,21],[7,6,7,13],[7,22,7,25],[7,26,7,29],[6,22,6,29],[7,30,7,37],[7,38,7,45],[6,30,6,45],[6,6,6,21],[29,5,29,42],[6,5,8,5],[26,5,26,42],[27,5,27,42],[28,5,28,42],[25,5,25,42],[20,5,20,10],[21,5,21,10],[8,36,8,37]]}
[null,null,null,null,null,"TABLE 3. Reporting on reusable packaging as established by Commission Decision 2005/270/EC\n as last amended by Commission Implementing Decision 2019/665 (1)"]
[null,null,null,null,null,"Country:",{"$f":"'Basic instructions'!J11","v":"LU"},{"$f":"IF('Basic instructions'!G11=\"\",\"\",'Basic instructions'!G11)","v":"Luxembourg"}]
[null,null,null,null,null,"Reference year:",{"$f":"IF('Basic instructions'!G12=\"\",\"\",'Basic instructions'!G12)","v":2018}]
[null,null,null,null,null,"unit ==>","T",null,null,null,"NR",null,null,null,"T",null,null,null,"NR",null,null,null,"T",null,null,null,"T",null,null,null,"T",null,null,null,"NR",null,null,null,"T",null,null,null,"NR"]
[null,null,null,null,null,"wst_oper","FMKT",null,null,null,"FMKT",null,null,null,"FMKT_S",null,null,null,"FMKT_S",null,null,null,"FMKT_RE",null,null,null,"FMKT_RE_S",null,null,null,"ROTY_RE    ",null,null,null,"ROTY_RE    ",null,null,null,"ROTY_RE_S",null,null,null,"ROTY_RE_S"]
[null,null,null,null,null,1,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8,null,null,null,9,null,null,null,10,null,null,null,11]
[null,null,null,null,null,"\nPackaging material ","Packaging placed on the market for the first time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reusable packaging placed on the market for the first time",null,null,null,null,null,null,null,"Rotations per year (4)"]
[null,null,null,null,null,null,"All packaging (2)",null,null,null,null,null,null,null,"Sales packaging (3)",null,null,null,null,null,null,null,"All reusable packaging",null,null,null,"Reusable sales packaging ",null,null,null,"All reusable packaging",null,null,null,null,null,null,null,"Reusable sales packaging"]
[null,null,null,"waste",null,null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(units)","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(units)","Standard footnotes","Explanatory\nfootnote",null," (t) ","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(t) (5)","Standard footnotes","Explanatory\nfootnote",null,"(number)","Standard footnotes","Explanatory\nfootnote",null,"(t) (5)","Standard footnotes","Explanatory\nfootnote",null,"(number)","Standard footnotes","Explanatory\nfootnote"]
[null,null,null,"W150102",null,"Plastic",null,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC10)=\"\", \"\", IF(VLOOKUP(AC10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG10)=\"\", \"\", IF(VLOOKUP(AG10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK10)=\"\", \"\", IF(VLOOKUP(AK10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO10)=\"\", \"\", IF(VLOOKUP(AO10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS10)=\"\", \"\", IF(VLOOKUP(AS10,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS10,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W150103",null,"Wood",null,null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC11)=\"\", \"\", IF(VLOOKUP(AC11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG11)=\"\", \"\", IF(VLOOKUP(AG11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK11)=\"\", \"\", IF(VLOOKUP(AK11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO11)=\"\", \"\", IF(VLOOKUP(AO11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS11)=\"\", \"\", IF(VLOOKUP(AS11,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS11,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W15010402",null,"Ferrous metal",null,null,null,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U12)=\"\", \"\", IF(VLOOKUP(U12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC12)=\"\", \"\", IF(VLOOKUP(AC12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG12)=\"\", \"\", IF(VLOOKUP(AG12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK12)=\"\", \"\", IF(VLOOKUP(AK12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO12)=\"\", \"\", IF(VLOOKUP(AO12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS12)=\"\", \"\", IF(VLOOKUP(AS12,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS12,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W15010401",null,"Aluminium",null,null,null,{"$f":"IF(TRIM(I13)=\"\", \"\", IF(VLOOKUP(I13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U13)=\"\", \"\", IF(VLOOKUP(U13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC13)=\"\", \"\", IF(VLOOKUP(AC13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG13)=\"\", \"\", IF(VLOOKUP(AG13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK13)=\"\", \"\", IF(VLOOKUP(AK13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO13)=\"\", \"\", IF(VLOOKUP(AO13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS13)=\"\", \"\", IF(VLOOKUP(AS13,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS13,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W150107",null,"Glass",null,null,null,{"$f":"IF(TRIM(I14)=\"\", \"\", IF(VLOOKUP(I14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U14)=\"\", \"\", IF(VLOOKUP(U14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC14)=\"\", \"\", IF(VLOOKUP(AC14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG14)=\"\", \"\", IF(VLOOKUP(AG14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK14)=\"\", \"\", IF(VLOOKUP(AK14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO14)=\"\", \"\", IF(VLOOKUP(AO14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS14)=\"\", \"\", IF(VLOOKUP(AS14,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS14,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W150101",null,"Paper and cardboard",null,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U15)=\"\", \"\", IF(VLOOKUP(U15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC15)=\"\", \"\", IF(VLOOKUP(AC15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG15)=\"\", \"\", IF(VLOOKUP(AG15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK15)=\"\", \"\", IF(VLOOKUP(AK15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO15)=\"\", \"\", IF(VLOOKUP(AO15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS15)=\"\", \"\", IF(VLOOKUP(AS15,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS15,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W150199",null,"Other",null,null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U16)=\"\", \"\", IF(VLOOKUP(U16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC16)=\"\", \"\", IF(VLOOKUP(AC16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG16)=\"\", \"\", IF(VLOOKUP(AG16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK16)=\"\", \"\", IF(VLOOKUP(AK16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO16)=\"\", \"\", IF(VLOOKUP(AO16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS16)=\"\", \"\", IF(VLOOKUP(AS16,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS16,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[null,null,null,"W1501",null,"Total",{"$f":"IF(TRIM(CONCATENATE(G10,G11,G12,G13,G14,G15,G16))=\"\",\"\",SUM(G10,G11,G12,G13,G14,G15,G16))","v":""},null,null,{"$f":"IF(TRIM(I17)=\"\", \"\", IF(VLOOKUP(I17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(I17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K10,K11,K12,K13,K14,K15,K16))=\"\",\"\",SUM(K10,K11,K12,K13,K14,K15,K16))","v":""},null,null,{"$f":"IF(TRIM(M17)=\"\", \"\", IF(VLOOKUP(M17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(M17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(O10,O11,O12,O13,O14,O15,O16))=\"\",\"\",SUM(O10,O11,O12,O13,O14,O15,O16))","v":""},null,null,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(S10,S11,S12,S13,S14,S15,S16))=\"\",\"\",SUM(S10,S11,S12,S13,S14,S15,S16))","v":""},null,null,{"$f":"IF(TRIM(U17)=\"\", \"\", IF(VLOOKUP(U17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(U17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W10,W11,W12,W13,W14,W15,W16))=\"\",\"\",SUM(W10,W11,W12,W13,W14,W15,W16))","v":""},null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AA10,AA11,AA12,AA13,AA14,AA15,AA16))=\"\",\"\",SUM(AA10,AA11,AA12,AA13,AA14,AA15,AA16))","v":""},null,null,{"$f":"IF(TRIM(AC17)=\"\", \"\", IF(VLOOKUP(AC17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AC17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AE10,AE11,AE12,AE13,AE14,AE15,AE16))=\"\",\"\",SUM(AE10,AE11,AE12,AE13,AE14,AE15,AE16))","v":""},null,null,{"$f":"IF(TRIM(AG17)=\"\", \"\", IF(VLOOKUP(AG17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AG17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AI10,AI11,AI12,AI13,AI14,AI15,AI16))=\"\",\"\",SUM(AI10,AI11,AI12,AI13,AI14,AI15,AI16))","v":""},null,null,{"$f":"IF(TRIM(AK17)=\"\", \"\", IF(VLOOKUP(AK17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AK17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AM10,AM11,AM12,AM13,AM14,AM15,AM16))=\"\",\"\",SUM(AM10,AM11,AM12,AM13,AM14,AM15,AM16))","v":""},null,null,{"$f":"IF(TRIM(AO17)=\"\", \"\", IF(VLOOKUP(AO17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AO17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AQ10,AQ11,AQ12,AQ13,AQ14,AQ15,AQ16))=\"\",\"\",SUM(AQ10,AQ11,AQ12,AQ13,AQ14,AQ15,AQ16))","v":""},null,null,{"$f":"IF(TRIM(AS17)=\"\", \"\", IF(VLOOKUP(AS17,'Footnotes list'!$B$5:$C$103,2,FALSE)=0,\"\",VLOOKUP(AS17,'Footnotes list'!$B$5:$C$103,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"Notes:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"White: Data provision is mandatory from 2022 (reference year 2020)"]
[null,null,null,null,null,"Light grey: The calculation of data is automatic. Can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[null,null,null,null,null,"Light blue: provision of data is voluntary."]
[null,null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[]
[null,null,null,null,null,"(1) Commission Decision 2005/270/EC establishing the formats relating to Directive 94/62/EC on packaging and packaging waste as last amended by Commission Implementing Decision  2019/665"]
[null,null,null,null,null,"(2)  This means all reusable and single-use packaging comprising sales, transport and grouped packaging"]
[null,null,null,null,null,"(3) This means reusable and single-use sales packaging."]
[null,null,null,null,null,"(4) This means the number of rotations that reusable packaging completes in a given year."]
[null,null,null,null,null,"(5) This means the number of rotations that reusable packaging completes in a given year multiplied by their mass."]

{"sheet":"ErrorLog","index":10,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Link to Error","Validation Rule","Cell","Sheet","Description","Severity","Former Color"]

{"sheet":"Lists","index":11,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Country label","Country code",null,"Valid flags","Label"]
["Belgium","BE",null,"B","break in time series"]
["Bulgaria","BG",null,"E","estimated data"]
["Czechia","CZ",null,"P","provisional"]
["Denmark","DK",null,"BE"]
["Germany","DE",null,"BP"]
["Estonia","EE",null,"EP"]
["Ireland","IE",null,"BEP"]
["Greece","EL"]
["Spain","ES"]
["France","FR"]
["Croatia","HR"]
["Italy","IT"]
["Cyprus","CY"]
["Latvia","LV"]
["Lithuania","LT"]
["Luxembourg","LU"]
["Hungary","HU"]
["Malta","MT"]
["Netherlands","NL"]
["Austria","AT"]
["Poland","PL"]
["Portugal","PT"]
["Romania","RO"]
["Slovenia","SI"]
["Slovakia","SK"]
["Finland","FI"]
["Sweden","SE"]
["United Kingdom","UK"]
["Iceland","IS"]
["Liechtenstein","LI"]
["Norway","NO"]
["Switzerland","CH"]
["Montenegro","ME"]
["North Macedonia","MK"]
["Albania","AL"]
["Serbia","RS"]
["Turkey","TR"]
["Bosnia and Herzegovina","BA"]
["Kosovo (UNSCR 1244)","XK"]
[]
["ESTAT-E2-WASTE-2020","CDD"]

{"sheet":"Locks","index":12,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To","Content is Mandatory"]
["Table_1","G18","AI18",999,4,"Formulas","G8","YES"]
["Table_1","G10","AI10",999,4,"Formulas","G8","YES"]
["Table_1a","G16","K16",999,4,"Formulas","G8","YES"]
["Table_3","G17","AQ17",999,4,"Formulas","G10","YES"]

{"sheet":"CountryName","index":13,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Basic instructions","G11","G11",1,1]
[]
[]
[]
["DESCRIPTION"]
["Spot the position where the reporting country is defined"]
[]
["PARAMETERS"]
[{"$f":"B1","v":"SheetName"},"Name of the sheet to be validated (e.g. Table 1)"]
[{"$f":"C1","v":"TopLeftCell"},"Cell where the country name must be selected"]
[{"$f":"D1","v":"BottomRightCell"},"Same as TopLeftCell (*)  "]
[{"$f":"E1","v":"RowStep"},"Must be \"1\"  (*)  "]
[{"$f":"F1","v":"ColumnStep"},"Must be \"1\"  (*)  "]
[]
["(*) These parameters, apparently useless, are kept to make this validation compatible with other standard validation structures"]

{"sheet":"Summations","index":14,"n_rows":115,"n_cols":11,"rows_kept":115,"cut":false,"hidden":true,"merged":[[16,5,16,6]]}
["Severity","Sheet Name","List of Cells\n (first block)","First Total Cell (first block)","Last Total Cell\n(Last block)","Row Block Repetition Step","Column Block Repetition Step","Greater or Equal","Valid Tolerance","Only if all data is available","Display text in error"]
["Error","Table_1","G8,G9,G10,G15,G16,G17","G18","AI18",999,4,"EQ",0.1,"YES","Total waste not consistent to the sum of materials"]
["Error","Table_1","K8,O8,S8","W8","W18",1,999,"GE",0.1,"NO","Total Recycling must be greater than the sum of its components"]
["Error","Table_1","K8,O8,S8","W8","W18",1,999,"EQ",0.1,"YES","Total Recycling must be equal than the sum of its components"]
["Error","Table_1","G11,G12","G10","AI10",999,4,"EQ",0.1,"YES","Total metals not consistent to the sum of Al + Fe"]
["Error","Table_1","K8,O8,S8,AA8,AE8,AI8","G8","G18",1,999,"GT",0,"NO","Generation must be bigger than the sum of all other columns"]
["Error","Table_1","W8,AA8,AE8,AI8","G8","G18",1,999,"GT",0,"NO","Generation must be bigger than the sum of all other columns"]
["Error","Table_1","K8,O8,S8,AA8,AE8,AI8","G8","G12",1,999,"GT",0,"NO","Generation must be bigger than the sum of all other columns"]
["Error","Table_1","W15,AA15,AE15,AI15","G15","G18",1,999,"GT",0,"NO","Generation must be bigger than the sum of all other columns"]
["Error","Table_1a","G8,G9,G10,G13,G14,G15","G16","K16",999,4,"EQ",0.1,"YES","Total waste not consistent to the sum of materials"]
["Error","Table_1a","G11,G12","G13","K13",999,4,"GE",0.1,"NO","Total metals not consistent to the sum of Al + Fe"]
["Error","Table_1a","K8","G8","G16",1,999,"GT",0,"YES","Generation must be biger than recycling"]
["Error","Table_3","G10,G11,G12,G13,G14,G15,G16","G17","AQ17",999,4,"EQ",0.1,"YES","Total waste not consistent to the sum of materials"]
["Error","Table_3","O10","G10","K17",1,4,"GT",0,"YES","Sales packaging must be smaller than all packaging"]
["Error","Table_3","AA10","W10","W17",1,999,"GT",0,"YES","Reusable sales packaging must be smaller than all sales packaging"]
[]
[null,null,null,null,null,"Must be > 0 for a not relevant dimension. Else you get an infinite loop",null,"EQ or GE or GT","GT does not admit Tolerance","NO or YES"]
[]
["DESCRIPTION"]
["This sheet is meant to define the validation for summations in a row or in a column."]
["- A block is defined as a sequence of addendums in the same row or column"]
["- Only the first block must be explicitly defined"]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(Summations!B3º)","v":{"$error":"#NAME?"}}]

{"sheet":"Mandatory","index":15,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Empty Is Valid If Footnote Exists","Footnote Shift From Value"]
["Error","Basic instructions","D16","D24",2,999,"NO",3]
["Error","Table_1","G8","W10",1,4,"YES",3]
["Error","Table_1","G15","W18",1,4,"YES",3]
["Error","Table_1","AE8","AI10",1,4,"YES",3]
["Error","Table_1","AI15","AI15",1,4,"YES",3]
["Error","Table_1","AE16","AI16",1,4,"YES",3]
[]
[]
[]
["Error","Table_2","K10","K12",1,4,"YES",3]
["Error","Table_2","O8","S12",1,4,"YES",3]
["Error","Table_3","G8","G11",1,4,"YES",3]
["Error","Table_4","P8","P9",1,4,"YES",3]
["Error","Table_4","P15","P16",1,4,"NO",3]
["Error","Table_4","P10","P14",1,4,"YES",3]

{"sheet":"MustNotBeNegative","index":16,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table_1","G8","AI18",1,4]
["Error","Table_1a","G8","K16",1,4]
["Error","Table_2","G8","J14",1,4]
["Error","Table_3","G10","AQ17",1,4]

{"sheet":"Thresholds","index":17,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lower value","Upper value","Error Is Valid If Footnote Exists","Footnote Shift From Value"]
["Error","Table_2","G8","J14",1,1,0,100,"NO",999]

{"sheet":"IsFormula","index":18,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step"]
["Info","Table_1","G18","AI18",999,4]
["Info","Table_1","G10","W10",999,4]
["Info","Table_1","AE10","AI10",999,4]
["Info","Table_1a","G16","K16",999,4]
["Info","Table_3","G17","AQ17",999,4]

{"sheet":"FootnoteContent","index":19,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Table_1","I8","AK18",1,4,1]
["Error","Table_1a","I8","M16",1,4,1]
["Error","Table_3","I10","AS17",1,4,1]

{"sheet":"IsNumeric","index":20,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table_1","G8","AI18",1,4,null,null,"it is meant to check that there are numerical values"]
["Error","Table_1a","G8","K16",1,4]
["Error","Table_2","G8","J14",1,1]
["Error","Table_3","G10","AQ17",1,4]

{"sheet":"Validation rules","index":21,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,"This sheet shows checks that Eurostat plans to implement in an automatic way - to be completed"]
["Preliminary checks:"]
[]
[null,"The reporting country name and Reference year must be filled in the sheet \"Basic Instructions\"."]
[null,"Primary contact point should be filled."]
[]
["Mandatory Data:"]
[]
[null,"All the mandatory cells in table 1 must be filled-in when the reference year is 2020 or later. Before this date, the  breakdown of metals (ferrous metal and aluminium) and the breakdown of recycling were not compulsory according the old rules)"]
[null,"All the mandatory cells in table 3 must be filled-in when the reference year is 2020 or later."]
[]
["Arithmetic rules"]
[]
[null,"All reported values must be equal or bigger than 0 (positive values)"]
[]
[null,"TABLE_1: The 'Metal (total)' row should be equal to the sum of the 'Ferrous metal' and 'Aluminium' rows (when the reference year is 2020 or later). Before, only if reported all of them."]
[]
[null,"TABLE_1:The 'Total' row should be a sum of all the amounts given in the separate material within the table (Excluding the individual metals which are accounted in Metals (total)",null,"TABLE_1:The 'Total' row should be a sum of all the amounts given in the separate rows within the table (except only one of either the 'Metal (total)' or 'Ferrous metal' and 'Aluminium' rows should be included, to ensure there is no double counting)."]
[]
[null,"TABLE_1: The \"Waste generation\" column must be bigger than the amounts given in all other columns within the table "]
[null,"TABLE_1a: The 'Metal (total)' row should be equal to the sum of the Steel' and 'Aluminium' rows (when reported all of these values since according to the old rules provision of separate data for aluminium and steel packaging would be voluntary)."]
[]
[null,"TABLE_1a:The 'Total' row should be a sum of all the amounts given in the separate rows within the table except  'Steel' and 'Aluminium' rows to ensure there is no double counting."]
[]
[null,"TABLE_1a: The \"Packaging Waste Generated \" column must be bigger than the \"Packaging Waste Recycled\" column."]
[]
[null,"TABLE_2: All reported figures must be between 0 and 100."]
[]
[null,"TABLE_3:The 'Total' row should be a sum of all the amounts given in the separate rows within the table."]
[]
[null,"TABLE_3:The columns concerning 'Sales packaging\"' must be smaller than the respective \"all packaging\" columns (having the same unit)"]
[]
[null,"TABLE_3:\"Reusable packaging placed on the market for the first time\" must be smaller than \"Packaging placed on the market for the first time\""]
[]
["Formula:"]
[null,"Table_1, Table_1a, Table_3. Include formula in total waste. Create macro to unblock the cell. "]
[null,"Table_1. Include formula in total recycling. This column should be hidden. Create macro to unblock the cell. "]

{"sheet":"Quality_report >>>","index":22,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,0,12,10],[3,6,3,10],[3,0,3,5],[0,3,0,7],[6,9,6,10]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["Quality report",null,null,null,null,null,"Sheet(s)"]
["1. General information",null,null,null,null,null,"Overview & Waste Gen."]
["2. Description of the parties involved in the data collection",null,null,null,null,null,"Overview & Waste Gen."]
["3. Description of methods used",null,null,null,null,null,"Overview & Waste Gen.","Waste Management ","Data Accuracy","Reusable & Traceability"]
["4. Traceability of waste and ensuring conditions are broadly equivalent of the requirements of EU law ",null,null,null,null,null,"Reusable & Traceability"]
["5. Confidentiality",null,null,null,null,null,"Confidentiality & References"]
["6. Main national websites, reference documents and publications",null,null,null,null,null,"Confidentiality & References"]
[]
[]
["The structure of the quality report follows the structure set out in Commission Decision 2005/270 in most cases. Where there are some differences the intention of the Act is maintained. However, changes have been introduced to ensure the responses are more accurate and easier to fill in by the Member States. Please aim to complete the QR as it is structured, if it is not possible to provide the relevant information explain the reasons why. Do not leave responses blank."]

{"sheet":"Overview & Waste Gen.","index":23,"n_rows":117,"n_cols":12,"rows_kept":117,"cut":false,"hidden":false,"merged":[[46,0,46,2],[47,0,47,2],[52,0,52,11],[81,4,81,6],[82,4,82,6],[78,7,78,11],[79,7,79,11],[80,7,80,11],[81,7,81,11],[82,7,82,11],[75,0,75,3],[78,0,78,3],[82,0,82,3],[64,4,64,11],[65,4,65,11],[66,4,66,11],[64,0,64,3],[65,0,65,3],[70,0,70,3],[67,4,67,11],[69,0,69,11],[83,0,83,11],[99,0,99,11],[117,0,117,11],[108,0,108,11],[74,4,74,11],[62,0,62,11],[55,0,55,11],[48,0,48,2],[49,0,49,2],[50,0,50,2],[51,0,51,11],[79,0,79,3],[80,0,80,3],[78,4,78,6],[79,4,79,6],[80,4,80,6],[75,4,75,11],[71,0,71,3],[74,0,74,3],[67,0,67,3],[116,7,116,8],[116,1,116,2],[106,0,106,11],[109,5,109,6],[110,9,110,10],[111,9,111,10],[95,0,95,2],[115,5,115,6],[114,9,114,10],[115,9,115,10],[116,9,116,10],[113,1,113,2],[113,3,113,4],[114,3,114,4],[115,3,115,4],[96,0,96,2],[109,1,109,2],[109,3,109,4],[110,3,110,4],[113,7,113,8],[112,9,112,10],[113,9,113,10],[98,0,98,2],[116,5,116,6],[116,3,116,4],[113,5,113,6],[114,7,114,8],[115,7,115,8],[111,3,111,4],[103,0,103,11],[105,0,105,11],[85,0,85,11],[88,0,88,11],[111,1,111,2],[112,1,112,2],[100,0,100,11],[89,7,90,7],[89,8,90,8],[89,9,90,9],[89,10,90,10],[109,7,109,8],[110,7,110,8],[111,7,111,8],[112,7,112,8],[92,0,92,2],[93,0,93,2],[94,0,94,2],[90,0,90,2],[89,4,90,4],[89,0,89,2],[114,5,114,6],[66,0,66,3],[112,3,112,4],[110,1,110,2],[102,0,102,11],[81,0,81,3],[77,0,77,11],[97,0,97,2],[61,9,61,10],[68,0,68,11],[76,0,76,11],[84,0,84,11],[86,0,86,11],[87,0,87,11],[89,3,90,3],[101,0,101,11],[107,0,107,11],[91,0,91,2],[109,9,109,10],[111,5,111,6],[104,0,104,11],[112,5,112,6],[89,5,90,5],[89,6,90,6],[110,5,110,6],[53,0,53,11],[5,0,5,4],[5,5,5,11],[18,0,18,11],[6,0,6,4],[6,5,6,11],[19,0,19,11],[20,0,20,10],[21,0,21,11],[17,0,17,4],[17,5,17,11],[10,5,10,11],[11,0,11,4],[11,5,11,11],[22,0,22,11],[23,0,23,11],[24,0,24,11],[42,0,42,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[25,0,25,9],[0,3,0,7],[3,0,3,10],[4,0,4,4],[4,5,4,11],[12,0,12,11],[13,0,13,10],[15,0,15,4],[15,5,15,11],[16,0,16,4],[16,5,16,11],[14,0,14,11],[7,0,7,4],[7,5,7,11],[8,0,8,4],[8,5,8,11],[9,0,9,4],[9,5,9,11],[10,0,10,4],[26,0,26,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[44,11,45,11],[31,0,31,11],[32,0,32,11],[43,0,43,11],[44,0,45,2],[44,3,44,10],[30,0,30,11],[33,0,34,2],[33,3,33,10],[33,11,34,11],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,11],[41,0,41,11],[56,7,57,8],[56,9,57,10],[54,0,54,11],[56,3,57,4],[56,5,56,6],[60,0,60,2],[61,0,61,2],[63,0,63,11],[58,3,58,4],[58,7,58,8],[58,9,58,10],[59,3,59,4],[60,3,60,4],[61,3,61,4],[61,7,61,8],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["1. General information"]
["1.1. Member State",null,null,null,null,"Luxembourg"]
["1.2. Organisation submitting the data and the description"," ",null,null,null,"Administration de l’environnement"]
["1.3. Contact name"," ",null,null,null,"Tim Mirgain"]
["1.4. Contact email address"," ",null,null,null,"tim.mirgain@aev.etat.lu"]
["1.5. Contact phone number"," ",null,null,null,"(+352) 40 56 56 - 322 "]
["1.6. Reference year"," ",null,null,null,2018]
["1.7. Delivery date / version"," ",null,null,null,"2020-06-30"]
["1.8. Link to data publication by the Member State (if any)"," ",null,null,null,"http://www.statistiques.public.lu/stat/ReportFolders/ReportFolder.aspx?IF_Language=fra&MainTheme=1&FldrName=3&RFPath=65"]
[]
["2. Description of the parties involved in the data collection"]
["The various institutions involved in the data collection processes should be listed in this table, one per line (add more if necessary), and a description of their key responsibilities given.\nThe parties should include the main public institution returning the quality check report to Eurostat, any other public institutions involved in the process, any extended producer responsibility schemes providing data, any private companies supporting in the data gathering and/or validation processes, and any other entity of relevance."]
["Name of institution",null,null,null,"Description of key responsibilities","Description of key responsibilities"]
["Administration de l’environnement",null,null,null,null,"Collecting, processing and analysing of data"]
[]
["Add rows as appropriate."]
[]
["3. Description of methods used"]
["3.1. Packaging waste generation"]
["3.1.1. Methods for determining packaging waste generation (mark with a cross)"]
["Which basic approach do you use to calculate waste generated? "]
["Please, indicate the approximate share of each approach in % of the total packaging waste generated."]
["Approach",null,null,null,null,null,null,null,null,null,"% of waste generated based on this approach"]
["Approach 1 \nPut on the Market (POM) based on EPR data, complemented with estimates to ensure full coverage of the EPR data",null,null,null,null,null,null,null,null,null,0]
["Approach 2\nPOM based on sources other than EPR (e.g. based on production and import statistics and factors to estimate the amount of packaging associated to these product flows)",null,null,null,null,null,null,null,null,null,0]
["Approach 3\nWaste analysis",null,null,null,null,null,null,null,null,null,1]
["Other approaches (please specify here):"]
[]
["Approach 1 - Put on the Market (POM) based on EPR"]
["Primary sources and their shares in the total."]
["Sources for calculation of PoM",null,null,"% of packaging total covered",null,null,null,null,null,null,null,"Threshold of this source(*)"]
[null,null,null,"Total","Plastic","Wood","Ferrous metals","Aluminium","Glass","Paper and Cardboard","Other"]
["EPR scheme data",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Administrative reporting different from EPR",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Surveys",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Electronic registry (please specify here):",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Other (please specify here):",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["(*) Is there a certain minimum amount of waste, turnover etc. which is necessary to be registered?"]
[]
["Approach 2 - Put on the market (POM) calculated from production and foreign trade statistics and using coefficients of packaging for the sold goods in question"]
["Primary sources and their shares in the total."]
["Sources for calculation of PoM",null,null,"% of packaging total covered",null,null,null,null,null,null,null,"Threshold of this source(*)"]
[null,null,null,"Total","Plastic","Wood","Ferrous metals","Aluminium","Glass","Paper and Cardboard","Other"]
["Production statistics",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Foreign trade statistics",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Specific surveys (please specify here):",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Electronic registry (please specify here):",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["Other (please specify here):",null,null,"NA","NA","NA","NA","NA","NA","NA","NA","NA"]
["(*) Is there a certain minimum amount of waste, turnover etc. which is necessary to be registered?"]
[]
["Approach 3 - Waste analysis"]
["Packaging waste generated estimated by waste analysis\nThe first column in the table below just describes the structure of the question, please add respective categories, if different in your country (for example: Household-kerbside waste may be split into 3 waste streams: residual waste, mixed dry recyclables and organic waste)."]
[]
["Type of waste",null,null,"Number of samples taken",null,"Total volume or weight of samples taken",null,"What proportion does the sample represent of the total waste generated \n(in %)\n",null,"Frequency of sample"]
[null,null,null,null,null,"Volume in cubic metres","Weight in tonnes"]
["Mixed household and similar waste",null,null,32,null,null,23.93,2.1000000000000001E-4,null,"5years"]
["Separately collected municipal waste",null,null,"NO",null,"NO","NO","NO","NO","NO","NO"]
["Separately collected business waste",null,null,"NO",null,"NO","NO","NO","NO","NO","NO"]
["Others (please specify, add rows as needed):",null,null,24,null,584,null,4.4999999999999998E-2,null,"5 years"]
[]
["The waste samples for waste analysis are taken…"]
["Approach",null,null,null,"Please cross / provide details about the flows of waste covered"]
["Directly from the bin"]
["From the waste trucks",null,null,null,"x"]
["Other approaches (please specify here):"]
[]
["Impurities and humidity. Please fill in accordingly…"]
["Factors",null,null,null,"Total","Plastic","Wood","Ferrous metals","Aluminium","Glass","Paper and Cardboard","Other"]
["Correction factors for impurities and humidity in % of waste",null,null,null,null,0.35,0.11,0.05,"NE",0.01,0.3,"NE"]
[]
[]
["How did you derive the correction factors?",null,null,null,"Broad estimates"]
["If you do not apply any correction of impurities and humidity, how do you account for them?",null,null,null,"NA"]
[]
["For the estimation we also use waste flow data from…"]
["Source",null,null,null,"Please indicate sources…",null,null,"Please indicate materials covered"]
["Waste collectors",null,null,null,"x",null,null,"all"]
["Waste treatment operators",null,null,null,"x",null,null,"all"]
["Municipalities"]
["Others (please specify here):"]
[]
["3.1.2. Explanation of the application of estimates in case data on packaging placed on the market is used (for instance, where data collection does not cover the whole market or in order to take account of free riders, private shipments in or out of the country or on-line sales) "]
["Where data on packaging placed on the market is used and any estimates are made to fill gaps, each should be explained in detail, including sources of information, assumptions made, when the estimates were made etc."]
["NA"]
["3.1.3. Indication whether an estimate has been calculated and added (Yes/No) and if ‘Yes’ the added volume in % of the total "]
["All cells in the table should be filled in either with a ‘No’, or a ‘Yes’ alongside the % of the total figure included. For example: No, or Yes 5%."]
["Packaging waste material",null,null,"Total","Plastic","Wood","Ferrous metals","Aluminium","Glass","Paper and Cardboard","Other"]
["Validation"]
["Corrections for underreporting of units covered by the above sources",null,null,"No","No","No","No","No","No","No","No"]
["Estimates for units below the threshold (de minimis)",null,null,"No","No","No","No","No","No","No","No"]
["Estimates for other units legally exempt from reporting",null,null,"No","No","No","No","No","No","No","No"]
["Estimates for freeriders",null,null,"No","No","No","No","No","No","No","No"]
["Private imports /exports by private parcels",null,null,"No","No","No","No","No","No","No","No"]
["Private imports /exports (from journeys)",null,null,"No","No","No","No","No","No","No","No"]
["Internet imports and exports i.e. on-line sales",null,null,"No","No","No","No","No","No","No","No"]
["Other corrections (please specify here):",null,null,"No","No","No","No","No","No","No","No"]
[]
["3.1.4. Description of the methodology and verification of data on packaging waste generated in case waste analysis is used. This should include an explanation of how: (a) non-packaging waste collected together with packaging waste as well as (b) packaging materials in other waste (mixed waste streams) are accounted for. "]
["Where waste generation data is used, it is important to understand how the packaging element has been identified as packaging, if regularly collected with non-packaging materials. In addition, estimates of the amounts of packaging waste in mixed waste would be required, so a detailed explanation of the approach to determining those amounts should be provided."]
["\n(a)\tThe distinction of non-packaging waste collected together with packaging waste was mainly done on the EWC used by waste handlers and waste collectors. For certain fractions like mixed packaging waste (15 01 06) or paper and cardboard waste (20 01 01) waste analysis were carried out. For all remaining fractions estimates were being used \n\n(b)\tThe packaging materials in mixed waste streams from households is based on the results of the waste analysis. The packaging waste contained in non-household waste is based on an estimate provided by waste handlers of their outgoing residual or combustion waste."]
["3.1.5. Description of the methodology to report on composite packaging, including where materials contained in composite packaging and representing less than 5 % of the mass of the packaging unit are not reported separately."]
["Explain how composite packaging is included in the data. For example: (a) which key types of packaging where any component is >5% are dealt with and which material categories this applies to, as well as (b) which key material is used to report on any key types of packaging where composite elements are <5%."]
["Drink cartons are reported under paperboard as it is assumed that 95% of its weight is made of cardboard. In previous years LU reported composite packaging , contained within residual waste, under “other packaging”. Unfortunately, the waste analysis only makes the distinction between drink cartons and composite packaging (for which the composition is unknown). For the reporting of 2018, LU has taken the assumption that composite packaging (in residual waste) contains 50% paperboard and 50% of plastic. With the implementation of the new calculation rules LU will thrive to improve data on this point. \nFor the EWC fraction 150110 the distinction between plastic and metal packaging was done according to the treatment code (R03 for plastic and R04 for metal)."]
["3.1.6. Verification of data on packaging waste generated "]
["The columns in the table relate to information on verification procedures used within the national statistical reporting system to validate the accuracy of the data. In all of the following columns, for all materials, include a ‘yes’ or ‘no’ in the table cell to indicate whether they are used or not: \n• Cross-check (yes/no)\n• Time-series check (yes/no)\n• Audit (yes/no)\nIf ‘yes’ is identified for any of these aspects, for any of the materials, in the final column ‘Verification process’, please describe the details of the process. "]
[]
[null,"Packaging waste material",null,"Cross-check (yes/no)",null,"Time-series check (yes/no)",null,"Audit (yes/no)",null,"Verification process"]
[null,"Plastic",null,"YES",null,"YES",null,"NO",null,"comparison with EPR"]
[null,"Wood",null,"NO",null,"YES",null,"NO"]
[null,"Ferrous metals",null,"NO",null,"YES",null,"NO"]
[null,"Aluminium",null,"NO",null,"YES",null,"NO"]
[null,"Glass",null,"NO",null,"YES",null,"NO"]
[null,"Paper and cardboard",null,"NO",null,"YES",null,"NO"]
[null,"Others"]

{"sheet":"Waste Management","index":24,"n_rows":98,"n_cols":11,"rows_kept":98,"cut":false,"hidden":false,"merged":[[3,0,3,11],[0,3,0,7],[10,10,11,10],[11,0,11,2],[12,0,12,2],[4,0,4,11],[5,0,5,11],[6,0,6,11],[7,0,7,11],[8,0,8,11],[10,0,10,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[10,7,11,7],[10,8,11,8],[10,9,11,9],[28,1,28,4],[28,5,28,10],[29,1,29,4],[29,5,29,10],[30,1,30,4],[30,5,30,10],[19,0,19,2],[20,0,20,11],[21,0,21,11],[22,0,22,11],[24,0,24,11],[25,0,25,11],[26,0,26,11],[34,1,34,4],[34,5,34,10],[35,1,35,4],[35,5,35,10],[37,0,37,11],[38,0,38,11],[31,1,31,4],[31,5,31,10],[32,1,32,4],[32,5,32,10],[33,1,33,4],[33,5,33,10],[45,0,45,11],[46,0,46,11],[48,1,48,4],[48,6,48,10],[49,1,49,4],[49,6,49,10],[39,0,39,11],[40,0,40,11],[41,0,41,11],[42,0,42,11],[43,0,43,11],[44,0,44,11],[56,1,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,10],[66,0,66,11],[67,0,67,11],[51,0,51,11],[52,0,52,11],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,10],[57,1,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,10],[58,1,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,10],[59,1,59,2],[59,3,59,4],[59,5,59,6],[59,7,59,10],[72,0,72,11],[73,0,73,11],[74,0,74,11],[75,0,75,11],[76,0,76,11],[77,0,77,11],[69,1,69,2],[69,3,69,4],[69,5,69,6],[69,7,69,10],[70,1,70,2],[70,3,70,4],[70,5,70,6],[70,7,70,10],[84,9,84,10],[85,1,85,2],[85,3,85,4],[85,5,85,6],[85,7,85,8],[85,9,85,10],[78,0,78,11],[79,0,79,11],[80,0,80,11],[81,0,81,11],[83,1,83,2],[83,3,83,4],[83,5,83,6],[83,7,83,8],[83,9,83,10],[97,0,97,4],[97,5,97,11],[91,0,91,11],[92,0,92,11],[94,0,94,4],[94,5,94,11],[95,0,95,4],[95,5,95,11],[88,1,88,2],[88,3,88,4],[88,5,88,6],[88,7,88,8],[88,9,88,10],[89,1,89,2],[89,3,89,4],[89,5,89,6],[89,7,89,8],[89,9,89,10],[60,1,60,2],[60,3,60,4],[60,5,60,6],[60,7,60,10],[61,1,61,2],[61,3,61,4],[61,5,61,6],[61,7,61,10],[96,0,96,4],[96,5,96,11],[86,1,86,2],[86,3,86,4],[86,5,86,6],[86,7,86,8],[86,9,86,10],[87,1,87,2],[87,3,87,4],[87,5,87,6],[87,7,87,8],[87,9,87,10],[84,1,84,2],[84,3,84,4],[84,5,84,6],[84,7,84,8],[62,1,62,2],[62,3,62,4],[62,5,62,6],[62,7,62,10],[63,1,63,2],[63,3,63,4],[63,5,63,6],[63,7,63,10],[64,1,64,2],[64,3,64,4],[64,5,64,6],[64,7,64,10]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["3.2. Packaging waste management"]
["3.2.1. Classifications of treatment operations \n\nInformation on the classification used for treatment operations (if a standard classification is used such as the disposal operation or recovery operation codes established in Annexes I and II of Directive 2008/98/EC, refer to its name or specify and describe all the relevant categories used). "]
["State clearly whether the R/D codes in Annexes I and II of Directive 2008/98/EC are solely used, or whether additional national based classifications are used to complement or are used instead of R/D codes. Where there is any variation from the codes set out in the annexes, the full list of national codes must be described. The correlation of any national codes and the codes in the annexes must be made explicit in the response."]
["Solely the R/D codes in Annexes I and II of Directive 2008/98/EC are used"]
["3.2.2. Description of methods for determining packaging waste treatment (mark with a cross) "]
["Place a cross in the relevant box to identify which method you use for each material.\nIf you use the same method for all materials put the cross in the ‘Total’ row.\nIf you use another method please describe this in the ‘Other’ column."]
[]
["Packaging waste material",null,null,"Total","Plastic","Wood","Ferrous metals","Aluminium","Glass","Paper and Cardboard","Other"]
["Data collection methods"]
["Administrative reporting",null,null,"x"]
["Surveys"]
["Electronic registry"]
["Waste analysis",null,null,"x"]
["Data from waste operators",null,null,"x"]
["Data from municipalities"]
["Data from extended producer responsibility schemes"]
["Other (specify)"]
["Additional information about the methodology, including the combination of methods used."]
["Provide a description of the different methodologies used, particularly where these vary for the different components of packaging waste. If relevant include documents or links to documents where the methodologies are described in more detail. Ensure any links to documents are accessible for Eurostat’s validation team. Documents should be in English.\nWhere a combination of methods is used, provide an explanation of what the different methods are used for and the different types of treatment they cover. \nWhere surveys and electronic registries or administrative data are indicated for the same component of packaging waste, explain how the data from each method is used in combination to calculate the total amount of waste treated."]
["Waste flows are entirely based on the data submitted in annual reports of of waste handlers in Luxembourg. Packaging waste within those waste flows are based on EWC codes and waste analysis."]
[]
["3.2.3. Measurement points for recycling applied by the Member State"]
["For each component of packaging waste a description of the measurement points that have been used should be provided. If necessary, these descriptions could be attached in a separate document if further detail is required for the explanation. These documents should be in English.\nDiagrams that help explain the location of the measurement points within the recycling value chain should be provided.\nWhere calculation points other than those indicated in Annex II are used, these must be clearly described, along with the associated measurement points.\nWhere there are multiple measurements points for different types of recycling for a given component of packaging waste, these should be clearly described for each type.\nFor ‘Metals from IBA’ the measurement points can be described briefly, or, if also included in section 3.2.11 below, then just refer to that section for the description of the measurement points."]
["For the purposes of voluntary reporting using the new rules in June 2020, if data at the new calculation points cannot be obtained, or estimated, please state exactly at which points in the recycling chain the data relate to for each material (and ideally for plastics by polymer). In addition, please outline the nature of the waste collection systems used to capture the material for recycling. This information will be assessed and a review with the Member State regarding a suitable average loss rate(s) will be undertaken, in order to correct the data such that it reflects the amounts that should be reported at the calculation point (to ensure the recycled amounts are not overestimated)."]
[]
[null,"Packaging waste material",null,null,null,"Description of measurement points used (at calculation point or at the output of sorting operation with subtraction of non-target materials as appropriate, end-of-waste criteria, etc.), including variation at regional and local level "]
[null,"Plastic",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Wood",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Ferrous metals",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Aluminium",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Glass",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Paper and cardboard",null,null,null,"output sorting facility with substraction of impurities and humidity (see 3.2.6)"]
[null,"Others"]
[]
["Detailed description of the methodology to calculate the amount of non-target materials removed between the measurement and the calculation points, where applicable "]
["Provide example calculations to indicate how the amounts of non-target materials are deducted from the amounts reported at the measurement points. This is necessary to explain how the correct amounts at the calculation points have been calculated. Refer to the example diagrams reported under the above response, if necessary.\nA description of how it is ensured that non-target material sent to recycling operations of other material recycling processes is a) not missed out of the reporting, or b) is not double counted, should also be provided."]
["Measurement are made at the output of the sorting facility and hence non-target material are not missed out or double counted. Contamination (impurities) and humidity rate of waste at the output of the sorting plant is estimated. It is assumed that those impurities, removed at the recycling plant, are not recycled."]
["This should include a detailed description of how compostable packaging recovered at biowaste treatment plants has been identified and recorded in the data e.g. compostable plastic packaging and/or paper/card."]
["Compostable packaging treated in biowaste treatment plants have not been considered."]
["3.2.4. Description of the methodology to determine per material the amount of recycled materials contained in composite packaging or of packaging composed of multiple materials, and information on any exemptions applied for materials constituting less than 5 % of the total mass of the packaging unit."]
["Describe how the composition of wastes composed of multiple materials at any calculation point are determined, in order that the amounts are recorded under the respective components of packaging waste, as set out in the Table 1 of Annex I.\nWhere exemptions have been applied for composite materials constituting less than 5% of the total mass of the packaging unit all such exemptions shall be listed here."]
["It it assumed that for all recycled materials, composed of multiple materials, the proportion of the different material is less than 5%. This applies to cardbard packaging collected, drink bottles, cans and drink cartons. It is important to understand that composite packaging (e.g for food) are not seperately collected in LU."]
["3.2.5. Use of Average Loss Rates (ALRs) \n\nDescription of the sorted packaging waste to which ALRs are applied, types of sorting plants to which different ALRs apply, the methodological approach to calculating ALRs at such point(s), including the statistical accuracy of any surveys used, or the nature of any technical specifications. "]
["Describe the approaches used to calculate ALRs.\nIf necessary, these descriptions could be attached in a separate document if further detail is required for the explanation. These documents should be in English.\nWhere surveys are used, provide details regarding the total population (e.g. total number of sorting plants), the sample size and the confidence interval of the reported data (e.g. 95% +/- 10%).\nThe description of each ALR used for each material and each sorting plant type, should be given in the table. Each ALR should be set out on a separate row in the table."]
[]
[null,"Sorted waste material and sorting plant type",null,null,null,"ALR applied (in %)","Description"]
[null,null,null,null,null,null,"ALR are not yet applied"]
["Add rows as appropriate"]
["3.2.6. Attribution of waste to packaging and non-packaging types and correction for humidity \n\nDescription, where applicable, of the methodology to exclude non-packaging waste from the reported amount of recycled packaging waste and of the methodology to correct the amount of packaging waste at the measurement point in order to reflect the natural humidity rate of packaging (including by using relevant European standards). Aggregated data across facilities of a similar type is acceptable. "]
["For each waste and facility type, include the estimate share of packaging in the input, and describe the methodologies used. For example, surveying of plant operators or use of actual reported data to an electronic registry.\nAdd rows for all main facility types.\nAny assumptions made regarding the deduction of moisture to ensure the amount of packaging waste recycled corresponds to the weight of such waste at its natural humidity rate shall be described in detail for each material."]
[]
[null,"Packaging waste material",null,"Facility type",null,"Share of packaging waste (%)",null,"Description of the methodologies applied to obtain the percentage "]
[]
[null,"plastic",null,"recycling",null,0.01,null,"estimation"]
[null,"plastic",null,"combustion waste",null,0.05,null,"estimation"]
[null,"wood",null,"recycling",null,5.0999999999999997E-2,null,"estimation"]
[null,"wood",null,"combustion waste",null,0.105,null,"estimation"]
[null,"ferrous material",null,"recycling",null,0.03,null,"estimation"]
[null,"glass",null,"recycling",null,5.0000000000000001E-3,null,"estimation"]
[null,"paperboard",null,"recycling",null,1.4999999999999999E-2,null,"estimation"]
[null,"paperboard",null,"combustion waste",null,0.06,null,"estimation"]
[]
["Add rows as appropriate"]
["3.2.7. Attribution of waste to different Member States \n\nDescription of the methodology to exclude waste originating from other countries, where applicable. Aggregated data across facilities of a similar type is acceptable. "]
["For each waste and facility type, include the estimated share of waste in the input from the Member State that is reporting only, and describe the methodologies used. For example, surveying of plant operators or use of actual reported data through an electronic registry"]
[]
[null,"Packaging waste material",null,"Facility type",null,"Share of waste from the Member State (%)",null,"Description of the methodologies applied to obtain the percentage "]
[null,null,null,null,null,null,null,"The waste flows are mainly measured at the output of the sorting plants. There is only a very small amount of imported waste imported by waste sorting or treatment plants. Those waste flows are identified in annual waste reported and discarded. "]
["Add rows as appropriate"]
["3.2.8. Other recovery of waste\n\nDescription of treatment of waste reported under the category of other recovery and the share of waste (%) subject to such treatment"]
["Describe the wastes and treatment types related to ‘other recovery’. "]
["The category 'other recovery' is not used."]
["Include the % of Energy Recovery that is from R1 incinerators, out of all Energy Recovery reported (e.g. that may include cement kilns etc)."]
[0.42]
["3.2.9. Information on the relevance of temporary storage of packaging waste to the amounts of treated waste in a given year and any estimates of waste recycled in the current reference year following temporary storage in a previous reference year, and waste going to temporary storage in the current reference year "]
["Describe the quantities of waste by each key component of packaging waste that has been stored in previous years and is going to temporary storage in the current reference year. \nProvide details of the actual or estimated tonnages, and how this information was obtained from waste management operators e.g. through surveys or through electronic registries. \nIf surveys are used provide further information including their periodicity, sample size, subsamples, and confidence intervals (e.g. 95% +/- 10%)."]
["Temporary storage is not considered"]
["3.2.10. Verification of data on packaging waste recycling "]
["The columns in the table relate to information on verification procedures used within the national statistical reporting system to validate the accuracy of the data. In all of the following columns, for all materials, include a ‘yes’ or ‘no’ in the table cell to indicate whether they are used or not: \nCross-check (yes/no)\nTime-series check (yes/no)\nAudit (yes/no)\nIf ‘yes’ is identified for any of these aspects, for any of the materials, in the final column ‘verification process’ please describe the details of the process. "]
[]
[null,"Packaging waste material",null,"Cross-check (yes/no)",null,"Time-series check (yes/no)",null,"Audit (yes/no)",null,"Verification process"]
[null,"Plastic",null,"yes",null,"yes",null,"no",null,"comparison with EPR data"]
[null,"Wood",null,"no",null,"yes",null,"no"]
[null,"Ferrous metals",null,"no",null,"yes",null,"no"]
[null,"Aluminium",null,"no",null,"yes",null,"no"]
[null,"Mixed waste",null,"no",null,"yes",null,"no"]
[null,"Others",null,"na",null,"na",null,"na"]
[]
["3.2.11. Calculation of recycling of metals from incinerator bottom ash \n\nDetailed description of the method to collect data in order to calculate the amount of metals separated from incineration bottom ash in accordance with the Commission Implementing Act adopted in accordance with Article 37(7) of Directive 2008/98/EC "]
["Provide a detailed description of the method undertaken to collect the data that is used to calculate the amount of metals separated from incineration bottom ash. For example, requiring all incinerator operators and IBA processors to report such data in weight to a national electronic registry. This should include a description of the approach taken to measure the total amount of metal concentrate extracted from the incinerator bottom ash.\nDescribe the method used to estimate the average level of metallic content in the total amount of metal concentrate, including the reliability of any surveys undertaken. For example, an annual survey of the metallic content of metal concentrate output from IBA processors.\nDescribe the method to estimate the proportion of municipal waste entering incineration plants, including the reliability of any surveys undertaken. For example, surveying of plant operators or use of actual reported data to an electronic registry."]
[]
["Data",null,null,null,null,"Description of the measurement method to obtain the data "]
["Total amount of metal concentrate extracted from incinerator bottom ash ",null,null,null,null,"It is assumed that all metal packaging (identified via the waste analysis) entering the waste incineration plant is recylced to 100%. LU thrives to improve the calculation of this calculation method. The metal quantity contained within metal waste going into an incineration plant is almost equal to the amount being seperately collected."]
["waste",null,null,null,null,"NA"]
["Proportion of waste entering incineration plants that is packaging waste, including the reliability of any surveys undertaken ",null,null,null,null,"NA"]

{"sheet":"Data Accuracy","index":25,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,0,3,10],[0,3,0,7],[16,0,16,11],[4,0,4,11],[5,0,5,11],[6,0,6,11],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[12,8,12,9],[13,8,13,9],[14,0,14,11],[15,0,15,11],[23,1,23,4],[23,6,23,10],[17,0,17,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[22,1,22,4],[22,6,22,10]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["3.3. Accuracy of the data for packaging waste generation and treatment "]
["3.3.1. Description of main issues affecting the accuracy of data on the generation and treatment of packaging waste, including errors related to sampling, coverage, measurement, processing and non-response "]
["Challenges:\n•\tanalysist of over 800 reports \n•\tdifferent EWC codes at input and output of sorting facility\n•\twaste streams between waste handlers\n•\twrongly attributed EWC codes and treatment codes\n•\tFinal treatment often unknown when waste is exported to another waste sorting facility abroad"]
["3.3.2. Explanation of the scope and validity of surveys to collect data on the generation and treatment of packaging waste "]
["Provide links to documents or other sources where this information would be available, if relevant."]
["https://data.public.lu/en/datasets/dechets-municipaux/"]
["3.3.3. Statistical surveys used regarding packaging waste generation and treatment "]
["The information in this section is to provide an overarching understanding of the accuracy of any statistical surveys used relating to packaging waste. Some of the information may be available in previous questions.\nIf the survey(s) relates to individual components of packaging waste separate rows for each component / survey must be included. \nWhere the survey relates to the whole of packaging waste, the component could be categorised as ‘Total’ and only one line filled in the table."]
[]
[null,"Component of packaging waste","Year","Statistical units","Percentage of population surveyed","Data (tonnes)","Confidence level","Error margin","Details of adjustments from the survey year to the current year",null,"Other details"]
[]
["Add rows for each survey used."]
[]
["3.3.4. Differences from previous year's data"]
["If relevant, explain any significant methodological changes in the calculation method for the reported data on waste treatment in the current reference year compared to the previous year of reporting. Please include in particular retrospective revisions, their nature and whether a break-flag is required for a certain year."]
["A rang of methodological changes were introduced in 2018. Those changes were also applied backwards to the years 2015, 2016 and 2017 and submitted to Eurostat.\n"]
["3.3.5. Explanation detailing the causes of the tonnage difference (in relation to which waste streams, sectors or estimates have caused the difference, and what the underlying cause is) for any component of packaging waste generated and recycled which shows greater than a 10 % variation from the data submitted for the previous data year "]
["For each component of packaging waste where the % Variation is greater than 10% then the table must be filled in. \nOne row should be used for each component. The name of the component should be entered into the first column (e.g. metals, glass, plastic, paper and cardboard, etc), with the calculated % Variation in the second column, and a description of the main reason(s) for this variation should be entered in the third column. \nThis may require some in-depth analysis of the data reported from one year to the next in order to provide and response that sufficiently clarifies the reason for the variation."]
[]
[null,"Material",null,null,null,"Variation (%)","Main reason for variation"]
[null,"all",null,null,null,null,"Two main reasons have led to different results between 2017 and 2018:\n•\tThe results of a new residual waste analysis have been applied in 2018. A general trend in reduction of packaging material\t has been observed compared to the waste analysis conducted in 2013. This has led to a decrease in most material fractions between 2017 and 2018.\n•\tAnother decrease in recycled material was observed for metal and plastic packaging as the main sorting plant, for collected household packaging, was upgraded. During the time of the upgrade the sorting process was partly interrupted."]
[null,"other",null,null,null,null,"see footnotes"]
["Add rows as appropriate"]

{"sheet":"Reusable & Traceability","index":26,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,0,9,11],[3,0,3,10],[0,3,0,7],[4,0,4,11],[5,0,5,11],[6,0,6,11],[7,0,7,11],[8,0,8,11],[23,0,23,11],[10,0,10,11],[12,8,12,9],[13,8,13,9],[14,0,14,11],[15,0,15,11],[16,0,16,11],[17,0,17,11],[18,0,18,11],[21,0,21,11],[22,0,22,11],[19,0,19,11],[20,0,20,11],[26,0,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,11],[25,0,25,2],[25,3,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,11],[28,0,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,11],[27,0,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,11],[30,0,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,11],[29,0,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,11],[34,0,34,11],[35,0,35,11],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,11],[32,0,32,2],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,11]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["3.5. Accuracy of the data for reusable packaging"]
["3.5.1. Description of main issues affecting the accuracy of data on reusable packaging, including errors related to sampling, coverage, measurement, processing and non-response "]
["NA"]
["3.5.2. Explanation of the scope and validity of surveys to collect data on reusable packaging"]
["Provide links to documents or other sources where this information would be available, if relevant."]
[]
["3.5.3. Statistical surveys used regarding reusable packaging"]
["The information in this section is to provide an overarching understanding of the accuracy of any statistical surveys used relating to packaging waste. Some of the information may be available in previous questions.\nIf the survey(s) relates to individual components of packaging waste separate rows for each component / survey must be included. \nWhere the survey relates to the whole of packaging waste, the component could be categorised as ‘Total’ and only one line filled in the table."]
[]
[null,"Packaging material","Year","Statistical units","Percentage of population surveyed","Data (tonnes)","Confidence level","Error margin","Details of adjustments from the survey year to the current year",null,"Other details"]
[]
["Add rows for each survey used."]
[]
["3.5.4. Differences from previous year's data"]
["If relevant, explain any significant  methodological  changes  in  the  calculation  method  for  the  current reference  year,  if  any  (please  include  in  particular  retrospective  revisions,  their nature  and  whether  a  break-flag  is  required  for  a  certain  year)"]
[]
[]
["4. Traceability of waste and ensuring its treatment in conditions broadly equivalent to the requirements of EU environmental law "]
["4.1 1. Detailed description of the system for quality control and traceability for packaging waste pursuant to Article 6a(3) and (8) of Directive 94/62/EC "]
["Traceability is mainly covered by the requirements under the WasteShipmentRegulation. "]
["4.1.2. Waste treated outside the Member State"]
[]
["Packaging waste material",null,null,"Subject to final treatment in the Member State (yes/no) ",null,"Shipped to another EU Member State (yes/no) ",null,"Exported outside the EU (yes/no) ",null,"Description of specific measures for quality control and traceability of packaging waste, in particularly as regards monitoring and validation of data "]
["Plastic",null,null,"no",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Wood",null,null,"no",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Ferrous metals",null,null,"yes",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Aluminium",null,null,"no",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Glass",null,null,"no",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Paper and cardboard",null,null,"no",null,"yes",null,"no",null,"annual reports of waste handlers"]
["Others"]
[]
["4.1.3. Description of measures to ensure that, in accordance with Article 6a(8) of Directive 94/62/EC, the exporter can prove that the shipment of waste complies with the requirements of Regulation (EC) No 1013/2006 of the European Parliament and of the Council ( 1 ) and that the treatment of waste outside the Union took place in conditions that are broadly equivalent to the requirements of the relevant Union environmental law"]

{"sheet":"Confidentiality & References","index":27,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,11],[3,0,3,10],[4,0,4,11],[5,0,5,11],[0,3,0,7],[6,0,6,11],[7,0,7,10],[8,0,8,11],[10,0,10,11],[9,0,9,11]]}
[null,null,null,"Packaging and Packaging Waste\nQUALITY REPORT"]
[null,null," "]
[]
["5. Confidentiality"]
["Justification to withhold the publication of specific parts of this report (please indicate the exact elements not to be published, and why)"]
["If a part of this report cannot be published for confidentiality reasons, please provide your justification for doing so here and specify exactly which part should not be publisihed."]
[]
["6. Main national websites, reference documents and publications"]
["Please provide the name and url of the main websites, reference documents and publications related to this data collection"]
["https://data.public.lu/en/datasets/dechets-municipaux/"]
[]
["Add rows as appropriate."]

{"sheet":"Any further detailed data...","index":28,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,0,2,8],[3,0,3,8]]}
[]
["Any further detailed data may be added in this sheet. For example, if the waste generation figures are available at a higher level of granularity than the main material categories of Table 1."]