{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["COVER","INDEX","Basic Instructions","Methodology","GETTING STARTED","Footnotes list","Table 2 - Material breakdown","Table 3 - Recycling rate","QR Table 2 - Material-breakdown","QR Table 3 - Recycling rate","ErrorLog","IsNumeric","FootnoteContent","Mandatory","MustNotBeNegative","Changelog","Summations","Lists","Lists (specific)","MacroBehaviour"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"COVER","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[]
[null,null,{"$f":"Lists!K4","v":"Directorate E: Sectoral and regional statistics"}]
[null,null,{"$f":"Lists!K5","v":"Unit E-2: Environmental statistics and accounts; sustainable development"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 27 May 2026"}]

{"sheet":"INDEX","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,2,19,4],[1,2,1,4],[3,2,3,4],[4,2,4,4],[6,2,6,4],[8,2,8,4],[13,2,13,4]]}
[]
[]
[null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[]
[null,null," INDEX - STRUCTURE OF THE QUESTIONNAIRE"]
[]
[null,null,"I. Basic information"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Index","Structure of the questionnaire","for information"]
[null,null,"Basic instructions ","Basic instructions","for reading before filling in the questionnaire"]
[null,null,"Methodology","Methodology and legal acts","for reading before filling in the questionnaire"]
[null,null,"II. Reporting data (To be filled in by the country)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"GETTING STARTED","Country and data collection definition. Administrative data.","for filling in"]
[null,null,"Footnotes list","List of explanatory footnotes","for filling in"]
[null,null,"Table 2 - Material breakdown","Table 2 - Material breakdown according to Commission Implementing Decision 2019/1004/EC Annex V - Format for the reporting of data","For filling in. This table must be used in all cases from reference year 2020"]
[null,null,"Table 3 - Recycling rate","Table 3 - Recycling rate for measuring compliance with the policy target according to point (a) of Article 11(2) of Directive 2008/98/EC, according to the format set out in Annex IV of the Commission Implementing Decisions 2019/1004","For filling in only if your country wants to be measured against 2020 targets using the old methodology (methods 1 to 3) "]
[null,null,"III. Quality report (Orange tabbed sheets)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Quality report - Table 2 - Material breakdown","Quality report for table 2 as required by  Annex V of Commission Decision 2019/1004/EC","For filling in connection with Table 2 - Material breakdown"]
[null,null,"Quality report - Table 3 - Recycling rate for 2020 target if not using method 4","Quality report for table 3 as required by  Annex IV of Commission Decision 2019/1004/EC","For filling in in connection with Table 3 - Recycling rate for 2020 target if not using method 4"]

{"sheet":"Basic Instructions","index":2,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[3,2,3,6],[4,2,4,6],[6,2,6,6],[7,2,7,6],[76,2,76,5],[59,3,59,5],[65,2,65,5],[66,2,66,5],[67,2,67,5],[75,2,75,5],[53,2,53,5],[54,2,54,5],[55,2,55,5],[58,2,58,5],[23,2,23,5],[25,2,25,5],[84,2,84,5],[85,2,85,5],[86,2,86,5],[87,2,87,5],[88,2,88,5],[82,2,82,6],[13,2,13,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[19,2,19,5],[78,2,78,5],[79,2,79,5],[80,2,80,5],[29,2,29,5],[39,2,39,5],[44,2,44,5],[37,2,37,6],[61,3,61,5],[50,2,50,6],[73,2,73,6],[9,2,9,6],[8,2,8,6],[11,10,11,13],[11,14,11,15],[11,2,11,6],[10,2,10,6],[68,2,68,6],[71,2,71,6],[21,2,21,6],[14,2,14,5],[18,2,18,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"This questionnaire is designed to collect  Municipal waste reporting obligations. It contains 2 tables, each of them with their corresponding quality report; each of the quality reports needs to be filled in and transmitted together with their corresponding data transmissions."]
[null,null,"Table 2 - Material breakdown collects data according to Article 11(2) of Directive 2008/98/EC on waste and Annex V of Implementing Decision 2019/1004, which became mandatory from the reference year 2020.\nTable 3 - Recycling rate is only to be used if a Member State wants to prove compliance with the target under point (a) of Article 11(2) of Directive 2008/98/EC until the reference year 2025\n",null,null,null,null,null,null,null,null,null," "]
[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,"Before submitting the questionnaire to Eurostat, It is strongly recommended to use 'Validate questionnaire’ button included in each table to streamline the validation workflow; this will avoid unnecessary iterations between your organisation and Eurostat. You can consult the errors in the ‘ErrorLog’ worksheet. Please revise/correct the questionnaire until the check runs without highlighting errors or warnings. "]
[null,null,{"$f":"CONCATENATE(\"We kindly ask you to send us the data latest by \",Lists!K10)","v":"We kindly ask you to send us the data latest by 30 June 2026"}]
[]
[null,null,"Table of contents"]
[null,null,"1. Data transmission"]
[null,null,"2. Reporting conventions"]
[null,null,"3. Footnotes"]
[null,null,"4. Revisions"]
[null,null,"4. Methodology and questions"]
[null,null,"Annex: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"1. 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."]
[]
[null,null,"Please submit this questionnaire to Eurostat using the eDAMIS reporting system. Use the following details: "]
[null,null,"Domain name:",{"$f":"Lists!K12","v":"WASTE"}]
[null,null,"Dataset name:",{"$f":"Lists!K13","v":"WASTE_MWRODAT_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,"   web page:","https://webgate.ec.europa.eu/edamis4 "]
[null,null,"   e-mail address:","ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"]
[null,null,"   telephone:","(+352) 4301 33213"]
[null,null,"For methodological questions please contact:"]
[null,null,"   e-mail address:","ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
[]
[]
[null,null,"2.  Reporting conventions:"]
[]
[null,null,"Reporting of zeroes and not availble data must follow this convention:"]
[null,null,"Description","Symbol"]
[null,null,"Real zero",0]
[null,null,"Not available",null," (empty cell)"]
[]
[null,null,"1. White shaded (uncoloured) boxes: Provision of data is mandatory under law or under a gentlemen's agreement."]
[null,null,"2. Light blue shaded boxes: Provision of data is voluntary"]
[null,null,"3. Black shaded boxes: reporting is not applicable"]
[null,null,"4.  Grey shaded boxes: calculation is automatic."]
[]
[]
[null,null,"3. Footnotes:"]
[]
[]
[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: "]
[null,null,"- Letters for standard footnotes (as defined by Eurostat) and…"]
[null,null,"- Numbers for explanatory footnotes (to be defined by the data compilers). "]
[]
[null,null,"3.1 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 (as described in annex I of Commission Decision  2011/753/EU) to the new calculation rules (as described in Article 11(b) of Directive 2008/98/EC). Please use this flag only when the change in methods, sources or calculation rules has a substantial impact and makes data uncomparable."]
[null,null,"E estimated data"]
[null,null,"P provisional"]
[null,null,"To include standard footnotes use the drop-down menu. "]
[]
[null,null,"3.2 Explanatory footnotes"]
[null,null,"The explanatory footnotes can be used for any meaning beyond the pre-defined footnotes."]
[null,null,"To include a explanatory 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."]
[null,null,"Please do not report footnotes that elaborate on e.g. source data and compilation methods; these are to be described in the quality report sheet. "]
[null,null,"4. Revisions"]
[]
[null,null,"For sending data revisions of previous years, please use this questionnaire changing the reference year in sheet GETTING STARTED"]
[null,null,"If you send a table that contains data, it will overwrite the old table. Empty cells in a filled table in the latest received questionnaire will replace with “empty” the cells that contain a value ."]
[]
[null,null,"5. Methodology and questions:"]
[]
[null,null,"The guidelines to report on municipal 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 data are compiled and maintained on consistent basis. They explain the scope and 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 effort has been put into increasing coherence and providing guideline users with practical recommendations. Full implementation of these recommendations should help to ensure that data are compiled and maintained on a consistent basis. "]
[null,null,"If you have questions, please send them to the following email addresses:"]
[null,null,"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
[]
[null,null,"Annex: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"1)     All mandatory data cells must be filled in with a value. In the questionnaire all these cells are uncoloured."]
[null,null,"2)     Flags (footnote symbols) can be entered in the reporting tables in the footnote columns."]
[null,null,"3)     To include standard footnotes use the drop-down menu."]
[null,null,"4)     The text of explanatory footnotes can be entered in the worksheet 'Footnotes list'."]
[null,null,"5)     Complete the quality reports, providing as much information as possible."]

{"sheet":"Methodology","index":3,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[9,2,9,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[25,2,25,5],[26,2,26,5],[28,2,28,5],[29,2,29,5],[13,2,13,5],[14,2,14,5],[16,2,16,5],[21,2,21,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[]
[null,null,"METHODOLOGY AND LEGAL ACTS"]
[null,null,"Table of contents"]
[null,null,"1. Background"]
[null,null,"2. Legal acts"]
[]
[null,null,"1. Background"]
[]
[null,null,"The European Parliament and the Council adopted the (Waste Framework) Directive 2008/98/EC to reduce the impact of municipal waste on the environment. "]
[null,null,"This Excel reporting template allows Member States to report municipal waste pursuant to the requirements of Commission Implementing Decisions 2019/1004 , as well as, until 2024, Commission Implementing Decision 2011/753/EU."]
[]
[null,null,"Further guidance is provided in a document that can be found under the link below. The document not only includes guidance on how to fill in the data tables but as well on how to fill in the quality reports. The guidance will be improved and updated according to the experience gained with the data collections and according to new legislation still expected, e.g. a delegated act on average loss rates."]
[]
[]
[]
[null,null,"The guidelines are available here:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/methodology"]
[]
[null,null,"2.  Legal acts"]
[]
[]
[null,null,"Directive (EU) 2018/851 of the European Parliament and of the Council of 30 May 2018 amending the Waste Framework Directive 2008/98/EC. It includes reporting requirements for Municipal waste. These requirements are further detailed in the Commission Implementing Decision (EU) 2019/1004 of 7 June 2019 laying down rules for the calculation, verification and reporting of data on waste.\n"]
[]
[null,null,"The legislation is available here:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/legislation"]

{"sheet":"GETTING STARTED","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,24,6],[3,2,3,6],[4,2,4,6],[6,2,6,6],[13,3,13,6],[15,3,15,6],[17,3,17,6],[19,3,19,6],[21,3,21,6]]}
[]
[]
[null,null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):    ",null,"Finland",null,""]
[null,null,"Reference year:    ",null,2024]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 June 2026"}]
[null,null,"Who is the primary contact point for annual reporting obligations of municipal waste in your country?"]
[]
[null,null,"Name:","Heidi Pirtonen"]
[]
[null,null,"Institution:","Finnish Environment Institute"]
[]
[null,null,"Unit:","Circular Economy Solutions"]
[]
[null,null,"Telephone:","+358 505 727 968"]
[]
[null,null,"Email adress:","jateraportoinnit@syke.fi"]
[]
[]
[null,null,"Eurostat would be grateful if you could send us the completed questionnaire ahead of the deadline. "]

{"sheet":"Footnotes list","index":5,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,1,4],[3,3,3,4],[4,3,4,4],[6,3,6,4],[7,3,7,4]]}
[]
[]
[null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,null,{"$f":"UPPER(Lists!K7)","v":"MUNICIPAL WASTE REPORTING OBLIGATIONS"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2026 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,1,"INCLUDES: 160107*, 191210, 200202"]
[null,null,null,2,"\"W091_092_MUN\" included in \"MUN_OTH\" due to confidentiality reasons. "]
[null,null,null,3,"The validation does not take into account the black cells (for error logs 2 and 3). Needed to add more \"other waste\" in order to validate the questionnaire"]
[null,null,null,4,"The numbers are correct (for error logs 4 and 5)"]
[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,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]

{"sheet":"Table 2 - Material breakdown","index":6,"n_rows":37,"n_cols":31,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,5,36,18],[34,5,34,18],[30,5,30,30],[29,5,29,30],[4,9,4,10],[4,13,4,14],[4,17,4,18],[4,21,4,22],[4,25,4,26],[4,29,4,30],[2,4,2,5],[3,4,3,5],[1,4,1,30],[35,5,35,18],[4,1,4,2],[2,6,2,30],[3,6,3,30]]}
[]
[null,null,null,null,"Table 2 - material breakdown according to Implementing Decision 2019/1004/EC Annex V"]
[null,null,null,null,"Country:",null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",VLOOKUP('GETTING STARTED'!E9,Lists!A2:B40,2,FALSE))","v":"FI"}]
[null,null,null,null,"Reference year: ",null,{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2024}]
[null,"TO HIDE",null,null,"Codes","Municipal waste","List of Waste codes (LoW) (for generated amounts only)","Municipal waste generated (tonnes)(1) ","Standard footnotes","Explanatory\nfootnote",null,"Separate collection(8) (tonnes)","Standard footnotes","Explanatory\nfootnote",null,"Preparing for reuse (tonnes)","Standard footnotes","Explanatory\nfootnote",null,"Recycling (tonnes)","Standard footnotes","Explanatory\nfootnote",null,"Energy recovery (tonnes)(2) ","Standard footnotes","Explanatory\nfootnote",null,"Other recovery (tonnes)(3) ","Standard footnotes","Explanatory\nfootnote"]
[null,"Source","unit",null,null,null,null,"GEN",null,null,null,"COL_SEP",null,null,null,"PRP_REU",null,null,null,"RCY",null,null,null,"RCV_E",null,null,null,"RCV_OTH"]
[null,"ANNEX_V","T",null,"TOTAL","Total",null,2519645,null,null,{"$f":"IF(TRIM(J7)=\"\", \"\", IF(VLOOKUP(J7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N7)=\"\", \"\", IF(VLOOKUP(N7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},7476,null,null,{"$f":"IF(TRIM(R7)=\"\", \"\", IF(VLOOKUP(R7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},1208749,null,3,{"$f":"IF(TRIM(V7)=\"\", \"\", IF(VLOOKUP(V7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"The validation does not take into account the black cells (for error logs 2 and 3). Needed to add more \"other waste\" in order to validate the questionnaire"},1281916,null,3,{"$f":"IF(TRIM(Z7)=\"\", \"\", IF(VLOOKUP(Z7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"The validation does not take into account the black cells (for error logs 2 and 3). Needed to add more \"other waste\" in order to validate the questionnaire"},4420,null,null,{"$f":"IF(TRIM(AD7)=\"\", \"\", IF(VLOOKUP(AD7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W063_122_MUN","Metals","20 01 40, 15 01 04, 15 01 11*    ",48814,null,null,{"$f":"IF(TRIM(J8)=\"\", \"\", IF(VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N8)=\"\", \"\", IF(VLOOKUP(N8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R8)=\"\", \"\", IF(VLOOKUP(R8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},48803,null,null,{"$f":"IF(TRIM(V8)=\"\", \"\", IF(VLOOKUP(V8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Z8)=\"\", \"\", IF(VLOOKUP(Z8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AD8)=\"\", \"\", IF(VLOOKUP(AD8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W063_122_MUN_INC","Metals separated after incineration of waste(4) ","20 01 40, 15 01 04, 15 01 11*    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TRIM(V9)=\"\", \"\", IF(VLOOKUP(V9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W071_MUN","Glass","20 01 02, 15 01 07 ",101747,null,null,{"$f":"IF(TRIM(J10)=\"\", \"\", IF(VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N10)=\"\", \"\", IF(VLOOKUP(N10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R10)=\"\", \"\", IF(VLOOKUP(R10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},101135,null,null,{"$f":"IF(TRIM(V10)=\"\", \"\", IF(VLOOKUP(V10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,552]
[null,"ANNEX_V","T",null,"W074_MUN","Plastic","20 01 39, 15 01 02 ",63945,null,null,{"$f":"IF(TRIM(J11)=\"\", \"\", IF(VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N11)=\"\", \"\", IF(VLOOKUP(N11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R11)=\"\", \"\", IF(VLOOKUP(R11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},46996,null,null,{"$f":"IF(TRIM(V11)=\"\", \"\", IF(VLOOKUP(V11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},16696,null,null,{"$f":"IF(TRIM(Z11)=\"\", \"\", IF(VLOOKUP(Z11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD11)=\"\", \"\", IF(VLOOKUP(AD11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W072_MUN","Paper and cardboard","20 01 01, 15 01 01 ",415155,null,null,{"$f":"IF(TRIM(J12)=\"\", \"\", IF(VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N12)=\"\", \"\", IF(VLOOKUP(N12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R12)=\"\", \"\", IF(VLOOKUP(R12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},398348,null,null,{"$f":"IF(TRIM(V12)=\"\", \"\", IF(VLOOKUP(V12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},16805,null,null,{"$f":"IF(TRIM(Z12)=\"\", \"\", IF(VLOOKUP(Z12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD12)=\"\", \"\", IF(VLOOKUP(AD12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W091_092_MUN","Bio-waste","20 01 08, 20 01 25, 20 02 01    ",435128,null,null,{"$f":"IF(TRIM(J13)=\"\", \"\", IF(VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N13)=\"\", \"\", IF(VLOOKUP(N13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,391922,null,null,{"$f":"IF(TRIM(V13)=\"\", \"\", IF(VLOOKUP(V13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},39450,null,null,{"$f":"IF(TRIM(Z13)=\"\", \"\", IF(VLOOKUP(Z13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,2,{"$f":"IF(TRIM(AD13)=\"\", \"\", IF(VLOOKUP(AD13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"\"W091_092_MUN\" included in \"MUN_OTH\" due to confidentiality reasons. "}]
[null,"ANNEX_V","T",null,"W091_092_MUN_S","Bio-waste separated and recycled at source(5) ","20 01 08, 20 01 25, 20 02 01    ",58844,null,4,{"$f":"IF(TRIM(J14)=\"\", \"\", IF(VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"The numbers are correct (for error logs 4 and 5)"},null,null,null,{"$f":"IF(TRIM(N14)=\"\", \"\", IF(VLOOKUP(N14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,58844,null,null,{"$f":"IF(TRIM(V14)=\"\", \"\", IF(VLOOKUP(V14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(Z14)=\"\", \"\", IF(VLOOKUP(Z14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD14)=\"\", \"\", IF(VLOOKUP(AD14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W075_MUN","Wood","20 01 37*, 20 01 38, 15 01 03      ",105699,null,null,{"$f":"IF(TRIM(J15)=\"\", \"\", IF(VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N15)=\"\", \"\", IF(VLOOKUP(N15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R15)=\"\", \"\", IF(VLOOKUP(R15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},70467,null,null,{"$f":"IF(TRIM(V15)=\"\", \"\", IF(VLOOKUP(V15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},28528,null,null,{"$f":"IF(TRIM(Z15)=\"\", \"\", IF(VLOOKUP(Z15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD15)=\"\", \"\", IF(VLOOKUP(AD15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W076_MUN","Textiles ","20 01 10, 20 01 11, 15 01 09 ",456,null,null,{"$f":"IF(TRIM(J16)=\"\", \"\", IF(VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N16)=\"\", \"\", IF(VLOOKUP(N16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R16)=\"\", \"\", IF(VLOOKUP(R16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(V16)=\"\", \"\", IF(VLOOKUP(V16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},232,null,null,{"$f":"IF(TRIM(Z16)=\"\", \"\", IF(VLOOKUP(Z16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD16)=\"\", \"\", IF(VLOOKUP(AD16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W082_84_MUN","Electrical and electronic equipment ","20 01 21*, 20 01 23*, 20 01 35*, 20 01 36     ",67457,null,null,{"$f":"IF(TRIM(J17)=\"\", \"\", IF(VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N17)=\"\", \"\", IF(VLOOKUP(N17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R17)=\"\", \"\", IF(VLOOKUP(R17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},67146,null,null,{"$f":"IF(TRIM(V17)=\"\", \"\", IF(VLOOKUP(V17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},1,null,null,{"$f":"IF(TRIM(Z17)=\"\", \"\", IF(VLOOKUP(Z17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD17)=\"\", \"\", IF(VLOOKUP(AD17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W0841_MUN","Batteries ","20 01 33*, 20 01 34 ",1147,null,null,{"$f":"IF(TRIM(J18)=\"\", \"\", IF(VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N18)=\"\", \"\", IF(VLOOKUP(N18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R18)=\"\", \"\", IF(VLOOKUP(R18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},1137,null,null,{"$f":"IF(TRIM(V18)=\"\", \"\", IF(VLOOKUP(V18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(Z18)=\"\", \"\", IF(VLOOKUP(Z18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD18)=\"\", \"\", IF(VLOOKUP(AD18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W1011_MUN","Bulky waste(6) ","20 03 07     ",528,null,4,{"$f":"IF(TRIM(J19)=\"\", \"\", IF(VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"The numbers are correct (for error logs 4 and 5)"},null,null,null,{"$f":"IF(TRIM(N19)=\"\", \"\", IF(VLOOKUP(N19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R19)=\"\", \"\", IF(VLOOKUP(R19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(V19)=\"\", \"\", IF(VLOOKUP(V19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},528,null,null,{"$f":"IF(TRIM(Z19)=\"\", \"\", IF(VLOOKUP(Z19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD19)=\"\", \"\", IF(VLOOKUP(AD19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"W1011_1021_MUN","Mixed waste","20 03 01, 15 01 06     ",1007177,null,null,{"$f":"IF(TRIM(J20)=\"\", \"\", IF(VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(N20)=\"\", \"\", IF(VLOOKUP(N20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,null,null,null,null,997174,null,null,{"$f":"IF(TRIM(Z20)=\"\", \"\", IF(VLOOKUP(Z20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AD20)=\"\", \"\", IF(VLOOKUP(AD20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"ANNEX_V","T",null,"MUN_OTH","Other","See below(7) ",213548,null,1,{"$f":"IF(TRIM(J21)=\"\", \"\", IF(VLOOKUP(J21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"INCLUDES: 160107*, 191210, 200202"},null,null,null,{"$f":"IF(TRIM(N21)=\"\", \"\", IF(VLOOKUP(N21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(N21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(R21)=\"\", \"\", IF(VLOOKUP(R21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(R21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"20750+3201","v":23951},null,null,{"$f":"IF(TRIM(V21)=\"\", \"\", IF(VLOOKUP(V21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(V21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"182476+26","v":182502},null,null,{"$f":"IF(TRIM(Z21)=\"\", \"\", IF(VLOOKUP(Z21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Z21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},3868,null,2,{"$f":"IF(TRIM(AD21)=\"\", \"\", IF(VLOOKUP(AD21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(AD21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"\"W091_092_MUN\" included in \"MUN_OTH\" due to confidentiality reasons. "}]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"White: Data provision is required."]
[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,"Black: Reporting is not applicable."]
[]
[null,null,null,null,null,"(1) The amount of generated waste per material may be based on data on separately collected waste and on estimates derived from regularly updated waste composition surveys of municipal waste. Where no such surveys are available, the category of mixed waste may be used. The concept of municipal waste generated is the same as in Table 1 - JQ Format. The LoW codes relate to the generated quantities only, other codes e.g. chapter 19 10 / 19 12 would relate to waste treatment."]
[null,null,null,null,null,"(2) This includes incineration with energy recovery and the reprocessing of waste to be used as fuels or other means to generate energy. The weight of waste subject to energy recovery per material may be based on estimates derived from regularly updated waste composition surveys of municipal waste. Where no such surveys are available, the category of mixed waste may be used. "]
[null,null,null,null,null,"(3) This excludes preparing for reuse, recycling and energy recovery, and includes backfilling. "]
[null,null,null,null,null,"(4) Metals separated after incineration of municipal waste shall be reported separately and shall not be included in the row for metals and in the total amount of waste entering energy recovery operations."]
[null,null,null,null,null,"(5) Bio-waste separated and recycled at source shall be reported separately and shall not be included in the row for bio-waste."]
[null,null,null,null,null,"(6)   This includes large dimension waste items which require specific collection and treatment such as furniture and mattresses.\n      Note: as you move through the waste process (e.g. from waste generation to recycling) there will be no bulky waste (e.g. under recycling) as this will be broken down by then."]
[null,null,null,null,null,"(7)   20 01 13*,20 01 14*, 20 01 15*, 20 01 17*, 20 01 19*, 20 01 21*, 20 01 23*,  20 01 26*, 20 01 27*, 20 01 28, 20 01 29*, 20 01 30, 20 01 31*, 20 01 32, 20 01 41, 20 01 99, 20 02 03, 20 03 02, 20 03 03, 20 03 99, 15 01 05, 15 01 10*"]
[null,null,null,null,null,"(8)   Proportion of municipal waste generated that is collected separately - this does not equal the sum total of the subsequent columns."]

{"sheet":"Table 3 - Recycling rate","index":7,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,1,5,3],[10,4,10,15],[11,4,11,15],[12,4,12,15],[1,4,1,12],[2,5,2,12],[3,5,3,12],[4,6,4,12],[5,6,6,6],[5,7,6,8],[5,10,6,10],[5,11,6,12]]}
[]
[null,null,null,null,"Table 3 - Recycling rate for measuring compliance with the policy target according to point (a) of Article 11(2) of Directive 2008/98/EC, according to the format set out in Annex IV of the Commission Implementing Decisions 2019/1004 - to be filled in only by the Member States wanting to prove compliance with the old targets until 2025 using the old rules"]
[null,null,null,null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",VLOOKUP('GETTING STARTED'!E9,Lists!A2:B40,2,FALSE))","v":"FI"}]
[null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2024}]
[null,null,null,null,"Calculation method(1) ",2,{"$f":"IF(F5=\"\",\" <= Select the calculation method here\",VLOOKUP(F5,'Lists (specific)'!A2:B6,2,FALSE))","v":"Preparation for reuse and recycling of paper, metal, plastic, glass household waste and other single types of household waste or similar waste "}]
[null,"TO HIDE",null,null,null,"Municipal waste generated (2) ","Standard footnotes","Explanatory footnote",null,"Preparing for re-use and recycling(2)","Standard footnotes","Explanatory footnote"]
[null,"Source","waste","unit",null,"GEN",null,null,null,"RCY_PRP_REU"]
[null,"ANNEX_IV","TOTAL","T","Tonnes",2045365,null,null,{"$f":"IF(TRIM(H8)=\"\", \"\", IF(VLOOKUP(H8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(H8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},1141488,null,null,{"$f":"IF(TRIM(L8)=\"\", \"\", IF(VLOOKUP(L8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(L8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,"Notes:"]
[null,null,null,null,"(1) Calculation method chosen pursuant to Decision 2011/753/EU: the number of the chosen calculation method (1 to 4) as in the second column of Annex I of that Decision shall be inserted here. \nMember States may choose to prove compliance with the target in Article 11(2) a. until reference year 2024 using the new reporting rules and format required for the targets under Article 11(2) c. to d., as set out through Decision 2019/1004, including Annex V. In this case the completion of  table 3 is not required.\n\nIn summary, the waste generated and recycled in Method 1  is based on household paper/card, metals, glass and plastics only, in Method 2 on those wastes used for Method 1 + any other household wastes chosen, in Method 3 on all household waste, and in Method 4 on all municipal waste – Method 4 therefore uses the same data as in the previous tables, so it should be the same. If any other method is chosen the figures will be different."]
[null,null,null,null,"(2) Depending on the method chosen, the amounts to be reported here will differ from that in table 1 and table 2. Only if method 4 is chosen, the amounts should be the same as the corresponding amounts reported in Tables 1 and 2."]

{"sheet":"QR Table 2 - Material-breakdown","index":8,"n_rows":237,"n_cols":8,"rows_kept":237,"cut":false,"hidden":false,"merged":[[17,0,17,1],[17,2,17,3],[18,0,18,1],[18,2,18,3],[221,0,221,11],[223,0,223,11],[224,0,224,11],[202,0,202,11],[222,0,222,11],[204,1,204,4],[193,0,193,11],[196,0,196,11],[200,0,200,11],[201,0,201,11],[203,0,203,11],[204,8,218,11],[188,0,188,11],[189,0,189,11],[191,0,191,11],[192,0,192,11],[194,0,194,11],[195,0,195,11],[197,0,197,11],[198,0,198,1],[235,0,235,11],[237,0,237,11],[226,0,226,11],[227,0,227,11],[229,0,229,11],[219,0,219,11],[230,8,231,11],[232,0,232,11],[233,0,233,11],[225,0,225,11],[228,0,228,11],[220,0,220,10],[234,0,234,11],[236,0,236,11],[198,2,198,3],[198,4,198,5],[198,6,199,11],[199,0,199,1],[199,2,199,3],[199,4,199,5],[181,0,181,11],[182,0,182,11],[183,0,183,11],[184,0,184,11],[185,0,185,11],[178,0,178,11],[186,0,186,11],[187,0,187,11],[190,0,190,11],[171,0,171,11],[172,0,172,11],[173,0,173,11],[174,0,174,11],[175,0,175,11],[176,0,176,11],[177,0,177,11],[179,0,179,11],[180,0,180,11],[161,0,161,11],[160,0,160,11],[155,0,155,11],[157,0,157,11],[158,0,158,1],[158,2,158,3],[158,4,158,5],[158,6,158,7],[152,0,152,1],[152,2,152,3],[167,0,167,11],[168,0,168,11],[169,0,169,11],[170,0,170,11],[166,0,166,11],[165,0,165,11],[164,0,164,11],[163,0,163,11],[162,0,162,11],[150,0,150,11],[151,0,151,1],[151,2,151,3],[151,4,151,5],[135,0,135,11],[134,0,134,11],[152,6,152,7],[159,0,159,1],[159,2,159,3],[159,4,159,5],[159,6,159,7],[152,4,152,5],[156,0,156,11],[153,0,153,11],[154,0,154,11],[143,0,143,11],[141,0,141,11],[139,0,139,11],[138,0,138,11],[136,0,136,11],[144,6,145,11],[142,0,142,11],[149,0,149,11],[151,6,151,7],[20,0,20,11],[21,0,21,11],[67,0,67,11],[69,0,69,11],[70,0,70,11],[93,0,93,11],[85,0,85,11],[84,0,84,11],[96,8,109,11],[78,0,78,11],[80,0,80,11],[88,0,88,11],[95,0,95,11],[92,0,92,11],[77,0,77,11],[81,0,81,11],[82,0,82,11],[86,0,86,1],[86,2,86,3],[86,4,86,5],[87,0,87,1],[87,2,87,3],[87,4,87,5],[83,0,83,11],[10,0,10,4],[5,0,5,4],[5,5,5,11],[6,0,6,4],[6,5,6,11],[10,5,10,11],[11,0,11,4],[11,5,11,11],[15,0,15,11],[0,0,0,11],[16,0,16,1],[16,2,16,3],[19,0,19,1],[19,2,19,3],[47,0,47,11],[48,0,48,11],[49,0,49,11],[22,0,22,11],[23,0,23,10],[24,0,24,11],[28,8,44,11],[3,0,3,10],[4,0,4,4],[4,5,4,11],[12,0,12,11],[13,0,13,10],[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],[25,0,25,11],[27,0,27,11],[45,0,45,11],[46,0,46,11],[73,0,73,11],[75,0,75,11],[76,0,76,11],[26,0,26,11],[72,0,72,11],[52,6,52,8],[53,6,53,8],[54,6,54,8],[56,6,56,8],[57,6,57,8],[58,6,58,8],[60,6,60,8],[62,6,62,8],[63,6,63,8],[61,6,61,8],[64,6,64,8],[59,6,59,8],[55,6,55,8],[51,3,51,8],[51,2,52,2],[147,0,147,11],[148,0,148,11],[137,0,137,11],[140,0,140,11],[144,0,144,1],[144,2,144,3],[144,4,144,5],[145,0,145,1],[145,2,145,3],[145,4,145,5],[146,0,146,11],[133,1,133,2],[132,1,132,2],[131,1,131,2],[130,1,130,2],[123,1,123,2],[120,1,120,2],[119,0,119,11],[118,0,118,11],[117,0,117,11],[120,3,133,11],[121,1,121,2],[122,1,122,2],[116,0,116,11],[115,0,115,11],[124,1,124,2],[125,1,125,2],[126,1,126,2],[127,1,127,2],[128,1,128,2],[129,1,129,2],[68,0,68,11],[51,1,52,1],[51,0,52,0],[79,0,79,11],[114,0,114,11],[113,0,113,11],[112,0,112,11],[111,0,111,11],[110,0,110,11],[94,0,94,11],[91,0,91,11],[90,0,90,11],[89,0,89,11],[71,0,71,11],[74,0,74,11]]}
["Municipal Waste\nQuality report - Table 2 - Material breakdown"]
[null,null," "]
[]
["1. General information"]
["1.1. Member State",null,null,null,null,"Finland"]
["1.2. Organisation submitting the data and the description"," ",null,null,null,"Finnish Environment Institute"]
["1.3. Contact name"," ",null,null,null,"Heidi Pirtonen"]
["1.4. Contact email address"," ",null,null,null,"jateraportoinnit@syke.fi"]
["1.5. Contact phone number"," "]
["1.6. Reference year"," ",null,null,null,2024]
["1.7. Delivery date / version"," ",null,null,null,"2026-07-07"]
["1.8. Link to data publication by the Member State (if any)"," "]
[]
["2. Description of the parties involved in the data collection"]
["Add rows as appropriate"]
[]
["Name of institution",null,"Description of key responsibilities"]
["Regional environmental authorities",null,"Collects annual waste reports from facilities."]
["Statistics Finland",null,"Calculates MW counts from register data for LoW-level entries."]
["Finnish Environment Institute (Syke)",null,"Provides estimations on composting of households"]
[]
["3.2 Shall the data on municipal waste reported in part A be used to demonstrate compliance with the target laid down in point (a) of Article 11(2) of Directive 2008/98/EC? Yes/No "]
["No, if the part A means OECD-Eurostat JQ; because it presents all municipal waste and reporting obligations and chosen calculating method allow different coverage and counts."]
["3. Description of methods used"]
["3.1. Municipal waste generation"]
["3.1.1. Methods for determining municipal waste generation (mark with a cross or specify in last column)"]
["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."]
[]
["Municipal waste component","Administrative data","Surveys","Electronic registry","Data from waste operators","Data from municipalities","Data from extended producer responsibility","Other (specify)"]
["Total","X",null,null,null,null,"x"]
["Metals",null,null,null,null,null,"x"]
["Glass",null,null,null,null,null,"x"]
["Plastic",null,null,null,null,null,"x"]
["Paper and cardboard",null,null,null,null,null,"x"]
["Biowaste"]
["Wood",null,null,null,null,null,"x"]
["Textiles"]
["Electrical and electronic equipment",null,null,null,null,null,"x"]
["Batteries",null,null,null,null,null,"x"]
["Bulky waste"]
["Mixed waste"]
["Other (specify)"]
["Also included: Municipal waste not mentioned above (please specify)","200399, 150111*, (160107* from municipalities), 200130, 200131*, (200132* classified all hazardous), 200128, 200303, 150105, 150110*, 200141, 200199, (191210 if from municipalities), 200303 and 200306 if from households or municipal services."]
["Also included: Hazardous household waste","20 01 13* - 23*, \n20 01 26* - 27*, \n20 01 29*, 20 01 21*, 20 01 37*, 20 01 39*"]
[]
["3.1.2. Description of the methodology used to operationalise the definition of municipal waste in the national data collection systems, including the methodology used to collect data on the non-household fraction of municipal waste "]
["Describe the approach and methods that are used by national data collection system to identify wastes which are defined as municipal. For example, are EU list of waste (LoW) codes the primary method, are other methods used? Are reporting systems asking businesses to self-report whether they are handling municipal waste or not, or is some national business classification used?"]
["LoW codes are the primary information used to identify MW. Administrative register YLVA collects annual waste reporting data from most of the industry and waste mangement services. Connected to every waste entry is information on the process or type of industry, where the waste was generated. We try to separate similar waste than MW but generated from other activities like not from households, not from services and not from supporting activities of manufacturing industry. Shortly, to exclude manufacturing waste."]
["3.1.3. Statistical codes, use of waste codes and verification of data on municipal waste generation "]
["The LoW codes in the column ‘LoW Codes (Decision 2000/532/EC)’ are those that relate to municipal wastes. If there is any variation to the codes that are applied for the different materials, please describe these in the column ‘Other classification used’.\nThe other 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•\tCross-check (yes/no)\n•\tTime-series check (yes/no)\n•\tAudit (yes/no)\nIf ‘yes’ is identified for any of these aspects, for any of the materials, in the final column ‘Description of the verification process’ please describe the details of the process. Where cross-checks are done, please describe with which other datasets (national or European or other) are used as the cross-check, what the nature of the check is and any margins or error or tolerances identified as acceptable or not acceptable between the data being cross checked. For time series checks please explain the period over which the checks are taking place, and any other necessary information. Related to ‘audits’ please describe whether they are voluntary or mandatory, if mandatory the legal basis for which the audit is based upon, the nature of the entities being audited and doing the auditing, the level of training or guidance given to the auditors, and the mechanisms used to fund the audits including who pays whom. Please also describe any penalties or further actions resulting from non-compliance with such audits."]
[]
["Municipal waste component","Waste codes(1) ","Other classification used","Verification process"]
[null,null,null,"Cross-check (yes/no)","Time-series check (yes/no)","Audit (yes/no)","Description of the verification process"]
["Metals","20 01 40, 15 01 04, 15 01 11*",null,"yes","yes","no"]
["Glass","20 01 02, 15 01 07",null,"yes","yes","no"]
["Plastic","20 01 39, 15 01 02 ",null,"yes","yes","no"]
["Paper and cardboard","20 01 01, 15 01 01",null,"yes","yes","no"]
["Biowaste","20 01 08, 20 01 25, 20 02 01 ",null,"yes","yes","no"]
["Wood","20 01 37*, 20 01 38, 15 01 03",null,"yes","yes","no"]
["Textiles","20 01 10, 20 01 11, 15 01 09     ",null,null,"yes","no"]
["Electrical and electronic equipment","20 01 21*, 20 01 23*, 20 01 35*, 20 01 36    ",null,"yes","yes","no"]
["Batteries","20 01 33*, 20 01 34    ",null,"yes","yes","no"]
["Bulky waste","20 03 07",null,null,"yes","no"]
["Mixed waste","20 03 01, 15 01 06    ",null,null,"yes","no"]
["Other (specify)","20 01 13*, 20 01 14*, 20 01 15*, 20 01 17*, 20 01 19*, 20 01 26*, 20 01 27*, 20 01 28, 20 01 29*, 20 01 30, 20 01 31*, 20 01 32, 20 01 41, 20 01 99, 20 02 03, 20 03 02, 20 03 03, 20 03 99, 15 01 05, 15 01 10*     ","All producer responsibility register data used for cross checks and for additional datasource uses classifications of certain reporting obligations on that waste. ","yes","yes","no","For all LoW-entries: Facilities reporting annually of their generation and treatment of waste are advised by environmantal authorities to follow reporting manuals provided to them. Regional environmental authorities and Statistics Finland also check and validate in their own systems the reported data with different methods. There are some automated validation procedures in the YLVA-register's user interface for the facilities alerting the data saver for certain possible errors or impossible combinations. Regiter authorities and Statistics Finland both do timeseries checks to previous years data. Cross checks on observation level not possible but on aggregated material level this is done if producer responsibility register reporting data is available.   "]
["(1) Waste codes established by Decision 2000/532/EC. "]
[]
["3.1.4. Methods used to estimate the composition of mixed municipal waste generated per material "]
["Firstly, describe the waste compositional analyses undertaken to estimate the composition of mixed municipal wastes generated. For example, a national sampling programme, statistical analyses of regional or municipal level analyses etc. Include information on the statistical accuracy of the data where possible, e.g. what confidence level was used — such as 95% — and what the sampling error was calculated to be — such as +/- 10%.\nNext, as stipulated in the guidance above for the table in Part A, record any assumptions made in correlating categories used in national waste compositional analyses with the categories in the table."]
["Statistics Finland does not estimate the composition of mixed municipal waste, it is reported to FEI as it is."]
["3.1.5. Estimated share of waste generated by households in municipal waste (in %) and description how that estimate was calculated "]
["Describe the method used to estimate the share of waste generated by households in municipal waste. For example, whether separate data collection systems are used, or if household waste and non-household municipal wastes are collected together on the same collection rounds, what sampling, surveying or other analyses has been used to estimate the proportion of household waste collected.\nFor example, a representative survey of waste operators in the country could be carried out. Waste collectors are likely to have on record the number, or volume, of bins for both household and non-household customers they serve. If sampling of the actual weight of waste collected from households and non-household customers is not possible, the total number of bins, or better still, the total volume of waste collected, could be used to pro-rate the total weight of waste collected by that operator within the year. This would allow for the total weight of waste from households only to be estimated."]
["For separating amounts of municipal waste generated by households and services the corresponding coefficients in the calculating model were updated using 2018-2020 three year averages for the generation of waste from services in the metropolitan area, area responsible for about one fourth of national municipal waste generation, and this update effected also to the national level share. For HH share the model was updated using Metropolitan area HH data for year 2024."]
["3.1.6.  Approaches to exclude waste that is not similar in nature and composition to household waste, in particular as regards: \n—  packaging waste and waste electric and electronic equipment from commercial and industrial sources that is not similar to waste generated by households, and \n—  types of waste that are generated by households but are not part of municipal waste such as construction and demolition waste.   "]
["Describe any approaches taken to ensure wastes not similar in nature and composition to household are excluded from the total amount of MSW generated reported. For example, selection of waste codes, or surveying or sampling work to estimate the proportion of waste categorised under certain codes that is similar in nature and composition to household wastes."]
["LoW codes are the primary information used to identify MW. Administrative register YLVA collects annual waste reporting data from most of the industry and waste mangement services. Connected to every waste entry is information on the process or type of industry  where the waste was generated. We try to separate similar waste than MW but generated from other activities like not from households, not from services and not from supporting activities of manufacturing industry. Shortly, to exclude manufacturing waste."]
["3.1.7.  Explanation of estimates used to cover gaps in data on generated municipal waste as regards the amounts of waste generated by households (for instance, due to incomplete coverage of households by the collection systems) and of similar waste (for instance, due to incomplete coverage of similar waste by data on waste collection)  "]
["Explain how any estimates to cover gaps in data on generated municipal waste have been developed. For example, if the coverage of the collection systems is incomplete, the waste generated by household outside of the system could be estimated by assuming the average per household waste generated amount from households which are covered, also applies on a per household basis to households that are not covered by the collection system."]
["Our municipal waste collection scheme and collecting bins on remote areas for real estates not covered by organized municipal waste collection routes from real estates covers together all our households."]
["3.1.8. Differences from data reported in previous years "]
["\nExplanation of any significant methodological changes in the municipal waste data collection approach applied for the current reference year in relation to the approach applied for previous reference years (in particular retrospective revisions, their nature and whether a break in the series has to be flagged for a certain year)."]
["Explain any significant methodological changes, for example, if a new waste data collection system was implemented, or there was a change from statistical estimates from surveys to actual data reported directly by operators."]
["Not any big methodological changes compared to previous years. Most coefficients in the calculation method sharing the municipal waste between services and households updated because new referencedata available. Environmental authorities YLVA-register is under renovation and provides a bit better data for sharing waste between municipal waste and non municipal waste, that may have affected to the counts. Because there was simultaneously a big drop in amounts we can't estimate the possible effects magnitude."]
["Explanation detailing the causes of the tonnage difference for any component of municipal waste which shows more than 10 % variation from the data submitted for the previous reference year. "]
["For each municipal waste component (component in this context means each waste category defined in the table in Part A, e.g. metals, glass, plastic, paper and cardboard, etc) calculate the % variation in waste generated from the current year of reporting relative to the previous. For example:\n% Variation=100 ×  ((〖Waste generated〗_(Year x)-〖Waste generated〗_(Year x-1) ))/〖Waste generated〗_(Year x-1) \nWhere 'Year x' = the current year of reporting.\nFor each component of municipal waste where the % Variation is greater than 10% then the table must be filled in. One 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. This 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."]
[]
["Municipal waste component",null,"Variation (%)",null,"Main reson for variation"]
["In general small amounts, small number of observations, variations occur due nature of the item."]
["Add rows as appropriate"]
["3.2. Municipal waste management"]
["3.2.1. Classification of treatment operations \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 used only, or whether additional national based classifications are used to complement or used instead of R/D codes. Where any variation from the codes set out in the annexes is taken, 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."]
["R/D-codes used, and a guiding document given by environmental authorities in order to assist the proper implementation of classifications. In an updated version for 2017 onwards certain R-codes on national level are split to more precise subcategories enabling e.g.separation of pre treatment from final recovery/disposal or backfilling. Preparation for reuse was added to the treatment classification from 2022 onwards. The national classification is hierarchical so the more specific national codes can be summed up to official R/D-codes."]
["3.2.2.  Description of methods for determining the amount of municipal waste treated (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."]
[]
["Municipal waste component","Administrative data","Surveys","Electronic registry","Data from waste operators","Data from municipalities","Data from extended producer responsibility","Other (specify)"]
["Total","X"]
["Metals",null,null,null,null,null,"x"]
["Glass",null,null,null,null,null,"x"]
["Plastic",null,null,null,null,null,"x"]
["Paper and cardboard",null,null,null,null,null,"x"]
["Biowaste"]
["Wood",null,null,null,null,null,"x"]
["Textiles"]
["Electrical and electronic equipment",null,null,null,null,null,"x"]
["Batteries",null,null,null,null,null,"x"]
["Bulky waste"]
["Mixed waste"]
["Other (specify)"]
[]
["Additional information about the methodology including combination of methods used."]
["Provide a description of the different methodologies used, particularly where these vary for the different components of municipal 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 what different types of treatment they cover. For example, ‘Data from extended producer responsibility schemes’ may relate to dry recycling, ‘Data from waste operators’ could relate to biowaste treatment and ‘Data from municipalities’ could relate to incineration or landfilling of municipal wastes.\nWhere surveys and electronic registries or administrative data are indicated for the same component of municipal waste, explain how the data from each method is used in combination to calculate the total amount of waste treated.\nIf there are any other methods used not list as column headers, please outline these in the final column entitled ‘Other (specify)’.\nFurthermore, as outlined in the guidance for Part A above, please include any further methodological information in this section relating to:\n•\tany assumptions that have been made to correlate national categories of waste to the categories of waste given in the table for recycling, energy recovery or other recovery; and\n•\twhere any recycling is recorded under the ‘Other’ row, some qualitative explanation of the main fractions within this amount should be described."]
[]
["3.2.3.  Preparing for re-use \nDescription of how the amounts recorded under preparing for reuse have been calculated.   "]
["Provide a description of how the amounts recorded under preparing for reuse in the table under Part A have been calculated. For example, whether registries of preparing for reuse operations / sites have been developed, whether data is reported directly from each site using electronic registries — or other means — or whether a survey of such sites has been carried out. If the latter, provide details regarding the total population, the sample size and the confidence interval of the reported data (e.g. 95% +/- 10%).\nWhere preparation for reuse operations receive wastes on a per item basis, and is therefore not weighed at the site, please outline how the weight of such items has been estimated.\nIf voluntary data has been submitted relating to the amounts of waste prepared for reuse by component of municipal waste, explain the methodology used for recording or estimating these amounts."]
["Treatment code for preparation for reuse was added to the codec of administrative register YLVA we use as main datasource from 2022 onwards. "]
["3.2.4.  Description of applied measurement points for recycling, for instance at the calculation point, at the output of a sorting operation with subtraction of non-target materials as appropriate, and of end-of-waste criteria, etc., including variation at regional and local level and for household and similar waste where relevant "]
["For each component of municipal 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. For example, as per those given in the main measurement method report.\nWhere calculation points other than those indicated in Annex I of the Implementing Act, 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 municipal 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 then just refer to that section for the description of the measurement points in the response for this section.\nFor ‘Biowaste’ the measurement points should relate only relate to biowaste that is not separated and recycled at source, as information on the methodology for describing the amounts of that particular waste stream should be given in section 3.2.10."]
[]
["Municipal waste component","Description of measurement points used"]
["Metals"]
["Metals from IBA"]
["Glass"]
["Plastic"]
["Paper and cardboard"]
["Biowaste"]
["Wood"]
["Textiles"]
["Electrical and electronic equipment"]
["Batteries"]
["Bulky waste"]
["Mixed waste"]
["Other (specify)","x"]
["We use administrative register data and producer responsibility data and don't know exact measuring points, but calculating points used in the reported data are advised to be used according WFD calculating rules. "]
["Detailed description of the methodology used to calculate the amount of non-target materials removed between the measurement points 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."]
["Look at previous answer."]
["3.2.5.  Description of the methodology used to determine per material the amount of recycled materials contained in waste items composed of multiple materials. "]
["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 municipal waste, as set out in the table in Part A.\nFor example, a survey of producers of the products that become waste could be carried out in order to ascertain the composition of the products being placed on the market. This could be assumed to be equivalent to the composition of such products when they become wastes. The composition would then be applied to the total weight of waste composed of multiple materials, to calculate the amount of waste recycled per material.\nSampling of a given waste stream could also be carried out at the calculation points to determine the per material amounts of recycled materials. In this case, the methodology may have to correct for changes in moisture content or contaminants, so that the data are consistent with the amounts reported as generated municipal wastes."]
["Look at point 3.2.4. answer."]
["3.2.6. Use of Average Loss Rates (ALRs) \nDescription of the sorted 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."]
[]
["Sorted waste material and sorting plant type",null,"ALR applied (in%)",null,"Description"]
[]
["Add rows as appropriate"]
["ALR:s not used on data level, maybe used by producer responsibility organisations calculations. Statistics Finland does not have access to nonaggregated data and calculating methods used in produser responsibility organisations reporting."]
["3.2.7.  Attribution of waste to municipal sources and non-municipal sources at the measurement point \nDescription of the methodology used to exclude non-municipal wastes (aggregated data across facilities of a similar type is acceptable). "]
["For each waste and facility type, include the estimate share of MSW in the input, and describe the methodologies used. For example, surveying of plant operators or use of actual reported data to an electronic registry."]
[]
["Waste material/Waste codes",null,"Facility type",null,"Share of municipal waste (%)",null,"Description of the methodologies applied to obtain the percentage    "]
[]
["Add rows as appropriate"]
[]
["3.2.8.  Attribution of waste to different Member States at the measurement point \nDescription of the methodology used to exclude waste originating from other Member States or third countries (aggregated data across facilities of a similar type is acceptable)."]
["For each waste and facility type, include the estimate 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 to an electronic registry."]
[]
["Waste material/Waste codes",null,"Facility type",null,"Share of municipal waste from reporting Member State (%)",null,"Description of the methodologies applied to obtain the percentage    "]
[]
["Add rows as appropriate"]
["3.2.9.  Recycling of municipal bio-waste that is not separately collected or separated and recycled at source (relevant until 2026) \nInformation about measures to ensure that the conditions specified in the first subparagraph of Article 11a(4) of Directive 2008/98/EC regarding the recycling of municipal bio-waste that is not separately collected or separated and recycled at source are met.  "]
["Until 2026, for municipal bio-waste that is not separately collected or separated and recycled at source but is treated and classified as ‘recycling’ in the reported statistics, explain the details of how the conditions of Article 11a(4) of Directive 2008/98/EC have been met."]
[]
["3.2.10.  Municipal bio-waste separated and recycled at source "]
["•\tGeneral description of the methodology applied, including the use of direct and indirect measurement and where a simplified methodology to measure municipal bio-waste separated and recycled at source may have been used if the total reported quantity is <5% of total MSW generated.\n•\tDescribe the methods used to obtain the number of active recycling units or the number of persons involved in recycling of municipal bio-waste separated at source, for example through registries or surveys. In addition, set out the methods used to ensure that the number of active recycling units includes only those recycling units that are actively used by waste producers (e.g. that drop outs are being excluded from the total number of active units).\n•\tDescribe the methods to establish the amounts of municipal bio-waste separated and recycled at source as required by the formulas in Annex II. Explain how the key parameters in the formulas have been derived, and what values have been used.\n•\tProvide a detailed description of any surveys undertaken, including their periodicity, subsamples, confidence levels and confidence intervals (e.g. 95% +/- 10%).\n•\tDescribe the measures used to ensure that the reported amounts of municipal bio-waste that is separated and recycled at source are not overestimated. For example, what cross-checks have been taken comparing the reported figures to other data e.g. the estimate proportion of food/kitchen waste in MSW per household. If a coefficient related to moisture loss has been used in the calculations, describe how this has been calculated.\n•\tDescribe any measures used to ensure that the treatment of municipal bio-waste that is separated and recycled at source is properly carried out and that the recycled output is used and results in benefits to agriculture or ecological improvement. For example, training, auditing etc."]
["FEI has provided a separate study report to Eurostat by EDAMIS with year 2021 reporting. (Quality report_small_scale_composting_23052...)"]
["Description of the methods used to obtain the number of active recycling units or the number of persons involved in recycling of municipal bio-waste separated at source through registries or surveys and to ensure that the number of active recycling units includes only those recycling units that are actively used by waste producers. "]
[]
["Description of the methods to establish the amounts of municipal bio-waste separated and recycled at source as required by the formulas in Annex II.   "]
[]
["Detailed description of surveys, including their periodicity, subsamples, confidence levels and confidence intervals.  "]
[]
["Description of measures to ensure that the reported amounts of municipal bio-waste that is separated and recycled at source are not overestimated (including the application of a coefficient related to moisture loss). "]
[]
["Description of measures to ensure that the treatment of municipal bio-waste that is separated and recycled at source is properly carried out and that the recycled output is used and results in benefits to agriculture or ecological improvement. "]
[]
["3.2.11.  Calculation of recycled metals separated after incineration of municipal waste  "]
["•\tProvide 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.\n•\tDescribe 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.\n•\tDescribe 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."]
["Not effort to use this voluntary method. "]
["Description of the approach taken to measure the total amount of metal concentrate extracted from the incinerator bottom ash. "]
["Not effort to use this voluntary method. "]
["Description of the method to estimate the average level of metallic content in the total amount of metal concentrate, including the reliability of any surveys undertaken. "]
["Not effort to use this voluntary method. "]
["Description of the method to estimate the proportion of municipal waste entering incineration plants, including the reliability of any surveys undertaken.  "]
["Not effort to use this voluntary method. "]
["3.2.12.  Other recovery of waste "]
["Describe the different waste treatment operations reported under the category “other recovery” in the table in part A and their share (%). Ensure that the descriptions are clear and explain which of the key components of municipal waste relate to each type of ‘other recovery’ process."]
[]
["3.2.13.  Information on the relevance of temporary storage of waste to 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(s), and waste going to temporary storage in the current reference year  "]
["Describe the quantities of waste by each key component of municipal waste that has been stored in previous years and is going to temporary storage in the current reference year. Provide 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. If surveys are used provide further information including their periodicity, sample size, subsamples, and confidence intervals (e.g. 95% +/- 10%)."]
["We don't have calculted this kind of information out of the scope of the WFD reporting obligations. We know that storage variations affect to treatment amounts and use a specific classification for waste entries to identify if the treated waste is released from previous years storage. But we don't know when it was put in to the temporary storage. Such waste not generated during reporting perios is not included in the treated amounts."]
["3.2.14.  Differences from the data reported for the previous reference years \nSignificant methodological changes in the calculation method used for the current reference year in relation to the calculation method used for previous reference years, if any (in particular retrospective revisions, their nature and whether a break in the series has to be flagged for a certain year). "]
["Explain any significant methodological changes relating to reported data on waste treatment since the previous year of reporting."]
["Not any significant changes. If we have had wrong LoW codes used for non municipal waste or wrong other classifications used to identify municipal waste during previous years, now we may have put a bit more effort to identify wrong classifications as municipal waste. Especially for metal waste and some waste directed to energy recovery. "]
["Explanation detailing the causes of the tonnage difference (which waste streams, sectors or estimates have caused the difference, and what the underlying cause is) for any component of municipal waste recycled which shows greater than a 10 % variation from the data submitted for the previous reference year. "]
[" For each municipal waste component (component in this context means each waste category defined in the table in Part A, e.g. metals, glass, plastic, paper and cardboard, etc) calculate the % variation in waste treated from the current year of reporting relative to the previous. For example:\n% Variation=100 ×  ((〖Waste treated〗_(Year x)-〖Waste treated〗_(Year x-1) ))/〖Waste treated〗_(Year x-1) \nWhere 'Year x' = the current year of reporting.\nFor each component of municipal waste where the % Variation is greater than 10% then the table must be filled in. One 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. This 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."]
[]
["Municipal waste component",null,"Variation (%)",null,"Main reason for variation"]
["In general small amounts, small number of observations, variations occur due nature of the item."]
["Add rows as appropriate"]
["3.2.15.  Verification of data on recycling of municipal waste"]
["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•\tCross-check (yes/no)\n•\tTime-series check (yes/no)\n•\tAudit (yes/no)\nIf ‘yes’ is identified for any of these aspects, for any of the materials, in the final column ‘Description of the verification process’ please describe the details of the process. Where cross-checks are done, please describe with which other datasets (national or European or other) are used as the cross-check, what the nature of the check is and any margins or error or tolerances identified as acceptable or not acceptable between the data being cross checked. For time series checks please explain the period over which the checks are taking place, and any other necessary information. Related to ‘audits’ please describe whether they are voluntary or mandatory, if mandatory the legal basis for which the audit is based upon, the nature of the entities being audited and doing the auditing, the level of training or guidance given to the auditors, and the mechanisms used to fund the audits including who pays whom. Please also describe any penalties or further actions resulting from non-compliance with such audits."]
[]
["Municipal waste component","Verification Process"]
[null,"Cross-check (yes/no)","Time-series check (yes/no)","Audit (yes/no)","Description of the verification process"]
["Metals","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Metals from IBA"]
["Glass","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Plastic","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Paper and cardboard","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Biowaste","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Wood","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Textiles",null,"yes"]
["Electrical and electronic equipment","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Batteries","yes","yes",null,"YLVA register vs producer reesponsibility reports"]
["Bulky waste",null,"yes"]
["Mixed waste",null,"yes"]
["Other (specify)",null,"yes"]
[]
["4. Accuracy of data"]
["4.1.1.  Description of main issues affecting the accuracy of data on the generation and treatment of municipal waste, including errors related to sampling, coverage, measurement, processing and non-response "]
["Describe the main issues affecting the accuracy of data on the generation and treatment of municipal waste, including errors related to sampling, coverage, measurement, processing and non-response."]
["No survey data used. Good administrative data coverage,  normal measurement errors exist. Usually waste amount is measured by scale instead of volumetric quesses when treated. Errors to classify waste to LoW entries are behind the biggest possible errors."]
["4.1.2.  Explanation of the scope and validity of surveys to collect data on the generation and treatment of municipal waste "]
["Explain the scope and validity of surveys to collect data on the generation and treatment of municipal waste. Provide links to documents or other sources where this information would be available, if relevant."]
[]
["4.1.3.  Statistical surveys used regarding municipal 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 municipal waste. Some of the information may be available in previous questions.\nIf the survey(s) relates to individual components of municipal waste separate rows for each component / survey must be included. Where the survey relates to the whole of municipal waste, the component could be categorised as ‘Total’ and only one line filled in the table."]
[]
["Component of Municipal Waste","Year","Percentage of popoulation surveyed","Data (tonnes)","Confidence level","Error margin","Details of adjustments from the survey year to the current year","Other details"]
[]
[]
["5.  Confidentiality \n"]
["Justification to withhold the publication of specific parts of this quality check report where that is requested.   "]
[]
["6.  Main national websites, reference documents and publications"]

{"sheet":"QR Table 3 - Recycling rate","index":9,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,11],[56,0,56,11],[58,0,58,11],[60,0,60,11],[36,0,36,11],[54,0,54,11],[51,0,51,11],[55,0,55,11],[57,0,57,11],[46,0,46,11],[37,0,37,11],[38,0,38,11],[42,0,42,11],[45,0,45,11],[39,0,39,11],[40,0,40,11],[43,0,43,11],[44,0,44,11],[59,0,59,11],[47,0,47,11],[48,0,48,11],[49,0,49,11],[50,0,50,11],[52,0,52,11],[53,0,53,11],[13,0,13,11],[14,0,14,11],[12,0,12,11],[16,0,16,11],[21,0,22,0],[21,1,22,1],[15,0,15,11],[18,0,18,11],[17,0,17,11],[19,0,19,11],[21,2,21,6],[20,0,20,11],[21,7,35,11],[9,0,9,11],[10,0,10,10],[11,0,11,11],[7,0,7,4],[7,5,7,11],[8,0,8,4],[8,5,8,11],[6,0,6,4],[6,5,6,11],[3,0,3,10],[4,0,4,4],[4,5,4,11],[5,0,5,4],[5,5,5,11]]}
["Municipal Waste\nQuality report - Table 3 - Recycling rate for 2020 target if not using method 4"]
[]
[null,null," "]
["1. General information"]
["1.1. Member State",null,null,null,null,"Finland"]
["1.1. Organisation submitting the data and the description"," ",null,null,null,"Finnish Environment Institute"]
["1.3. Contact person/contact details"," ",null,null,null,"Heidi Pirtonen / jateraportoinnit@syke.fi"]
["1.4. Reference year"," ",null,null,null,2024]
["1.5. Delivery date / version"," ",null,null,null,"2026-07-07"]
[]
["2. Information on waste from households and similar waste from other origins"]
["2.1.  How are the generated amounts of waste established for the compliance with the waste target?"]
["Main part of the statistics were generated using YLVA waste data register, which are supplemented by data gathered by Statistics Finland. YLVA-data covers almost the whole yearly amount of professional waste treatment. Statistics of municipal waste are mostly based on the amount received on waste treatment plants reported yearly on YLVA. Supplementary information on various data are collected on other statistics or state registers, or they are collected by the Ministry of Employment and the Economy, SYKE, research institutes, treatment plants, Centres for Economic development, Transport and the Environment and by producer responsibility organizations. \nYLVA-systems provide acute surveillance data on accumulation of industrial waste and its treatment. On other sectors, including households, the amounts are defined by reports and calculations based on models, which define the amounts of received waste of each sector. When needed, different sources of information were combined to calculate as accurate result as possible. The shares of the service sector and households of the municipal waste, excluding cardboard and paper, are estimated with model. The model is based on a waste study in Helsinki Region Environmental Services HSY and on statistics of companies, public sector and households provided by Statistics Finland. Data on paper and cardboard waste is collected directly from waste collectors through producer responsibility organisations. Municipal waste statistics data on electrical waste and packaging diverge somewhat  from producer responsibility reporting data because of the conceptual and data collecting differences."]
["2.2.  Has a sorting analysis of waste from households and similar waste from other origins been carried out? Yes/No"]
["Yes, both sorting analysis of mixed municipal waste and energy waste."]
["2.3. Where other methods have been used, please describe:  "]
["To define the composition of mixed municipal waste a national data bank by Suomen Kiertovoima Oy (KIVO) was used. Link to the study: https://kivo.fi/ymmarramme/koostumustietopankki/kotitalousjatteen_koostumus_yhteenveto/ . To define the composition of so called energy waste (municipal waste), a SYKE research ”Salmenperä H., Moliis K. ja Nevala S-M. Ympäristöministeriön raportteja 17/2015, Jätemäärien ennakointi vuoteen 2030\" was used https://julkaisut.valtioneuvosto.fi/handle/10138/155189. To define the quantity of kitchen and food waste home composted, a study by Finnish environment institute was used. Methodology for home composting was introduced last year with quality report."]
["2.4. How do the amounts of waste reported in part A relate to waste statistics reported on the basis of Regulation (EC) No 2150/2002 of the European Parliament and of the Council (1)?  "]
["The total amount of municipal waste is based on Statistics Finland's municipal waste statistics, which complies to the OECD and Eurostat environmental survey on municipal waste guidelines. Waste statistics announced based on European Parliament and Regulation (EC) No 2150/2002, don't include separate reporting of municipal waste and the municipal waste quantities can't be calculated using the data required for the above-mentioned reporting, even though municipal waste amounts were included in the other amounts reported. Distribution of the accumulated amount of municipal waste between different treatment methods adjusts to the above-mentioned Regulation and treatment methods defined in the Waste Directive (R/D-codes and their aggregation to different classes)."]
["2.5. Please describe the composition and sources of waste from households and similar waste from other origins as appropriate by ticking the relevant cells in the table. "]
[]
["Waste Materials","Waste Codes(1)","Generated by"]
[null,null,"Households","Small enterprises","Restaurants, canteens","Public areas","Others (please specify)"]
["Paper and cardboard","20 01 01, 15 01 01 ","x","x","x","x","a)"]
["Metals","20 01 40, 15 01 04  ","x","x","x","x","a)"]
["Plastic","20 01 39, 15 01 02  ","x","x","x","x","a)"]
["Glass","20 01 02, 15 01 07","x","x","x","x","a)"]
["Biodegradable kitchen and canteen waste","20 01 08  ","x","x","x","x","a)"]
["Biodegradable garden and park waste","20 02 01       ","x","x","x","x","a)"]
["Non-biodegradable garden and park waste","20 02 02, 20 02 03     "]
["Wood","20 01 38, 15 01 03  "]
["Textiles","20 01 10,  20 01 11, 15 01 09 "]
["Batteries","20 01 34, 20 01 33* ","x","x","x","x","a)"]
["Discarded equipment","20 01 21*, 20 01 35*, 20 01 23*, 20 01 36","x","x","x","x","a)"]
["Other municipal waste","20 03 01, 20 03 07, 20 03 02, 15 01 06","x","x","x","x","a)"]
["Municipal waste not mentioned above (please specify)    ",null,"x","x","x","x","a)"]
["(1) Regulation (EC) No 2150/2002 of the European Parliament and of the Council of 25 November 2002 on waste statistics (OJ L 332, 9.12.2002, p. 1). "]
["2.6  For calculation methods 1 and 2: Please provide in rows (a) to (c) below the respective amounts or shares and the waste codes used for calculating waste generation in line with the following rationale: (a)  % paper, metal, plastic, glass (and, for method 2, other single waste streams) in household waste (and, for method 2, in similar waste) determined by a sorting analysis × (b)  annual amount of household waste (and, for method 2, of similar waste) generated + (c)  separately collected paper, metal, plastic and glass (and, for method 2, other single waste streams) from households (and, for method 2, separately collected similar waste from other origins) (waste codes 15 01, 20 01) "]
["(a) Paper and cardboard 18,6 %; metal 2,2 %; plastic 17,3 %; glass 2,1 %; WEEE 0,6 % biowaste 29,2 %"]
["(b) These figures include amounts in mixed municipal waste, in energy waste and separately collected waste; paper & cardboard 398348 t, metal 48595 t, plastic 63956 t, glass 101748 t, biodegradables 462857 t, electrical waste 68267 t."]
["(c) paper and cardboard 398348 t; metal 48589 t; plastic 46996 t; glass 101687 t; WEEE 67968 t, biowaste 433955 t"]
[]
["2.7.  How are the data on preparing for re-use and on recycling compiled? "]
["2.7.1. Are data based on the input to preliminary treatment facilities (e.g. sorting plant, mechanical biological treatment)? Yes/No "]
["If yes, please provide information on the recycling efficiency: "]
["The data consists mainly of amounts received on pre-treatment facilities and they are improved with eg. calculation on home composting. Municipal waste data of industry and energy production sectors is partly calculated from data reported by waste-producing facilities."]
["2.7.2.  Are data based on the input to the final recycling process? Yes/No "]
["No"]
["2.7.3.  Please describe the data validation process:  "]
["The data consists mainly of amounts received on pre-treatment facilities and they are improved with eg. calculation on home composting. Municipal waste data of industry and energy production sectors is partly calculated from data reported by waste-producing facilities."]
["2.8. Have there been problems with applying the rules on the calculation of biodegradable waste? Yes/No "]
["No"]
["If yes, please describe the problem(s): "]
[]
["2.9. Has waste been:"]
["(a) shipped to another Member State? (Yes/No) "]
["Yes"]
["(b)  exported out of the Union for treatment? (Yes/No) "]
["Waste statistics doesn't separate the amount of exported waste from the amount of reuse or recycle. Preparation for reuse is not separated from recycling because the preparation for reuse hasn't had separate code, and so it couldn't have been identified. YLVA-register used as the data set contains information if the produced or treated waste shipment has been shipped, exported, imported or treated in Finland or abroad. The statistics of wastes under producer responsibility such as packaging consists mainly of data aggregated by producer responsibility organisations and their statistics haven't discerned exported waste."]
["If the answer to (a) and/or (b) is yes, how have the preparing for re-use and recycling rates for those shipped or exported amounts been derived, monitored and validated?   "]

{"sheet":"ErrorLog","index":10,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Link to Error","Validation Rule","Cell","Sheet","Description","Severity","Former Color"]
["Go to cell","Summations","H14","Table 2 - Material breakdown","Total Generated should be greater than PRP_REU + RCY + RCV_E + RCV_OTH","Error",16777215]
["Go to cell","Summations","H19","Table 2 - Material breakdown","Total Generated should be greater than PRP_REU + RCY + RCV_E + RCV_OTH","Error",16777215]

{"sheet":"IsNumeric","index":11,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 2 - Material breakdown","H7","AB21",1,4,null,null,"it is meant to check that there are numerical values"]
["Error","Table 3 - Recycling rate","F8","J8",999,4]

{"sheet":"FootnoteContent","index":12,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Table 2 - Material breakdown","J7","AD21",1,4,1]
["Error","Table 3 - Recycling rate","H8","L8",999,4,1]

{"sheet":"Mandatory","index":13,"n_rows":16,"n_cols":9,"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","GETTING STARTED","E9","E10",1,999,"NO",999,"STANDARD FOR ALL QUESTIONNAIRES"]
["Error","GETTING STARTED","D14","D22",2,999,"NO",999]
["Error","Table 2 - Material breakdown","H7","H8",1,999,"YES",3]
["Error","Table 2 - Material breakdown","H10","H19",1,999,"YES",3]
["Error","Table 2 - Material breakdown","H21","H21",999,999,"YES",3]
["Error","Table 2 - Material breakdown","P7","P7",999,999,"YES",3]
["Error","Table 2 - Material breakdown","T7","T8",1,999,"YES",3]
["Error","Table 2 - Material breakdown","T10","T19",1,999,"YES",3]
["Error","Table 2 - Material breakdown","T21","T21",999,999,"YES",3]
["Error","Table 2 - Material breakdown","X7","X7",999,999,"YES",3]
["Error","Table 2 - Material breakdown","X11","X19",1,999,"YES",3]
["Error","Table 2 - Material breakdown","X21","X21",999,999,"YES",3]
["Error","Table 2 - Material breakdown","AB7","AB7",999,999,"YES",3]
["Error","Table 2 - Material breakdown","AB10","AB19",1,999,"YES",3]
["Error","Table 2 - Material breakdown","AB21","AB21",999,999,"YES",3]

{"sheet":"MustNotBeNegative","index":14,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 2 - Material breakdown","H7","AB21",1,4]
["Error","Table 3 - Recycling rate","F8","J8",999,4]

{"sheet":"Changelog","index":15,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Change","Changed by","SheetName","Cell","Version","Date","REMARKS"]
["Add macros version m01b","CDD","VB",null,"v00m01b","2024-03-20"]
["Add macro \"Workbook_SheetChange\" in \"ThisWorkbook\"","CDD","VB",null,"v00m01b","2024-03-20"]
["Add sheet \"MacroBehaviour\"","CDD","MacroBehaviour",null,"v00m01b","2024-03-20"]
["Add sheet \"Lists (specific)\"","CDD","Lists (specific)",null,"v00m01b","2024-03-20"]

{"sheet":"Summations","index":16,"n_rows":113,"n_cols":13,"rows_kept":113,"cut":false,"hidden":true,"merged":[[14,5,14,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","Non compliance Is Valid If Footnote Exists","Footnote Shift From Value","Display text in error"]
["Error","Table 2 - Material breakdown","H8,H9,H10,H11,H12,H13,H14,H15,H16,H17,H18,H19,H20,H21","H7","AB7",999,4,"EQ",0.1,"NO","NO",3,"Total waste not consistent to the sum of materials"]
["Error","Table 2 - Material breakdown","P7,T7,X7,AB7","H7","H21",1,999,"GT",0,"NO","NO",3,"Total Generated should be greater than PRP_REU + RCY + RCV_E + RCV_OTH"]
["Error","Table 2 - Material breakdown","H20","H7","H7",999,999,"GT",0,"YES","NO",3,"Total Generated 'Mixed Waste' should be less than than the 'Total Generated Waste'  "]
["Error","Table 3 - Recycling rate","J8","F8","F8",999,999,"GT",0,"YES","NO",3,"Total Generated should be greater than RCY_PRP_REU"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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",null,"Not Applicable if the previous column is \"NO\""]
[]
["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":"Lists","index":17,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,9,1,10],[5,9,5,10],[10,9,10,10],[15,9,15,10]]}
["Country label","Country code",null,"Valid flags\n(obs_status)","Label",null,"Valid flags\n(obs_conf)","Label",null,"Textual variables","String",null,"WASTE-2026-DC"]
["Belgium","BE",null,"B","Break in time series",null,null,null,null,"Institutional names"]
["Bulgaria","BG",null,"E","Estimated data",null,null,null,null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ",null,"P","Provisional",null,null,null,null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK",null,"BE","Break in time series, estimated",null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE",null,"BP","Break in time series, provisional",null,null,null,null,"Data collection information"]
["Estonia","EE",null,"EP","Estimated, provisional",null,null,null,null,"Data Collection Text","Municipal waste reporting obligations"]
["Ireland","IE",null,"BEP","Break in time series, estimated, provisional",null,null,null,null,"Data Collection Year",2026]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","27 May 2026"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","30 June 2026"]
["France","FR",null,null,null,null,null,null,null,"EDAMIS data"]
["Croatia","HR",null,null,null,null,null,null,null,"Domain name","WASTE"]
["Italy","IT",null,null,null,null,null,null,null,"Dataset name","WASTE_MWRODAT_A"]
["Cyprus","CY",null,null,null,null,null,null,null,"Web page","https://webgate.ec.europa.eu/edamis4 "]
["Latvia","LV",null,null,null,null,null,null,null,"Functional e-mail","ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"]
["Lithuania","LT",null,null,null,null,null,null,null,"E2 information"]
["Luxembourg","LU",null,null,null,null,null,null,null,"Telephone","(+352) 4301 3817"]
["Hungary","HU",null,null,null,null,null,null,null,"Contact","ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
["Malta","MT",null,null,null,null,null,null,null,"Methodology URL","https://ec.europa.eu/eurostat/web/waste/methodology"]
["Netherlands","NL",null,null,null,null,null,null,null,"Legislation URL","https://ec.europa.eu/eurostat/web/waste/legislation"]
["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"]

{"sheet":"Lists (specific)","index":18,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Calculation method label","Calculation method code"]
[null,"<= Select the calculation method here"]
[1,"Preparation for reuse and recycling of paper, metal, plastic and glass household waste "]
[2,"Preparation for reuse and recycling of paper, metal, plastic, glass household waste and other single types of household waste or similar waste "]
[3,"Preparation for reuse and recycling of household waste "]
[4,"Preparation for reuse and recycling of municipal waste "]

{"sheet":"MacroBehaviour","index":19,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["COMMON TO ALL (OR MOST)  QUESTIONNAIRE",null,null,null,"SPECIFIC TO THIS QUESTIONNAIRE"]
["Parameter","Value","(Valid values)",null,"Parameter","Value","(Valid values)"]
["DevelopementMode",false,"TRUE (during development)\nFALSE (For real reporting and testing)"]