{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["COVER","INDEX","Basic Instructions","Methodology","Validation rules","GETTING STARTED","Footnotes list","Reporting","Quality report","ErrorLog","MacroBehaviour","Lists","Lists_Specific","Changelog","Summations","Mandatory","MustNotBeNegative","IsFormula","FootnoteContent","IsNumeric","Locks"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":49,"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 CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 22 May 2025"}]

{"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],[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":"ANNUAL REPORTING OF CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 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,"Reporting","Material recovery rate for measuring compliance with the policy target defined in Waste Framework Directive 2008/98/EC, point (b) of Article 11(2), according to the format set out in Annex IV, section C, of the Commission Implementing Decisions (EC) 2019/1004 ","for filling in. This table must be used in all cases"]
[null,null,"ErrorLog","Validation result. List of errors and warnings revealed by the validation process","For consultation"]
[null,null,"III. Quality report (Orange tabbed sheets)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Quality report","Quality report for Reporting as required by Annex IV, section D, of Commission Implementing Decision (EC) 2019/1004/EC","for filling in"]

{"sheet":"Basic Instructions","index":2,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[[89,2,89,5],[90,2,90,5],[91,2,91,5],[10,2,10,5],[85,2,85,5],[87,2,87,5],[80,2,80,5],[82,2,82,5],[84,2,84,5],[86,2,86,5],[88,2,88,5],[21,2,21,5],[13,2,13,5],[36,2,36,5],[50,2,50,5],[45,2,45,5],[19,2,19,5],[34,2,34,5],[23,2,23,5],[27,2,27,5],[41,2,41,5],[17,2,17,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[64,2,64,5],[42,2,42,5],[53,2,53,5],[48,2,48,5],[49,2,49,5],[75,2,75,5],[76,2,76,5],[70,2,70,5],[71,2,71,5],[73,2,73,5],[78,2,78,5],[79,2,79,5],[92,2,92,5],[11,2,11,5],[16,2,16,5],[14,2,14,5],[15,2,15,5],[12,2,12,5],[77,2,77,5],[62,2,62,5],[54,3,54,5],[60,2,60,5],[61,2,61,5],[66,2,66,5],[67,2,67,5],[69,2,69,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 CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"Before filling in the questionnaire please read carefully the instructions below. This EXCEL workbook is the questionnaire. Please do not  delete or add rows in the questionnaire (except where instructed in the quality report tab)."]
[null,null,{"$f":"CONCATENATE(\"Please do not  delete or add rows in the questionnaire (except where instructed in the quality report tabs). We kindly ask you to send us the data latest by \",Lists!K10)","v":"Please do not  delete or add rows in the questionnaire (except where instructed in the quality report tabs). We kindly ask you to send us the data latest by 30 June 2025"}]
[]
[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,"Table of contents"]
[null,null,"1. Data transmission"]
[null,null,"2. Reporting conventions"]
[null,null,"3. Footnotes"]
[null,null,"4. Methodology and questions"]
[null,null,"Annex I: How to fill in the data sheets of the questionnaire"]
[null,null,"Annex II: How to fill in the data sheets of the questionnaire for revisions (reference years before 2019)"]
[]
[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_CDDATA_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:",{"$f":"Lists!K17","v":0}]
[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."]
[null,null,"2. 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 to the new calculation rules. Please use this flag only when the change in methods, sources or calculation rules has a substantial impact."]
[null,null,"E) estimated data"]
[null,null,"P) provisional"]
[null,null,"To include standard footnotes use the drop-down menu. "]
[]
[null,null,"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. Methodology and questions:"]
[]
[null,null,"The guidelines to report on construction and demolition waste are available on Eurostat website:"]
[null,null,{"$f":"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":"Lists!K18","v":"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"}]
[]
[null,null,"Annex I: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"Table 'Reporting'"]
[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 report, providing as much information as possible."]
[]
[null,null,"Annex II: How to fill in the data sheets of the questionnaire  for revisions (reference years before 2019)"]
[]
[null,null,"Table 'Reporting'"]
[null,null,"1)    In 'GETTING STARTED' sheet, select the reference year for which revisions are sent"]
[null,null,"2)     All mandatory data cells for Waste generated, backfilling and Total material recovery must be filled in with a value . \n         In order to edit the cell for Total material recovery, use the button 'Unlock formulas'."]
[null,null,"3)    When running the 'Validate questionnaire', please ignore the errors related to the missing mandatory cells K8 (preparing for re-use), \n        O8 (recycling) and W8 (other material recovery) in the ‘ErrorLog’ worksheet. Any other error should be corrected."]
[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 report, providing as much information as possible."]

{"sheet":"Methodology","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[31,2,31,5],[27,2,27,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[22,2,22,5],[26,2,26,5],[9,2,9,5],[17,2,17,5],[19,2,19,5],[10,2,10,5],[14,2,14,5],[15,2,15,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 CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 DATA COLLECTION"}]
[]
[null,null,"METHODOLOGY AND LEGAL ACTS"]
[null,null,"Table of contents"]
[null,null,"1. Background"]
[null,null,"2. Legal acts"]
[null,null,"3. Data reporting - questionnaire"]
[]
[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 construction and demolition waste on the environment. "]
[null,null,"Commission Decision of 18 November 2011 establishing rules and calculation methods for verifying compliance with the targets set in Article 11(2) of Directive 2008/98/EC of the European Parliament and of the Council (2011/753/EU)\", which specifies the scope of the reporting and the \"calculation methods\"."]
[]
[null,null,"This Excel reporting template allows Member States to report construction and demolition waste pursuant to the requirements of Commission Implementing Decisions (EU) 2019/1004."]
[]
[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 table and 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 be 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"}]
[]
[null,null,"2.  Legal acts"]
[]
[null,null,"Waste Framework Directive 2008/98/EC of the European Parliament and the Council."]
[null,null,"Commission Decision of 18 November 2011 (2011/753/EU)."]
[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. \nIt includes reporting requirements for construction and demolition waste. "]
[null,null,"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."]
[null,null,"The legislation is available here:"]
[null,null,{"$f":"Lists!K20","v":"https://ec.europa.eu/eurostat/web/waste/legislation"}]
[]
[]
[null,null,"3. Data reporting - questionnaire"]
[]
[null,null,"This document assists Member States to report high quality, harmonised and efficient statistics on construction and demolition waste according to the format set out in Annex IV, section C, of the Commission Implementing Decisions 2019/1004 . Detailed instructions can be found in the guidance document referred to above."]
[null,null,"The reporting shall cover a full calendar year."]
[null,null,"The Basic Instructions sheet consists of some information necessary for filling in this questionnaire correctly, like allowed symbols, metadata, footnotes, and transmission to Eurostat while the country codes, reference years are included in the GETTING STARTED sheet."]
[null,null,"The Commission Implementing Decision (EU) 2019/1004 , Annex IV, section D, establishes a quality report and sets out its format,  that needs to be completed, see sheet 'Quality report'. These questions are necessary to understand the data collection methodology used by the country and the coverage of the data transmitted which in turn will allow for better comparison of data across countries."]

{"sheet":"Validation rules","index":4,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[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],[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]]}
[]
[]
[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 CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 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 \"Reporting\" 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,"Recycling must be smaller than generation"]
[null,null,"Backfilling must be smaller than generation"]
[null,null,"\"Other material recovery\" must be smaller than generation"]
[null,null,"\"Preparing for re-use\" must be smaller than generation"]
[null,null,"\"Total material recovery\" must be smaller than generation"]
[null,null,"\"Total material recovery\" is equal to Recycling + Backfilling + \"Other material recovery\" + \"Preparing for reuse\" (automatically calculated in the Reporting and not editable)\n"]
[]
[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,"ANNUAL REPORTING OF CONSTRUCTION AND DEMOLITION WASTE"]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):    ",null,"Finland",null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B40,2,FALSE))","v":"FI"}]
[null,null,"Reference year:    ",null,2023]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 June 2025"}]
[null,null,"Who is the primary contact point for the data collection 'Annual reporting of construction and demolition waste' in your country?"]
[]
[null,null,"Name:","Pia Högmander"]
[]
[null,null,"Institution:","Finnish Environment Institute"]
[]
[null,null,"Unit:","Circular economy solutions"]
[]
[null,null,"Telephone:","+358 295 252 028"]
[]
[null,null,"Email adress:","pia.hogmander@syke.fi"]
[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 CONSTRUCTION AND DEMOLITION WASTE"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2025 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[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":"Reporting","index":7,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,6,1,29],[4,6,4,8],[14,5,14,10],[11,5,11,13],[5,7,6,7],[5,11,6,11],[5,15,6,15],[5,19,6,19],[5,23,6,23],[5,27,6,27],[5,8,6,9],[5,12,6,13],[5,16,6,17],[5,20,6,21],[5,24,6,25],[5,28,6,29]]}
[]
[null,null,null,null,null,null,"Reporting of the implementation of point (b) of Article 11(2) of Directive 2008/98/EC, concerning construction and demolition\n according to the format set out in Annex IV of the Commission Implementing Decisions 2019/1004"]
[null,null,null,null,null,"Country:",{"$f":"'GETTING STARTED'!G9","v":"FI"},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,null,null,"Reference year:",{"$f":"'GETTING STARTED'!E10","v":2023}]
[null,null,null,"calcmeth",null,"Calculation method (1)","REGL_2150_2002",null,null,{"$f":"IF(G5=\"\",\"<= Select the calculation method here\",VLOOKUP(G5,Lists_Specific!A2:B4,2,FALSE))","v":"Data based on Regulation  (EC)  No  2150/2002"}]
[null,null,null,null,null,null,"Waste generated","Standard footnotes","Explanatory\nfootnote",null,"Preparing for re-use","Standard footnotes","Explanatory\nfootnote",null,"Recycling","Standard footnotes","Explanatory\nfootnote",null,"Backfilling","Standard footnotes","Explanatory\nfootnote",null,"Other material recovery(2) ","Standard footnotes","Explanatory\nfootnote",null,"Total material recovery(3)","Standard footnotes","Explanatory\nfootnote"]
[null,null,null,"wst_oper",null,null,"GEN",null,null,null,"PRP_REU",null,null,null,"RCV_R",null,null,null,"RCV_B",null,null,null,"RCV_OTH",null,null,null,"RCV"]
[null,null,null,"UNIT","T","Tonnes",1346120,null,null,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},89905,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},588158,null,null,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},48246,null,null,{"$f":"IF(TRIM(U8)=\"\", \"\", IF(VLOOKUP(U8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K8,O8,S8,W8))=\"\",\"\",SUM(K8,O8,S8,W8))","v":726309},null,null,{"$f":"IF(TRIM(AC8)=\"\", \"\", IF(VLOOKUP(AC8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(AC8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"(1) Data pursuant to Annex III Decision 2011/753/EU based on Regulation  (EC)  No  2150/2002 or reporting system of the Member State, chose from drop-down-menu in cell G5:\nREGL_2150_2002 = data based on Regulation  (EC)  No  2150/2002\nRS_MS = data based on Reporting system of the Member State\n"]
[null,null,null,null,null,"(2) This includes material recovery other than preparing for re-use, recycling and backfilling."]
[null,null,null,null,null,"(3) This is the sum of the amounts reported under preparing for re-use, recycling, backfilling and other material recovery.\n"]
[null,null,null,null,null,"\n(3) This is the sum of the amounts reported under preparing for re-use, recycling, backfilling and other material recovery.\n"]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,null,"Light orange: footnotes (only to be filled-in when relevant)"]
[null,null,null,null,null,"Grey: The calculation of data is automatic and cannot be edited."]

{"sheet":"Quality report","index":8,"n_rows":96,"n_cols":12,"rows_kept":96,"cut":false,"hidden":false,"merged":[[12,1,12,11],[6,0,6,11],[5,0,5,11],[4,0,4,11],[20,0,20,11],[64,0,64,11],[81,0,81,11],[49,0,49,11],[50,0,50,11],[21,0,21,11],[32,0,32,11],[33,0,33,11],[28,0,28,11],[29,0,29,11],[42,0,42,11],[30,0,30,11],[40,0,40,11],[39,0,39,11],[38,0,38,11],[37,0,37,11],[36,0,36,11],[35,0,35,11],[34,0,34,11],[31,0,31,11],[58,5,58,6],[59,5,59,6],[55,7,55,8],[56,7,56,8],[72,0,72,11],[80,0,80,11],[73,1,73,11],[74,1,74,11],[75,1,75,11],[76,1,76,11],[77,1,77,11],[78,1,78,11],[79,1,79,11],[58,1,58,2],[59,1,59,2],[58,3,58,4],[65,0,68,11],[71,0,71,11],[63,0,63,11],[55,1,55,2],[56,1,56,2],[57,1,57,2],[59,3,59,4],[55,3,55,4],[95,0,95,11],[89,0,89,11],[84,1,84,11],[85,1,85,11],[86,1,86,11],[87,1,87,11],[88,1,88,11],[90,0,90,11],[94,0,94,11],[0,3,0,7],[10,1,10,11],[11,1,11,11],[19,0,19,11],[13,1,13,11],[14,1,14,11],[83,0,83,11],[41,0,41,11],[43,0,43,11],[82,0,82,11],[69,0,69,11],[51,0,51,11],[61,0,61,11],[52,1,52,2],[52,3,52,4],[57,7,57,8],[58,7,58,8],[59,7,59,8],[55,9,55,10],[56,9,56,10],[57,9,57,10],[58,9,58,10],[59,9,59,10],[52,5,52,6],[22,4,22,6],[22,10,22,11],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[23,4,23,6],[24,4,24,6],[25,4,25,6],[26,4,26,6],[27,4,27,6],[22,7,22,9],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[23,10,23,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[53,1,53,2],[54,1,54,2],[53,3,53,4],[54,3,54,4],[44,3,44,8],[44,9,44,11],[45,9,45,11],[46,9,46,11],[47,9,47,11],[48,9,48,11],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[45,3,45,8],[46,3,46,8],[47,3,47,8],[48,3,48,8],[56,3,56,4],[57,3,57,4],[55,5,55,6],[56,5,56,6],[57,5,57,6],[52,7,52,8],[52,9,52,10],[53,9,53,10],[54,9,54,10],[53,7,53,8],[54,7,54,8],[53,5,53,6],[54,5,54,6]]}
[null,null,null,"Construction and demolition waste\nQUALITY REPORT"]
[null,null,null,null,null,null,null,null,null,"STATISTICAL OFFICE OF THE EUROPEAN UNION"]
[null,null," "]
[]
["1. Objective of the report"]
["The objective of this report is to gather information on the data compilation methods and coverage of the submitted data. The report should allow a better understanding of the approaches taken by Member States as well as the possibilities and limits of data comparability across countries."]
["The structure of the quality report follows the structure set out in Commission Implementing Decision (EU) 2019/1004 in most cases. Where there are some differences the intention of the Act is maintained. However, changes have been introduced to ensure the responses are more accurate and easier to fill in by the Member States. Please aim to complete the QR as it is structured, if it is not possible to provide the relevant information explain the reasons why."]
[]
[]
["2. General information"]
["2.1. Member State","Finland"]
["2.2. Organisation submitting the data and the description","Statistics Finland"]
["2.3. Contact person/contact details","Mr. Juha Espo (juha.espo@stat.fi)"]
["2.4. Reference year",2023]
["2.5. Delivery date / version","2025-06-26"]
[]
[]
[]
["3. Information on construction and demolition waste"]
["3.1.  How are the amounts of generated construction and demolition waste determined? How do those amounts relate to data reported on the basis of Regulation (EC) No 2150/2002?"]
["3.1.1 Methodology description:"]
["C&D waste calculating method for WFD reporting is the same as for WStatReg. -reporting. Same data sources and methodology. For surplus soils we use data from transport statistics to estimate the national total generated, and use environmental authorities YLVA-register data for identifying the different waste types and treatments. For non soil C&D waste, the YLVA-register data is used. Treatment is counted from the facilities treating the waste, not pretreating. Pretreatment facilities are on large scale covered by the YLVA-register so it can be used for additional checks. We assume facilities follow the instructions to use WFD reporting/calculating rules when reporting the material recovery. There is many similarites in the methodology of counting municipal waste and C&D waste amounts because we don't have data from the generation sites but from the sites pre-/treating the waste. For energy recovery counts, which are not asked to report in WFD -reporting, but needed for checking if the generated totals are OK, the preparing of RDF in pretreatment facilities is counted in order to better identify the source of energy recovered RDF; is it's nature of origin from MW or C&D or industrial waste. Only the soils transported from C&D sites are taken as soil to be included in to waste statistics, otherwise the use is taken as internal recycling if recovered where it was excavated. We have done years ago some studies on the share of waste soil among all transported soil, and we use this percentage as a coefficient for calculating the waste status soil share from all professinally transported soils during the reference year.  This total is then allocated to different treatments and classified to be NH or HZ using the YLVA-register data. From YLVA we can find all landfilled soils and their classification. HZ classified soils must be treated in facilities included in the YLVA register data, their amount can be added to HZ part of the soil also. Allso a lot of mildly contaminated but non HZ soils can be found from the YLVA register if such soils are transported and recovered in bigger construction sites. All the rest surplus soil for which we can't find treatment from YLVA we assume to be just landfilled to sites where soil landfilling is accepted if the soil is not heavily polluted. We lag information of some material recovery sites which were not applied an environmental permit and which recovery as substituting virgin soil is  allowed according our other legislation. That kind of material recovery for substituting virgin soil in construction and building sites may be underestimated. We hope we can in the furure get more info on  that particular part recovered but interpreted now as landfilled. There is a register data for these recoverysites for mildly contaminated non HZ soils and some other C&D wastes like clean concrete or tiles and bricks but the register don't collect data annually, but just after the building site has ended the building/contruction phase and is taken to the regular use.  "]
["Data Sources","Type of data collection",null,null,"Statistical entities",null,null,"Waste nomenclature",null,null,"Frequency"]
["Environmental administration, YLVA-register","register data",null,null,"faclities with environmental permit for waste treatment",null,null,"LoW",null,null,"annual"]
["Statistics Finland, transport statistics for transported soil and stones","questionnaire",null,null,"professional traffic trucks",null,null,"classification of transported items",null,null,"quarterly, summed up to annual"]
[]
[]
["Add rows as appropriate"]
["3.1.2 Description of sampling survey:"]
["C&D waste calculation for soil and stones, based on Statistics Finland's survey and modelling: Estimation of soil and stones classified as waste and transported uses aggregated tables from transport statistics, description for the methodology of transport statistics can be found from Statistics Finland webpages https://www.stat.fi/en/statistics/documentation/kttav."]
["3.1.3 Methodological changes compared to previous reporting (if any):"]
["No"]
["3.2.  How are the data on preparing for re-use, recycling, backfilling and other recovery compiled? "]
["General description: In the YLVA-data a separate treatment code for backfilling has been added from 2017 onwards. We can separate preparation for reuse as a separate treatment from recycling year 2022 onwards because class for it was added to the YLVA -registerdata. Recycling and other recovery are defined using national more detailed version of R/D-codes and we can also separate true recovery from pretreatment using national more detailed version of R-codes."]
["3.2.1 List of Waste codes (LoW) used for the compilation of C&D waste recovery"]
["LoW codes are the ones aggregated to WStatReg EWCStat-aggregates included in to the reporting obligations and rules (2011/753/EU). Only exception is that for EWCStat entry 12.1 included is only waste from origin of NACE F. Other entries in our system may have observations of 17-class waste from other NACE-activities also like from renovations and repairs, and the wastecodes are reported by facilities where the waste is generated, in their  annual reporting to YLVA-register, not by the construction and buildin NACE companies hired to do the job. In our system data reporting forms for facilities have a variable with information if the waste was generated in an 'action' classified as construction or demolition. Facilities receiving C&D-waste can thus provide such information to register data. "]
[]
[]
[]
[]
["Add rows as appropriate"]
["3.2.2 Description of how the definition of backfilling laid down in Article 3(17a) of Directive 2008/98/EC is applied in your country in the context of reporting on construction and demolition waste"]
["In the YLVA-register, we use as a source for most C&D-waste data, a separate treatment code for backfilling has been added from 2017 onwards."]
["3.2.3 Description of the different waste treatment operations reported under the category ‘other recovery’ in the Reporting and their share (%)."]
["Description of waste treatment operation",null,null,"Type of waste",null,null,null,null,null,"Share on Other recovery (%)"]
["If this point asks definition for Other Material Recovery-column in the reporting form, we can't recognise any recent recovery operation defined and covered by R/D-codes to be classified under this item. "]
[]
[]
["Add rows if needed"]
["3.2.4 Methodological changes compared to previous reporting (if any):"]
[]
["3.2.5 Reporting by material (on voluntary basis)"]
["Material","Generated waste\n(t)",null,"Preparing for re-use\n(t)",null,"Recycling\n(t)",null,"Backfilling\n(t)",null,"Other material recovery\n(t)",null,"Total material recovery\n(t)"]
["Mineral C&D waste"]
["Metal waste"]
["Glass waste"]
["Plastic waste"]
["Wood waste"]
["Other waste1)"]
["Total"]
["1) Please specify. Add rows as appropriate"]
["3.3. Are the data based on the input to preliminary treatment facilities? Yes/No"]
[null,"Yes",null,"No",null,"Partially"]
["Comments: "]
["If yes, please provide information on the efficiency of preliminary treatment:"]
["Most data is from final treatment facilities, only such treatments as pretreatment prior energy recovery are taken from pretreatment facilities. Pretreatment data is used for cross checkings etc. if needed. No data calculated for the efficiency of pretreatment facilities. Facilities are advised to follow reporting obligations of WFD, so we assume that material recovery is reported correctly."]
[]
[]
[]
["3.4. Are the data based on the input to the final material recovery process? Yes/No"]
[null,"Yes",null,"No",null,"Partially"]
["Comments: Most data is from final treatment facilities, only such treatments as pretreatment prior energy recovery are taken from pretreatment facilities. Pretreatment data is used for cross checkings etc. if needed. No data calculated for the efficiency of pretreatment facilities. Facilities are advised to follow reporting obligations of WFD, so we assume that material recovery is reported correctly."]
["If yes,  please specify the points of measurement by material if possible:"]
["Material","Points of measurement"]
["Mineral C&D waste"]
["Metal waste"]
["Glass waste"]
["Plastic waste"]
["Wood waste"]
["Other waste1)"]
["1) Please specify. Add rows if needed"]
["3.5. Please describe the data validation process"]
["General description: Most data is from final treatment facilities, only such treatments as pretreatment prior energy recovery are taken from pretreatment facilities. Pretreatment data is used for cross checkings etc. if needed. No data calculated for the efficiency of pretreatment facilities. Facilities are advised to follow reporting obligations of WFD, so we assume that material recovery is reported correctly. Validation is done as with municipal waste reporting data from YLVA-register, look at the municipal waste QR. Because register data, it has been checked by facilities, register data receiving phase authorities at regional environmental authorities level and finally by Statistics Finland compiling the statistics in its own workflow for this data. Validation in Statistics Finland includes automated and manual stages, comparing to previous years, both on individual facilities and aggregated level."]
["3.5.1 Please specify the validation checks and the quality issues with regard to the following aspects:"]
["Completeness and full coverage of data collection"]
["Outliers"]
["Classification errors"]
["Identification of double-counting, in particular with regard to recovery"]
["Changes over time"]
["3.6. Has waste been"]
["(a) shipped to another Member State?"]
[null,"Yes",null,"No"]
["(b) exported out of the Union for treatment?"]
[null,"Yes",null,"No"]
["If yes, how have the reuse and recycling rates and the recovery rates for those shipped or exported amounts been derived and monitored/validated?"]
["When compiling waste statistics we are not able to check the final destinations or first origin of recorder waste streams. Available is information of import or export of waste records in YLVA-register covering almost all professional weaste treatment facilities so we can separate those streams from other streams efficiently. We have not calculated separate counts for export/import of C&D waste streams in our data nor calculated the share of intra EU/ex EU streams. There is not such reporting obligation in EU. Statistics Finland doesn't have data on reuse of products, and reuse of products and import/export for reuse don't effect waste statistics. For export for recovery, most such steams are assumed to be handled by facilities included in the YLVA-data, but it is possible that some amounts of C&D waste is pretreated and sent abroad by generating facilities themselves, without any brokers or pretreratment companies involved, and if the waste is so called green list waste, then we haven't been able to monitor such streams.  Waste streams regulated under producer rersponsibility legislation are reported to regional environmental authorities and aggregated reports are compiled by Pirkanmaan ELY-keskus, but there is not available any estimations how much C&D waste is included in these streams and exported. To sum up, if a facility informs that it has sent abroad waste for recovery, we must assume all the amount to be treated as it is in told in the report, without any possibility to find out are pretreatment losses taken in account or not."]

{"sheet":"ErrorLog","index":9,"n_rows":8,"n_cols":7,"rows_kept":8,"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,12566463]

{"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":"Lists","index":11,"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,"Code","Description",null,"Textual variables","String",null,"WASTE-2025-DC"]
["Belgium","BE",null,"B","break in time series",null,"C","confidential",null,"Institutional names"]
["Bulgaria","BG",null,"E","estimated data",null,"D","secondary confidentiality set by the sender",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","Annual reporting of construction and demolition waste"]
["Ireland","IE",null,"BEP",null,null,null,null,null,"Data Collection Year",2025]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","22 May 2025"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","30 June 2025"]
["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_CDDATA_A",null,"WASTE-2023-DC"]
["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"]

{"sheet":"Lists_Specific","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Data based on "]
[null,"<= Select the calculation method here"]
["REGL_2150_2002","Data based on Regulation  (EC)  No  2150/2002"]
["RS_MS","Data based on Reporting system of the Member State"]

{"sheet":"Changelog","index":13,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Changed by","SheetName","Cell","Change","Version","Date","REMARKS"]
["CDD","ALL","ALL","Widely adapt to 2021 style and conventions","00m16","29/03/2021"]
["CDD","Reporting","AA8","Change summation formulas","00m16","29/03/2021"]
["CDD",null,null,"Add Macros v17","00m16","29/03/2021","CDD: I forgot to change the macro version in the filename."]
["CDD",null,null,"Add validation Specific Settings Sheests (SSS)","00m16","29/03/2021"]
["CDD","Validation rules",null,"Add new introductory text to validation rules sheet","01m17","2021-03-31"]
["CDD",null,null,"Change macro version name to v17","01m17","2021-03-31","CDD: Change of version name. Macros were changed before (see line 4)"]
["CC","Metadata",null,"Deleted the sheet Metadata","02m17","2021-04-12"]
["CC","Reporting",null,"1) updated codes for calculation method in the footnotes and in the drop-down menu","02m17","2021-04-12"]
["CC","Reporting","G5","2) Updated the protection of the cell G5 (must be editable)","02m17","2021-04-12"]
["CC","Mandatory",null,"Added cell G5 from reporting","02m17","2021-04-12"]
["CC","Basic Instructions",null,"1) In Annex: How to fill in the data sheets of the questionnaire deleted point 2) on voluntary data","02m17","2021-04-12"]
["CC","Basic Instructions",null,"2) Deleted rows from 43 to 46 referring to Metadata","02m17","2021-04-12"]
["CC","Basic Instructions",null,"3) Deleted rows 69 to 70 referring to Packaging and packaging waste","02m17","2021-04-12"]
["CC","Basic Instructions",null,"4) Row 61 deleted reference to sheet Metadata","02m17","2021-04-12"]
["CC","Validation rules",null,"1) Changed line 39 referring to Total material recovery (value is calculated automatically)","02m17","2021-04-12"]
["CC","Index",null,"1) Deleted row 22, Metadata","02m17","2021-04-12"]
["CC","Summations",null,"1) Changed the severity of errors to warning.","02m17","2021-04-12"]
["CC","Summations",null,"2) Proposed additional text in the Display text in error","02m17","2021-04-12"]
["CC","Summations",null,"3) I’d delete the row 2 (check on Total material recovery = to the sum of the recovery waste operations ) because this quantity is calculated and the cell is not editable.","02m17","2021-04-12"]
["CDD","Several pages",null,"Hyperlinks to the same sheet have been removed","03m18","2021-04-14"]
["CDD",null,null,"Change macro version v18","03m18","2021-04-14"]
["CDD",null,null,"Change password","03m18","2021-04-14"]
["CDD","Input data tables",null,"Change default sheet protection in input tables: allow selection of locked cells.","03m18","2021-04-14"]
["CDD","Summations","K:L","Add columns for \"Non compliance Is Valid If Footnote Exists\" and \"Footnote Shift From Value\"","03m18","2021-04-20"]
["CDD","Reporting/Locks",null,"Add button to unlock/lock formulas // Add \"locks\" sheet (hidden)","06m18","2021-06-07"]

{"sheet":"Summations","index":14,"n_rows":107,"n_cols":13,"rows_kept":107,"cut":false,"hidden":true,"merged":[[8,5,8,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","Reporting","K8,O8,S8,W8","AA8","AA8",999,999,"EQ",0.1,"NO","NO",3,"Total material recovery not consistent to the sum of subcomponents"]
["Warning","Reporting","G8","K8","K8",999,999,"LT",0.1,"NO","NO",3,"\"Preparing for reuse\" must be smaller than \"Generation\". If not, please provide clarifications."]
["Warning","Reporting","G8","O8","O8",999,999,"LT",0.1,"NO","NO",3,"\"Recycling\" must be smaller than \"Generation\". If not, please provide clarifications."]
["Warning","Reporting","G8","S8","S8",999,999,"LT",0.1,"NO","NO",3,"\"Backfilling\" must be smaller than \"Generation\". If not, please provide clarifications."]
["Warning","Reporting","G8","W8","W8",999,999,"LT",0.1,"NO","NO",3,"\"Other material recovery\" must be smaller than \"Generation\". If not, please provide clarifications."]
["Warning","Reporting","G8","AA8","AA8",999,999,"LT",0.1,"NO","NO",3,"\"Total material recovery\" must be smaller than Generation. 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"]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(Summations!B3º)","v":{"$error":"#NAME?"}}]

{"sheet":"Mandatory","index":15,"n_rows":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]
["Error","Reporting","G5","G5",999,999,"NO",3]
["Error","Reporting","G8","G8",999,999,"YES",3]
["Error","Reporting","K8","K8",999,999,"YES",3]
["Error","Reporting","O8","O8",999,999,"YES",3]
["Error","Reporting","S8","S8",999,999,"YES",3]
["Error","Reporting","W8","W8",999,999,"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","Reporting","G8","AA8",1,4]

{"sheet":"IsFormula","index":17,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step"]
["Info","Reporting","AA8","AA8",999,999]

{"sheet":"FootnoteContent","index":18,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Reporting","I8","AC8",1,4,1]

{"sheet":"IsNumeric","index":19,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Reporting","G8","AA8",1,4,null,null,"it is meant to check that there are numerical values"]

{"sheet":"Locks","index":20,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To"]
["Reporting","AA8","AA8",999,999,"Formulas","G8"]