{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Cover","Index","Basic Instructions","Methodology","Reference values","Validation rules","GETTING STARTED","Footnotes list","Table 1","Table 2","Table 3","Quality Report","ErrorLog","Changelog","Lists","Locks","IsFormula","Summations","Mandatory","MandatoryAtLeast","ForbiddenStrings","FootnoteContent","MustNotBeNegative","IsNumeric"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[18,1,23,3]]}
[]
[]
[null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[]
[null,null,{"$f":"Lists!K4","v":"Directorate E: Sectoral and regional statistics"}]
[null,null,{"$f":"Lists!K5","v":"Unit E-2: Environmental statistics and accounts; sustainable development"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: 29 April 2022"}]

{"sheet":"Index","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[21,2,21,4],[24,2,24,4],[1,2,1,4],[3,2,3,4],[4,2,4,4],[6,2,6,4],[8,2,8,4],[14,2,14,4]]}
[]
[]
[null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2022 DATA COLLECTION"}]
[]
[null,null," INDEX - STRUCTURE OF THE QUESTIONNAIRE"]
[]
[null,null,"I. Basic information (green-tabbed sheets; informational)"]
[null,null,"WORKSHEET TITLE","DESCRIPTION","TYPE"]
[null,null,"Index","Structure of the questionnaire","Informational"]
[null,null,"Basic instructions ","Basic instructions","For reading before filling in the questionnaire"]
[null,null,"Methodology","Methodology and legal acts","For reading before filling in the questionnaire"]
[null,null,"Reference values","Reference values for the calculation of generated waste oil","Informational (to be applied if no country-specific data is available)"]
[null,null,"II. Reporting data (turquoise/ teal-tabbed sheets; to be filled in by the country)"]
[null,null,"WORKSHEET 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","Table 1 - Reporting on data on the placing on the market of mineral and synthetic lubrication and industrial oils and on the treatment of waste oils (in tonnes)","For filling in"]
[null,null,"Table 2","Table 2 - Reporting on data on the treatment of waste oils (in tonnes)","For filling in"]
[null,null,"Table 3","Table 3 - Reporting on data on the placing on the market of mineral and synthetic lubrication and industrial oils and treatment of waste oils other than those listed in Table 1 (in tonnes)","For filling in"]
[null,null,"III. Quality report (orange-tabbed sheets; to be filled in by the country)"]
[null,null,"WORKSHEET TITLE","DESCRIPTION","TYPE"]
[null,null,"Quality report","The Quality Report document","For filling in"]
[null,null,"IV. Error log (red-tabbed sheets; items to be corrected by the country)"]
[null,null,"WORKSHEET TITLE","DESCRIPTION","TYPE"]
[null,null,"Error log","List of validation errors from the data tables (Tables 1, 2 and 3) and the Quality report. Countries are requested to resolve the errors before submission.","For reference"]

{"sheet":"Basic Instructions","index":2,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":false,"merged":[[91,2,91,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[67,2,67,5],[47,2,47,5],[49,2,49,5],[51,2,51,5],[53,2,53,5],[55,2,55,5],[56,2,56,5],[57,2,57,5],[60,2,60,5],[18,2,18,5],[9,2,9,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[35,2,35,5],[16,2,16,5],[19,2,19,5],[21,2,21,5],[25,2,25,5],[33,2,33,5],[88,2,88,5],[89,2,89,5],[93,2,93,5],[84,2,84,5],[68,2,68,5],[70,2,70,5],[72,2,72,5],[74,2,74,5],[75,2,75,5],[77,2,77,5],[78,2,78,5],[79,2,79,5],[81,2,81,5],[83,2,83,5],[90,2,90,5],[92,2,92,5],[59,2,59,5],[66,2,66,5],[85,2,85,5],[86,2,86,5],[87,2,87,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[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. This EXCEL workbook is the questionnaire. Please do not  delete or add rows in the questionnaire (except where instructed in the Quality Report worksheet)."]
[null,null,"Table of contents"]
[null,null,"1. Data transmission"]
[null,null,"2. Reporting conventions"]
[null,null,"3. Quality report"]
[null,null,"4. Footnotes"]
[null,null,"5. 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_OILS_A"}]
[]
[null,null,"If you have 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,"   email 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,"   web page:",{"$f":"Lists!K19","v":"https://ec.europa.eu/eurostat/web/waste/methodology"}]
[null,null,"   e-mail address:",{"$f":"Lists!K18","v":"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"}]
[]
[null,null,"2.  Reporting conventions:"]
[]
[null,null,"Reporting of zeroes and not availble data must follow this convention:"]
[null,null,"Description","Symbol"]
[null,null,"Real zero",0]
[null,null,"Not available",null," (empty cell)"]
[]
[null,null,"Green-shaded cells: ",null,"Reference values"]
[null,null,"White-shaded (uncoloured) cells: ",null,"Provision of data is mandatory"]
[null,null,"Light blue-shaded cells:",null,"Provision of data is voluntary"]
[null,null,"Black-shaded cells: ",null,"Reporting is not applicable"]
[null,null,"Grey-shaded cells: ",null,"Calculation is automatic; do not input any data into these cells"]
[null,null,"Beige-shaded cells:",null,"Footnotes (only to be filled in where needed)"]
[]
[null,null,"3. Quality report:"]
[]
[null,null,"From reference year 2020, it is mandatory to report the methodological information according to Commission Implementing Decision (EU) 2019/1004, Annex VI. In the orange worksheet named 'Quality report', please provide information on the sources available and methodology used to produce the statistics Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils."]
[]
[null,null,"4. Footnotes:"]
[]
[null,null,"You are asked to report data that follow as closely as possible to the Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils definitions and reporting rules (see paragraphs below). "]
[]
[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) "]
[null,null,"- Numbers for explanatory footnotes (to be defined by the data compilers). "]
[]
[null,null,"4.1 Standard footnotes"]
[null,null,"The following footnotes will be used for the automatic data processing and data dissemination. Hence, they cannot be changed:"]
[null,null,"B) break in time series"]
[null,null,"E) estimated data"]
[null,null,"P) provisional"]
[null,null,"To include any one or a combination of these standard footnotes, use the drop-down menu next to the applicable data. "]
[]
[null,null,"4.2 Explanatory footnotes"]
[null,null,"The explanatory footnotes can be used for describing meanings or relevant information 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 type in the corresponding footnote reference number. 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."]
[null,null,"If by mistake a number is chosen from the drop-down menu, it is sufficient to press the key delete to clear the cell."]
[null,null,"Please do not report footnotes that elaborate on e.g. source data and compilation methods; these are to be described in the quality report sheet. "]
[]
[null,null,"5. Methodology and questions:"]
[]
[null,null,"The guidelines to report on Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils are available on the Eurostat website:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/methodology"]
[]
[null,null,"The guidelines contain definitions, examples and recommendations to ensure data are compiled and maintained on consistent basis. They explain the scope and reasoning behind the terms of the tables, and provide extra information necessary to allow a consistent collection and interpretation of the data to be reported by countries. A great effort has been put into increasing coherence and providing guideline users with practical recommendations. Full implementation of these recommendations should help to ensure that data are compiled and maintained on a consistent basis. "]
[null,null,"If you have questions, please send them to the following email addresses:"]
[null,null,"ESTAT-WASTE-STATISTICS@EC.EUROPA.EU"]
[]
[null,null,"Annex: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"Tables 1 to 3"]
[null,null,"Filling in Table 1 and 2 is obligatory for the reference year 2020 onwards. The first report is due by 30 June 2022. "]
[null,null,"All the cells that include mandatory data should be filled in with a value. In the tables, all these cells are uncoloured/ white."]
[null,null,"All the cells that include voluntary data can be filled in with a value, a real zero or remain empty if data are not available. In the questionnaire, all such cells are coloured in light blue."]
[null,null,"Flags (footnote symbols) can be entered in the reporting tables in the 'standard footnotes' columns. To include these, use the drop-down menu."]
[null,null,"The text of specific explanatory footnotes can be entered in the worksheet 'Footnotes list'."]
[null,null,"Complete the quality report providing as much information as possible."]
[null,null,"Data reporting in Table 3 is voluntary."]
[]
[null,null,"Reference values"]
[null,null,"A table with reference values (see worksheet 'Reference values') provides data for the calculation of waste oil generated (see Table 1, column 2). These default values are to be applied if no country-specific data is available."]

{"sheet":"Methodology","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"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],[23,2,23,5],[24,2,24,5],[25,2,25,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[17,2,17,5],[21,2,21,5],[22,2,22,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[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,"1. Background"]
[]
[null,null,"In the context of the Circular Economy Package, the amending Directive 2018/851 recently introduced certain changes to the Waste Framework Directive (WFD). Based on these amendments, Member States shall report data on oil placed on the market and the amount of waste oil collected and treated. "]
[null,null,"Therefore, a data format for reporting on oil and waste oil had to be developed in compliance with Article 37 WFD: \"[... ]4. Member States shall report the data on mineral or synthetic lubrication or industrial oils placed on the market and waste oils separately collected and treated for each calendar year to the Commission.”"]
[null,null,"This Excel reporting template allows Member States to report oils and waste oils pursuant to the requirements of Commission Implementing Decision (EU) 2019/1004, Annex VI, data on mineral and synthetic lubrication and industrial oils and waste oils."]
[null,null,"Further guidance is provided the guidelines documents available here:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/methodology"]
[]
[null,null,"2.  Legal acts"]
[]
[null,null,"More than 40 years ago the Directive 75/439/EC on waste oils entered into force to establish harmonised management of waste oil across the EU. In 1987 some major amendments were established with the result that among the different options for recovery, priority is given to the regeneration of waste oil over its incineration. "]
[null,null,"The Waste Oil Directive 75/439/EEC and the Hazardous Waste Directive 91/689/EEC were repealed as of 12 December 2010. The aspects of the two directives are integrated into the Waste Framework Directive 2008/98/EC, especially Articles 17 to 21 and 35. Based on the amended Article 37 WFD Member States shall report the data on oils and waste oils."]
[null,null,"The official format for reporting of waste oils data was adopted in mid-2019 as an essential basis of the reporting obligation: Commission Implementing Decision (EU) 2019/1004 of 7 June 2019, Annex VI, data on mineral and synthetic lubrication and industrial oils and waste oils referred to in Article 7(3)."]
[null,null,"The legislation is available here:"]
[null,null,"https://ec.europa.eu/eurostat/web/waste/legislation"]

{"sheet":"Reference values","index":4,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,1,5,1],[6,1,6,2],[9,1,9,2],[21,1,21,2]]}
[]
[null,"Reference values for the calculation of generated waste oil"]
[null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",VLOOKUP('GETTING STARTED'!E9,Lists!A2:B40,2,FALSE))","v":"FI"}]
[null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2021}]
[null,null,1]
[null,null,"Fraction of oils placed on market (%)"]
[null,"Engine and gear box oils"]
[null,"Engine oils",52]
[null,"Gear box oils",76]
[null,"Industrial oils"]
[null,"Machine oils",50]
[null,"Hydraulic oils",75]
[null,"Turbine oils",70]
[null,"Transformer oils",90]
[null,"Heat transmission oils",90]
[null,"Compressor oils",50]
[null,"Base oils",50]
[null,"Metal working oils used in emulsions",49]
[]
[null,"Notes:"]
[null,"Cell shading:"]
[null,"Light green: Default reference values; to be applied if no country-specific data is available."]

{"sheet":"Validation rules","index":5,"n_rows":52,"n_cols":6,"rows_kept":52,"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],[24,2,24,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],[21,2,21,5],[39,3,39,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[30,2,30,5],[32,2,32,5],[33,2,33,5],[34,3,34,5],[35,3,35,5],[36,3,36,5],[37,2,37,5],[38,3,38,5],[46,3,46,5],[48,2,48,5],[50,2,50,5],[51,2,51,5],[40,3,40,5],[41,2,41,5],[42,3,42,5],[43,2,43,5],[44,3,44,5],[45,3,45,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[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. The user needs first to unlock the cells defined as \"formulas\" by means of the \"unlock formulas\" button placed on the top left corner of the tables."]
[null,null,"The following validation rules are implemented by the validation tool"]
[null,null,"Table of contents"]
[null,null,"1. Mandatory data"]
[null,null,"2. Arithmetic rules"]
[null,null,"3. Explanatory footnotes"]
[]
[]
[null,null,"1. Mandatory Data:"]
[]
[null,null,"All the information requested in the sheet \"GETTING STARTED\" must be filled in."]
[null,null,"All the mandatory cells in 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 equal or bigger than 0 (positive values)"]
[null,null,"Table 1: "]
[null,null,null,"The 'Metal (total)' row should be equal to the sum of the 'Ferrous metal' and 'Aluminium' rows (when the reference year is 2020 or later). Before, only if reported all of them. "]
[null,null,null,"The 'Total' row should be a sum of all the amounts given in the separate material within the table (Excluding the individual metals which are accounted in Metals (total)"]
[null,null,null,"The \"Waste generation\" column must be bigger than total recovery. Including an explanatory footnote this is a warning, because in exceptional circumstances it could be smaller."]
[null,null,"Table 1a: "]
[null,null,null,"The 'Metal (total)' row should be equal to the sum of the Steel' and 'Aluminium' rows (when reported all of these values since according to the old rules provision of separate data for aluminium and steel packaging would be voluntary)."]
[null,null,null,"The 'Total' row should be a sum of all the amounts given in the separate rows within the table except  'Steel' and 'Aluminium' rows to ensure there is no double counting."]
[null,null,null,"The \"Packaging Waste Generated \" column must be bigger than the \"Packaging Waste Recycled\" column.  Including an explanatory footnote this is a warning, because in exceptional circumstances it could be smaller."]
[null,null,"TABLE_2: "]
[null,null,null,"All reported figures must be between 0 and 100."]
[null,null,"TABLE_3: "]
[null,null,null,"The 'Total' row should be a sum of all the amounts given in the separate rows within the table."]
[null,null,null,"The columns concerning 'Sales packaging\"' must be smaller than the respective \"all packaging\" columns (having the same unit)"]
[null,null,null,"\"Reusable packaging placed on the market for the first time\" must be smaller than \"Packaging placed on the market for the first time\""]
[]
[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."]
[null,null,"Explanatory footnotes must not contain hidden characters such as tabulators, carriage return or line feed. "]

{"sheet":"GETTING STARTED","index":6,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,2,3,6],[4,2,4,6],[6,2,6,6],[24,2,24,6],[13,3,13,6],[15,3,15,6],[17,3,17,6],[19,3,19,6],[21,3,21,6]]}
[]
[]
[null,null,null,null,null,null,"STATISTICAL OFFICE OF THE EUROPEAN UNION"]
[null,null,{"$f":"Lists!K7","v":"Annual reporting of Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils"}]
[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,"Finland",null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B40,2,FALSE))","v":"FI"}]
[null,null,"Reference year:    ",null,2021]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 June 2022"}]
[null,null,"Who is the primary contact point for annual reporting of municipal waste in your country?"]
[]
[null,null,"Name:","Heidi Pirtonen"]
[]
[null,null,"Institution:","Finnish Environment Institute"]
[]
[null,null,"Unit:","Circular economy solutions, Waste"]
[]
[null,null,"Telephone:","+358 295 251 677"]
[]
[null,null,"Email address:","heidi.pirtonen@syke.fi"]
[]
[]
[null,null,"Eurostat would be grateful if you could send us the completed questionnaire ahead of the deadline. "]

{"sheet":"Footnotes list","index":7,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,3,1,4],[3,3,3,4],[4,3,4,4],[6,3,6,4],[7,3,7,4]]}
[]
[]
[null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF MINERAL AND SYNTHETIC LUBRICATION AND INDUSTRIAL OILS AND WASTE OILS"}]
[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":"Finland"}]
[null,null,null,1,"Contains all PRODCOM 1920290000.   Amount of production is calculated using value of the sold production ja import prices. All oil classes under reporting obligations included in the sum. Only PRODCOM-classified data available."]
[null,null,null,2,"Data not available"]
[null,null,null,3,"Register data has no entries in the category combination, assumed to be zero"]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]

{"sheet":"Table 1","index":8,"n_rows":33,"n_cols":71,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,54,11,57],[11,58,11,61],[11,62,11,65],[6,60,6,61],[6,68,6,69],[11,66,11,69],[1,70,3,70],[11,6,11,9],[11,10,11,13],[11,14,11,17],[11,18,11,21],[11,22,11,25],[11,26,11,29],[11,30,11,33],[11,34,11,37],[11,38,11,41],[11,42,11,45],[11,46,11,49],[11,50,11,53],[6,8,6,9],[6,12,6,13],[6,20,6,21],[6,28,6,29],[6,36,6,37],[6,16,6,17],[6,24,6,25],[6,32,6,33],[6,40,6,41],[6,48,6,49],[6,56,6,57],[6,64,6,65],[4,10,4,13],[4,14,4,21],[4,22,4,29],[4,30,4,37],[4,38,4,45],[5,30,5,37],[5,38,5,45],[5,46,5,53],[5,54,5,61],[5,62,5,69],[6,44,6,45],[6,52,6,53],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[1,4,1,69],[2,6,2,69],[3,6,3,69],[4,6,4,9],[4,46,4,53],[4,54,4,61],[4,62,4,69],[4,4,6,5],[5,6,5,9],[5,10,5,13],[5,14,5,21],[5,22,5,29]]}
[]
[null,null,null,null,"Table 1. Reporting on data on the placing on the market of mineral and synthetic lubrication and industrial oils and on the treatment of waste oils (in tonnes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plausibility Warning"]
[null,null,null,null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,null,"Reference year: ",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2021}]
[null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,"Oils placed on the market5",null,null,null,"Waste oil generated6 (dry oil)",null,null,null,"Separately collected7 waste oils ",null,null,null,null,null,null,null,"Exported8 waste oils",null,null,null,null,null,null,null,"Imported9 waste oils",null,null,null,null,null,null,null,"Regeneration10",null,null,null,null,null,null,null,"Other recycling11",null,null,null,null,null,null,null,"Energy recovery12 (R1) ",null,null,null,null,null,null,null,"Disposal13"]
[null,null,null,null,null,null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote",null,"Including water (t)","Standard footnotes","Explanatory\nfootnote",null,"Dry oil14 (t)","Standard footnotes","Explanatory\nfootnote"]
[null,null,null,null,"Engine and gear box oils1",null,359659.79741899599,"E",1,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Contains all PRODCOM 1920290000.   Amount of production is calculated using value of the sold production ja import prices. All oil classes under reporting obligations included in the sum. Only PRODCOM-classified data available."},22897,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},24888,null,null,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AA8,AQ8,AY8,BG8,BO8,AI8))=\"\",\"\",AA8+AQ8+AY8+BG8+BO8-AI8)","v":-1250},null,null,{"$f":"IF(TRIM(U8)=\"\", \"\", IF(VLOOKUP(U8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC8)=\"\", \"\", IF(VLOOKUP(AC8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},26062,null,null,{"$f":"IF(TRIM(AG8)=\"\", \"\", IF(VLOOKUP(AG8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},23977,null,null,{"$f":"IF(TRIM(AK8)=\"\", \"\", IF(VLOOKUP(AK8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,21206,null,null,{"$f":"IF(TRIM(AS8)=\"\", \"\", IF(VLOOKUP(AS8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,0,null,null,{"$f":"IF(TRIM(BA8)=\"\", \"\", IF(VLOOKUP(BA8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,569,null,null,{"$f":"IF(TRIM(BI8)=\"\", \"\", IF(VLOOKUP(BI8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,952,null,null,{"$f":"IF(TRIM(BQ8)=\"\", \"\", IF(VLOOKUP(BQ8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BQ8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF((O8<S8),\"Warning: section 3 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((W8<AA8),\"Warning: section 4 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AE8<AI8),\"Warning: section 5 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",\"No warning\")))","v":"No warning"}]
[null,null,null,null,"Industrial oils2",null,null,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},2099,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},2281,null,null,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AA9,AQ9,AY9,BG9,BO9,AI9))=\"\",\"\",AA9+AQ9+AY9+BG9+BO9-AI9)","v":2098},null,null,{"$f":"IF(TRIM(U9)=\"\", \"\", IF(VLOOKUP(U9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC9)=\"\", \"\", IF(VLOOKUP(AC9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AG9)=\"\", \"\", IF(VLOOKUP(AG9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK9)=\"\", \"\", IF(VLOOKUP(AK9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,1757,null,null,{"$f":"IF(TRIM(AS9)=\"\", \"\", IF(VLOOKUP(AS9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,0,null,null,{"$f":"IF(TRIM(BA9)=\"\", \"\", IF(VLOOKUP(BA9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,96,null,null,{"$f":"IF(TRIM(BI9)=\"\", \"\", IF(VLOOKUP(BI9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,null,245,null,null,{"$f":"IF(TRIM(BQ9)=\"\", \"\", IF(VLOOKUP(BQ9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BQ9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF((O9<S9),\"Warning: section 3 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((W9<AA9),\"Warning: section 4 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AE9<AI9),\"Warning: section 5 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",\"No warning\")))","v":"No warning"}]
[null,null,null,null,"Industrial oils (emulsions only)3",null,null,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},482,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},4824,null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(AA10,AQ10,AY10,BG10,BO10,AI10))=\"\",\"\",AA10+AQ10+AY10+BG10+BO10-AI10)","v":482},null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC10)=\"\", \"\", IF(VLOOKUP(AC10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AG10)=\"\", \"\", IF(VLOOKUP(AG10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK10)=\"\", \"\", IF(VLOOKUP(AK10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AO10)=\"\", \"\", IF(VLOOKUP(AO10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AS10)=\"\", \"\", IF(VLOOKUP(AS10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AW10)=\"\", \"\", IF(VLOOKUP(AW10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(BA10)=\"\", \"\", IF(VLOOKUP(BA10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},3542,null,null,{"$f":"IF(TRIM(BE10)=\"\", \"\", IF(VLOOKUP(BE10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},354,null,null,{"$f":"IF(TRIM(BI10)=\"\", \"\", IF(VLOOKUP(BI10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},1282,null,null,{"$f":"IF(TRIM(BM10)=\"\", \"\", IF(VLOOKUP(BM10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BM10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},128,null,null,{"$f":"IF(TRIM(BQ10)=\"\", \"\", IF(VLOOKUP(BQ10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BQ10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF((O10<S10),\"Warning: section 3 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((W10<AA10),\"Warning: section 4 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AE10<AI10),\"Warning: section 5 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AM10<AQ10),\"Warning: section 6 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AU10<AY10),\"Warning: section 7 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((BC10<BG10),\"Warning: section 8 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((BK10<BO10),\"Warning: section 9 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",\"No warning\")))))))","v":"No warning"}]
[null,null,null,null,"Oil and concentrates from separation4",null,null,null,null,null,null,null,null,null,4,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},4,null,null,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC11)=\"\", \"\", IF(VLOOKUP(AC11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AG11)=\"\", \"\", IF(VLOOKUP(AG11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AK11)=\"\", \"\", IF(VLOOKUP(AK11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AO11)=\"\", \"\", IF(VLOOKUP(AO11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AS11)=\"\", \"\", IF(VLOOKUP(AS11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(AW11)=\"\", \"\", IF(VLOOKUP(AW11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(BA11)=\"\", \"\", IF(VLOOKUP(BA11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(BE11)=\"\", \"\", IF(VLOOKUP(BE11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},0,null,null,{"$f":"IF(TRIM(BI11)=\"\", \"\", IF(VLOOKUP(BI11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},4,null,null,{"$f":"IF(TRIM(BM11)=\"\", \"\", IF(VLOOKUP(BM11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BM11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},4,null,null,{"$f":"IF(TRIM(BQ11)=\"\", \"\", IF(VLOOKUP(BQ11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BQ11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF((O11<S11),\"Warning: section 3 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((W11<AA11),\"Warning: section 4 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AE11<AI11),\"Warning: section 5 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AM11<AQ11),\"Warning: section 6 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((AU11<AY11),\"Warning: section 7 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((BC11<BG11),\"Warning: section 8 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",IF((BK11<BO11),\"Warning: section 9 -- 'Including water' cannot be lower than 'dry oil'. Please correct the values.\",\"No warning\")))))))","v":"No warning"}]
[null,null,null,null,null,null,{"$f":"IF(AND(OR(LEN(G8)>0,LEN(J8)>0), OR(LEN(G9)>0,LEN(J9)>0), OR(LEN(G10)>0, LEN(J10)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"Warning: mandatory cell is empty. Please provide value or explanation"},null,null,null,{"$f":"IF(AND(OR(LEN(K8)>0,LEN(N8)>0), OR(LEN(K9)>0,LEN(N9)>0), OR(LEN(K10)>0, LEN(N10)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(O8)>0,LEN(R8)>0), OR(LEN(O9)>0,LEN(R9)>0), OR(LEN(O10)>0, LEN(R10)>0), OR(LEN(O11)>0, LEN(R11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(S8)>0,LEN(V8)>0), OR(LEN(S9)>0,LEN(V9)>0), OR(LEN(S10)>0, LEN(V10)>0), OR(LEN(S11)>0, LEN(V11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(W8)>0,LEN(Z8)>0), OR(LEN(W9)>0,LEN(Z9)>0), OR(LEN(W10)>0, LEN(Z10)>0), OR(LEN(W11)>0, LEN(Z11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"Warning: mandatory cell is empty. Please provide value or explanation"},null,null,null,{"$f":"IF(AND(OR(LEN(AA8)>0,LEN(AD8)>0), OR(LEN(AA9)>0,LEN(AD9)>0), OR(LEN(AA10)>0, LEN(AD10)>0), OR(LEN(AA11)>0, LEN(AD11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"Warning: mandatory cell is empty. Please provide value or explanation"},null,null,null,{"$f":"IF(AND(OR(LEN(AE8)>0,LEN(AH8)>0), OR(LEN(AE9)>0,LEN(AH9)>0), OR(LEN(AE10)>0, LEN(AH10)>0), OR(LEN(AE11)>0, LEN(AH11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(AI8)>0,LEN(AL8)>0), OR(LEN(AI9)>0,LEN(AL9)>0), OR(LEN(AI10)>0, LEN(AL10)>0), OR(LEN(AI11)>0, LEN(AL11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(AM10)>0,LEN(AP10)>0),OR(LEN(AM11)>0,LEN(AP11)>0)),\"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(AQ8)>0,LEN(AT8)>0), OR(LEN(AQ9)>0,LEN(AT9)>0), OR(LEN(AQ10)>0, LEN(AT10)>0), OR(LEN(AQ11)>0, LEN(AT11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(AU10)>0,LEN(AX10)>0),OR(LEN(AU11)>0,LEN(AX11)>0)),\"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(AY8)>0,LEN(BB8)>0), OR(LEN(AY9)>0,LEN(BB9)>0), OR(LEN(AY10)>0, LEN(BB10)>0), OR(LEN(AY11)>0, LEN(BB11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(BC10)>0,LEN(BF10)>0),OR(LEN(BC11)>0,LEN(BF11)>0)),\"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(BG8)>0,LEN(BJ8)>0), OR(LEN(BG9)>0,LEN(BJ9)>0), OR(LEN(BG10)>0, LEN(BJ10)>0), OR(LEN(BG11)>0, LEN(BJ11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(BK10)>0,LEN(BN10)>0),OR(LEN(BK11)>0,LEN(BN11)>0)),\"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(AND(OR(LEN(BO8)>0,LEN(BR8)>0), OR(LEN(BO9)>0,LEN(BR9)>0), OR(LEN(BO10)>0, LEN(BR10)>0), OR(LEN(BO11)>0, LEN(BR11)>0)), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"}]
[null,null,null,null,"Notes:"]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is mandatory."]
[null,null,null,null,"Grey: The calculation of data is automatic. The cell can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[null,null,null,null,"Beige: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,"Black: Not applicable."]
[]
[null,null,null,null,"1 Including engine oils and gear oils (automotive, aviation, marine, industrial and other sectors); excluding greases and bilge oils."]
[null,null,null,null,"2 Including machine oils, hydraulic oils, oils for turbines, transformer oils, heat transmission oils, compressor oils, base oils; excluding greases and oils used for emulsions."]
[null,null,null,null,"3 Including metal working oils; in case national reporting does not distinguish industrial oils used in emulsions or otherwise, aggregated data on industrial oils may be provided and shall be specified in row ‘industrial oils’."]
[null,null,null,null,"4 Only waste oils under code 190207* of Decision 2000/532/EC."]
[null,null,null,null,"5 Oils placed on the market in a Member State taking into account export losses (e.g. export of passenger cars) and import gains (e.g. imports of passenger cars)."]
[null,null,null,null,"6 Amount of waste oils taking into account handling losses and losses during use. Amounts of waste oil generated may be calculated based on national statistics or by using the reference values listed in Table 4."]
[null,null,null,null,"7 Waste oils separately collected. In case collected waste oils are quantified by volume, the corresponding mass is determined by applying a conversion factor of 0,9 tonnes/m3."]
[null,null,null,null,"8 Waste oil exported to another country (considering the waste categories set out in Regulation (EC) No 1013/2006)."]
[null,null,null,null,"9 Waste oil generated in another country and imported from that country (considering the waste categories set out in Regulation (EC) No 1013/2006)."]
[null,null,null,null,"10-13 Amounts reported shall relate to the waste oil separately collected. The sum of the values for dry oil in columns 6 to 9 should be equal to the sum of the values for dry oil in column 3 adjusted for exported and imported waste oils (column 3 – column 4 + column 5 = column 6 + column 7 + column 8 + column 9)."]
[null,null,null,null,"11 Recycling other than regeneration, e.g. as flux oil."]
[null,null,null,null,"12 Including use of recovered oils as fuel, in accordance with the definition of recovery in Article 3(15) of Directive 2008/98/EC."]
[null,null,null,null,"13 Disposal operation D10 Incineration on land as laid down in Annex I of Directive 2008/98/EC."]
[null,null,null,null,"14 Waste oil excluding water content. The dry oil content is determined by measuring the water content. For waste oils other than emulsions, the dry content may alternatively be determined on the basis of a water content of 8 %. For dry oil in emulsions of industrial oils the dry content may alternatively be determined on the basis of a water content of 90 %."]

{"sheet":"Table 2","index":9,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[[22,6,22,9],[22,10,22,13],[22,14,22,17],[5,4,6,5],[5,6,5,9],[5,10,5,13],[5,14,5,17],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[5,18,5,21],[6,8,6,9],[6,12,6,13],[6,16,6,17],[6,20,6,21],[1,4,1,21],[2,6,2,21],[3,6,3,21],[4,6,4,9],[4,10,4,13],[4,14,4,17],[4,18,4,21],[4,4,4,5],[21,4,21,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5]]}
[]
[null,null,null,null,"Table 2. Reporting on data on the treatment of waste oils (in tonnes)"]
[null,null,null,null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,null,"Reference year: ",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2021}]
[null,null,null,null,"Section                                      1",null,2,null,null,null,3,null,null,null,4,null,null,null,5]
[null,null,null,null,"Type of output from recovery",null,"Regeneration1",null,null,null,"Other recycling",null,null,null,"Energy recovery or reprocessing into materials that are to be used as fuels (including regenerated oils used as fuel) ",null,null,null,"Disposal (D10)"]
[null,null,null,null,null,null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote",null,"(t)","Standard footnotes","Explanatory\nfootnote"]
[null,null,null,null,"Regenerated base oil – group I2, 3",null,null,null,2,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"},null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Regenerated base oil – group II4 ",null,null,null,2,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"},null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Regenerated base oil – group III5",null,null,null,2,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"},null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Regenerated base oil – group IV6",null,null,null,2,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"},null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Recycled products7 (specify)",null,null,null,null,null,0,null,3,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Register data has no entries in the category combination, assumed to be zero"}]
[null,null,null,null,"Fuel products for off-site energy recovery – Light fuel oil",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Fuel products for off-site energy recovery – Distillate fuel oil",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Fuel products for off-site energy recovery – Heavy fuel oil",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Fuel products for off-site energy recovery – Recovered fuel oil",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Fuel products for off-site energy recovery – Processed fuel oil",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"On-site energy recovery8",null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(TRIM(Q18)=\"\", \"\", IF(VLOOKUP(Q18,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q18,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"}]
[null,null,null,null,"Other",null,null,null,2,{"$f":"IF(TRIM(I19)=\"\", \"\", IF(VLOOKUP(I19,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I19,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":"Data not available"},{"$f":"IF(TRIM(CONCATENATE(K20,K21,K22))=\"\",\"\",SUM(K20:K22))","v":""},null,null,{"$f":"IF(TRIM(M19)=\"\", \"\", IF(VLOOKUP(M19,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M19,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(O20,O21,O22))=\"\",\"\",SUM(O20:O22))","v":""},null,null,{"$f":"IF(TRIM(Q19)=\"\", \"\", IF(VLOOKUP(Q19,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q19,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE('Table 1'!BO8, 'Table 1'!BO9, 'Table 1'!BO10,'Table 1'!BO11))=\"\",\"\",SUM('Table 1'!BO8:BO11))","v":1329},null,null,{"$f":"IF(TRIM(U19)=\"\", \"\", IF(VLOOKUP(U19,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U19,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,"[specify 'other']",null,null,null,null,{"$f":"IF(TRIM(I20)=\"\", \"\", IF(VLOOKUP(I20,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I20,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M20)=\"\", \"\", IF(VLOOKUP(M20,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M20,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q20)=\"\", \"\", IF(VLOOKUP(Q20,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q20,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,"[specify 'other']",null,null,null,null,{"$f":"IF(TRIM(I21)=\"\", \"\", IF(VLOOKUP(I21,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I21,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M21)=\"\", \"\", IF(VLOOKUP(M21,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M21,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q21)=\"\", \"\", IF(VLOOKUP(Q21,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q21,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,"[specify 'other']",null,null,null,null,{"$f":"IF(TRIM(I22)=\"\", \"\", IF(VLOOKUP(I22,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I22,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M22)=\"\", \"\", IF(VLOOKUP(M22,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M22,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q22)=\"\", \"\", IF(VLOOKUP(Q22,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q22,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,null,null,{"$f":"IF(('Table 1'!AQ8+'Table 1'!AQ9+'Table 1'!AQ10+'Table 1'!AQ11)<(G8+G9+G10+G11+G19), \"WARNING: The sum of all outputs listed in Table 2, section 2, column '(t)' should be lower than the total input in Table 1, section 6, column 'dry oil (t)'\", IF(OR(LEN(G8)>0,LEN(J8)>0,LEN(G9)>0,LEN(J9)>0,LEN(G10)>0, LEN(J10)>0,LEN(G11)>0, LEN(J11)>0,LEN(G19)>0,LEN(J19)>0), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\"))","v":"No warning"},null,null,null,{"$f":"IF(OR(LEN(K12)>0,LEN(N12)>0,LEN(K20)>0,LEN(N20)>0,LEN(K21)>0,LEN(N21)>0,LEN(K22)>0,LEN(N22)>0),\"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"},null,null,null,{"$f":"IF(OR(LEN(O8)>0,LEN(R8)>0,LEN(O9)>0,LEN(R9)>0,LEN(O10)>0, LEN(R10)>0,LEN(O11)>0,LEN(R11)>0,LEN(O13)>0,LEN(R13)>0,LEN(O14)>0,LEN(R14)>0,LEN(O15)>0,LEN(R15)>0,LEN(O16)>0,LEN(R16)>0,LEN(O17)>0,LEN(R17)>0,LEN(O18)>0,LEN(R18)>0,LEN(O20)>0,LEN(R20)>0,LEN(O21)>0,LEN(R21)>0,LEN(O22)>0,LEN(R22)>0), \"No warning\",\"Warning: mandatory cell is empty. Please provide value or explanation\")","v":"No warning"}]
[null,null,null,null,"Notes:"]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Data provision is required."]
[null,null,null,null,"Light blue: Reporting is voluntary."]
[null,null,null,null,"Beige: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,"Black: Reporting is not applicable."]
[null,null,null,null,"Grey: The calculation of data is automatic. The cell can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[]
[null,null,null,null,"1 Amount of regenerated oils. The sum of the entries in Column 2 of table 2 divided by the sum of the entries in column 6 of Table 1 corresponds to the conversion efficiency of oil regeneration."]
[null,null,null,null,"2 Base oil group I contains less than 90 % saturates and/or more than 0,03 % sulphur and has a viscosity index greater than or equal to 80 and less than 120."]
[null,null,null,null,"3 In case national reporting does not distinguish groups I-IV, aggregated data on regenerated base oils may be provided and shall be specified in row ‘Other’."]
[null,null,null,null,"4 Base oil group II contains more than or equal to 90 % saturates and less than or equal to 0,03 % sulphur and has a viscosity index greater than or equal to 80 and less than 120."]
[null,null,null,null,"5 Base oil group III contains more than or equal to 90 % saturates and less than or equal to 0,03 % sulphur and has a viscosity index greater than or equal to 120."]
[null,null,null,null,"6 Base oil group IV are polyalphaolefins. Base oil not included in groups I-IV shall be specified in row ‘Other’."]
[null,null,null,null,"7 Includes recycled products from other recycling of waste oils reported under column 7 of Table 1."]
[null,null,null,null,"8 On-site energy recovery means recovery of waste oils through internal energy consumption e.g. in a refinery."]

{"sheet":"Table 3","index":10,"n_rows":19,"n_cols":62,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,5,1,61],[2,6,2,61],[3,6,3,61],[4,6,4,13],[4,14,4,21],[4,22,4,29],[4,30,4,37],[4,38,4,45],[4,46,4,53],[4,54,4,61],[5,38,5,45],[6,52,6,53],[6,60,6,61],[6,12,6,13],[6,20,6,21],[6,28,6,29],[6,36,6,37],[6,44,6,45],[5,46,5,53],[5,54,5,61],[5,6,5,13],[5,14,5,21],[5,22,5,29],[5,30,5,37],[6,8,6,9],[6,16,6,17],[6,24,6,25],[6,32,6,33],[6,40,6,41],[6,48,6,49],[6,56,6,57]]}
[]
[null,null,null,null,null,"Table 3. Reporting on data on the placing on the market of mineral and synthetic lubrication and industrial oils and treatment of waste oils other than those listed in Table 1 (in tonnes)"]
[null,null,null,null,null,"Country:",{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":"Finland"}]
[null,null,null,null,null,"Reference year:",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":2021}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,"Collected1 Waste Oils (t)",null,null,null,null,null,null,null,"Exported2 Waste Oils (t)",null,null,null,null,null,null,null,"Imported3 Waste Oils (t)",null,null,null,null,null,null,null,"Disposal4 (D10) (t)",null,null,null,null,null,null,null,"Regeneration (t)5",null,null,null,null,null,null,null,"Other recycling6 (t)",null,null,null,null,null,null,null,"Energy recovery(t)7"]
[null,null,null,null,null,null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote",null,"Including water (t)","Standard footnotes","Explanatory footnote",null,"Dry oil (t)","Standard footnotes","Explanatory footnote"]
[null,null,null,null,null,"Process oils",null,null,null,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U8)=\"\", \"\", IF(VLOOKUP(U8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC8)=\"\", \"\", IF(VLOOKUP(AC8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG8)=\"\", \"\", IF(VLOOKUP(AG8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK8)=\"\", \"\", IF(VLOOKUP(AK8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO8)=\"\", \"\", IF(VLOOKUP(AO8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS8)=\"\", \"\", IF(VLOOKUP(AS8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AW8)=\"\", \"\", IF(VLOOKUP(AW8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BA8)=\"\", \"\", IF(VLOOKUP(BA8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BE8)=\"\", \"\", IF(VLOOKUP(BE8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BI8)=\"\", \"\", IF(VLOOKUP(BI8,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI8,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,null,"Industrial oils not lubricating",null,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U9)=\"\", \"\", IF(VLOOKUP(U9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC9)=\"\", \"\", IF(VLOOKUP(AC9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG9)=\"\", \"\", IF(VLOOKUP(AG9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK9)=\"\", \"\", IF(VLOOKUP(AK9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO9)=\"\", \"\", IF(VLOOKUP(AO9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS9)=\"\", \"\", IF(VLOOKUP(AS9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AW9)=\"\", \"\", IF(VLOOKUP(AW9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BA9)=\"\", \"\", IF(VLOOKUP(BA9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BE9)=\"\", \"\", IF(VLOOKUP(BE9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BI9)=\"\", \"\", IF(VLOOKUP(BI9,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI9,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,null,"Greases",null,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC10)=\"\", \"\", IF(VLOOKUP(AC10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG10)=\"\", \"\", IF(VLOOKUP(AG10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK10)=\"\", \"\", IF(VLOOKUP(AK10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO10)=\"\", \"\", IF(VLOOKUP(AO10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS10)=\"\", \"\", IF(VLOOKUP(AS10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AW10)=\"\", \"\", IF(VLOOKUP(AW10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BA10)=\"\", \"\", IF(VLOOKUP(BA10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BE10)=\"\", \"\", IF(VLOOKUP(BE10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BI10)=\"\", \"\", IF(VLOOKUP(BI10,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI10,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,null,"Extracts from lubricant refining",null,null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC11)=\"\", \"\", IF(VLOOKUP(AC11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG11)=\"\", \"\", IF(VLOOKUP(AG11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK11)=\"\", \"\", IF(VLOOKUP(AK11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO11)=\"\", \"\", IF(VLOOKUP(AO11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS11)=\"\", \"\", IF(VLOOKUP(AS11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AW11)=\"\", \"\", IF(VLOOKUP(AW11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BA11)=\"\", \"\", IF(VLOOKUP(BA11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BE11)=\"\", \"\", IF(VLOOKUP(BE11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BI11)=\"\", \"\", IF(VLOOKUP(BI11,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI11,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[null,null,null,null,null,"Bilge oils",null,null,null,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U12)=\"\", \"\", IF(VLOOKUP(U12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(U12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AC12)=\"\", \"\", IF(VLOOKUP(AC12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AC12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AG12)=\"\", \"\", IF(VLOOKUP(AG12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AG12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AK12)=\"\", \"\", IF(VLOOKUP(AK12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AK12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AO12)=\"\", \"\", IF(VLOOKUP(AO12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AO12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AS12)=\"\", \"\", IF(VLOOKUP(AS12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AS12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(AW12)=\"\", \"\", IF(VLOOKUP(AW12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(AW12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BA12)=\"\", \"\", IF(VLOOKUP(BA12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BA12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BE12)=\"\", \"\", IF(VLOOKUP(BE12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BE12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(BI12)=\"\", \"\", IF(VLOOKUP(BI12,'Footnotes list'!$D$5:$E$54,2,FALSE)=0,\"\",VLOOKUP(BI12,'Footnotes list'!$D$5:$E$54,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"Notes:"]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"Light blue: Reporting is voluntary."]
[null,null,null,null,null,"Beige: Footnotes (only to be filled-in when relevant)"]
[]
[null,null,null,null,null,"1–7 See column sections 3 to 9 in Table 1, and the corresponding Notes for explanations of the terms used."]

{"sheet":"Quality Report","index":11,"n_rows":130,"n_cols":12,"rows_kept":130,"cut":false,"hidden":false,"merged":[[18,1,18,5],[17,6,17,12],[18,6,18,12],[14,1,14,12],[24,6,24,12],[6,7,6,12],[6,1,6,6],[1,4,1,9],[17,1,17,5],[2,4,2,9],[36,1,36,3],[30,11,31,12],[25,1,25,11],[26,1,26,12],[29,1,29,12],[19,6,19,12],[20,6,20,12],[21,6,21,12],[22,6,22,12],[23,6,23,12],[22,1,22,5],[23,1,23,5],[24,1,24,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[32,11,32,12],[33,11,33,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[42,11,42,12],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[55,1,55,12],[56,1,56,12],[48,1,48,12],[49,1,49,12],[51,1,51,12],[52,1,52,12],[54,1,54,12],[43,1,43,12],[45,1,45,12],[46,1,46,12],[40,8,40,9],[41,8,41,9],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,8,42,9],[53,1,53,12],[61,7,61,8],[110,1,110,12],[111,1,111,11],[112,1,112,12],[113,1,113,12],[107,1,107,11],[109,1,109,12],[90,1,90,12],[91,1,91,12],[92,1,92,12],[93,1,93,12],[62,5,62,6],[63,5,63,6],[62,2,62,3],[63,2,63,3],[60,2,60,3],[60,5,60,6],[101,6,101,12],[102,6,102,12],[103,6,103,12],[62,7,62,8],[63,7,63,8],[60,9,60,10],[39,8,39,9],[50,1,50,12],[47,1,47,12],[86,1,86,12],[83,1,83,12],[84,1,84,12],[85,1,85,12],[72,1,72,12],[73,1,73,12],[77,1,77,12],[78,1,78,11],[79,1,79,12],[64,1,64,12],[66,1,66,12],[67,1,67,12],[69,1,69,12],[70,1,70,12],[65,1,65,12],[68,1,68,12],[60,7,60,8],[63,11,63,12],[61,5,61,6],[62,11,62,12],[61,11,61,12],[42,1,42,3],[31,1,31,3],[31,8,31,9],[30,4,30,10],[59,2,59,3],[59,5,59,6],[59,7,59,8],[59,9,59,10],[44,1,44,12],[30,1,30,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,11,40,12],[41,11,41,12],[59,11,59,12],[58,2,58,6],[58,7,58,12],[37,8,37,9],[38,8,38,9],[62,9,62,10],[63,9,63,10],[61,2,61,3],[115,2,115,12],[116,2,116,12],[71,1,71,12],[74,1,74,12],[94,1,94,12],[97,1,97,4],[97,6,97,12],[87,1,87,12],[80,1,80,12],[88,1,88,12],[89,1,89,12],[60,11,60,12],[117,2,117,12],[118,2,118,12],[119,2,119,12],[104,6,104,12],[105,6,105,12],[95,1,95,12],[96,1,96,12],[114,2,114,12],[108,1,108,12],[98,6,98,12],[106,6,106,12],[98,1,98,4],[106,1,106,4],[99,1,99,4],[100,1,100,4],[101,1,101,4],[102,1,102,4],[103,1,103,4],[104,1,104,4],[105,1,105,4],[99,6,99,12],[100,6,100,12],[61,9,61,10],[125,2,125,12],[126,2,126,12],[127,2,127,12],[128,2,128,12],[129,2,129,12],[120,2,120,12],[121,2,121,12],[122,2,122,12],[123,2,123,12],[124,2,124,12]]}
[]
[null,null,null,null,{"$f":"Lists!K7","v":"Annual reporting of Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils"}]
[null,null,null,null,"QUALITY REPORT"]
[null,null,null," "]
[null,{"$f":"CONCATENATE(\"Country: \", 'GETTING STARTED'!E9,\" (\",'GETTING STARTED'!G9,\")\")","v":"Country: Finland (FI)"},null,null,null,null,null,{"$f":"CONCATENATE(\"Reference year: \",'GETTING STARTED'!E10,IF('GETTING STARTED'!E10=2018,\" (only for voluntary reporting of 6 categories)\",\"\"))","v":"Reference year: 2021"}]
[]
[null,"Quality report",null,null,null,null,null,"Hyperlink"]
[null,"1. General information",null,null,null,null,null,"General information"]
[null,"2. Descriptions of methods used for data and information and for data collection",null,null,null,null,null,"Data collection & Methods"]
[null,"4. Accuracy of the data on mineral and synthetic lubrication and industrial oils and waste oils",null,null,null,null,null,"Data accuracy"]
[null,"5. Confidentiality",null,null,null,null,null,"Confidentiality"]
[null,"6. Main national websites, reference documents and publications",null,null,null,null,null,"References"]
[]
[]
[null,"The structure of the quality report follows the structure set out in Commission Implementing Decision (EU) 2019/1004, Annex VI. Where there are some differences the intention of the Act is maintained. However, changes have been introduced to ensure the responses are more accurate and easier to fill in by the Member States. Please aim to complete the Quality Report as it is structured. If it is not possible to provide the relevant information, please explain the reasons why; do not leave responses blank."]
[]
[null,"I. General information"]
[null,"1.1. Member State",null,null,null,null,{"$f":"CONCATENATE('GETTING STARTED'!E9,\" (\",'GETTING STARTED'!G9,\")\")","v":"Finland (FI)"}]
[null,"1.2. Organisation and unit submitting the data and the description"," ",null,null,null,{"$f":"CONCATENATE('GETTING STARTED'!D16, \", \", 'GETTING STARTED'!D18)","v":"Finnish Environment Institute, Circular economy solutions, Waste"}]
[null,"1.3. Contact name"," ",null,null,null,{"$f":"'GETTING STARTED'!D14","v":"Heidi Pirtonen"}]
[null,"1.4. Contact email address"," ",null,null,null,{"$f":"'GETTING STARTED'!D22","v":"heidi.pirtonen@syke.fi"}]
[null,"1.5. Contact phone number"," ",null,null,null,{"$f":"'GETTING STARTED'!D20","v":"+358 295 251 677"}]
[null,"1.6. Reference year"," ",null,null,null,{"$f":"'GETTING STARTED'!E10","v":2021}]
[null,"1.7. Delivery date / version"," "]
[null,"1.8. Link to data publication by the Member State (if any)"," "]
[null,"II. Information on oils placed on the market and waste oils"]
[null,"1. Data collection methods (the relevant column should be ticked and the last column should be filled in)"]
[null,"Place an 'x' in the relevant box to identify which method you use for each data set."]
[null,"If you use another method please describe this in the ‘Other (specify)’ column."]
[null,"The rows of the table are based on the columns of Table 1 of the waste oil reporting format."]
[null,null,null,null,"Data collection methods",null,null,null,null,null,null,"Detailed description of the methodology"]
[null,"Data set",null,null,"Administrative data","Surveys","Electronic registry","Data from waste operators","Data from extended producer responsibility  schemes",null,"Other (specify)"]
[null,"Oils placed on the market ",null,null,"x",null,null,null,null,null,null,"From Custom imp/exp.data  and Business register."]
[null,"Collected waste oils ",null,null,"x",null,null,null,null,null,null,"From env. authorities YLVA-register"]
[null,"Regeneration of waste oils",null,null,"x",null,null,null,null,null,null,"From env. authorities YLVA-register"]
[null,"Other recycling of waste oils ",null,null,"x",null,null,null,null,null,null,"From env. authorities YLVA-register"]
[null,"Energy recovery of waste oils",null,null,"x",null,null,null,null,null,null,"From env. authorities YLVA-register"]
[null,"Disposal of waste oils ",null,null,"x",null,null,null,null,null,null,"From env. authorities YLVA-register"]
[null,"[specify specific types of waste oil]"]
[null,"[specify specific types of waste oil]"]
[null,"[specify specific types of waste oil]"]
[null,"[specify specific types of waste oil]"]
[null,"[specify specific types of waste oil]"]
[null,"2. Description of the methodology used to determine the amount of waste oil generated"]
[null,"Please describe the method followed for calculating the amount of waste oil generated, as reported in Table 1, section 2."]
[]
[null,"3. Description of the method used to determine the dry oil content of the waste oil (e.g. chemical analysis of the water content, expert knowledge, etc.)"]
[null,"Please also explain whether the data on waste oils is measured as 'dry oil' or 'including water' and how the corresponding amount that includes water / dry oil is determined. Reporting of both data 'dry oil' and 'including  water' is mandatory. What is the water content considered for the different waste oil catergories (engine and gear box oils, etc.)?"]
[]
[null,"4. Description of the outputs of treated waste oils reported under the category “other recycling” and an indication of their amounts"]
[null,"Please provide the amounts of and describe the outputs of treated waste oils reported under the category \"Other recycling\" in Table 2, section 3."]
[]
[null,"5. Description of the method used to determine the amount of base oils used as fuel"]
[null,"Please describe the method that was used to determine how much base oils are used as fuel, from Table 2, section 4."]
[]
[null,"6. Data on waste oil treatment outside the Member State (export) and import and final treatment inside the Member State"]
[null,"This question refers to the amount of waste oil exported to another country, which is therefore subject to provisions of the Regulation (EC) 1013/2006, reported in sections 4 and 5 of Table 1 for waste oil. "]
[null,"Please provide data on the share of each treatment option (regeneration, other recycling, energy recovery and disposal in %) of the total waste oil exported and imported."]
[null,null,"Export of waste oil and treatment outside the Member State",null,null,null,null,"Import of waste oil and treatment inside the Member State"]
[null,"Waste oil category","Shipped to another EU Member State for final treatment (yes/no) ",null,"Exported outside the EU for final treatment (yes/no) ","Export: Share of each final treatment option outside the Member State (regeneration, other recycling, energy recovery and disposal) in %",null,"Imported from another EU Member State for final treatment in the Member State (yes/no) ",null,"Imported from a country outside the EU for final treatment in the Member State (yes/no) ",null,"Import: Share of each final treatment in the Member State (disposal, regeneration, other recycling, energy recovery) in %"]
[null,"Engine and gear box oils"]
[null,"Industrial oils"]
[null,"Industrial oils (emulsions only)"]
[null,"Oil and concentrates from separation"]
[null,"7. Detailed description of the specific measures for quality control and traceability of waste oils, in particular, as regards monitoring and validation of data"]
[null,"Please describe the specific measures to check the quality and ensure traceability of waste oils. A description of the monitoring and validation of data should be included."]
[]
[null,"8. Description of the data sources for treatment of waste oils in another Member State or outside the Union (e.g. Regulation (EC) No 1013/2006 or primary data from the treatment operator) and the quality of the data"]
[null,"Please detail data quality and the data sources used for the data concerning waste oil treatment in another Member State or outside of the European Union."]
[]
[null,"9. Description of any difficulties in collecting data from treatment operators located in another Member State or outside the Union"]
[null,"Please explain any difficulties your Member State encountered when collecting data from treatment operators that are located in a different Member State or are outside of the European Union."]
[]
[null,"10. Description of measures to ensure that the exporter of waste oils outside the Union can prove that the shipment of waste complies with the requirements of Regulation (EC) No 1013/2006 and that the treatment of waste outside the Union took place in conditions that are broadly equivalent to the requirements of the relevant Union environmental law"]
[null,"Please detail the applied measures that sought to make certain that exporters of waste oils to countries outside of the European Union could prove that the waste shipments comply with the applicable EU requirements. "]
[null,"In particular, the requirement under Regulation (EC) No 1013/2006 should be followed. "]
[null,"As well, waste treatment outside of the EU should occur under conditions that are broadly equivalent to the requirements of the applicable EU environmental law. "]
[]
[null,"11. Accuracy of the data"]
[null,"11.1.Description of main issues affecting the quality and accuracy of data on the generation, collection and treatment of waste oils, including errors related to sampling, coverage, measurement, processing and non-response"]
[null,"Please detail the primary issues that impact the data quality and accuracy for generation, collection and treatment of waste oils. The explanation should describe any errors that are linked to sampling, coverage, measurement, processing and non-response. "]
[null,"Please also describe if bio lubricant oils are included in the data. If yes, please estimate their share of lubricant oils placed on the market as well as of the collected waste oils."]
[null,"If available, please also describe the share of marine oil reported in the aggregated figure of motor and gear-box oil, as reported in row 1 of Table 1. "]
[]
[null,"11.2. Completeness of the data collection on mineral and synthetic lubrication and industrial oils and waste oils"]
[null,"Please include detailed information on how the sources of data cover all the amounts of mineral and synthetic lubrication and industrial oils placed on the market and waste oils collected and treated, and on any amounts added by using estimates, including how the estimates are determined and what share of the total amount of the respective data set they account for."]
[null,"Data addressing 'placed on the market' shall include lubricant and industrial oils placed on the market within vehicles, machineries and other products. Therefore, the export losses of lubricant oils (e.g. export of lubricant oils within passenger cars) and the import gains (e.g. imports of lubricant oils within passenger cars) shall be taken into account. Please explain if and how this is considered in the data collection."]
[null,"Please also describe if data is only available from one or more EPR schemes / PRO systems and the data is missing from additional organisations / companies involved in waste oil management."]
[]
[null,"11.3. Differences from previous year's data"]
[null,"If relevant, explain any significant methodological changes in the calculation method for the reported data in the current reference year compared to the previous year(s) of reporting. Please include in particular retrospective revisions, their nature and whether a break-flag is required for a certain year."]
[]
[null,"Explanation detailing the causes of the tonnage difference (which waste oils, sectors or estimates have caused the difference, and what the underlying cause is) for any category of waste oils treated which shows a greater than 10 % variation from the data submitted for the previous reference year."]
[null,"Completion of the table below is mandatory for each waste oil category and treatment method where the % variation is greater than 10% (see Table 1 for waste oil)."]
[null,"One row should be used for each waste oil category and treatment. The name of the waste oil category and treatment should be entered into the first column (e.g. regeneration of engine and gear box oils; energy recovery of industrial oils; etc)."]
[null,"The second column should contain the calculated % variation, and the third column should contain a description of the main reason(s) for this variation. "]
[null,"Providing a response that sufficiently clarifies the reasons for variation may require some in-depth analysis of the data reported from one year to the next."]
[null,"Waste oil category and treatment",null,null,null,"Variation (%)","Main reason for variation"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"[please specify]"]
[null,"III. Confidentiality"]
[null,"Justification to withhold the publication of specific parts of this report where that is requested (please indicate the exact elements not to be published, and why)."]
[null,"If specific parts of this report may not be published, please provide an explanation detailing the specific reasons and sections that should be exempt from publication."]
[]
[null,"IV. Main national websites, reference documents and publications"]
[null,"This includes reports addressing aspects of the data quality, coverage or other aspects of enforcement such as reports on best practice on waste oil collection and treatment, and reports on import, export or losses of oil."]
[null,"Please provide the name and url of the main websites, reference documents and publications related to this data collection."]
[null,null,"Name/ URL of reference document"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]

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

{"sheet":"Changelog","index":13,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Change","Changed by","SheetName","Cell","REMARKS"]
["v00.m20","2022-04-01","Add macros version 20","CDD"]
["v00.m20","2022-04-01","Initialise Specific Setting Sheets (SSS)","CDD"]
["v00.m20","2022-04-01","Add informative sheet \"Validation rules\"","CDD","Validation rules"]
["v00.m20","2022-04-01","Change tab colours to style guide convention","CDD","Data tables and quality report"]
["v00.m20","2022-04-01","Change formulas to prevent \"0\" when there is no data","CDD","Table 1","P8-P11","=IF(TRIM(CONCATENATE(X8,AN8,AV8,BD8,BL8,AF8))=\"\",\"\",X8+AN8+AV8+BD8+BL8-AF8)"]
[null,null,null,null,"Table 2","P19"]
[null,null,null,null,"Table 1,2,3","C3, C4","=IF('Getting started'!E10=\"\",\"\",'Getting started'!E10)"]
["v00.m20","2022-04-01","Substitution of \"Footnotes list\" sheet by the standard one","CDD","Footnotes list"]
["v00.m20","2022-04-01","Added columns to start data grid in G8","CDD","Table 1,2,3",null,"This is to create some placeholders for the codes in the future."]
["v00.m20","2022-04-01","Explanatory footnotes: dropdown list to \"footnotes list\"","CDD","Table 1,2,3"]

{"sheet":"Lists","index":14,"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]]}
["Country label","Country code",null,"Valid flags","Label",null,"yes",null,null,"Textual variables","String"]
["Belgium","BE",null,"B","break in time series",null,"no",null,null,"Institutional names"]
["Bulgaria","BG",null,"E","estimated data",null,null,null,null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ",null,"P","provisional",null,null,null,null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK",null,"BE",null,null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE",null,"BP",null,null,null,null,null,"Data collection information"]
["Estonia","EE",null,"EP",null,null,null,null,null,"Data Collection Text","Annual reporting of Mineral and Synthetic Lubrication and Industrial Oils and Waste Oils"]
["Ireland","IE",null,"BEP",null,null,null,null,null,"Data Collection Year",2022]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","29 April 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_OILS_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":15,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To"]
["Table 1","S8","S11",1,999,"Formulas","G8"]
["Table 2","K19","S19",999,4,"Formulas","G8"]

{"sheet":"IsFormula","index":16,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step"]
["Info","Table 1","S8","S11",1,999]
["Info","Table 2","K19","S19",999,4]

{"sheet":"Summations","index":17,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":true,"merged":[[6,5,6,6]]}
["Severity","Sheet Name","List of Cells\n (first block)","First Total Cell (first block)","Last Total Cell\n(Last block)","Row Block Repetition Step","Column Block Repetition Step","Greater or Equal","Valid Tolerance","Only if all data is available","Display text in error"]
["Error","Table 1","K10","S8","K8",1,999,"GE",0,"YES","Value of 'Waste oil generated' in section 2 should be larger than 'Separately collected waste oil' in section 3 column 'Dry oil'\")"]
[]
[]
[]
[]
[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":"Mandatory","index":18,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Empty Is Valid If Footnote Exists","Footnote Shift From Value"]
["Error","GETTING STARTED","E9","E10",1,999,"NO",999,"STANDARD FOR ALL QUESTIONNAIRES"]
["Error","GETTING STARTED","D14","D22",2,999,"NO",999]
["Error","Table 1","G8","K10",1,4,"YES",3]
["Error","Table 1","O8","AI11",1,4,"YES",3]
["Error","Table 1","AM10","BK11",1,8,"YES",3]
["Error","Table 1","AQ8","BO11",1,8,"YES",3]
["Error","Table 2","K12","K12",999,999,"YES",3]

{"sheet":"MandatoryAtLeast","index":19,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","List of Cells","Mandatory at least X cells","Mandatory at most Y cells","Display text in error"]
["Error","Table 2","G8,G9,G10,G11,G19",1,999]
["Error","Table 2","O8,O9,O10,O11,O13,O14,O15,O16,O17,O18,O19",1,999]
[]
[]
[]
[]
[]
[]
[]
["DESCRIPTION"]
["This sheet is meant to define the list of cells, of which at least one (or more, as indicated in column D) must be filled-in"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells",null,"First cell in the first block to be validated"]
["Mandatory at least X cells",null,"Number of cells in the list that, at least, must be filled in"]
["Mandatory at most Y cells",null,"Maximum number of cells in the list that must be filled in"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]

{"sheet":"ForbiddenStrings","index":20,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","ForbiddenString","Display text in error"]
["Warning","Footnotes list","E9","E58",1,999,"not available","Please verify the explanatory note sufficiently explains why the data is not available"]
["Warning","Footnotes list","E9","E58",1,999,"not reported","Please verify the explanatory note sufficiently explains why the data is not available"]
["Warning","Footnotes list","E9","E58",1,999,"unavailable data","Please verify the explanatory note sufficiently explains why the data is not available"]
["Warning","Footnotes list","E9","E58",1,999,"no data available","Please verify the explanatory note sufficiently explains why the data is not available"]

{"sheet":"FootnoteContent","index":21,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["Error","Table 1","I8","AJ10",1,4,1]
["Error","Table 1","Q11","AJ11",1,4,1]
["Error","Table 1","AO10","BQ11",1,4,1]
["Error","Table 1","AS8","BQ9",1,8,1]
["Error","Table 2","I8","Q11",1,8,1]
["Error","Table 2","I19","U19",999,4,1]
["Error","Table 2","M12","M12",999,999,1]
["Error","Table 2","Q13","Q18",1,999,1]
["Error","Table 2","U19","U19",999,999,1]

{"sheet":"MustNotBeNegative","index":22,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1","G8","K10",1,4]
["Error","Table 1","O8","AI11",1,4]
["Error","Table 1","AM10","BK11",1,8]
["Error","Table 1","AQ8","BO11",1,8]
["Error","Table 2","G8","O11",1,8]
["Error","Table 2","G19","S19",999,4]
["Error","Table 2","K12","K12",999,999]
["Error","Table 2","O13","O18",1,999]
["Error","Table 3","G8","BG12",1,4]

{"sheet":"IsNumeric","index":23,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1","G8","K10",1,4]
["Error","Table 1","O8","AI11",1,4]
["Error","Table 1","AM10","BK11",1,8]
["Error","Table 1","AQ8","BO11",1,8]
["Error","Table 2","G8","O11",1,8]
["Error","Table 2","G19","S19",999,4]
["Error","Table 2","K12","K12",999,999]
["Error","Table 2","O13","O18",1,999]
["Error","Table 3","G8","BG12",1,4]