{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["COVER","INDEX","Basic Instructions","Methodology","GETTING STARTED","Footnotes list","Table 4 - Landfill rate","QR Table 4 - Landfill rate","ErrorLog","Changelog","MacroBehaviour","Summations","Lists","FootnoteContent","IsNumeric","Mandatory","MustNotBeNegative"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":38,"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":"LANDFILL RATE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 27 May 2024"}]

{"sheet":"INDEX","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,2,18,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":"LANDFILL RATE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 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 4 - Landfill rate","Table 4 - Landfill rate for measuring compliance with the policy target in accordance with Article 5(5) of Council Directive 1999/31/EC concerning the landfilling of waste according to the format set out in Annex II of Commission Implementing Decision 201","for filling in"]
[null,null,"III. Quality report (Orange tabbed sheets)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Quality report - Table 4 - Landfill rate","Quality report  for Table 4 as required by annex 11 of Commission Decision 2019/1885/EC","For filling in connection with Table 4 - Landfill rate"]

{"sheet":"Basic Instructions","index":2,"n_rows":89,"n_cols":13,"rows_kept":89,"cut":false,"hidden":false,"merged":[[68,2,68,6],[71,2,71,6],[21,2,21,6],[14,2,14,5],[18,2,18,5],[9,2,9,6],[8,2,8,6],[11,10,11,13],[11,14,11,15],[11,2,11,6],[10,2,10,6],[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],[84,2,84,5],[85,2,85,5],[86,2,86,5],[87,2,87,5],[88,2,88,5],[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]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"LANDFILL RATE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"This questionnaire is designed to collect the variables required under Article 5(5) of Directive 1999/31/EC on the landfill of waste and the Annex II of Decision 2019/1885/EC. "]
[null,null,"It contains Table 4 - Landfill rate and the corresponding quality report, to be filled in and transmitted together with the corresponding data transmissions.",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 2024"}]
[]
[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_LNDFILL_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:"]
[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. 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 overwrite cells that contain a value with “empty”."]
[]
[null,null,"5. Methodology and questions:"]
[]
[null,null,"The guidelines to report on municipal waste are available on Eurostat website:"]
[null,null,{"$f":"HYPERLINK(Lists!K19)","v":"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,{"$f":"HYPERLINK(Lists!K18)","v":"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":[[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],[9,2,9,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"LANDFILL RATE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 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  (Landfill) Directive 1999/31/EC to reduce the impact of landfilling on the environment. "]
[null,null,"This Excel reporting template allows Member States to report landfill pursuant to the requirements of Commission Implementing Decisions  2019/1885."]
[]
[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/850 of the European Parliament and of the Council of 30 May 2018 amending Directive 1999/31/EC on the landfill of waste requeires the collection of data for the calculation of a landfill rate. The data and metadata to be provided for this is further detailed by Commission Implementing Decision (EU) 2019/1885 of 6 November 2019 laying down rules for the calculation, verification and reporting of data on landfill of municipal waste in accordance with Council Directive 1999/31/EC and repealing Commission Decision 2000/738/EC.\n\n\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":"LANDFILL RATE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 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,2022]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 June 2024"}]
[null,null,"Who is the primary contact point for annual reporting of landfill rate in your country?"]
[]
[null,null,"Name:","Heidi Pirtonen"]
[]
[null,null,"Institution:","Finnish Environment Institute"]
[]
[null,null,"Unit:","Circular economy solutions, Waste"]
[]
[null,null,"Telephone:","+358 295 251 677"]
[]
[null,null,"Email adress:","heidi.pirtonen@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":"LANDFILL RATE"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2024 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,1,"This information is voluntary if the method is not used by member state, so there is an error in validation rules. The count is not zero if it is not reported, because it may be something in reality but it is not used for reporting. Empty cell is the only proper filling option in such a case. "]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,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 4 - Landfill rate","index":6,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,1,4,3],[11,5,11,20],[4,7,4,8],[4,11,4,12],[4,15,4,16],[4,19,4,20],[2,6,2,20],[3,6,3,20],[9,5,9,20],[10,5,10,20],[1,9,1,20]]}
[]
[null,null,null,null,null,null,null,null,null,"Table 4 - Landfill rate - for measuring compliance with the policy target in accordance with Article 5(5) of Council Directive 1999/31/EC concerning the landfilling of waste according to the format set out in Annex II of Commission Implementing Decision 2019/1885 for the calculation of the landfill rate"]
[null,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,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2022}]
[null,"TO HIDE",null,null,null,"Municipal waste generated(1) \n(tonnes) ","Standard footnotes","Explanatory\nfootnote",null,"Landfilling(2) (tonnes) ","Standard footnotes","Explanatory\nfootnote",null,"Incineration disposal(3) (tonnes) ","Standard footnotes","Explanatory\nfootnote",null,"Material recovery of waste from incineration disposal (tonnes)","Standard footnotes","Explanatory\nfootnote"]
[null,"Source","waste","unit",null,"GEN",null,null,null,"DSP_L",null,null,null,"DSP_I",null,null,null,"RCV_M_ID"]
[null,"ANNEX_II","TOTAL","T",null,2898043,null,null,{"$f":"IF(TRIM(H7)=\"\", \"\", IF(VLOOKUP(H7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(H7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},10660,null,null,{"$f":"IF(TRIM(L7)=\"\", \"\", IF(VLOOKUP(L7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(L7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},16947,null,null,{"$f":"IF(TRIM(P7)=\"\", \"\", IF(VLOOKUP(P7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(P7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,1,{"$f":"IF(TRIM(T7)=\"\", \"\", IF(VLOOKUP(T7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":"This information is voluntary if the method is not used by member state, so there is an error in validation rules. The count is not zero if it is not reported, because it may be something in reality but it is not used for reporting. Empty cell is the only proper filling option in such a case. "}]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"(1) The concept of municipal waste generated is the same as in Table 1-municipal waste statistics (joint questionnaire (JQ),\n Table 2 - Material breakdown and - in case method 4 is chosen - as well in Table 3 - Recycling rate (questionnaire MWRO)."]
[null,null,null,null,null,"(2) This column does not include waste entering incineration disposal operations and subsequently recovered from incineration disposal operations."]
[null,null,null,null,null,"(3) Incineration disposal refers to operations carried out by facilities classified as D10 in Annex I to Directive 2008/98/EC of the European Parliament and of the Council of 19 November 2008 on waste and repealing certain Directives (OJ L 312, 22.11.2008, p. 3).   "]

{"sheet":"QR Table 4 - Landfill rate","index":7,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[44,0,44,11],[31,0,31,11],[32,0,32,11],[33,0,33,11],[34,0,34,11],[38,0,38,11],[39,0,39,11],[36,0,36,11],[37,0,37,11],[42,0,42,11],[41,0,41,11],[35,0,35,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[21,0,21,11],[22,0,22,11],[0,0,0,11],[14,0,14,11],[43,0,43,11],[40,0,40,11],[15,0,15,1],[16,0,16,1],[15,2,15,5],[16,2,16,5],[26,0,26,11],[27,0,27,11],[28,0,28,11],[29,0,29,11],[30,0,30,11],[23,0,23,11],[24,0,24,11],[25,0,25,11],[10,0,10,4],[10,5,10,11],[4,0,4,10],[5,0,5,4],[5,5,5,11],[6,0,6,4],[6,5,6,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],[17,0,17,1],[17,2,17,5],[11,0,11,11],[12,0,12,10],[13,0,13,11]]}
["Municipal Waste\nQuality report - Table 4 - Landfill rate"]
[]
[null,null," "]
[]
["I. General information"]
["1. Member State",null,null,null,null,"Finland"]
["2. Organisation submitting the data and the description"," ",null,null,null,"Statistics Finland"]
["3. Contact person/contact details"," ",null,null,null,"mr Juha Espo,   e-mail  juha.espo@stat.fi"]
["4. Reference year"," ",null,null,null,2022]
["5. Delivery date / version"," ",null,null,null,"2022-06-30"]
["6. Link to data publication by the Member State (if any):"]
[]
["II. Information on landfilling of municipal waste"]
["1.  Description of the entities involved in the data collection"]
[]
["Name of instiution",null,"Description of key responsibilities"]
["Regional environmental authorities.",null,"Collect annual waste reports from facilities."]
["Statistics Finland",null,"Calculates MW landfilled counts from register data."]
["Add rows as appropriate"]
["2.2. Description of the methodology used to include waste resulting from treatment operations prior to recycling or other recovery of municipal waste and subsequently landfilled   "]
["LoW codes and variables describing the origin of the waste used for identification."]
["2.2.1. Description of the approach to ensure traceability of municipal waste when it undergoes treatment, including the use of codes related to municipal waste generation (such as those in chapter 20 in the list of waste established by Commission Decision 2000/532/EC of 3 May 2000 replacing Decision 94/3/EC establishing a list of wastes pursuant to Article 1(a) of Council Directive 75/442/EEC on waste and Council Decision 94/904/EC establishing a list of hazardous waste pursuant to Article 1(4) of Council Directive 91/689/EEC on hazardous waste, OJ L 226, 6.9.2000, p. 3) and codes related to waste from waste treatment (such as those in chapter 19 in the list of waste established by that Decision) "]
["If the municipal waste is treated in a long treatment facility chain we can't anymore identify it. Only short treatment chains are believed to maintain the correct classification of waste in order to identify municipal waste. LoW codes are advised not to be changed if possible.  In the data is a variable describing the origin of the weaste like from municipalities."]
["2.2. Description of the methodology used to include waste resulting from treatment operations prior to recycling or other recovery of municipal waste and subsequently landfilled   "]
["Look at the previous answer"]
["2.3. Description of the approach to include waste resulting from treatment operations prior to recycling or other recovery of municipal waste and subsequently landfilled outside the Member State     "]
["We don't have such information. If municipal waste is from treatment operations prior recycling or other recovery  and it is sent to landfilling, it may be identified based on the LoW-codes as municipal waste when landfilled, but if the LoW code is changed to some 19-entry, it can't be identified anymore as municipal waste. Still waiting the ALR decision from DG Env in order to organise data collection on this kind of matters. "]
["2.4. Description of data collection on municipal waste entering incineration disposal operations in order to be subsequently landfilled, including the methodology used to calculate materials originating from municipal waste that are recovered from waste resulting from incineration disposal operations     "]
["Not yet have  used this kind of calculations in our MW reporting. "]
["2.5. Description of any estimates used to cover gaps in the data on landfilled municipal waste   "]
[]
["2.6. Differences from previous reference year’s data \nSignificant methodological changes in the calculation method used for the current reference year, if any (in particular retrospective revisions, their nature and whether a break in the series has to be flagged for a certain year)   "]
[]
["Explanation detailing the causes of the tonnage difference where municipal waste subject to landfilling or incineration disposal operations in order to be subsequently landfilled shows greater than a 10 % variation from the data submitted for the previous reference year "]
["Small amounts, small number of observations, variations occur due nature of the item."]
["3. Accuracy of the data"]
["3.1. Description of main issues affecting the accuracy of data on landfilling of municipal waste     "]
["Possible classification errors in facilities annual reporting data."]
["3.2. Description of the scope and validity of surveys to collect data on landfilling of municipal waste   "]
["No surveys."]
["4.  Confidentiality "]
["Justification to withhold the publication of specific parts of this quality check report where that is requested.  "]
[]
["5.  Main national websites, reference documents and publications"]

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

{"sheet":"Changelog","index":9,"n_rows":7,"n_cols":7,"rows_kept":7,"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"]
["Add bottons","CC","Table 4",null,"v01m01b","2024-05-15"]
["Add validation rules","CC","Summations, etc.",null,"v01m01b","2024-05-15"]

{"sheet":"MacroBehaviour","index":10,"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)"]

{"sheet":"Summations","index":11,"n_rows":105,"n_cols":13,"rows_kept":105,"cut":false,"hidden":true,"merged":[[6,5,6,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 4 - Landfill rate","J7,N7,R7","F7","F7",999,999,"GT",0,"NO","YES",3,"Generation must be bigger  than the sum of all other columns"]
["Error","Table 4 - Landfill rate","J7","F7","F7",999,999,"GT",0,"NO","NO",3,"Generation must be bigger  than landfilling"]
["Error","Table 4 - Landfill rate","N7","F7","F7",999,999,"GT",0,"YES","NO",3,"Generation must be bigger  than Incineration disposal"]
["Error","Table 4 - Landfill rate","R7","F7","F7",999,999,"GT",0,"NO","NO",3,"Generation must be bigger  than material recovery of waste from incineration disposal"]
[]
[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":12,"n_rows":42,"n_cols":13,"rows_kept":42,"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-2024-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",null,null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE",null,"BP",null,null,null,null,null,"Data collection information"]
["Estonia","EE",null,"EP",null,null,null,null,null,"Data Collection Text","Landfill rate"]
["Ireland","IE",null,"BEP",null,null,null,null,null,"Data Collection Year",2024]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","27 May 2024"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","30 June 2024"]
["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_LNDFILL_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"]
["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"]
[]
["ESTAT-E2-WASTE-MUNWAS","CDD"]

{"sheet":"FootnoteContent","index":13,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Table 4 - Landfill rate","H7","T7",999,4,1]

{"sheet":"IsNumeric","index":14,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 4 - Landfill rate","F7","R7",999,4,null,null,"it is meant to check that there are numerical values"]

{"sheet":"Mandatory","index":15,"n_rows":4,"n_cols":9,"rows_kept":4,"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 4 - Landfill rate","F7","R7",999,4,"YES",3]

{"sheet":"MustNotBeNegative","index":16,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 4 - Landfill rate","F7","R7",999,4]