{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["COVER","INDEX","Basic Instructions","Methodology","Validation rules","GETTING STARTED","Footnotes list","Table 1 - JQ","QR Table 1 - JQ","ErrorLog","Lists","MacroBehaviour","Changelog","Summations","Mandatory","MustNotBeNegative","FootnoteContent","IsNumeric"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":86,"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":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 26 October 2023"}]

{"sheet":"INDEX","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"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],[14,2,14,4]]}
[]
[]
[null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 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,"Validation rules","Validation performed by the 'Validate questionnaire' button","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 1 - JQ","Joint Questionnaire of Eurostat and OECD","for filling in"]
[null,null,"III. Quality report (Orange tabbed sheets)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"QR - Table 1 - JQ","Quality report for the Joint questionnaire of Eurostat and OECD","for filling in connection with Table 1 - JQ"]

{"sheet":"Basic Instructions","index":2,"n_rows":88,"n_cols":6,"rows_kept":88,"cut":false,"hidden":false,"merged":[[84,2,84,5],[85,2,85,5],[86,2,86,5],[87,2,87,5],[75,2,75,5],[77,2,77,5],[78,2,78,5],[79,2,79,5],[81,2,81,6],[83,2,83,5],[74,2,74,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[57,2,57,5],[58,3,58,5],[60,3,60,5],[64,2,64,5],[65,2,65,5],[66,2,66,5],[67,2,67,6],[72,2,72,6],[10,10,10,13],[10,14,10,15],[12,2,12,5],[13,2,13,5],[49,2,49,6],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[20,2,20,6],[22,2,22,5],[24,2,24,5],[28,2,28,5],[36,2,36,6],[38,2,38,5],[43,2,43,5],[14,2,14,5],[3,2,3,6],[4,2,4,6],[6,2,6,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"This questionnaire is designed to collect municipal waste statistics (joint questionnaire (JQ) of Eurostat and OECD on municipal waste statistics)."]
[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 20 November 2023"}]
[]
[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_MWJQDAT_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:",{"$f":"Lists!K14","v":"https://cros-legacy.ec.europa.eu/content/edamis_en"}]
[null,null,"   e-mail address:",{"$f":"Lists!K15","v":"ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"}]
[null,null,"   telephone:",{"$f":"Lists!K17","v":"(+352) 4301 33213"}]
[null,null,"For methodological questions please contact:"]
[null,null,"   e-mail address:",{"$f":"Lists!K18","v":"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"," Please use this flag for deliveries of table 1 that can be considered as early estimates at t+11 according to the flow chart above"]
[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,"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,{"$f":"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":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,2,14,5],[19,2,19,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[13,2,13,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"METHODOLOGY AND LEGAL ACTS"]
[null,null,"Table of contents"]
[null,null,"1. Background"]
[]
[null,null,"1. Background"]
[]
[]
[null,null,"The OECD/Eurostat questionnaires on the state of the environment are an attempt to set up worldwide coherent data collections on the main environmental issues. The OECD first established the data collection in 1980 and Eurostat joined the exercise in 1988. The United Nations Statistical Division (UNSD) set up environmental data collections that are on a more reduced scale but entirely compatible with the OECD/Eurostat Joint Questionnaire. The work on municipal waste statistics is covered by the European statistical programme 2021-27 (Regulation (EU) 2021/690)."]
[null,null,"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 table but as well on how to fill in the quality report. 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,{"$f":"Lists!K19","v":"https://ec.europa.eu/eurostat/web/waste/methodology"}]

{"sheet":"Validation rules","index":4,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[42,2,42,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[17,2,17,5],[18,2,18,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,3,11,5],[12,3,12,5],[13,2,13,5],[14,2,14,5],[15,3,15,5],[32,2,32,5],[23,2,23,5],[16,2,16,5],[39,2,39,5],[41,2,41,5],[19,2,19,5],[35,2,35,5],[36,2,36,5],[29,2,29,5],[33,2,33,5],[34,2,34,5],[20,2,20,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[31,2,31,5],[37,2,37,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"VALIDATION RULES"]
[]
[null,null,"An automatic validation tool is provided along with this questionnaire. In order to launch the validation process, please use the button \"Validate Questionnaire\", placed on the top left corner of each reporting table."]
[null,null,"The validation process evaluates a list of predefined logical and arithmetic statements, such as \"a value exists in this cell\" or \"A = A01+A02+A03\". These predefined logical and arithmetic statements are called \"Validation rules\". "]
[null,null,"When the criteria defined in a validation rule is not met, the validation process will issue a \"positive\" result (This is same terminology used for medical tests). This \"positive\" result can be an \"error\" or a \"warning\", and will be recorded in the ErrorLog sheet."]
[null,null,null,"A \"warning\" is an issue that requires the attention of the desk officer at Eurostat. It will be further analysed and it might trigger further questions to the data provider."]
[null,null,null,"An \"error\" is an issue that will trigger further question from Eurostat to the data provider and will very likely end with the request from Eurostat for a new data submission."]
[null,null,"The countries are kindly requested to launch the validation tool before submitting the questionnaire, and correct the errors highlighted in the ErrorLog sheet."]
[null,null,"Important facts to notice:"]
[null,null,null,"Empty cells are accounted as 0 in the formulas defining aggregation of data (totals)"]
[null,null,"The following validation rules are implemented by the validation tool:"]
[null,null,"Table of contents"]
[null,null,"1. Mandatory data"]
[null,null,"2. Arithmetic rules"]
[null,null,"3. Explanatory footnotes"]
[]
[]
[null,null,"1. Mandatory Data:"]
[]
[null,null,"All the information requested in the sheet \"GETTING STARTED\" must be filled in."]
[null,null,"All the mandatory cells in table \"Table 1 - JQ\" must be filled-in. Otherwise the automatic validation process will issue an \"error\" in the ErrorLog sheet."]
[null,null,"If an explanatory footnote is added for a mandatory cell, as explained in Basic Instructions sheet (3.2), the automatic validation process will accept the reporting without filling the mandatory cells."]
[]
[null,null,"2. Arithmetic rules"]
[]
[null,null,"All reported values must be equal or bigger than 0 (positive values)"]
[null,null,"\"Municipal waste treated\" must be equal to the sum of Recovery and Disposal."]
[null,null,"\"Recovery\" must be equal to the sum of Preparing for reuse, Recycling - material, Recycling - composting and digestion, Recovery - energy recovery, Recovery - other."]
[null,null,"\"Disposal\" must be equal to the sum of Disposal - incineration, Disposal - landfill and Disposal - others"]
[null,null,"\"Metal recycling from incineration bottom ash\" must be smaller than \"Recycling - material\". "]
[null,null,"\"Separate collection and recycling of biowaste at source\" must be smaller than \"Recycling - composting and digestion\"."]
[null,null,"\"Total municipal waste generated\" must be equal to the sum of Waste generated by households and Waste generated by other sources (only for OECD countries)."]
[]
[null,null,"3. Explanatory footnotes"]
[]
[null,null,"When an explanatory footnote is referenced (by means of a number selected from a drop-down list), the referenced footnote must not be empty."]

{"sheet":"GETTING STARTED","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[17,3,17,6],[19,3,19,6],[21,3,21,6],[22,2,22,6],[3,2,3,6],[4,2,4,6],[6,2,6,6],[11,2,11,6],[13,3,13,6],[15,3,15,6]]}
[]
[]
[null,null,null,null,null,null,"STATISTICAL OFFICE OF THE EUROPEAN UNION"]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):    ",null,null,null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B40,2,FALSE))","v":""}]
[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 20 November 2023"}]
[null,null,"Who is the primary contact point for annual reporting of municipal waste in your country?"]
[]
[null,null,"Name:"]
[]
[null,null,"Institution:"]
[]
[null,null,"Unit:"]
[]
[null,null,"Telephone:"]
[]
[null,null,"Email adress:"]
[null,null,"Eurostat would be grateful if you could send us the completed questionnaire ahead of the deadline. "]

{"sheet":"Footnotes list","index":6,"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":"ANNUAL REPORTING OF MUNICIPAL WASTE -\n JOINT QUESTIONNAIRE EUROSTAT/OECD"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":""}]
[null,null,null,1,"Type your text here"]
[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 1 - JQ","index":7,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,5,28,11],[29,5,29,11],[1,6,1,11],[2,6,2,11],[3,1,3,3],[3,6,3,11],[4,10,4,11],[23,5,23,11],[27,5,27,11],[26,5,26,11]]}
[]
[null,null,null,null,null,null," Generation and treatment of municipal waste (Eurostat and OECD Joint Questionnaire)\n(in this questionnaire, please only report those parts of waste that fall under the definition of municipal waste)"]
[null,null,null,null,null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",VLOOKUP('GETTING STARTED'!E9,Lists!A2:B40,2,FALSE))","v":""}]
[null,"TO HIDE",null,null,null,"Reference year: ",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2022}]
[null,"Source","waste","unit",null,"Municipal waste ","WST_OPER","UNIT","DATA","Standard footnotes","Explanatory\nfootnote"]
[null,"JQ","TOTAL","T",null,"Total municipal waste generated*","GEN","Tonnes",null,null,null,{"$f":"IF(TRIM(K6)=\"\", \"\", IF(VLOOKUP(K6,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K6,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Waste generated by households (OECD)","GEN_HH","Tonnes",null,null,null,{"$f":"IF(TRIM(K7)=\"\", \"\", IF(VLOOKUP(K7,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K7,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Waste generated by other sources (OECD)","GEN_OTH","Tonnes",null,null,null,{"$f":"IF(TRIM(K8)=\"\", \"\", IF(VLOOKUP(K8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Separate collection (of total municipal waste generated)","COL_SEP","Tonnes",null,null,null,{"$f":"IF(TRIM(K9)=\"\", \"\", IF(VLOOKUP(K9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Municipal waste treated (of the waste generated, no matter in which country)*","TRT","Tonnes",null,null,null,{"$f":"IF(TRIM(K10)=\"\", \"\", IF(VLOOKUP(K10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Recovery","RCV","Tonnes",null,null,null,{"$f":"IF(TRIM(K11)=\"\", \"\", IF(VLOOKUP(K11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Preparing for reuse","PRP_REU","Tonnes",null,null,null,{"$f":"IF(TRIM(K12)=\"\", \"\", IF(VLOOKUP(K12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Recycling - material","RCY_M","Tonnes",null,null,null,{"$f":"IF(TRIM(K13)=\"\", \"\", IF(VLOOKUP(K13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"    of which Metal recycling from incineration bottom ash","RCY_M_IBA","Tonnes",null,null,null,{"$f":"IF(TRIM(K14)=\"\", \"\", IF(VLOOKUP(K14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Recycling - composting and digestion","RCY_C_D","Tonnes",null,null,null,{"$f":"IF(TRIM(K15)=\"\", \"\", IF(VLOOKUP(K15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"    of which Separate collection and recycling of biowaste at source - e.g. home composting","COL_SEP_RCY_S","Tonnes",null,null,null,{"$f":"IF(TRIM(K16)=\"\", \"\", IF(VLOOKUP(K16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Recovery - energy recovery (R1)*","RCV_E","Tonnes",null,null,null,{"$f":"IF(TRIM(K17)=\"\", \"\", IF(VLOOKUP(K17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Recovery - other*","RCV_OTH","Tonnes",null,null,null,{"$f":"IF(TRIM(K18)=\"\", \"\", IF(VLOOKUP(K18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Disposal","DSP","Tonnes",null,null,null,{"$f":"IF(TRIM(K19)=\"\", \"\", IF(VLOOKUP(K19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null," "]
[null,"JQ","TOTAL","T",null,"Disposal - incineration (D10)*","DSP_I","Tonnes",null,null,null,{"$f":"IF(TRIM(K20)=\"\", \"\", IF(VLOOKUP(K20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Disposal - landfill (D1, D5, D12)*","DSP_L","Tonnes",null,null,null,{"$f":"IF(TRIM(K21)=\"\", \"\", IF(VLOOKUP(K21,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K21,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","T",null,"Disposal - other (D2-D4, D6-D7); (OECD)","DSP_OTH","Tonnes",null,null,null,{"$f":"IF(TRIM(K22)=\"\", \"\", IF(VLOOKUP(K22,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K22,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,"JQ","TOTAL","PC",null,"Coverage of the collection system (share of population covered by the data)","COV","%",null,null,null,{"$f":"IF(TRIM(K23)=\"\", \"\", IF(VLOOKUP(K23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(K23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,null,null,null,"*Mandatory from reference year 2020 onwards for Reporting obligations according to Commission Implementing Decisions 2019/1004 and  2019/1885 "]
[]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"White: Data provision is required."]
[null,null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,null,"Green: Variable collected only from OECD countries"]
[null,null,null,null,null,"NOTES:  The approach to producing the statistics, particularly the definition of municipal waste and recycling, should be aligned with the new reporting rules under the WFD (as set out in the guidance document and described in detail in its Annexes). Note, the grey cells sum relevant parameters automatically in the sheet. Waste generated by households and by other sources add up to total municipal waste generated. The variable separate collection is a subset of  total municipal waste generated. The waste treatment operations and related codes are indicated in the first two columns. Note that Preparation for reuse, Recycling - material, Recycling - composting and digestion, Recovery - energy recovery (R1) and Recovery - other  are subsets of total Recovery. Metal recycling from incineration bottom ash is a subset of material recycling. Separate collection and recycling of biowaste at source - e.g. home composting is a subset of Composting and digestion. Total Disposal contains the subsets Disposal - incineration (D10), Disposal - landfill (D1, D5, D12) and Disposal - other (D2-D4, D6-D7)."]
[null,null,null,null,null,"DEFINITIONS OF VARIABLES"]
[null,null,null,null,null,"•\t‘bio-waste’ means biodegradable garden and park waste, food and kitchen waste from households, offices, restaurants, wholesale, canteens, caterers and retail premises;\n•\t‘separate collection’ means the collection where a waste stream is kept separately by type and nature so as to facilitate a specific treatment;\n•\t‘treatment’ means recovery or disposal operations;\n•\t‘recovery’ means any operation the principal result of which is waste serving a useful purpose by replacing other materials which would otherwise have been used to fulfil a particular function, or waste being prepared to fulfil that function, in the plant or in the wider economy. Annex II of Directive 2008/98/EC on waste sets out a non-exhaustive list of recovery operations;\n•\t‘preparing for re-use’ means checking, cleaning or repairing recovery operations, by which products or components of products that have become waste are prepared so that they can be re-used without any other pre-processing. For example, furniture, objects, books, clothes, electric and electronic devises prepared (by means of repairing or refurbishing operations) to be reintroduced in the market;\n•\t‘recycling’ means any recovery operation by which waste materials are reprocessed into products, materials or substances whether for the original or other purposes. It includes the reprocessing of organic material but does not include energy recovery and the reprocessing into materials that are to be used as fuels or for backfilling operations;\n•\t‘disposal’ means any operation which is not recovery even where the operation has as a secondary consequence the reclamation of substances or energy. Annex I of Directive 2008/98/EC sets out a non-exhaustive list of disposal operations;"]

{"sheet":"QR Table 1 - JQ","index":8,"n_rows":147,"n_cols":14,"rows_kept":147,"cut":false,"hidden":false,"merged":[[142,0,142,11],[143,0,143,11],[144,0,144,11],[145,0,145,11],[146,0,146,11],[147,0,147,11],[136,0,136,11],[137,0,137,11],[138,0,138,11],[139,0,139,11],[140,0,140,11],[141,0,141,11],[133,1,133,2],[133,3,133,5],[133,6,133,7],[133,8,133,9],[133,10,133,11],[133,12,133,13],[132,1,132,2],[132,3,132,5],[132,6,132,7],[132,8,132,9],[132,10,132,11],[132,12,132,13],[128,10,130,11],[128,12,130,13],[129,4,129,5],[130,4,130,5],[131,1,131,2],[131,3,131,5],[131,6,131,7],[131,8,131,9],[131,10,131,11],[131,12,131,13],[128,0,130,0],[128,1,130,2],[128,3,130,3],[128,4,128,5],[128,6,130,7],[128,8,130,9],[125,0,127,0],[125,1,127,2],[125,3,127,3],[125,4,125,5],[125,6,127,7],[125,8,127,9],[124,1,124,2],[124,3,124,5],[124,6,124,7],[124,8,124,9],[124,10,124,11],[124,12,124,13],[125,10,127,11],[125,12,127,13],[126,4,126,5],[127,4,127,5],[119,3,119,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,1,123,2],[123,3,123,5],[113,12,113,13],[114,12,114,13],[115,3,115,4],[116,3,116,4],[117,3,117,4],[118,3,118,4],[123,6,123,7],[123,8,123,9],[123,10,123,11],[123,12,123,13],[109,0,109,11],[110,0,110,11],[111,0,111,11],[112,0,114,0],[112,1,114,2],[112,3,112,13],[113,3,114,5],[113,6,114,7],[113,8,114,9],[113,10,114,11],[103,3,103,11],[104,0,104,11],[105,0,105,11],[106,0,106,11],[107,0,107,11],[108,0,108,11],[96,0,96,11],[97,0,97,11],[98,0,98,11],[100,3,100,11],[101,3,101,11],[102,3,102,11],[90,0,90,11],[91,0,91,11],[92,0,92,11],[93,3,93,11],[94,3,94,11],[95,0,95,11],[84,0,84,11],[85,0,85,11],[86,0,86,11],[87,0,87,11],[88,3,88,11],[89,3,89,11],[78,0,78,11],[79,0,79,11],[80,0,80,11],[81,0,81,11],[82,2,82,11],[83,2,83,11],[72,7,72,11],[73,7,73,11],[74,7,74,11],[75,7,75,11],[76,7,76,11],[77,0,77,11],[67,0,68,0],[67,3,67,11],[68,3,68,11],[69,0,69,11],[70,0,70,11],[71,3,71,4],[71,5,71,6],[71,7,71,11],[61,0,61,11],[62,0,62,11],[63,0,63,11],[64,0,64,11],[65,0,65,11],[66,0,66,11],[55,0,55,11],[56,0,56,11],[57,0,57,11],[58,0,58,11],[59,0,59,11],[60,0,60,11],[49,0,49,11],[50,0,50,11],[51,0,51,11],[52,0,52,11],[53,0,53,11],[54,0,54,11],[42,0,42,11],[43,0,43,11],[44,0,44,11],[45,0,48,0],[45,3,45,11],[46,3,46,11],[47,3,47,11],[48,3,48,11],[36,0,36,11],[37,0,41,0],[37,3,37,11],[38,3,38,11],[39,3,39,11],[40,3,40,11],[41,3,41,11],[30,0,30,11],[31,0,31,11],[32,0,32,11],[33,0,33,11],[34,0,34,11],[35,0,35,11],[24,0,24,11],[25,0,25,11],[26,0,26,11],[27,0,27,11],[28,0,28,11],[29,0,29,11],[17,3,17,11],[18,0,18,11],[19,0,19,11],[20,0,20,11],[21,0,21,11],[22,0,23,0],[22,3,22,11],[23,3,23,11],[8,0,8,11],[9,0,9,10],[10,0,10,11],[11,0,11,11],[12,0,12,11],[13,0,17,0],[13,3,13,11],[14,3,14,11],[15,3,15,11],[16,3,16,11],[5,0,5,4],[5,5,5,11],[6,0,6,4],[6,5,6,11],[7,0,7,4],[7,5,7,11],[0,0,0,11],[1,1,1,7],[2,0,2,10],[3,0,3,4],[3,5,3,11],[4,0,4,4],[4,5,4,11]]}
["\nMunicipal Waste\nQuality report - Table 1 - JQ"]
[]
["I General information"]
["2.1. Member State"]
["2.2. Organisation submitting the data and the description"," "]
["2.3. Contact person/contact details"," "]
["2.4. Reference year"," "]
["2.5. Delivery date / version"," "]
[]
["Information on municipal waste"]
["1.Generation of Municipal Waste"]
["1.1 Municipal waste data collection: Please indicate the data sources (please mark each source used with an x)."]
[]
[null,"Written surveys"]
[null,"Administrative data"]
[null,"Data collected from waste treatment facilities"]
[null,"Data collected from municipalities"]
[null,"Other, please specify"]
["\tIn case municipal waste data is collected by a survey, please indicate the response rate"]
["1.2 Data coverage"]
["a) the data presented refer to amounts of waste (please mark with an x)"]
[]
[null,"Generated"]
[null,"Collected"]
[]
["b) In case the total population is not covered by a municipal waste collection, do you include an estimate for the amount of municipal waste generated by the un-covered population in your figure on municipal waste generation?\t"]
["If yes answer c), if no answer d)"]
["c) If yes, please provide the following information:"]
["c1) Amount of municipal waste collected (tonnes)"]
[]
["c2) How do you determine the un-covered population (number of residents /  number of households / others) and how do you estimate the amount of waste generated?"]
[]
["d) If No, why is this estimate missing?"]
[]
["1.3 Please provide in a more general way the following information:"]
["a) The data presented refer to tonnes of waste originating from "]
[]
[null,null,"tonnes"]
[null,"households"]
[null,"commerce and trade, small businesses, office buildings, institutions"]
[null,"municipal services, i.e. street and market cleaning, yard waste, litter containers"]
[null,"other (please describe)"]
[]
["b) The data presented refer to tonnes of "]
[]
[null,null,"tonnes"]
[null,"household and similar waste"]
[null,"bulky waste"]
[null,"other"]
[]
["c) Please describe in more detail the composition and sources of household/municipal waste by ticking the relevant cells in the table at the end of this document. \n\tIf you are able to estimate the share of municipal waste coming from households we would be grateful if you could provide the percentage (Note that we are aware of the involved difficulties): "]
[]
["1.4 Please explain how the distinction between municipal waste and production waste is made for packaging waste collected from businesses."]
[]
["1.5 Please explain significant methodological changes in your municipal waste data collection compared to the data delivery of last year, if any (please include in particular retrospective revisions, their nature and whether a break-flag is required for a certain year): "]
[]
["2. Treatment of municipal waste: "]
["Please provide information on the classification used for treatment operations (if a standard classification is used, just refer to its name, else please specify the available categories (in this case, you may attach a file containing a list of these categories):"]
[]
["2.1 Temporary storage may lead to time lags between waste generation and treatment. This may explain imbalances between generation and treatment reported in a given year.\n\tDoes temporary storage exist in your country to what extent \n(share of national waste generation in %):"]
[]
["Did temporary storage exist in your country in former reference years   Yes / No \n\tIf yes, please provide information on the extent (ref year / share in %) and the (most important) way of treatment after storage: (share of national waste generation in %):"]
[]
["2.2 Reporting on municipal waste treatment is broken down into four treatment operations. In case of pre-treatment (Sorting process - SP; Mechanical-Biological treatment - MBT), the reporting of the respective amounts should ideally be based on the destination of the output of the pre-treatment. \n\ta) Please state to which of the four treatment categories the reported amounts are assigned and whether input data or output data of the pre-treatment processes are reported. "]
[]
["Please mark the boxes with an x, if the following pre-treatment processes exist in your country (you may provide a comment on the relevance of these treatments or other issues):"]
[]
[null,"SP",null,"(comment)"]
[null,"MBT",null,"(comment)"]
["(If yes, please mark the relevant cell(s) with a cross)"]
[]
[null,"Possible assignments",null,"SP",null,"MBT"]
[null,null,null,"input","output","input","output"]
[null,"a)     Landfill"]
[null,"b)     Incineration (with or without energy recovery)"]
[null,"c)     Recycling"]
[null,"d)     Composting "]
[]
["b) If data are based on input, please provide information / an estimation of the share of sorting residues from the pre-treatment operations and the share of the actually recycled amount (recycling efficiency):"]
[]
["c) Based on the information provided on the classification of treatment above, please list the codes / categories used to collect data and the approximate amounts for"]
[]
["SP"]
["MBT"]
[]
["2.3 Please describe the data validation process:"]
[]
["2.4 Has municipal waste or separately collected fractions of municipal waste been sent to /from a Member State of the EU (please, mark with an x)? "]
[null,"Export"]
[null,"Import"]
["If yes, how have the reuse and recycling rates for these amounts been derived and monitored/validated?"]
[]
["2.5 Has municipal waste or separately collected fractions of municipal waste been sent to /from countries outside of the European Union (please, mark with an x)? "]
[null,"Export"]
[null,"Import"]
["If yes, how have the reuse and recycling rates for these amounts been derived and monitored/validated?"]
[]
["2.6 As a summary of the above answers, please specify by using tick marks below. The data presented refer to the amounts of waste"]
[]
[null,null,"tonnes"]
[null,"collected in the country"]
[null,"collected minus exported"]
[null,"collected plus imported"]
[null,"to be managed in the country, i.e. amounts collected plus imported amounts minus exported amounts"]
["Comment:"]
["2.7 Is the energy efficiency criterion for the differentiation of R1 and D10 according to the WFD implemented in your municipal waste data? "]
["Yes/No"]
["If the energy efficiency criterion is implemented, please state the first reference year from which the implementation of the criterion is in place:  "]
[]
["If the energy efficiency criterion is NOT implemented, please state, for which reference year the first implementation is envisaged:  "]
[]
["Table 1: Municipal waste materials and relevant sources related to section 1.3 c), please mark the relevant cell(s) with an x"]
["Waste materials","List of Waste code Com. Dec. 2000/532/EC",null,"Generated by"]
[null,null,null,"Households",null,null,"Small enterprises/ Restaurants, etc",null,"Office buildings/ institutions ",null,"Public Services",null,"Others"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(please specify)"]
[null,"Chap 20",null,"Chap 20",null,"Chap 15","Ch 20","Ch 15","Ch 20","Ch 15","Ch 20","Ch 15","Ch 20","Ch 15"]
["Paper and cardboard","20 01 01"]
["Metals","20 01 40"]
["Plastic","20 01 39"]
["Glass","20 01 02"]
["Wood","20 01 38 "]
["Textiles","20 01 10, 20 01 11 "]
["Mixed municipal waste / mixed  packaging","20 03 01"]
["Waste from markets","20 03 02"]
["Bulky waste","20 03 07"]
["Biodegradable kitchen and canteen waste","20 01 08, 20 01 25 ",null,null,"Including home-"]
[null,null,null,null,"composting?"]
[null,null,null,null,"yes….. / no…."]
["Biodegradable garden and park waste","20 02 01",null,null,"Including home-"]
[null,null,null,null,"composting?"]
[null,null,null,null,"yes …. / no…."]
["Non-biodegradable garden and park waste","20 02 03"]
["Batteries","20 01 34,  20 01 33*"]
["Discarded equipment","20 01 21*, 20 01 23*, 20 01 35*, 20 01 36"]
[]
[]
[]
["The following questions are only to be answered by the OECD Member States (if you need further clarification, please, refer to sarah.miet@oecd.org) :"]
["Municipal waste - national definition:"]
[]
["A. Comments on the level of accuracy of the data presented / Commentaires sur le niveau d’exactitude des données présentées:"]
[]
["B. Additional comments and information to help interpret the data/ Commentaires et informations supplémentaires pour aider à interpréter les données:\n[e.g. a brief explanation of the observed trends, their characteristics, and the underlying drivers (socio-economic factors, policy measures, natural factors, …), main challenges to which the country is confronted, …]\n[p.ex. une explication des tendances observées, de leurs caractéristiques et de leurs moteurs (facteurs socio-économiques, mesures politiques, facteurs naturels, …) ; principaux défis auxquels le pays est confronté, …]"]
[]
["C. Main national websites/ Principaux sites internet nationaux:"]
[]
["D. Main reference documents and publications/ Principaux documents et publications de référence: "]

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

{"sheet":"Lists","index":10,"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","Label",null,"Calculation methods",null,null,"Textual variables","String",null,"WASTE-2023-DC"]
["Belgium","BE",null,"B","break in time series",null,null,"<= Select the calculation method here",null,"Institutional names"]
["Bulgaria","BG",null,"E","estimated data",null,1,"Preparation for reuse and recycling of paper, metal, plastic and glass household waste ",null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ",null,"P","provisional",null,2,"Preparation for reuse and recycling of paper, metal, plastic, glass household waste and other single types of household waste or similar waste ",null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK",null,"BE",null,null,3,"Preparation for reuse and recycling of household waste ",null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE",null,"BP",null,null,4,"Preparation for reuse and recycling of municipal waste ",null,"Data collection information"]
["Estonia","EE",null,"EP",null,null,null,null,null,"Data Collection Text","Annual reporting of Municipal waste -\n Joint Questionnaire Eurostat/OECD"]
["Ireland","IE",null,"BEP",null,null,null,null,null,"Data Collection Year",2023]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","26 October 2023"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","20 November 2023"]
["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_MWJQDAT_A",null,"WASTE-2023-DC"]
["Cyprus","CY",null,null,null,null,null,null,null,"Web page","https://cros-legacy.ec.europa.eu/content/edamis_en"]
["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 33213"]
["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":"MacroBehaviour","index":11,"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":"Changelog","index":12,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Changed by","SheetName","Cell","Change","Version","Date","REMARKS"]
["CC","ALL",null,"Split from previous integrated Municipal Waste questionnaire",1,"2023-10-23"]

{"sheet":"Summations","index":13,"n_rows":106,"n_cols":13,"rows_kept":106,"cut":false,"hidden":true,"merged":[[7,5,7,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"]
["Warning","Table 1 - JQ","I7,I8","I6","I6",999,999,"EQ",0.1,"NO","NO",3,"Total municipal waste generated not consistent with the sum of subcomponents (only for OECD countries)."]
["Warning","Table 1 - JQ","I11,I19","I10","I10",999,999,"EQ",0.1,"NO","NO",3,"\"Municipal waste treated\" not consistent with the sum of subcomponents (Recovery and Disposal)."]
["Warning","Table 1 - JQ","I12,I13, I15,I17,I18","I11","I11",999,999,"EQ",0.1,"NO","NO",3,"\"Recovery\" not consistent with the sum of subcomponents."]
["Warning","Table 1 - JQ","I20,I21,I22","I19","I19",999,999,"EQ",0.1,"NO","NO",3,"\"Disposal\" not consistent with the sum of subcomponents"]
["Warning","Table 1 - JQ","I13","I14","I14",999,999,"LT",0.1,"NO","NO",3,"\"Metal recycling from incineration bottom ash\" must be smaller than \"Recycling - material\". If not, please provide clarifications."]
["Warning","Table 1 - JQ","I15","I16","I16",999,999,"LT",0.1,"NO","NO",3,"\"Separate collection and recycling of biowaste at source\" must be smaller than \"Recycling - composting and digestion\". If not, please provide clarifications."]
[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 or LT","GT does not admit Tolerance","NO or YES"]
[]
["DESCRIPTION"]
["This sheet is meant to define the validation for summations in a row or in a column."]
["- A block is defined as a sequence of addendums in the same row or column"]
["- Only the first block must be explicitly defined",null,null,null,null,null,null,null,null,null,null,null," "]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(Summations!B3º)","v":{"$error":"#NAME?"}}]

{"sheet":"Mandatory","index":14,"n_rows":9,"n_cols":9,"rows_kept":9,"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]
["Warning","Table 1 - JQ","I6","I6",999,999,"YES",3]
["Warning","Table 1 - JQ","I10","I10",999,999,"YES",3]
["Warning","Table 1 - JQ","I17","I17",999,999,"YES",3]
["Warning","Table 1 - JQ","I18","I18",999,999,"YES",3]
["Warning","Table 1 - JQ","I20","I20",999,999,"YES",3]
["Warning","Table 1 - JQ","I21","I21",999,999,"YES",3]

{"sheet":"MustNotBeNegative","index":15,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 - JQ","I6","I23",1,999]

{"sheet":"FootnoteContent","index":16,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Table 1 - JQ","K6","K23",1,999,1]

{"sheet":"IsNumeric","index":17,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 - JQ","I6","I23",1,999,null,null,"it is meant to check that there are numerical values"]