{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["COVER","INDEX","Basic Instructions","Methodology","Validation rules","GETTING STARTED","Footnotes list","Table_1","Table_1 (Prefilling)","Table_2","Table_2 (Prefilling)","VoluntaryReporting","ErrorLog","Changelog","Pre-filling parameters","Lists","Locks","NotStandardRules","CannotBeZero","Thresholds","IsFormula - cancelled","Summations","SimpleRatios","Mandatory","MustNotBeNegative","FoototeContent","IsNumeric"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":4,"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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 2 June 2022"}]

{"sheet":"INDEX","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[14,2,14,4],[1,2,1,4],[3,2,3,4],[4,2,4,4],[6,2,6,4],[8,2,8,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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 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","Explanatory notes and methodology","for reading before filling in the questionnaire"]
[null,null,"Validation rules","Validation rules","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","Monitoring Compliance for Directive 2006/66/EC on batteries and accumulators and waste batteries and accumulators","for filling in. "]
[null,null,"Table 2","Monitoring Compliance for Directive 2006/66/EC on batteries and accumulators and waste batteries and accumulators Recyling Efficiencies of the recycling processes on waste batteries and accumulators according to REG 493/2012","for filling in"]
[null,null,"Voluntary reporting","Voluntary declarations on stocks, shipments and landfilling and voluntary answers on JRC questions on possible further disaggregations by type of battery ","for filling in, voluntary reporting"]
[null,null,"ErrorLog","Validation result. List of errors and warnings revealed by the validation process","for checking accurately before submitting"]

{"sheet":"Basic Instructions","index":2,"n_rows":93,"n_cols":6,"rows_kept":93,"cut":false,"hidden":false,"merged":[[81,2,81,5],[82,2,82,5],[76,2,76,5],[78,2,78,5],[74,2,74,5],[34,2,34,5],[39,2,39,5],[40,2,40,5],[61,2,61,5],[44,2,44,5],[46,2,46,5],[48,2,48,5],[49,2,49,5],[50,2,50,5],[53,2,53,5],[59,2,59,5],[60,2,60,5],[41,2,41,5],[42,2,42,5],[16,2,16,5],[19,2,19,5],[21,2,21,5],[25,2,25,5],[32,2,32,5],[18,2,18,5],[14,2,14,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[63,2,63,5],[65,2,65,5],[66,2,66,5],[68,2,68,5],[69,2,69,5],[70,2,70,5],[71,2,71,5],[91,2,91,5],[92,2,92,5],[89,2,89,5],[90,2,90,5],[88,2,88,5],[85,2,85,5],[86,2,86,5],[87,2,87,5],[79,2,79,5],[80,2,80,5],[84,2,84,5],[83,2,83,5],[72,2,72,5],[77,2,77,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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"Before filling in the questionnaire please read carefully the instructions below and the latest version of the document \"Compiling guidance for the new reporting format of BATT Excel questionnaire\" available at the methodology link. 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,"This questionnaire includes tables 1 to 2 according to Commission Regulation 493/2012 laying down, pursuant to Directive 2006/66/EC, detailed rules regarding the calculation of recycling efficiencies of the recycling processes of waste batteries and accumulators ."]
[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: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"1. Data transmission:"]
[]
[null,null,"Before transmitting the data, it is mandatory to proceed with the validation by pressing the button Validate questionnaire on the top left corner of each table. It is mandatory to verify the ErrorLog sheet and provide explanatory footnotes or corrections for all the errors. The validation rules are explained in detail in sheet Validation Rules."]
[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_BATTDAT_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://webgate.ec.europa.eu/edamis/helpcenter/website/index.htm"}]
[null,null,"   e-mail address:",{"$f":"Lists!K15","v":"estat-support-edamis@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!K20","v":"https://ec.europa.eu/eurostat/web/waste/legislation"}]
[]
[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"]
[null,null,"2. Dark grey shaded boxes: prefilled data coming from previous year, to facilitate prevalidation; these data cannot be changed and inserted; in the case modifications are needed, please contact Eurostat"]
[null,null,"3. Light blue shaded boxes: provision of data is voluntary"]
[null,null,"4. Light grey shaded boxes: usually these cells contain a formula and the calculation is automatic; in this questionnaire these cells are never locked to permit the prefilling of the questionnaire. Therefore, please do not input any data into these cells if you prefer to have the automatic calculation. In any case, the validation process is highlighting errors and is warning about any inserted value differing from the expected formulas. Finally, inserting manually a formula that differs from the original one is forbidden."]
[]
[null,null,"3. Footnotes:"]
[]
[null,null,"You are asked to report data that follow as closely as possible batteries and accumulators and waste batteries and accumulators definitions and reporting rules. Please report problems with the coverage or data quality in the Quality Report document."]
[]
[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,"E) Estimated data"]
[null,null,"D) Definition differs, see metadata"]
[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 standard footnotes."]
[null,null,"To include an 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 document."]
[]
[null,null,"4. Methodology and questions:"]
[]
[null,null,"The guidelines to report on packaging and packaging 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,"A summary methodology is presented in this questionnaire, in the sheet named 'Methodology'. It is essential to read this sheet before filling in the questionnaire as it contains, beside the summary methodology, important information on priorities for filling in the tables, data sources and hints for establishing a methodology at national level."]
[null,null,"Annual reporting of batteries and accumulators and waste batteries and accumulators has to be reported according to Commission Regulation 493/2012, by transmitting via eDAMIS this annual data reporting and the methodology report."]
[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,"You are kindly requested to fill in all the four tables belonging to this questionnaire."]
[null,null,"5.1 Tables 1 to 2"]
[null,null,"1)     All the cells that include mandatory data should be filled in with a value. In the questionnaire all these cells are uncoloured."]
[null,null,"2)     When mandatory data is not reported, an explanatory footnote must be provided. If the explanation is extensively explained in the quality report, please add an explanatory footnote with the text \"See Quality report, section xxxxx\" or alike. This explanatory footnote is only meant for validation purposes and database storage. The official details on unreported data, whenever required, shall be reported in the quality report.  "]
[null,null,"3)     It is possible to insert decimal numbers. The display of decimal positions is limited to 3 decimal places. It is recommended to use all the decimal places when this information is available."]
[null,null,"4)     Zero values in this data collection are rare events. It is possible to report zeroes, but it is necessary to insert an explanatory footnote."]
[null,null,"5)     To include standard footnotes use the drop-down menu."]
[null,null,"6)     The text of explanatory footnotes can be entered in the worksheet 'Footnotes list'."]
[null,null,"7)     Provide the quality report, providing all mandatory explanations and any additional or available information related to the data collection. Please remember that the Quality Report has to be transmitted as a separate file, via dataset name  WASTE_BATTMTH_A"]
[null,null,"8)     Moreover, please pay attention to the following legislation, applied to specific indicators reported in the data tables, that will arise the constraints described in the validation rules"]
[null,null,"TABLE 1: collection rate\nCalculation of the collection rate should be made according to Annex I of Directive 2006/66/EC by the formula (to be provided in percentage)\n     CR(Y)=3*C(Y)/(S(Y-2)+S(Y-1)+S(Y))\nwhere: CR(Y) is the collection rate calculated for year Y, C(Y) is the collected total battery waste in year Y, S(Y) is the total of battery sales occurred in year Y, S(Y-1) is the total of battery sales occurred in the year Y-1 (the year before year Y), S(Y-2) is the total of battery sales occurred in the year Y-2 (two years before year Y);\nin this excel questionnaire it is implemented as\n     [Collection rate(%) in year T] = [Collection (Tonnes) in year T] * 100 / Average [Sales (Tonnes) in years T, T-1, T-2]"]
[null,null,"TABLE 2: recycling efficiency\nCalculation of the recycling efficiency should be made according to Annex I of Commission Regulation 493/2012 by the formula (to be provided in percentage)\n     Re=Moutput/Minput\nwhere, for each waste battery type: Re is the recycling efficiency calculated for year Y, as the ratio of the total Moutput (total mass per type of waste battery accounting for recycling in year Y) divided by the Minput (total mass per type of waste battery entering the recycling facilities in year Y), where the mass is provided in tonnes; \nthe recycling efficiencies has to be calculated separately for the current waste battery types: lead, nickel-cadmium and other batteries; \nin this excel questionnaire it is implemented as"]
[null,null,"Recycling efficiency (%) = Moutput, total (Tonnes) * 100 / Minput, total (Tonnes)."]
[null,null,"TABLE 2: rate of recycled lead content\nCalculation of the recycled lead content should be made according to Annex II of Commission Regulation 493/2012 by the formula (to be provided in percentage)\n     RPb=MoutputPb/MinputPb\nwhere, for each waste battery type: RPb is the rate of recycled lead calculated for year Y, as the ratio of the total MoutputPb (the mass of Pb in output fractions accounting for recycling that is the share of Pb contained in these fractions which results from the recycling of lead-acid batteries and accumulators in year Y) divided by the MinputPb (the mass of Pb in the input fraction entering the battery recycling process that is defined as the yearly average Pb content of waste lead-acid batteries and accumulators multiplied by the input mass of lead-acid batteries and accumulators in year Y),  where the mass is provided in tonnes; \nthe rate of recycled lead content has to be calculated on the waste lead-acid battery type; \nin this excel questionnaire it is implemented as"]
[null,null,"    Rate of recycled lead content (degree of recycled Pb) (%) = Moutput, Pb (Tonnes) * 100 / Minput, Pb (Tonnes)."]
[null,null,"TABLE 2: rate of recycled cadmium content\nCalculation of the recycled lead content should be made according to Annex II of Commission Regulation 493/2012 by the formula (to be provided in percentage)\n     RCd=MoutputCd/MinputCd\nwhere, for each waste battery type: RCd is the rate of recycled cadmium calculated for year Y, as the ratio of the total MoutputCd (the mass of Cd in output fractions accounting for recycling that is the share of Cd contained in these fractions which results from the recycling of nickel-cadmium batteries and accumulators in year Y) divided by the MinputCd (the mass of Cd in the input fraction entering the battery recycling process that is defined as the yearly average Cd content of waste nickel-cadmium batteries and accumulators multiplied by the input mass of  nickel-cadmium batteries and accumulators in year Y),  where the mass is provided in tonnes; \nthe rate of recycled cadmium content has to be calculated on the waste nickel-cadmium battery type; \nin this excel questionnaire it is implemented as"]
[null,null,"    Rate of recycled cadmium content (degree of recycled Cd) (%) = Moutput, Cd (Tonnes) * 100 / Minput, Cd (Tonnes)."]

{"sheet":"Methodology","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,2,9,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5],[10,2,10,5],[12,2,12,5],[14,2,14,5],[19,2,19,5],[22,2,22,5],[24,2,24,5],[21,2,21,5],[17,2,17,5],[16,2,16,5],[15,2,15,5],[31,2,31,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 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 Directive 2006/66/EC in order to:"]
[null,null,"- prevent or reduce the placing on the market of batteries and accumulators containing hazardous substances, "]
[null,null,"- provide specific rules for the collection, treatment, recycling and disposal of waste batteries and accumulators,"]
[null,null,"- promote a high level of collection and recycling of waste batteries and accumulators."]
[]
[null,null,"This reporting template allows Member States to report recycling efficiencies of the recycling processes of waste batteries and accumulators according to Commission Regulation 493/2012 laying down, pursuant to Directive 2006/66/EC of the European Parliament and of the Council, detailed rules regarding the calculation of recycling efficiencies of the recycling processes of waste batteries and accumulators."]
[]
[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,"Directive 2006/66/EC of the European Parliament and of the Council of 6 September 2006 on batteries and accumulators and waste batteries and accumulators and repealing Directive 91/157/EEC, as last amended."]
[null,null,"Commission Regulation (EU) No 493/2012 of 11 June 2012 laying down, pursuant to Directive 2006/66/EC of the European Parliament and of the Council, detailed rules regarding the calculation of recycling efficiencies of the recycling processes of waste batteries and accumulators."]
[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 recycling efficiencies of the recycling processes of waste batteries and accumulators according to Commission Regulation 493/2012. 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 country codes, reference years, unit of measure, allowed symbols, metadata, footnotes, and transmission to Eurostat."]
[null,null,"The quality report has to be transmitted as a separate file, via eDAMIS under dataset name WASTE_BATTMTH_A, it should contain methodology and coverage of the data collection, according to the guidance document referred to above. "]

{"sheet":"Validation rules","index":4,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[[10,2,10,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[8,2,8,5],[9,2,9,5],[25,2,25,5],[11,3,11,5],[12,3,12,5],[13,2,13,5],[14,2,14,5],[15,3,15,5],[16,3,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[23,2,23,5],[32,2,32,5],[35,3,35,5],[36,3,36,5],[26,2,26,5],[27,2,27,5],[29,2,29,5],[31,2,31,5],[33,2,33,5],[34,3,34,5],[51,2,51,5],[53,2,53,5],[43,3,43,5],[37,2,37,5],[45,3,45,5],[48,3,48,5],[49,3,49,5],[39,3,39,5],[40,3,40,5],[47,3,47,5],[46,3,46,5],[38,3,38,5],[44,3,44,5],[41,3,41,5],[42,3,42,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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 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,null,"It is possible to supersede the automatic calculation of formulas. In this questionnaire, all the cells are unlocked. In case of prefilling of previous years, the formulas are substituted with the reported value. Please have a look at sheet \"Basic instructions\" and at the comments in the tables to see the source of the formula arising from the legislation. "]
[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,"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 tables 1 and 2 must be filled-in. Otherwise the automatic vaiidation process will issue an \"error\" in the ErrorLog sheet."]
[null,null,"In case the mandatory data is not available please add an explanatory footnote providing a justification for failing to provide a mandatory figure. In this case, the automatic validation process will display a \"warning\" issue in the error log. This explanatory footnote is only meant for validation purposes and database storage. The official details on unreported data, whenever required, shall be reported in the quality report.  "]
[]
[null,null,"2. Arithmetic rules"]
[]
[null,null,"All reported values must be bigger than 0 (positive values)"]
[null,null,"Zero values will trigger an \"error\" unless the justification is described by an explanatory footnote."]
[null,null,"TABLE_1: "]
[null,null,null,"Collection rate(%) in a year T must be equal to the waste collected in tonnes in year T, multiplied by 100 and then divided by the average of the sales made in the years T, T-1, T-2, as in this formula:\n[Collection rate(%) in year T] = [Collection (Tonnes) in year T] * 100 / Average [Sales (Tonnes) in years T, T-1, T-2]   \nIf the reported value does not correspond or if the value is higher than 100: please provide an explanation in the explanatory footnote and in the quality report"]
[null,null,null,"When voluntary amounts are reported: for each year, Sales (Tonnes) for Portable batteries and accumulators should be the sum of Lead batteries, Ni-Cd Batteries and Other batteries and accumulators (if the reported value does not correspond, please provide an explanation in the explanatory footnote and in the quality report); if at least two out of three disaggregated value are missing, Sales (Tonnes) for Portable batteries and accumulators can be higher than the sum (if the reported value does not correspond, please provide an explanation in the explanatory footnote and in the quality report)."]
[null,null,null,"When voluntary amounts are reported: for each year, Collection (Tonnes) for Portable batteries and accumulators should be the sum of  Lead batteries, Ni-Cd Batteries and Other batteries and accumulators (if the reported value does not correspond, please provide an explanation in the explanatory footnote and in the quality report); if at least two out of three disaggregated value are missing,  Collection (Tonnes) for Portable batteries and accumulators can be higher than the sum (if the reported value does not correspond, please provide an explanation in the explanatory footnote and in the quality report)."]
[null,null,"TABLE_2: "]
[null,null,null,"These formulas are applied in the validation process when calculating the recycling efficiencies and the rates of recycled metals:\n"]
[null,null,null,"    Recycling efficiency (%) = Moutput, total (Tonnes) * 100 / Minput, total (Tonnes)."]
[null,null,null,"    Rate of recycled lead content (degree of recycled Pb) (%) = Moutput, Pb (Tonnes) * 100 / Minput, Pb (Tonnes)."]
[null,null,null,"    Rate of recycled cadmium content (degree of recycled Cd) (%) = Moutput, Cd (Tonnes) * 100 / Minput, Cd (Tonnes)."]
[null,null,null,"Any deviation from those values will issue an error message highlighted in the sheet \"ErrorLog\", that you must justify in the explanatory footnote and in the quality report document. When the justification in the footnote is provided, a warning may still appear.\nFinally, the rates are higher than 100%, an error message will appear: please correct the values, as the Minputs must be higher than the Moutputs."]
[null,null,null,"Mass outputs cannot be higher than mass inputs; in the case of the cadmium content recycling, the mass Moutput, Cd may be equal to the Minput (as of the current state of the art, the recycling technology in cadmium content permits the full recycling of the cadmium fraction)."]
[null,null,null,"The following two rules applies to lead batteries and accumulators: the lead content of lead batteries is arising from the sole fraction of treated material that is containing lead, once the rest of parts and materials (for instance the battery's chassis) have been separated from the fraction containing lead; if the reported values do not respect this rule, please provide an  explanation in the explanatory footnote and in the quality report:"]
[null,null,null,"   Input mass (Minput, total) for lead batteries must be higher than input mass for lead content of lead batteries (Minput, Pb)."]
[null,null,null,"   Output mass (Moutput, total) for lead batteries must be higher than output mass for lead content of lead batteries (Moutput, Pb)."]
[null,null,null,"The following two rules applies to nickel cadmium batteries and accumulators: the cadmium content of Ni-Cd batteries is arising from the sole fraction of treated material that is containing cadmium, once the rest of parts and materials (for instance the battery's chassis) have been separated from the fraction containing cadmium; if the reported values do not respect this rule, please provide an  explanation in the explanatory footnote and in the quality report:"]
[null,null,null,"   Input mass (Minput, total) for Ni-Cd batteries must be higher than input mass (Minput, Cd) for cadmium content of cadmium batteries."]
[null,null,null,"   Output mass (Moutput, total) for Ni-Cd batteries must be higher than output mass (Moutput, Cd) for cadmium content of cadmium batteries."]
[]
[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":[[22,2,22,6],[3,2,3,6],[4,2,4,6],[13,3,13,6],[15,3,15,6],[17,3,17,6],[19,3,19,6],[21,3,21,6],[11,2,11,6],[6,2,6,6]]}
[]
[]
[null,null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):",null,"Luxembourg",null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B40,2,FALSE))","v":"LU"}]
[null,null,"Reference year:    ",null,2020]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 June 2022"}]
[null,null,{"$f":"\"Who is the primary contact point for the data collection '\" &  Lists!K7&\"' in your country?\"","v":"Who is the primary contact point for the data collection 'Annual reporting on batteries and accumulators and waste batteries and accumulators' in your country?"}]
[]
[null,null,"Name:","Fabien Wahl"]
[]
[null,null,"Institution:","Administration de l'environnement"]
[]
[null,null,"Unit:","Unité Surveillance et évaluation de l'environnement"]
[]
[null,null,"Telephone:","40 56 56 - 1"]
[]
[null,null,"Email adress:","fabien.wahl@aev.etat.lu"]
[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 ON BATTERIES AND ACCUMULATORS AND WASTE BATTERIES AND ACCUMULATORS"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Luxembourg"}]
[null,null,null,1,"14@rounding error"]
[null,null,null,2,"The data for 2015 and 2016 only has a precision of 1 decimal. Since 2017 Luxembourg uses a precision of 3 decimals."]
[null,null,null,3,"The number of Ni-Cd batteries put on the market dropped over the last years but there are still Ni-Cd batteries collected"]
[null,null,null,4,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."]
[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","index":7,"n_rows":29,"n_cols":29,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,4,20,5],[28,4,28,5],[25,4,25,5],[23,4,23,5],[24,4,24,5],[27,4,27,5],[26,4,26,5],[16,4,18,4],[6,16,6,17],[6,20,6,21],[6,24,6,25],[3,26,5,28],[3,4,3,25],[7,4,9,4],[10,4,12,4],[13,4,15,4],[6,8,6,9],[6,12,6,13]]}
[]
[]
[]
[null,null,null,null,"TABLE 1: Monitoring Compliance for Directive 2006/66/EC on batteries and accumulators and waste batteries and accumulators\nCollection of Portable Batteries and Accumulators",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLAUSIBILITY WARNINGS"]
[null,null,null,null,"Country:",{"$f":"'GETTING STARTED'!G9","v":"LU"},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Luxembourg"}]
[null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2020}]
[null,null,null,null,null,null,{"$f":"CONCATENATE((F6-4),CHAR(10),\"(not editable)\")","v":"2016\n(not editable)"},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"CONCATENATE((F6-3),CHAR(10),\"(not editable)\")","v":"2017\n(not editable)"},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-2","v":2018},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-1","v":2019},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6","v":2020},"Standard footnotes","Explanatory\nfootnote",null,"Time series analysis against reference year","Reference year analysis","Previous years"]
["T","W1606B","MKT",null,"Portable batteries and accumulators\n(W1606B)","Sales (Tonnes)",196.05,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":""},200.67,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":""},209.32900000000001,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":""},241.91900000000001,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":""},261.43747499999995,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(ISNUMBER(W8), IF(ABS(W8-AVERAGE(G8, K8, O8,S8))>0.1*(W8+AVERAGE(G8, K8, O8,S8)),\"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years\",\"The percentage difference is below 20%\"),\"Warning: mandatory cell is empty, please provide value or explanation\")","v":"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years"},null,{"$f":"CONCATENATE(IF(ISNUMBER(S8), IF(ABS(S8-AVERAGE(G8, K8, O8,W8))>0.1*(S8+AVERAGE(G8, K8, O8,W8)),\"Warning: there is a percentage difference higher than 20% between cell S8 and the average of the other 4 years \",\"\"),\"Warning: mandatory cell S8 is empty, please provide value or explanation \"), IF(ISNUMBER(O8), IF(ABS(O8-AVERAGE(G8, K8, S8,W8))>0.1*(O8+AVERAGE(G8, K8, S8,W8)),\"Warning: there is a percentage difference higher than 20% between cell O8 and the average of the other 4 years\",\"\"),\"Warning: mandatory cell O8 is empty, please provide value or explanation\"))","v":""}]
["T","W1606B","COL",null,null,"Collection (Tonnes)",113.95,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},108.706,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},139.923,null,null,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},155.721,null,null,{"$f":"IF(TRIM(U9)=\"\", \"\", IF(VLOOKUP(U9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},162.70788899999997,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years",null,{"$f":"CONCATENATE(IF(ISNUMBER(S9), IF(ABS(S9-AVERAGE(G9, K9, O9,W9))>0.1*(S9+AVERAGE(G9, K9, O9,W9)),\"Warning: there is a percentage difference higher than 20% between cell S9 and the average of the other 4 years \",\"\"),\"Warning: mandatory cell S9 is empty, please provide value or explanation \"), IF(ISNUMBER(O9), IF(ABS(O9-AVERAGE(G9, K9, S9,W9))>0.1*(O9+AVERAGE(G9, K9, S9,W9)),\"Warning: there is a percentage difference higher than 20% between cell O9 and the average of the other 4 years\",\"\"),\"Warning: mandatory cell O9 is empty, please provide value or explanation\"))","v":""}]
["PC","W1606B","COL",null,null,"Collection rate (%)",63.37,null,1,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"14@rounding error"},57.305,null,2,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The data for 2015 and 2016 only has a precision of 1 decimal. Since 2017 Luxembourg uses a precision of 3 decimals."},69.262,null,2,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The data for 2015 and 2016 only has a precision of 1 decimal. Since 2017 Luxembourg uses a precision of 3 decimals."},71.66,null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(W9=\"\",CONCATENATE(O8,S8,W8)=\"\"),\"\",W9*100/AVERAGE(O8,S8,W8))","v":68.490755616985155},null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(W10), IF((W10<45),\"Warning: please check reported values, the target of 45% is not reached\",IF((W10>100),\"Warning: the rate should be below 100, explanatory footnote required\", \"The country has reached 45% in collection rate\")),\"Warning: mandatory cell is empty, please provide value\")","v":"The country has reached 45% in collection rate"},{"$f":"CONCATENATE(IF(ISNUMBER(S10), IF(ABS(S10-AVERAGE(G10, K10, O10,W10))>0.1*(S10+AVERAGE(G10, K10, O10,W10)),\"Warning: there is a percentage difference higher than 20% between cell S10 and the average of the other 4 years \",\"\"),\"Warning: mandatory cell S10 is empty, please provide value or explanation \"), IF(ISNUMBER(O10), IF(ABS(O10-AVERAGE(G10, K10, S10,W10))>0.1*(O10+AVERAGE(G10, K10, S10,W10)),\"Warning: there is a percentage difference higher than 20% between cell O10 and the average of the other 4 years\",\"\"),\"Warning: mandatory cell O10 is empty, please provide value or explanation\"))","v":""}]
["T","W160601","MKT",null,"Lead batteries\n(W160601) (*)","Sales (Tonnes)",null,null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},6.5620000000000003,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},3.4159999999999999,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},3.702,null,null,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},3.246839,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(ISNUMBER(W11), IF(ABS(W11-AVERAGE(G11, K11, O11,S11))>0.1*(W11+AVERAGE(G11, K11, O11,S11)),\"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years\",\"The percentage difference is below 20%\"),\"Info: voluntary cell is empty, if available please provide value\")","v":"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years"},null,{"$f":"CONCATENATE(IF(ISNUMBER(S11), IF(ABS(S11-AVERAGE(G11, K11, O11,W11))>0.1*(S11+AVERAGE(G11, K11, O11,W11)),\"Warning: there is a percentage difference higher than 20% between cell S11 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S11 is empty, if available please provide value \"), IF(ISNUMBER(O11), IF(ABS(O11-AVERAGE(G11, K11, S11,W11))>0.1*(O11+AVERAGE(G11, K11, S11,W11)),\"Warning: there is a percentage difference higher than 20% between cell O11 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O11 is empty, if available please provide value \"))","v":"Warning: there is a percentage difference higher than 20% between cell O11 and the average of the other 4 years"}]
["T","W160601","COL",null,null,"Collection (Tonnes)",null,null,null,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},2.8679999999999999,"E",null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},3.6909999999999998,null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},3.9239999999999999,null,null,{"$f":"IF(TRIM(U12)=\"\", \"\", IF(VLOOKUP(U12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},2.9250100000000003,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,{"$f":"CONCATENATE(IF(ISNUMBER(S12), IF(ABS(S12-AVERAGE(G12, K12, O12,W12))>0.1*(S12+AVERAGE(G12, K12, O12,W12)),\"Warning: there is a percentage difference higher than 20% between cell S12 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S12 is empty, if available please provide value  \"), IF(ISNUMBER(O12), IF(ABS(O12-AVERAGE(G12, K12, S12,W12))>0.1*(O12+AVERAGE(G12, K12, S12,W12)),\"Warning: there is a percentage difference higher than 20% between cell O12 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O12 is empty, if available please provide value \"))","v":"Warning: there is a percentage difference higher than 20% between cell S12 and the average of the other 4 years "}]
["PC","W160601","COL",null,null,"Collection rate (%)",null,null,null,{"$f":"IF(TRIM(I13)=\"\", \"\", IF(VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},57.558,null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},74.899000000000001,null,null,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},86.052999999999997,null,null,{"$f":"IF(TRIM(U13)=\"\", \"\", IF(VLOOKUP(U13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(W12=\"\",CONCATENATE(O11,S11,W11)=\"\"),\"\",W12*100/AVERAGE(O11,S11,W11))","v":84.661517655990608},null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(W13), IF((W13>100),\"Warning: the rate should be below 100, explanatory footnote required\",\"\"),\"Info: voluntary cell is empty, if available please provide value\")","v":""},{"$f":"CONCATENATE(IF(ISNUMBER(S13), IF(ABS(S13-AVERAGE(G13, K13, O13,W13))>0.1*(S13+AVERAGE(G13, K13, O13,W13)),\"Warning: there is a percentage difference higher than 20% between cell S13 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S13 is empty, if available please provide value  \"), IF(ISNUMBER(O13), IF(ABS(O13-AVERAGE(G13, K13, S13,W13))>0.1*(O13+AVERAGE(G13, K13, S13,W13)),\"Warning: there is a percentage difference higher than 20% between cell O13 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O13 is empty, if available please provide value \"))","v":""}]
["T","W160602","MKT",null,"Ni-Cd Batteries\n(W160602) (*)","Sales (Tonnes)",null,null,null,{"$f":"IF(TRIM(I14)=\"\", \"\", IF(VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},2.698,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1.448,null,null,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1.3380000000000001,null,null,{"$f":"IF(TRIM(U14)=\"\", \"\", IF(VLOOKUP(U14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1.222934,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years",null,{"$f":"CONCATENATE(IF(ISNUMBER(S14), IF(ABS(S14-AVERAGE(G14, K14, O14,W14))>0.1*(S14+AVERAGE(G14, K14, O14,W14)),\"Warning: there is a percentage difference higher than 20% between cell S14 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S14 is empty, if available please provide value  \"), IF(ISNUMBER(O14), IF(ABS(O14-AVERAGE(G14, K14, S14,W14))>0.1*(O14+AVERAGE(G14, K14, S14,W14)),\"Warning: there is a percentage difference higher than 20% between cell O14 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O14 is empty, if available please provide value \"))","v":"Warning: there is a percentage difference higher than 20% between cell S14 and the average of the other 4 years "}]
["T","W160602","COL",null,null,"Collection (Tonnes)",null,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},7.5129999999999999,"E",null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},9.6709999999999994,null,null,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},8.6039999999999992,null,null,{"$f":"IF(TRIM(U15)=\"\", \"\", IF(VLOOKUP(U15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},11.750472,null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years",null,{"$f":"CONCATENATE(IF(ISNUMBER(S15), IF(ABS(S15-AVERAGE(G15, K15, O15,W15))>0.1*(S15+AVERAGE(G15, K15, O15,W15)),\"Warning: there is a percentage difference higher than 20% between cell S15 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S15 is empty, if available please provide value  \"), IF(ISNUMBER(O15), IF(ABS(O15-AVERAGE(G15, K15, S15,W15))>0.1*(O15+AVERAGE(G15, K15, S15,W15)),\"Warning: there is a percentage difference higher than 20% between cell O15 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O15 is empty, if available please provide value \"))","v":""}]
["PC","W160602","COL",null,null,"Collection rate (%)",null,null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},227.196,null,3,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The number of Ni-Cd batteries put on the market dropped over the last years but there are still Ni-Cd batteries collected"},382.10199999999998,null,3,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The number of Ni-Cd batteries put on the market dropped over the last years but there are still Ni-Cd batteries collected"},470.678,null,3,{"$f":"IF(TRIM(U16)=\"\", \"\", IF(VLOOKUP(U16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The number of Ni-Cd batteries put on the market dropped over the last years but there are still Ni-Cd batteries collected"},{"$f":"IF(OR(W15=\"\",CONCATENATE(O14,S14,W14)=\"\"),\"\",W15*100/AVERAGE(O14,S14,W14))","v":879.32143557364623},null,3,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"The number of Ni-Cd batteries put on the market dropped over the last years but there are still Ni-Cd batteries collected"},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 4 years",{"$f":"IF( ISNUMBER(W16), IF((W16>100),\"Warning: the rate should be below 100, explanatory footnote required\",\"\"),\"Info: voluntary cell is empty, if available please provide value\")","v":"Warning: the rate should be below 100, explanatory footnote required"},{"$f":"CONCATENATE(IF(ISNUMBER(S16), IF(ABS(S16-AVERAGE(G16, K16, O16,W16))>0.1*(S16+AVERAGE(G16, K16, O16,W16)),\"Warning: there is a percentage difference higher than 20% between cell S16 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S16 is empty, if available please provide value  \"), IF(ISNUMBER(O16), IF(ABS(O16-AVERAGE(G16, K16, S16,W16))>0.1*(O16+AVERAGE(G16, K16, S16,W16)),\"Warning: there is a percentage difference higher than 20% between cell O16 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O16 is empty, if available please provide value \"))","v":"Warning: there is a percentage difference higher than 20% between cell O16 and the average of the other 4 years"}]
["T","W160605","MKT",null,"Other batteries and accumulators\n(W160605) (*)","Sales (Tonnes)",null,null,null,{"$f":"IF(TRIM(I17)=\"\", \"\", IF(VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},191.41,null,null,{"$f":"IF(TRIM(M17)=\"\", \"\", IF(VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},204.465,null,null,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},236.87899999999999,null,null,{"$f":"IF(TRIM(U17)=\"\", \"\", IF(VLOOKUP(U17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},256.96770199999997,null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,{"$f":"CONCATENATE(IF(ISNUMBER(S17), IF(ABS(S17-AVERAGE(G17, K17, O17,W17))>0.1*(S17+AVERAGE(G17, K17, O17,W17)),\"Warning: there is a percentage difference higher than 20% between cell S17 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S17 is empty, if available please provide value  \"), IF(ISNUMBER(O17), IF(ABS(O17-AVERAGE(G17, K17, S17,W17))>0.1*(O17+AVERAGE(G17, K17, S17,W17)),\"Warning: there is a percentage difference higher than 20% between cell O17 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O17 is empty, if available please provide value \"))","v":""}]
["T","W160605","COL",null,null,"Collection (Tonnes)",null,null,null,{"$f":"IF(TRIM(I18)=\"\", \"\", IF(VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},98.325000000000003,"E",null,{"$f":"IF(TRIM(M18)=\"\", \"\", IF(VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},126.56100000000001,null,null,{"$f":"IF(TRIM(Q18)=\"\", \"\", IF(VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},143.19300000000001,null,null,{"$f":"IF(TRIM(U18)=\"\", \"\", IF(VLOOKUP(U18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},148.03240699999998,null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,{"$f":"CONCATENATE(IF(ISNUMBER(S18), IF(ABS(S18-AVERAGE(G18, K18, O18,W18))>0.1*(S18+AVERAGE(G18, K18, O18,W18)),\"Warning: there is a percentage difference higher than 20% between cell S18 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S18 is empty, if available please provide value  \"), IF(ISNUMBER(O18), IF(ABS(O18-AVERAGE(G18, K18, S18,W18))>0.1*(O18+AVERAGE(G18, K18, S18,W18)),\"Warning: there is a percentage difference higher than 20% between cell O18 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O18 is empty, if available please provide value \"))","v":""}]
["PC","W160605","COL",null,null,"Collection rate (%)",null,null,null,{"$f":"IF(TRIM(I19)=\"\", \"\", IF(VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},54.201000000000001,null,null,{"$f":"IF(TRIM(M19)=\"\", \"\", IF(VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},65.05,null,null,{"$f":"IF(TRIM(Q19)=\"\", \"\", IF(VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},67.89,null,null,{"$f":"IF(TRIM(U19)=\"\", \"\", IF(VLOOKUP(U19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(W18=\"\",CONCATENATE(O17,S17,W17)=\"\"),\"\",W18*100/AVERAGE(O17,S17,W17))","v":63.595844051887298},null,null,{"$f":"IF(TRIM(Y19)=\"\", \"\", IF(VLOOKUP(Y19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(W19), IF((W19>100),\"Warning: the rate should be below 100, explanatory footnote required\",\"\"),\"Info: voluntary cell is empty, if available please provide value\")","v":""},{"$f":"CONCATENATE(IF(ISNUMBER(S19), IF(ABS(S19-AVERAGE(G19, K19, O19,W19))>0.1*(S19+AVERAGE(G19, K19, O19,W19)),\"Warning: there is a percentage difference higher than 20% between cell S19 and the average of the other 4 years \",\"\"),\"Info: voluntary cell S19 is empty, if available please provide value  \"), IF(ISNUMBER(O19), IF(ABS(O19-AVERAGE(G19, K19, S19,W19))>0.1*(O19+AVERAGE(G19, K19, S19,W19)),\"Warning: there is a percentage difference higher than 20% between cell O19 and the average of the other 4 years\",\"\"),\"Info: voluntary cell O19 is empty, if available please provide value \"))","v":""}]
[]
[null,null,null,null,"Notes: "]
[]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,"Dark grey: Pre-filled by Eurostat. Non-modifiable data. It appears only for information. If you need to change the non-modifiable data please contact Eurostat."]
[null,null,null,null,"Light grey: these cells usually contain formulas, but can be overwritten by the users as they are not locked; in case of prefilling, the formulas are substituted with the reported value. "]
[null,null,null,null,"Light blue (cyan): Data provision is voluntary."]
[null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,"(*) The Commission encourages countries to provide voluntary data on the disaggregated amounts of Sales, Collection and Collection Rates for Lead (W160601), Nickel-Cadmium (W160602) and other batteries and accumulators (W160605); Eurostat acknowledges that the quality of voluntary data is not as high as expected for mandatory data."]

{"sheet":"Table_1 (Prefilling)","index":8,"n_rows":29,"n_cols":25,"rows_kept":29,"cut":false,"hidden":true,"merged":[[3,4,3,25],[6,16,6,17],[6,20,6,21],[6,24,6,25],[7,4,9,4],[6,12,6,13],[26,4,26,5],[27,4,27,5],[28,4,28,5],[6,8,6,9],[23,4,23,5],[24,4,24,5],[10,4,12,4],[13,4,15,4],[16,4,18,4],[20,4,20,5],[25,4,25,5]]}
[]
[]
[]
[null,null,null,null,"TABLE 1: PREFILLING"]
[null,null,null,null,"Country:",{"$f":"'GETTING STARTED'!G9","v":"LU"},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Luxembourg"}]
[null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2020}]
[null,null,null,null,null,null,{"$f":"CONCATENATE((F6-4),CHAR(10),\"(not editable)\")","v":"2016\n(not editable)"},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"CONCATENATE((F6-3),CHAR(10),\"(not editable)\")","v":"2017\n(not editable)"},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-2","v":2018},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-1","v":2019},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6","v":2020},"Standard footnotes","Explanatory\nfootnote"]
["T","W1606B","MKT",null,"Portable batteries and accumulators\n(W1606B)","Sales (Tonnes)",196.05,null,null,null,200.67,null,null,null,209.32900000000001,null,null,null,241.91900000000001]
["T","W1606B","COL",null,null,"Collection (Tonnes)",113.95,null,null,null,108.706,null,null,null,139.923,null,null,null,155.721]
["PC","W1606B","COL",null,null,"Collection rate (%)",63.37,null,null,"14@rounding error",57.305,null,null,"The data for 2015 and 2016 only has a precision of 1 decimal. Since 2017 Luxembourg uses a precision of 3 decimals.",69.262,null,null,"The data for 2015 and 2016 only has a precision of 1 decimal. Since 2017 Luxembourg uses a precision of 3 decimals.",71.66]
["T","W160601","MKT",null,"Lead batteries\n(W160601) (*)","Sales (Tonnes)",null,null,null,null,6.5620000000000003,null,null,null,3.4159999999999999,null,null,null,3.702]
["T","W160601","COL",null,null,"Collection (Tonnes)",null,null,null,null,2.8679999999999999,"E",null,null,3.6909999999999998,null,null,null,3.9239999999999999]
["PC","W160601","COL",null,null,"Collection rate (%)",null,null,null,null,57.558,null,null,null,74.899000000000001,null,null,null,86.052999999999997]
["T","W160602","MKT",null,"Ni-Cd Batteries\n(W160602) (*)","Sales (Tonnes)",null,null,null,null,2.698,null,null,null,1.448,null,null,null,1.3380000000000001]
["T","W160602","COL",null,null,"Collection (Tonnes)",null,null,null,null,7.5129999999999999,"E",null,null,9.6709999999999994,null,null,null,8.6039999999999992]
["PC","W160602","COL",null,null,"Collection rate (%)",null,null,null,null,227.196,null,null,"The number of Ni-Cd batteries put on the market dropped over the last years",382.10199999999998,null,null,"The number of Ni-Cd batteries put on the market dropped over the last years",470.678,null,null,"The number of Ni-Cd batteries put on the market dropped over the last years"]
["T","W160605","MKT",null,"Other batteries and accumulators\n(W160605) (*)","Sales (Tonnes)",null,null,null,null,191.41,null,null,null,204.465,null,null,null,236.87899999999999]
["T","W160605","COL",null,null,"Collection (Tonnes)",null,null,null,null,98.325000000000003,"E",null,null,126.56100000000001,null,null,null,143.19300000000001]
["PC","W160605","COL",null,null,"Collection rate (%)",null,null,null,null,54.201000000000001,null,null,null,65.05,null,null,null,67.89]
[]
[null,null,null,null,"Notes: "]
[]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,"Dark grey: Pre-filled by Eurostat. Non-modifiable data. It appears only for information. If you need to change the non-modifiable data please contact Eurostat."]
[null,null,null,null,"Light grey: these cells usually contain formulas, but can be overwritten by the users as they are not locked; in case of prefilling, the formulas are substituted with the reported value. "]
[null,null,null,null,"Light blue (cyan): Data provision is voluntary."]
[null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,"(*) The Commission encourages countries to provide voluntary data on the disaggregated amounts of Sales, Collection and Collection Rates for Lead (W160601), Nickel-Cadmium (W160602) and other batteries and accumulators (W160605); Eurostat acknowledges that the quality of voluntary data is not as high as expected for mandatory data."]

{"sheet":"Table_2","index":9,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,4,26,5],[27,4,27,5],[28,4,28,5],[3,18,5,20],[6,16,6,17],[6,12,6,13],[6,8,6,9],[3,5,3,17],[19,4,21,4],[7,4,9,4],[10,4,12,4],[13,4,15,4],[16,4,18,4]]}
[]
[]
[]
[null,null,null,null,null,"TABLE 2: Monitoring Compliance for Directive 2006/66/EC on batteries and accumulators and waste batteries and accumulators\nRecyling Efficiencies of the recycling processes on waste batteries and accumulators according to REG 493/2012\n",null,null,null,null,null,null,null,null,null,null,null,null,"PLAUSIBILITY WARNINGS"]
[null,null,null,null,"Country:",{"$f":"'GETTING STARTED'!G9","v":"LU"},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Luxembourg"}]
[null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2020}]
[null,null,null,null,null,null,{"$f":"F6-2","v":2018},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-1","v":2019},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6","v":2020},"Standard footnotes","Explanatory\nfootnote",null,"Time series analysis against reference year","Reference year analysis","Previous years"]
["T","W160601","RCY_INP",null,"Lead batteries\n(W160601)","Minput, total (Tonnes)",1842.0409999999999,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":""},1807.7329999999999,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":""},1603.5129999999999,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":""},{"$f":"IF(ISNUMBER(O8), IF(ABS(O8-AVERAGE(G8,K8))>0.1*(O8+AVERAGE(G8,K8)),\"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 2 years\",\"The percentage difference is below 20%\"),\"Warning: mandatory cell is empty, please provide value or explanation\")","v":"The percentage difference is below 20%"},null,{"$f":"CONCATENATE(IF(ISNUMBER(G8),IF(ABS(G8-AVERAGE(K8,O8))>0.1*(G8+AVERAGE(K8,O8)),\"Warning: there is a percentage difference higher than 20% between column G and the average of the other 2 years \",\"\"),\"Warning: mandatory cell in column G is empty, please provide value or explanation \"),IF(ISNUMBER(K8),IF(ABS(K8-AVERAGE(G8,O8))>0.1*(K8+AVERAGE(G8,O8)),\"Warning: there is a percentage difference higher than 20% between column K and the average of the other 2 years \",\"\"),\"Warning: mandatory cell in column K is empty, please provide value or explanation \"))","v":""}]
["T","W160601","RCY",null,null,"Moutput, total (Tonnes)",1688.393,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1543.7909999999999,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1364.8264919999997,null,null,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(ISNUMBER(O9), IF(ABS(O9-AVERAGE(G9,K9))>0.1*(O9+AVERAGE(G9,K9)),\"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 2 years\",\"The percentage difference is below 20%\"),\"Warning: mandatory cell is empty, please provide value or explanation\")","v":"The percentage difference is below 20%"},null,{"$f":"CONCATENATE(IF(ISNUMBER(G9),IF(ABS(G9-AVERAGE(K9,O9))>0.1*(G9+AVERAGE(K9,O9)),\"Warning: there is a percentage difference higher than 20% between column G and the average of the other 2 years \",\"\"),\"Warning: mandatory cell in column G is empty, please provide value or explanation \"),IF(ISNUMBER(K9),IF(ABS(K9-AVERAGE(G9,O9))>0.1*(K9+AVERAGE(G9,O9)),\"Warning: there is a percentage difference higher than 20% between column K and the average of the other 2 years \",\"\"),\"Warning: mandatory cell in column K is empty, please provide value or explanation \"))","v":""}]
["PC","W160601","RCY",null,null,"Recycling efficiency%",91.659000000000006,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},85.399000000000001,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(TRIM(O8)=\"\", TRIM(O9)=\"\"), \"\", O9*100/O8)","v":85.114775620777607},null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(O10), IF((O10<65),\"Warning: please check reported values, the target of 65% is not reached\",IF((O10>100),\"Warning: the rate must be below 100, explanatory footnote required\", \"The country has reached 65% in recycling efficiency\")),\"Warning: mandatory cell is empty, please provide value\")","v":"The country has reached 65% in recycling efficiency"},""]
["T","W160601PB","RCY_INP",null,"Lead content of lead batteries\n(W160601PB)","Minput, Pb (Tonnes)",1166.107,null,4,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},1144.3879999999999,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1008.5337730101005,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["T","W160601PB","RCY",null,null,"Moutput, Pb (Tonnes)",1100.6030000000001,null,4,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},1116.1669999999999,null,null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},983.63521280512271,null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["PC","W160601PB","RCY",null,null,"Rate of recycled lead content (degree of recycled Pb)%",94.382999999999996,null,4,{"$f":"IF(TRIM(I13)=\"\", \"\", IF(VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},97.534000000000006,null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(TRIM(O11)=\"\", TRIM(O12)=\"\"), \"\", O12*100/O11)","v":97.53121205543124},null,null,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(O13), IF((O13>100),\"Warning: the rate must be below 100, explanatory footnote required\",\"\"),\"Warning: mandatory cell is empty, please provide value\")","v":""},""]
["T","W160602","RCY_INP",null,"Ni-Cd Batteries\n(W160602) ","Minput, total (Tonnes)",14.042,null,null,{"$f":"IF(TRIM(I14)=\"\", \"\", IF(VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},16.641999999999999,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},15.643000000000001,null,null,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["T","W160602","RCY",null,null,"Moutput, total (Tonnes)",11.33,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},13.727,null,null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},12.814105000000001,null,null,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["PC","W160602","RCY",null,null,"Recycling efficiency%",80.69,null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},82.486999999999995,null,null,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(TRIM(O14)=\"\", TRIM(O15)=\"\"), \"\", O15*100/O14)","v":81.915904877581042},null,null,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(O16), IF((O16<75),\"Warning: please check reported values, the target of 75% is not reached\",IF((O16>100),\"Warning: the rate must be below 100, explanatory footnote required\", \"The country has reached 75%  in recycling efficiency\")),\"Warning: mandatory cell is empty, please provide value\")","v":"The country has reached 75%  in recycling efficiency"},""]
["T","W160602CD","RCY_INP",null,"Cadmium content of cadmium batteries\n(W160602CD)","Minput, Cd (Tonnes)",2.0659999999999998,null,4,{"$f":"IF(TRIM(I17)=\"\", \"\", IF(VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},2.4489999999999998,null,null,{"$f":"IF(TRIM(M17)=\"\", \"\", IF(VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},2.2599999999999998,null,null,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["T","W160602CD","RCY",null,null,"Moutput, Cd (Tonnes)",1.0269999999999999,null,4,{"$f":"IF(TRIM(I18)=\"\", \"\", IF(VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},1.804,null,null,{"$f":"IF(TRIM(M18)=\"\", \"\", IF(VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},1.048,null,null,{"$f":"IF(TRIM(Q18)=\"\", \"\", IF(VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 2 years",null,"Warning: there is a percentage difference higher than 20% between column G and the average of the other 2 years Warning: there is a percentage difference higher than 20% between column K and the average of the other 2 years "]
["PC","W160602CD","RCY",null,null,"Rate of recycled cadmium content (degree of recycled Cd)%",49.701000000000001,null,4,{"$f":"IF(TRIM(I19)=\"\", \"\", IF(VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated."},73.662999999999997,null,null,{"$f":"IF(TRIM(M19)=\"\", \"\", IF(VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(TRIM(O17)=\"\", TRIM(O18)=\"\"), \"\", O18*100/O17)","v":46.37168141592921},null,null,{"$f":"IF(TRIM(Q19)=\"\", \"\", IF(VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"Warning: there is a percentage difference higher than 20% between the reference year and the average of the previous 2 years",{"$f":"IF( ISNUMBER(O19), IF((O19>100),\"Warning: the rate must be below 100, explanatory footnote required\",\"\"),\"Warning: mandatory cell is empty, please provide value\")","v":""},"Warning: there is a percentage difference higher than 20% between column K and the average of the other 2 years "]
["T","W160605","RCY_INP",null,"Other batteries and accumulators\n(W160605)","Minput, total (Tonnes)",126.18300000000001,null,null,{"$f":"IF(TRIM(I20)=\"\", \"\", IF(VLOOKUP(I20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},146.08099999999999,null,null,{"$f":"IF(TRIM(M20)=\"\", \"\", IF(VLOOKUP(M20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},137.64699999999999,null,null,{"$f":"IF(TRIM(Q20)=\"\", \"\", IF(VLOOKUP(Q20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["T","W160605","RCY",null,null,"Moutput, total (Tonnes)",72.89,null,null,{"$f":"IF(TRIM(I21)=\"\", \"\", IF(VLOOKUP(I21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},86.289000000000001,null,null,{"$f":"IF(TRIM(M21)=\"\", \"\", IF(VLOOKUP(M21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},76.016335999999995,null,null,{"$f":"IF(TRIM(Q21)=\"\", \"\", IF(VLOOKUP(Q21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",null,""]
["PC","W160605","RCY",null,null,"Recycling efficiency%",57.765999999999998,null,null,{"$f":"IF(TRIM(I22)=\"\", \"\", IF(VLOOKUP(I22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},59.069000000000003,null,null,{"$f":"IF(TRIM(M22)=\"\", \"\", IF(VLOOKUP(M22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(OR(TRIM(O20)=\"\", TRIM(O21)=\"\"), \"\", O21*100/O20)","v":55.225566848532836},null,null,{"$f":"IF(TRIM(Q22)=\"\", \"\", IF(VLOOKUP(Q22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"The percentage difference is below 20%",{"$f":"IF( ISNUMBER(O22), IF((O22<50),\"Warning: please check reported values, the target of 50% is not reached\",IF((O22>100),\"Warning: the rate must be below 100, explanatory footnote required\", \"The country has reached 50% in  in recycling efficiency\")),\"Warning: mandatory cell is empty, please provide value\")","v":"The country has reached 50% in  in recycling efficiency"},""]
[]
[null,null,null,null,"Notes:"]
[]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,"Light grey: these cells usually contain formulas, but can be overwritten by the users as they are not locked; in case of prefilling, the formulas are substituted with the reported value."]
[null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]

{"sheet":"Table_2 (Prefilling)","index":10,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":true,"merged":[[28,4,28,5],[3,4,3,17],[10,4,12,4],[13,4,15,4],[16,4,18,4],[19,4,21,4],[26,4,26,5],[27,4,27,5],[6,8,6,9],[6,12,6,13],[6,16,6,17],[7,4,9,4]]}
[]
[]
[]
[null,null,null,null,"TABLE 2: PRE-FILLING"]
[null,null,null,null,"Country:",{"$f":"'GETTING STARTED'!G9","v":"LU"},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Luxembourg"}]
[null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2020}]
[null,null,null,null,null,null,{"$f":"F6-2","v":2018},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6-1","v":2019},"Standard footnotes","Explanatory\nfootnote",null,{"$f":"F6","v":2020},"Standard footnotes","Explanatory\nfootnote"]
["T","W160601","RCY_INP",null,"Lead batteries\n(W160601)","Minput, total (Tonnes)","1 842.0410",null,null,null,"1 807.7330"]
["T","W160601","RCY",null,null,"Moutput, total (Tonnes)","1 688.3930",null,null,null,"1 543.7910"]
["PC","W160601","RCY",null,null,"Recycling efficiency%",91.659000000000006,null,null,null,85.399000000000001]
["T","W160601PB","RCY_INP",null,"Lead content of lead batteries\n(W160601PB)","Minput, Pb (Tonnes)","1 166.1070",null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.","1 144.3880"]
["T","W160601PB","RCY",null,null,"Moutput, Pb (Tonnes)","1 100.6030",null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.","1 116.1670"]
["PC","W160601PB","RCY",null,null,"Rate of recycled lead content (degree of recycled Pb)%",94.382999999999996,null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.",97.534000000000006]
["T","W160602","RCY_INP",null,"Ni-Cd Batteries\n(W160602) ","Minput, total (Tonnes)",14.042,null,null,null,16.641999999999999]
["T","W160602","RCY",null,null,"Moutput, total (Tonnes)",11.33,null,null,null,13.727]
["PC","W160602","RCY",null,null,"Recycling efficiency%",80.69,null,null,null,82.486999999999995]
["T","W160602CD","RCY_INP",null,"Cadmium content of cadmium batteries\n(W160602CD)","Minput, Cd (Tonnes)",2.0659999999999998,null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.",2.4489999999999998]
["T","W160602CD","RCY",null,null,"Moutput, Cd (Tonnes)",1.0269999999999999,null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.",1.804]
["PC","W160602CD","RCY",null,null,"Rate of recycled cadmium content (degree of recycled Cd)%",49.701000000000001,null,null,"Only the rate of recycling is known from the recyclers. The lead respectively cadmium content has been estimated.",73.662999999999997]
["T","W160605","RCY_INP",null,"Other batteries and accumulators\n(W160605)","Minput, total (Tonnes)",126.18300000000001,null,null,null,146.08099999999999]
["T","W160605","RCY",null,null,"Moutput, total (Tonnes)",72.89,null,null,null,86.289000000000001]
["PC","W160605","RCY",null,null,"Recycling efficiency%",57.765999999999998,null,null,null,59.069000000000003]
[]
[null,null,null,null,"Notes:"]
[]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,"Light grey: these cells usually contain formulas, but can be overwritten by the users as they are not locked; in case of prefilling, the formulas are substituted with the reported value."]
[null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]

{"sheet":"VoluntaryReporting","index":11,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,23],[22,1,22,3],[22,4,22,23],[17,1,18,1],[17,2,17,23],[18,2,18,23],[19,1,19,3],[19,4,19,23],[20,1,20,3],[20,4,20,23],[3,1,4,1],[16,3,16,23],[1,2,1,23],[2,2,2,23],[3,3,3,23],[4,3,4,6],[4,7,4,10],[4,11,4,14],[4,15,4,18],[4,19,4,22],[11,3,11,23],[12,3,12,23],[13,3,13,23],[14,3,14,23],[15,3,15,23]]}
[]
[null,null,"Special note for the attention of the reporting officer: \nThis voluntary sheet is treated as confidential and will only be shared with DG ENV, DG JRC and companies collaborating with the Commission under specific contracts, for data validation and research purposes.\nThe objective of the voluntary reporting is focused on: \n- diminish the validation and investigation burden on the country whenever there is a peculiar situation that prevents countries to ship batteries waste on a yearly basis,\n- to help the Commission to analyse the situations in which countries are not receiving from recyclers settled abroad the figures on their amounts of recycled batteries and their recycling rates (in this case, it is recommended to provide the ANNEX IV, V and VI sheets from the recyclers in the quality report).  \nIn addition to what countries are already providing in the QRs, Eurostat encourages countries to provide any data and information available in this sheet.\nThe voluntary sheet can be filled in and transmitted at any time. It is not necessary to fill in this sheet by 30 June (collection deadline). Once the voluntary sheet is compiled, it is strongly recommended that the country submit the questionnaire via eDAMIS, so that Eurostat can analyse the information and then report to the Commission whenever requested\nThis sheet is divide in two sections:  \n- section 1 is devoted for the voluntary reporting, in structured way, on stocks, shipments and landfilling, as well as additional descriptive textual information  \n- section 2 is devoted for specifid topics addressed in JRC researches.\nIn the event that these data (or part of it) are judged of high quality, Eurostat will contact the reporting officer asking for permission to publish parts of these information (e.g. as metadata). Only the finally agreed parts may be published."]
[null,"Country: ","Section 1: voluntary declarations on stocks, shipments and landfilling"]
[null,{"$f":" CONCATENATE('GETTING STARTED'!E9,\" \",'GETTING STARTED'!G9)","v":"Luxembourg LU"},"Unit: Tonnes","Voluntary table 3: Declaration of stocks levels (opening at 1.1.Year),  shipped for treatment, collected stocks and landfilled materials arising from batteries waste processing in the reference year per battery type in the country"]
[null,null,"Year",2016,null,null,null,2017,null,null,null,2018,null,null,null,2019,null,null,null,2020,null,null,null,2021]
[null,"waste code","type of battery","Stocks (open)","Shipped for treatment","Collected stocks","Landfilling","Stocks (open)","Shipped for treatment","Collected stocks","Landfilling","Stocks (open)","Shipped for treatment","Collected stocks","Landfilling","Stocks (open)","Shipped for treatment","Collected stocks","Landfilling","Stocks (open)","Shipped for treatment","Collected stocks","Landfilling","Stock (open)"]
[null,"W160601","Lead batteries",null,null,null,null,{"$f":"D7-E7+F7-G7","v":0},null,null,null,{"$f":"H7-I7+J7-K7","v":0},null,null,null,{"$f":"L7-M7+N7-O7","v":0},null,null,null,{"$f":"P7-Q7+R7-S7","v":0}]
[null,"W160601PB","Lead content of lead batteries",null,null,null,null,{"$f":"D8-E8+F8-G8","v":0},null,null,null,0,null,null,null,0,null,null,null,0]
[null,"W160602","Ni-Cd Batteries",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"W160602CD","Cadmium content of cadmium batteries",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"W160605","Other batteries and accumulators",null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]
[null,"waste code","type of battery","Further explanations on the data reported above (if the data are considered for estimations in the table 2 reporting, if the amounts are arising from estimations or supported by official records, if further disaggregation is available...) "]
[null,"W160601","Lead batteries"]
[null,"W160601PB","Lead content of lead batteries"]
[null,"W160602","Ni-Cd Batteries"]
[null,"W160602CD","Cadmium content of cadmium batteries"]
[null,"W160605","Other batteries and accumulators"]
[null,null,"Section 2: JRC questions on Batteries data collection 2022"]
[null,null,"The JRC (Joint Research Centre) of the European Commission is working to provide scientific evidence to the Battery Regulation Proposal COM(798)2020. In particular, JRC provides – among the others – support on the Article 57 on recycling efficiency and material recovery level to provide harmonized calculation rules for all the batteries (PbA, NiCd and others, Li-ion). \nAt this scope, JRC is interested in learning more on the reporting practices of the Member States (MS), with the following questions:\n"]
[null,"Which are the waste codes used (from the European Waste Catalogue) to label exported black mass(es)?"]
[null,"Classification of slag as a product or a waste currently depends on MSs. Would this classification stay unchanged for new possible (and targeted) fractions as lithium-rich slag or do MSs think of re-considering this classification?","W160601","Lead batteries"]
[null,"In the new legislation, specific lines for the Li-ion batteries might be added, following the classification of the COM(798)2020 (PbA, NiCd, LIBs and others). Please specify if your country is in the position of providing these information and please provide the available amounts in your answer, possibly by year.","W160601PB","Lead content of lead batteries"]
[null,"Further disaggregation target elements of Art. 57 for the NiCd batteries (i.e. also nickel), and for the Li-ion batteries (i.e. nickel, cobalt, copper and lithium). Please specify if your country is in the position of providing these information and please provide the available amounts in your answer, possibly by year.","W160602","Ni-Cd Batteries"]

{"sheet":"ErrorLog","index":12,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Link to Error","Validation Rule","Cell","Sheet","Description","Severity","Former Color"]
["Go to cell","DomainSpecific","O13","Table_1","The value does not match the expected ratio (Collected/average put on the market last 3 years)","Error",13487565]
["Go to cell","DomainSpecific","O16","Table_1","The value does not match the expected ratio (Collected/average put on the market last 3 years)","Error",13487565]
["Go to cell","DomainSpecific","O19","Table_1","The value does not match the expected ratio (Collected/average put on the market last 3 years)","Error",13487565]

{"sheet":"Changelog","index":13,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["Changed by","SheetName","Cell","Change","Version","Date","REMARKS"]
["CDD","Standard macros",null,"Summations: Accept LT and LE","m17","2021-03-29"]
["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"]
["CRE","Footnotes list, basic instructions","I suppressed country specific in front of footnote, this comes from some mess last year","Because: it leads confusion, in the data part there is written explanatory footnote,  last year it was there is written explanatory footnote in the questionnaire, the explantory footnote are meant to explain very specific issue related to the datum that can be general and not solely country related, while  country specifique notes are a document we prepare for explaining specific methodological explanation that has to go in the quality report and may differ from country to country. Here instead we have specific issues related to the inputed datum, that are usually not arising from methodological matters but by contingent situations; moreover \"country specific\" just creates confusion, as the country is already writen data of herself they will not report what is usually generic issues or depending from the year!!! It goes against also what we wrote in basic instructions: 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. ","04m18","2021-05-05"]
["CRE","all tables","T1 E 28  29 and 30, T2  E30 31 and 32","deleted the standard footnotes hints, it must be only in basic instructions, moreover it was looking different","04m18","2021-05-05"]
["CDD","INDEX",null,"Include page INDEX (It was missing)","04m18","2021-05-06"]
["CDD","All visible sheets",null,"Add page footer","04m19","2021-05-06"]
["CDD","Eurostat logo",null,"Property \"move but don't size with cells\"","04m20","2021-05-06"]
["CRE","T1","from O10 to W19","insertion of all formulas, not meant for the lock unlock; voluntary data from O11 to W19, explanation note for voluntary data; redited the comments","05m18","2021-05-18"]
["CRE","Mandatory","from O11 to W19","all mandatory cut, as these are now voluntary","05m18","2021-05-18"]
["CRE","T1","column AAAB, AC, voluntary","change of messages","05m18","2021-05-18"]
["CRE","T2","from O10 to W22","insertion of all formulas, not meant for the lock unlock; re-edited the comments","05m18","2021-05-18"]
["CRE","T1 and T2","from 24E to G30","change of cells, they were wrongly aligned, integration of text…","05m18","2021-05-18"]
["CRE","Basic Instructions:","several, already started in version 05m18","change of text here and there and added more info on legislation and formula","06m18","2021-05-19"]
["CRE","Validation rules","several, already started in version 05m18","change of text here and there and added more info on legislation and formula","06m18","2021-05-19"]
["CRE","Index","title table 2","correction of title table 2: the title was not having the second line, I had to merge it in notepad to be able to have it correctly displayed; no link was modified","06m18","2021-05-19"]
["CRE","T1","comments in blu cells","comments in the voluntary cells have been deleted: not anymore valida as there was not anymore the conditional formatting","07m18","2021-05-19"]
["CRE","Summations","M6 to M8","text changed from\n Output cannot be higher than input\n Total input must be higher than the specific metal input\n Total output must be higher than the specific metal output\nto\n Mass input must be higher than mass output\n Total mass input must be higher than the specific metal content mass input\n Total mass output must be higher than the specific metal content mass output","07m18","2021-05-19"]
["CRE","T2","from O10 to W22","colour changed for formulas, probably lost due to the failure of a save file operation!","07m18","2021-05-19"]
["CRE","ErrorLog","change of column width","column width changed to minimize emplty blank for short text columns and to permit to have the full line of alert visiblecolour changed for formulas, probably lost due to the failure of a save file operation!","07m18","2021-05-19","for approval Cesar"]
["CRE","Mandatory","row 2 and row3","first two lines for getting started were missing, I added them","07m18","2021-05-19","for check of Cesar (I copied from ELV)"]
["CRE","T1","col G and col K","formulas explanatory text dark grey cells: copied VLOOKUP formulas of the Explanatory text","07m18","2021-05-19","for check of Cesar (I copied from the other column)"]
["CRE","T2","comments mandatory cells(white)","changed \"red\" to \"light red\"","07m18","2021-05-19"]
["CRE","T1","col G and col K","deleted formulas explanatory text dark grey cells: copied VLOOKUP formulas of the Explanatory text: I rememberd that the numbered footnote is not available (I saw it was added this year to keep columns letter names standard)","08m18","2021-05-20","I deleted again, I remembered that it is not necessary (for check of Cesar) "]
["CRE","T1, T2","column warning AB (t1) and T (T2)","correction of this text: \"Warning: the target must be below 100, explanatory footnote required\" into this \"Warning: the rate must be below 100, explanatory footnote required\"","08m18","2021-05-20"]
["CRE","Validation rules","column warning AB (t1) and T (T2)","added :\nrow 35 If the reported value does not correspond or if the value is higher than 100:\nrow 43 Finally, the rates are higher than 100%, an error message will appear: please correct the values, as the Minputs must be higher than the Moutputs. ","08m18","2021-05-20"]
["CRE","Threshold","row 3","added warning on collection rate higher than 100%","08m18","2021-05-20"]
["CDD","Macros",null,"Macros version 19","10m19","2021-05-20"]
[null,null,null,"Macros and sheets for pre-filling"]
["CRE","Validation rules","clean ups of comment","cleaning of text after the checks with Oscar","10m19","2021-05-20"]
["CRE","INDEX","correction","cut of country specific in front of explanatory footnote","10m19","2021-05-20"]
["CRE","Macros",null,"Macros version 19 reupload: Cesar fixed error in SimpleRatio ","11m19","2021-05-21"]
["CRE","Basic Instructions:","row 19","Message on Validation rules before transmission","11m19","2021-05-21"]
["CDD","Macros",null,"Macros version 23; Macros and sheets for pre-filling","01m23","2022-05-19"]
["CDD","Lists",null,"Password updated cell A43"]
["CRE","Validation rules","ROW 6 Summations","Wrong W20 for table 2, it should have bee O20. Changed to O20","01m23","2022-05-24"]
["CRE","Lists","update 2022",null,"01m23","2022-05-24"]
["CRE","Table_1 and Table_2","cell format validation","Applied formatting with the data validation excel tool, according to paragraph \"2.7.3.1 Formatting data cells to permit only decimal numbers\", decimals from 0 to 999999999999999","01m23","2022-05-24"]
["CRE","Index","row 21","Adding line and title for the new voluntary reporting file","01m23","2022-05-24"]
["CRE","Voluntary Sheet","Manually adding sheet content from template","Adapting to respect formattiong issues, small changes in the text , format decimals, locks and so on","01m23","2022-05-24"]

{"sheet":"Pre-filling parameters","index":14,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Sheet From","Sheet To","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Confidentiality flag\n(YES/NO)","Replace locked cells\n(YES/NO)","Hide sheet after pasting\n(YES/NO)","Footnote Call-out (number) exists\n(YES/NO)"]
["Table_1 (Prefilling)","Table_1","G8","W19",1,4,"NO","YES","YES","YES"]
["Table_2 (Prefilling)","Table_2","G8","O22",1,4,"NO","YES","YES","YES"]

{"sheet":"Lists","index":15,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,9,1,10],[5,9,5,10],[10,9,10,10],[15,9,15,10],[2,5,7,5]]}
["Country label","Country code",null,"Valid flags (obs_status)","Label",null,"Valid flags (obs_conf)","Label",null,"Textual variables","String"]
["Belgium","BE",null,"E","Estimated data",null,null,null,null,"Institutional names"]
["Bulgaria","BG",null,"D","Definition differs, see metadata","checked: in Batteries definition differs is needed because some countries (ICELAND) may provide in table 1 also data coming from industrial batteries, or countries were the collection rate is higher because there are problem with internet sales (free riders)",null,null,null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ",null,null,null,null,null,null,null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK",null,null,null,null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE",null,null,null,null,null,null,null,"Data collection information"]
["Estonia","EE",null,null,null,null,null,null,null,"Data Collection Text","Annual reporting on batteries and accumulators and waste batteries and accumulators"]
["Ireland","IE",null,null,null,null,null,null,null,"Data Collection Year",2022]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","2 June 2022"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","30 June 2022"]
["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_BATTDAT_A"]
["Cyprus","CY",null,null,null,null,null,null,null,"Web page","https://webgate.ec.europa.eu/edamis/helpcenter/website/index.htm"]
["Latvia","LV",null,null,null,null,null,null,null,"Functional e-mail","estat-support-edamis@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"]
[]
["WASTE-2022-DC"]

{"sheet":"Locks","index":16,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","LockType","Focus Back To","Content is Mandatory"]
[]
["Table_1","W8","W10",1,4,"formulas","W11","YES"]
["Table_1","W13","W19",3,4,"formulas","W11","YES"]
["Table_1","O8","S10",1,4,"pre-filled formulas","W11","YES"]
["Table_1","O13","S19",3,4,"pre-filled formulas","W11","YES"]
["Table_1","O11","S17",3,4,"pre-filled values","W11","YES"]
["Table_1","O12","S18",3,4,"pre-filled values","W11","YES"]
["Table_2","O10","O22",3,4,"formulas","O8","YES"]
["Table_2","G10","K22",3,4,"pre-filled formulas","O8","YES"]
["Table_2","G8","K21",3,4,"pre-filled values","O8","YES"]
["Table_2","G9","K22",3,4,"pre-filled values","O8","YES"]
[]
[]
["IMPORTANT: The same cell must not be included in two ranges. In such a case the switch will operate twice, leaving the cell in the same original state"]

{"sheet":"NotStandardRules","index":17,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["RuleName"]
["RatioDenominatorIsAverage"]

{"sheet":"CannotBeZero","index":18,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Zero Is Valid If Footnote Exists","Footnote Shift From Value",null,"Inserted CR 20200511"]
["Warning","Table_1","O8","W19",1,4,"YES",2]
["Warning","Table_2","G8","O22",1,4,"YES",2]
[null,null,null,null,null,null,null,null,null,"Checked-Cri-OK-however policy to look for old data (if not changed- no error check should be done"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Formulas"]

{"sheet":"Thresholds","index":19,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lower value","Upper value","Is Valid If Footnote Exists","Footnote Shift From Value","if there is a footnote we accept that the rule is not respected","revised CR 20200511","percentage values in table 2, mandatory, values higher than 100% are no sense and not admitted, since the recovered  material (output fraction) cannot be higher than the input, and the process has to refer to the material treated within calendar year. As the reporting has to cover as of article 3 points 4 and 5, all individual steps of recycling and all corresponding output fractions, this means that any leftover not yet recycled in the calendar year has to be reported for the input and output in the next calendar year,m no stock is admitted "]
["Error","Table_2","G10","O22",3,4,0,100,"NO",2,"Top Left Cell","Lower value formula ","Upper value  formula "]
["Warning","Table_1","O10","W10",999,4,0,100,"YES",2]
[]
["Error","Table_2","G8",null,3,4,"G9",null,"YES",2,"RCY_INP.W160601","RCY_INP>=RCY"]
["Error","Table_2","G11",null,3,4,"G12","G8","YES",2,"RCY_INP.W160601PB","RCY_INP>=RCY","RCY_INP.W160601>=RCY_INP.W160601PB"]
["Error","Table_2","G14",null,3,4,"G15",null,"YES",2,"RCY_INP.W160602","RCY_INP>=RCY"]
["Error","Table_2","G17",null,3,4,"G18","G14","YES",2,"RCY_INP.W160601CD","RCY_INP>=RCY","RCY_INP.W160602>=RCY_INP.W160602CD"]
["Error","Table_2","G20",null,3,4,"G21",null,"YES",2,"RCY_INP.W160605","RCY_INP>=RCY"]
["Error","Table_2","K8",null,3,4,"K9",null,"YES",2,"RCY_INP.W160601","RCY_INP>=RCY"]
["Error","Table_2","K11",null,3,4,"K12","K8","YES",2,"RCY_INP.W160601PB","RCY_INP>=RCY","RCY_INP.W160601>=RCY_INP.W160601PB"]
["Error","Table_2","K14",null,3,4,"K15",null,"YES",2,"RCY_INP.W160602","RCY_INP>=RCY"]
["Error","Table_2","K17",null,3,4,"K18","K14","YES",2,"RCY_INP.W160601CD","RCY_INP>=RCY","RCY_INP.W160602>=RCY_INP.W160602CD"]
["Error","Table_2","K20",null,3,4,"K21",null,"YES",2,"RCY_INP.W160605","RCY_INP>=RCY"]
["Error","Table_2","O8",null,3,4,"O9",null,"YES",2,"RCY_INP.W160601","RCY_INP>=RCY"]
["Error","Table_2","O11",null,3,4,"O12","O8","YES",2,"RCY_INP.W160601PB","RCY_INP>=RCY","RCY_INP.W160601>=RCY_INP.W160601PB"]
["Error","Table_2","O14",null,3,4,"O15",null,"YES",2,"RCY_INP.W160602","RCY_INP>=RCY"]
["Error","Table_2","O17",null,3,4,"O18","O14","YES",2,"RCY_INP.W160601CD","RCY_INP>=RCY","RCY_INP.W160602>=RCY_INP.W160602CD"]
["Error","Table_2","O20",null,3,4,"O21",null,"YES",2,"RCY_INP.W160605","RCY_INP>=RCY"]
["Error","Table_2","G9",null,3,4,"G12","G8","YES",2,"RCY.W160601","RCY.W160601>=RCY.W160601PB","RCY_INP>=RCY"]
["Error","Table_2","G12",null,3,4,null,"G11","YES",2,"RCY.W160601PB",null,"RCY_INP>=RCY"]
["Error","Table_2","G15",null,3,4,"G18","G14","YES",2,"RCY.W160602","RCY.W160602>=RCY.W160602CD","RCY_INP>=RCY"]
["Error","Table_2","G18",null,3,4,null,"G17","YES",2,"RCY.W160601CD",null,"RCY_INP>=RCY"]
["Error","Table_2","G21",null,3,4,null,"G20","YES",2,"RCY.W160605",null,"RCY_INP>=RCY"]
["Error","Table_2","K9",null,3,4,"K12","K8","YES",2,"RCY.W160601","RCY.W160601>=RCY.W160601PB","RCY_INP>=RCY"]
["Error","Table_2","K12",null,3,4,null,"K11","YES",2,"RCY.W160601PB",null,"RCY_INP>=RCY"]
["Error","Table_2","K15",null,3,4,"K18","K14","YES",2,"RCY.W160602","RCY.W160602>=RCY.W160602CD","RCY_INP>=RCY"]
["Error","Table_2","K18",null,3,4,null,"K17","YES",2,"RCY.W160601CD",null,"RCY_INP>=RCY"]
["Error","Table_2","K21",null,3,4,null,"K20","YES",2,"RCY.W160605",null,"RCY_INP>=RCY"]
["Error","Table_2","O9",null,3,4,"O12","O8","YES",2,"RCY.W160601","RCY.W160601>=RCY.W160601PB","RCY_INP>=RCY"]
["Error","Table_2","O12",null,3,4,null,"O11","YES",2,"RCY.W160601PB",null,"RCY_INP>=RCY"]
["Error","Table_2","O15",null,3,4,"O18","O14","YES",2,"RCY.W160602","RCY.W160602>=RCY.W160602CD","RCY_INP>=RCY"]
["Error","Table_2","O18",null,3,4,null,"O17","YES",2,"RCY.W160601CD",null,"RCY_INP>=RCY"]
["Error","Table_2","O21",null,3,4,null,"O20","YES",2,"RCY.W160605",null,"RCY_INP>=RCY"]

{"sheet":"IsFormula - cancelled","index":20,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step",null,"Verified CR 20200504"]
["Info","Table_1","O8","W10",1,4,null," COL(%)=[COL(T)/(MKT.{Year}+MKT.{Year-1}+MKT.{Year-2})]*3*100 "]
["Info","Table_1","O13","W19",3,4]
["Info","Table_2","G10","O22",3,4]

{"sheet":"Summations","index":21,"n_rows":110,"n_cols":16,"rows_kept":110,"cut":false,"hidden":true,"merged":[[11,5,11,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",null,null,"Verified CR 20200504"]
["Error","Table_1","O11,O14,O17","O8","W8",999,4,"EQ",0.1,"YES","NO",3,"Summation not consistent: \"Portable batteries and accumulator-Sales\" should be equal to the sum of the \"Sales\" of the other three batteries types",null,null,"M8=M11+M14+M17"]
["Error","Table_1","O11,O14,O17","O8","W8",999,4,"GE",0.1,"NO","NO",3,"Summation not consistent: \"Portable batteries and accumulator-Sales\" should be equal or higher than the sum for the \"Sales\" of the reported batteries types"]
["Error","Table_1","O12,O15,O18","O9","W9",999,4,"EQ",0.1,"YES","NO",3,"Summation not consistent: \"Portable batteries and accumulator-Collection\" should be equal to the sum of the \"Collection\" of the other three batteries types"]
["Error","Table_1","O12,O15,O18","O9","W9",999,4,"GE",0.1,"NO","NO",3,"Summation not consistent: \"Portable batteries and accumulator-Collection\" should be equal or higher than the sum for the  \"Collection\" of the reported batteries types"]
["Error","Table_2","G9","G8","O20",3,4,"GE",0,"YES","NO",3,"Mass input must be higher than mass output"]
["Error","Table_2","G11","G8","O17",6,4,"GE",0,"YES","NO",3,"Total mass input must be higher than the specific metal content mass input"]
["Error","Table_2","G12","G9","O18",6,4,"GE",0,"YES","NO",3,"Total mass output must be higher than the specific metal content mass output"]
[]
[]
[]
[null,null,null,null,null,"Must be > 0 for a not relevant dimension. Else you get an infinite loop",null,"EQ or GE or GT","GT does not admit Tolerance","NO or YES"]
[]
["DESCRIPTION"]
["This sheet is meant to define the validation for summations in a row or in a column."]
["- A block is defined as a sequence of addendums in the same row or column"]
["- Only the first block must be explicitly defined"]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(Summations!B3º)","v":{"$error":"#NAME?"}}]

{"sheet":"SimpleRatios","index":22,"n_rows":6,"n_cols":17,"rows_kept":6,"cut":false,"hidden":true,"merged":[[5,6,5,7]]}
["Severity","Sheet Name","Numerator\n (first block)","Denominator (first block)","First result\n(First block)","Last result\n(Last block)","Row Block Repetition Step","Column Block Repetition Step","Numerator multiplied by ","Ratio Greater or Equal than result cell","Valid Tolerance","If denominator = 0","Display text in error","Accept error If Footnote Exists","Column shift from value to footnote",null,"Changed 20200527"]
["Error","Table_2","G9","G8","G10","O22",3,4,100,"EQ",0.1,"ZERO","Zero denominator error: the rate is calculated as output mass divided by the input mass","YES",3]
[]
[]
[]
[null,null,null,null,null,null,"Must be > 0 for a not relevant dimension. Else you get an infinite loop"]

{"sheet":"Mandatory","index":23,"n_rows":15,"n_cols":10,"rows_kept":15,"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",null,"Verified CR 20200504"]
["Error","GETTING STARTED","E9","E10",1,999,"NO",999,"STANDARD FOR ALL QUESTIONNAIRES"]
["Error","GETTING STARTED","D14","D22",2,999,"NO",999]
["Error","Table_1","O8","W9",1,4,"YES",2]
["Error","Table_2","G8","O9",1,4,"YES",2]
["Error","Table_2","G11","O12",1,4,"YES",2]
["Error","Table_2","G14","O15",1,4,"YES",2]
["Error","Table_2","G17","O18",1,4,"YES",2]
["Error","Table_2","G20","O21",1,4,"YES",2]
["Error","Table_1","O10","W10",1,4,"YES",2,null,"Formulas"]
["Error","Table_2","G10","O10",1,4,"YES",2]
["Error","Table_2","G13","O13",1,4,"YES",2]
["Error","Table_2","G16","O16",1,4,"YES",2]
["Error","Table_2","G19","O19",1,4,"YES",2]
["Error","Table_2","G22","O22",1,4,"YES",2]

{"sheet":"MustNotBeNegative","index":24,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep",null,"Verified CR 20200504"]
["Error","Table_1","O8","W19",1,4]
["Error","Table_2","G8","O22",1,4]

{"sheet":"FoototeContent","index":25,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText",null,"Verified CR 20200504"]
["Table_1","Q8","Y19",1,4,1]
["Table_2","I8","Q22",1,4,1]

{"sheet":"IsNumeric","index":26,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table_1","O8","W19",1,4]
["Error","Table_2","G8","O22",1,4]