{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Codes and labels","COVER","INDEX","Basic instructions","Validation rules","Methodology","METADATA","GETTING STARTED","Footnotes list","PEDS_ESA","Input for ECR-range","Catalogue of measures","ECR - range","Implicit transfers","ErrorLog","Changelog","Lists","MacroBehaviour","x Locks","IsFormula","StandardFootnotes","FootnoteContent","Summations","MustNotBeNegative","IsNumeric","Thresholds","Mandatory"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":14,"comments":2,"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":"Codes and labels","index":0,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Format and content still pending, but a list of the meaning of the codes (the ones in the heading of the sheets, the hidden ones NO)"]
["NA_ITEM: Codes in National Accounts (ESA 2010) for transactions"]
["D2","Taxes on production and imports"]
["D3","Subsidies"]
["D6","Social contributions and benefits"]
["D7","Other current transfers"]
["D9","Capital Transfers"]
[]
["SECTOR 2: Codes for institutional sectors in National Accounts (ESA 2010) paying the transfers"]
["S13","General Government"]
[]
["Unit: Monetary unit for reporting"]
["MIO_NAC","Millions of National Currency"]
["TCO2E","Toneladas de CO2 equivalent*"]
[]
["GEO: Country reporting"]
[]
[]
["Hidden codes:"]
["PEDS: Codes for Type of Potentially Environmentally Damaging Subsidy "]
["PEDS_FF","Potentially Environmentally Damaging Subsidies on Fossil Fuels"]
["PEDS_OTH","Other Potentially Environmentally Damaging Subsidies"]
["PEDS","Total PEDS, sum of the two previous categories"]
["NAP","Not applicable"]
[]
["NACE_R2: Codes for Industries receiving the subsidy (A10*)+ nec."]
["A"]
["B"]
["C"]
["D"]
["E"]
["F"]
["G"]
["H"]
["I-U"]
["NAL"]
["EP_HH"]
["TOTAL"]
["TOTAL_HH"]
[]
["SECTOR: Codes for Institutional sector in National Accounts (ESA 2010) receiving the transfer"]
["S11_S12_S14","Corporations plus Households"]
["S11_S12","Corporations"]
["S14","Households"]
["S1*","Average for the whole economy (in this case HH and Corporations)"]
[]
[]
[]
["*Since only CO2 is reported, is the same as simply CO2"]

{"sheet":"COVER","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[]
[null,null,{"$f":"Lists!K4","v":"Directorate E: Sectoral and regional statistics"}]
[null,null,{"$f":"Lists!K5","v":"Unit E-2: Environmental statistics and accounts; sustainable development"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[null,null,{"$f":"CONCATENATE(\"Launching date: \",Lists!K9)","v":"Launching date: December 15th 2023"}]

{"sheet":"INDEX","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,2,23,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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null," INDEX - STRUCTURE OF THE QUESTIONNAIRE"]
[]
[null,null,"I. Basic information"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Index","Structure of the questionnaire","for information"]
[null,null,"Basic instructions ","Basic instructions","for reading before filling in the questionnaire"]
[null,null,"Validation rules","Validation rules","for reading before filling in the questionnaire"]
[null,null,"Methodology","Explanatory notes and methodology","for reading before filling in the questionnaire"]
[null,null,"II. Reporting data (To be filled in by the country)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"GETTING STARTED","Country and data collection definition. Administrative data.","for filling in"]
[null,null,"Footnotes list","List of country-specific explanatory footnotes","for filling in"]
[null,null,"PEDS_ESA","TO EDIT","for filling in. "]
[null,null,"Input for ECR-range","TO EDIT","for filling in. "]
[null,null,"Catalogue of measures","TO EDIT","for filling in. "]
[null,null,"ECR - range","TO EDIT","For information / Filling in"]
[null,null,"ErrorLog","Validation result. List of errors and warnings revealed by the validation process","For consultation"]
[null,null,"III. Quality report (Orange tabbed sheets)"]
[null,null,"TITLE","DESCRIPTION","TYPE"]
[null,null,"Metadata ","Information on the methodology used for gathering the data reported in this questionnaire","for filling in"]

{"sheet":"Basic instructions","index":3,"n_rows":104,"n_cols":6,"rows_kept":104,"cut":false,"hidden":false,"merged":[[87,2,87,4],[34,3,34,5],[28,3,28,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[18,2,18,5],[20,2,20,5],[22,2,22,5],[27,2,27,5],[72,2,72,5],[63,3,63,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],[64,3,64,5],[69,3,69,5],[56,2,56,5],[58,2,58,5],[61,2,61,5],[62,3,62,5],[67,2,67,5],[68,3,68,5],[65,2,65,5],[57,2,57,5],[36,2,36,5],[38,2,38,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[54,2,54,5],[47,2,47,5],[49,2,49,5],[50,2,50,5],[52,2,52,5],[104,2,104,5],[80,2,80,5],[81,2,81,5],[83,2,83,5],[85,2,85,5],[86,2,86,5],[88,2,88,5],[89,2,89,5],[90,2,90,5],[91,2,91,5],[103,2,103,5],[100,2,100,5],[101,2,101,5],[96,2,96,5],[97,2,97,5],[102,2,102,5],[73,2,73,5],[75,2,75,5],[76,2,76,5],[78,2,78,5],[79,2,79,5],[93,2,93,5],[94,2,94,5],[95,2,95,5],[98,2,98,5],[99,2,99,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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[null,null,"Eurostat invites you to read carefully the “Basic instructions” tab before editing the data worksheets: “PEDS_ESA” ,“Input for ECR-range” and “Catalogue of measures”.  This EXCEL workbook is the questionnaire. Please do not  delete or add rows in the questionnaire. Note also that the questionnaire has hidden columns used for internal data processing."]
[null,null,"This EXCEL workbook contains macros. In order to make them work you need to save the file in your computer and then reopen it and enable macros to make it a trusted document."]
[null,null,"Once you filled in all the required fields, you have to validate the data before submitting the questionnaire (clicking on the button 'Validate questionnaire' on the top left-hand corner of the worksheets). It is of the utmost importance to confirm that there are no pending errors (see 'Errorlog' worksheet), since a questionnaire with errors (red shadowed cells) will be rejected. You can restore the color of the table clicking on 'Restore table color'."]
[null,null,"Table of contents"]
[null,null,"   1. Data transmission"]
[null,null,"   2. Basic reporting conventions"]
[null,null,"   3. Metadata"]
[" ","  ","   4. Footnotes"]
[null,null,"   5. Methodology and questions"]
[null,null,"   Annex 1: How to fill in the data sheets of the questionnaire\n   Annex 2: Reporting convention for 'not elsewhere classified', zeroes, 'not available' and more"]
[]
[null,null,"1. Data transmission:"]
[]
[null,null,"The standard tool for the transmission of statistical data is the eDAMIS system. The system creates a secure environment for the transmission of data, it records all data submissions and acknowledges the data delivery. The eDAMIS system has been installed in the National Statistical Institutes."]
[]
[null,null,"Please submit this questionnaire to Eurostat using the eDAMIS reporting system. Use the following details: "]
[null,null,"Domain name:",{"$f":"Lists!K12","v":"PEDS"}]
[null,null,"Dataset name:",{"$f":"Lists!K13","v":"ENVDATA_PEDS_A"}]
[]
[]
[null,null,"Should you have any questions regarding data transmission do not hesitate to contact your local eDAMIS coordinator or the Eurostat eDAMIS helpdesk at: "]
[null,null,"   web page:",{"$f":"Lists!K14","v":"https://webgate.ec.europa.eu/edamis/helpcenter/website/index.htm"}]
[null,null,"   e-mail address:",{"$f":"Lists!K15","v":"estat-support-edamis@ec.europa.eu"}]
[null,null,"   telephone:","(+352) 430133213"]
[null,null,"For methodological questions please contact:"]
[null,null,"   e-mail address:",{"$f":"Lists!K18","v":"ESTAT-ETEA-ESST-1@ec.europa.eu"}]
[null,null,"Reference year: ",2022]
[null,null,"Units of measure: ","PEDS_ESA: Millions of National Currency\nInput for ECR-range: Taxes in Millions of National Currency; Emissions in thousands of tonnes\nECR - range: AECR in National currency/tonne; Range of Emissions in percentage (/100)"]
[]
[null,null,"2.  Basic reporting conventions:"]
[]
[null,null,"Reporting of zeroes and not availble data must follow this convention:"]
[null,null,"Description","Symbol"]
[null,null,"Real zero or negligible",0]
[null,null,"Not available",null," (empty cell)"]
[]
[null,null,"1. White shaded (uncoloured) boxes: Provision of data"]
[null,null,"2. Grey shaded boxes: calculation is automatic; cells are protected. If for any technical issue, you were able to modify any of those cells, still please do not do it.  Please note that the formulae must not be overwritten. "]
[null,null,"3. Light orange boxes: Restricted to footnotes (see details in section 4 of this sheet)"]
[null,null,"4. Cyan boxes: Information beyond the primary scope of the questionnaire"]
[null,null,"3. Metadata:"]
[]
[null,null,"Please provide data by means of the \"Metadata\" worksheet. "]
[]
[]
[null,null,"4. Footnotes:"]
[]
[null,null,"You are asked to report data that follow as closely as possible PEDS guidance material and reporting rules (see paragraphs below). Please report problems with the coverage or data quality in the Metadata worksheet."]
[]
[null,null,"Flags (footnote symbols) should be entered in the reporting tables in the footnote columns, next to the value cell. There are three types of footnotes: "]
[null,null,"- Letters for standard footnotes and confidentiality (as defined by Eurostat) "]
[null,null,"- Numbers for country-specific 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 series","Please use this flag when the reported figure cannot be compared to the data reported for the previous year, e.g. because of new methods or sources being used or when you move from the old calculation rules to the new calculation rules. Please use this flag only when the change in methods, sources or calculation rules has a substantial impact."]
[null,null,"E) estimated data","Please use this flag only when a small subset of data points have been calculated using a significantly different methodology and/or sources than the rest of the data points in the questionnaire. Small methodological deviations should be explained in the METADATA tab and should not be flagged as estimate."]
[null,null,"P) provisional","Please use this flag when you plan to revise the data. All P) footnotes of data for references years submitted in an earlier data collection, for which no data is not resubmitted in the current data collection, will be systematically removed by Eurostat."]
[null,null,"The drop-down menu includes as well combinations of footnotes. If you need to put more than one footnote in a field, please, use these combinations in the drop-down menu."]
[null,null,"4.2. Confidentiality footnote"]
[null,null,"Report the confidential figure in the white value cell and add one of the following pre-defined footnote symbols: 'C) Confidential' or 'D) Secondary confidentiality'."]
[null,null,"C) Confidential data ","Please, use C) for confidential statistical information ( i.e. in cases where the value indeed has to be protected due to confidentiality). "]
[null,null,"\nD) Secondary confidentiality","Please, use C) for confidential statistical information ( i.e. in cases where the value indeed has to be protected due to confidentiality). D) Secondary confidentiality footnotes can be set to hide non-confidential values in order to prevent third parties to indirectly deduce confidential values. Please note that this footnote converts into confidential C) when published in Eurostat’s online database.\n "]
[null,null,"N) Not for publication","Please, use this flag when data is only for internal use by Eurostat and not to be published."]
[null,null,"4.3 Country-specific explanatory footnotes"]
[null,null,"The explanatory footnotes can be used for any meaning beyond the pre-defined footnotes.\n\nTo include an explanatory footnote, please first insert the text in the “Footnote list” sheet starting from number 1. Then in the data table please select the corresponding footnote reference number from the drop-down menu in the corresponding footnote column (to the left of the confidentiality one, i.e. columns J, O, T,Y ). The text you entered in the “Footnote list” sheet will then appear automatically next to the footnote reference number. The same explanatory footnote can be chosen for all the values for which the same explanation applies. If by mistake a number is chosen from the drop-down menu, it is sufficient to press the key delete to clean the cell.\n\nPlease do not report footnotes that elaborate on e.g. source data and compilation methods; these are to be described in the 'Metadata' tab"]
[null,null,"5. Methodology and questions:"]
[]
[null,null,"Guidance material for PEDS has been release in December 2022. Eurostat did not update it for the 2023 data collection.  Compilers are invited to ask for clarifications if needed."]
[null,null,{"$f":"Lists!K19","v":"https://ec.europa.eu/eurostat/web/environment/methodology"}]
[]
[null,null,"\nThe guidelines contain definitions, examples and recommendations to ensure that data are compiled and maintained on a consistent basis. They explain the scope and the 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."]
[null,null,"A summary methodology is presented in this questionnaire, in the sheet named 'Methodology'. It is essential to read this sheet before filling in the questionnaire as it contains, beside the summary methodology, important information on priorities for filling in the tables, data sources and hints for establishing a methodology at national level."]
[null,null,"If you have questions, please send them to the following email addresses:"]
[null,null,{"$f":"Lists!K18","v":"ESTAT-ETEA-ESST-1@ec.europa.eu"}]
[]
[null,null,"Annex 1: How to fill in the data sheets of the questionnaire"]
[]
[null,null,"You are kindly requested to:"]
[null,null,"1)    All data cells (whilte cells) must be filled in with a positive value or a zero."]
[null,null,"2)   Cyan cells refer to information beyond the primary scope of the questionnaire, which covers ESA transfers related to fossil fuels paid to institutional sectors. However, any information on any other PEDS transfers is welcomed"]
[null,null,"3)    Cells, which contain sums, are filled in automatically. In case, you realise that a formula should be added in a cell, please, send us an email with this formula. The formula may be helpful for all countries. Please, do not add the formula yourself. "]
[null,null,"4)    Flags (footnote symbols) can be entered in the reporting tables in the footnote columns."]
[null,null,"5)    To include standard footnotes use the drop-down menu."]
[null,null,"6)    The text of specific footnotes can be entered in the worksheet 'Footnotes list'."]
[]
[null,null,"Annex 2: Reporting conventions for 'not elsewhere classified', zeroes, 'not available' and more"]
[null,null,"1) When breakdown for transfers paid to corporations in 'PEDS_ESA' tab or Taxes/emissions associated to corporations in 'Input for ECR-range' is not available, all value must be reported under 'n.e.c.' category."]
[null,null,"2) Reporting n.e.c. with a value, while reporting all other NACEs with a zero, although it is technically possible with the current formulation is not allowed. If this reporting occurs and it is not corrected, data will not be validated."]
[null,null,"3) Reporting zero in 'n.e.c', while some NACEs are left empty is considered bad reporting by Eurostat, given that a zero in n.e.c. implies necessarely that NACEs are known (some with a value, some with zero). Therefore, countries will be asked during validation to report zero, if 'not available' (empty) appears in NACE, while 'n.e.c.' is zero. If it is the other way round and those NACEs are really 'not available', then, it is 'n.e.c.' the category to be changed by leaving it empty ('not available')"]
[null,null,"4) The last scenario in point 3 and any other in which 'n.e.c.' is empty, means that values exist, it is not possible to allocate it and it is not possible neither to have an estimation of the total amount of that value. This means Total Corporations are unknown, and subsequently the value for total transfers (fossil fuels or other PEDS). Therefore, those aggregates will be 'not available'"]
[null,null,"5) When 'n.e.c.' is reported in combination with other NACEs value also reported, consequences and interpretation differ depending on: a) 'n.e.c.' value referring to (potentially) all NACEs; b) 'n.e.c.' value referring only to NACEs with 'not available' (empty); c)'n.e.c' referring to a subset of NACEs combining values and 'not available', with other subset of NACEs not affected. Please, report in 'METADATA' tab point 10 to which NACEs, n.e.c. might refer. See below, what to do in each case and what to expect from Eurostat."]
[null,null,"      5a) Excessive values (not specific threshold established for the moment) in n.e.c. will be watched out, asking in the validation to allocate it to the correspondent\n      NACEs. If not possible, existing values in those NACEs will be asked to be added to 'n.e.c.', leaving those NACEs empty ('not available')."]
[null,null,"      5b) Excessive values (not specific threshold established for the moment) in n.e.c. will be watched out. Once, confirmed they only referred to 'not available',\n      NACEs values will be accepted."]
[null,null,"      5c) Excessive values (not specific threshold established for the moment) in n.e.c. will be watched out. Once, confirmed that there is a subset not affected by \n      this value, that subset will be accepted, asking to allocate the 'n.e.c' value to within the affected subset of NACEs. If not possible, existing values in that subset of \n      NACEs will be asked to be added to 'n.e.c.', leaving those NACEs empty ('not available')"]
[null,null,"6) Values in 'ECR-range' corresponding to average effective carbon rates, as a ratio, will require positive and reasonable values in 'Input for ECR-range' . The following well-known combination of numerator (taxes)/denominator (emissions) will lead to the unavailability of the values: 0/0; taxes>0/0 emissions; empty taxes/empty emissions; empty taxes/emissions>0; taxes>0/empty emissions.\n"]
[null,null,"0 taxes/ emissions>0 means that the AECR is zero, which is a strange, but plausible result. Therefore, a zero will appear automatically in the corresponding cell in 'ECR - range'"]

{"sheet":"Validation rules","index":4,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,2,9,5],[10,2,10,5],[14,2,14,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[21,2,21,5],[26,2,26,5],[22,2,22,5],[18,2,18,5],[19,2,19,5],[20,2,20,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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"VALIDATION RULES"]
[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,"2. Arithmetic rules"]
[]
[null,null,"All reported values must be equal or bigger than 0 (positive values). "]
[null,null,"PEDS_ESA tab"]
[null,null,"Total Subsidies on Fossil Fuels paid (Corporations + households) must be equal to the sum of Paid to households (Institutional sector as ESA-2010) and   Paid to corporations (Total NACE).\n Paid to corporations (Total NACE) must be equal to the sum of all Paid to NACE +    Transfers not elsewhere classified  "]
[null,null,"Input for ECR-range"]
[null,null,"TOTAL taxes paid (Corporations + households) must be equal to the sum of   Households as final consumers and Corporations (Total NACE).\nSimilarly for TOTAL CO2 (Corporations + households) must be equal to the sum of   Households as final consumers and Corporations (Total NACE).\nCorporations (Total NACE) must be equal to the sum of NACE + Not elsewhere classified ."]
[]
[null,null,"3. Explanatory footnotes"]
[]
[null,null,"When an explanatory footnote is referenced (by means of a number selected from the drop-down list), the referenced footnote in the sheet \"Footnotes list\" must not be empty."]

{"sheet":"Methodology","index":5,"n_rows":147,"n_cols":6,"rows_kept":147,"cut":false,"hidden":false,"merged":[[144,2,144,5],[128,2,128,5],[129,2,129,5],[130,2,130,5],[131,2,131,5],[147,2,147,5],[124,2,124,5],[125,2,125,5],[126,2,126,5],[143,2,143,5],[136,2,136,5],[140,2,140,5],[137,2,137,5],[145,2,145,5],[146,2,146,5],[141,2,141,5],[142,2,142,5],[97,2,97,5],[98,2,98,5],[80,2,80,5],[82,2,82,5],[81,2,81,5],[83,2,83,5],[85,2,85,5],[84,2,84,5],[87,2,87,5],[86,2,86,5],[88,2,88,5],[89,2,89,5],[90,2,90,5],[91,2,91,5],[93,2,93,5],[94,2,94,5],[95,2,95,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[19,2,19,5],[21,2,21,5],[23,2,23,5],[38,2,38,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[9,2,9,5],[20,2,20,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[30,2,30,5],[31,2,31,5],[32,2,32,5],[39,2,39,5],[72,2,72,5],[73,2,73,5],[74,2,74,5],[75,2,75,5],[76,2,76,5],[77,2,77,5],[40,2,40,5],[41,2,41,5],[78,2,78,5],[79,2,79,5],[42,2,42,5],[43,2,43,5],[45,2,45,5],[44,2,44,5],[58,2,58,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[53,2,53,5],[54,2,54,5],[57,2,57,5],[59,2,59,5],[60,2,60,5],[100,2,100,5],[109,2,109,5],[110,2,110,5],[111,2,111,5],[123,2,123,5],[96,2,96,5],[55,2,55,5],[56,2,56,5],[50,2,50,5],[51,2,51,5],[52,2,52,5],[61,2,61,5],[62,2,62,5],[63,2,63,5],[64,2,64,5],[67,2,67,5],[102,2,102,5],[101,2,101,5],[68,2,68,5],[65,2,65,5],[66,2,66,5],[69,2,69,5],[70,2,70,5],[71,2,71,5],[103,2,103,5],[104,2,104,5],[105,2,105,5],[106,2,106,5],[107,2,107,5],[108,2,108,5],[138,2,138,5],[139,2,139,5],[92,2,92,5],[112,2,112,5],[113,2,113,5],[114,2,114,5],[115,2,115,5],[116,2,116,5],[117,2,117,5],[118,2,118,5],[127,2,127,5],[133,2,133,5],[119,2,119,5],[120,2,120,5],[121,2,121,5],[122,2,122,5],[135,2,135,5],[99,2,99,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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"METHODOLOGY AND LEGAL ACTS"]
[null,null,"Table of contents"]
[null,null,"1. Background"]
[null,null,"2. Legal acts "]
[null,null,"3. Data reporting - questionnaire"]
[null,null,"   3.1 Data sheets"]
[null,null,"   3.2 Classifications"]
[null,null,"   3.3 Data sources"]
[null,null,"   3.4 confidentiality"]
[null,null,"4. Main references"]
[]
[null,null,"1. Background"]
[]
[null,null,"This reporting template allows Member States to report data on potential environmentally damaging subsidies."]
[null,null,"The reporting is a voluntary one initiated in December 2022. Proposal for this data reporting was agreed with the working group on environmental statistics in May 2022 and with the directors of sectoral and environmental statistics and accounts (DIMESA) in October 2022."]
[null,null,"The methodology sheet gives a summary of the most important methodological issues in the compilation of PEDS statistics: definition of subsidies, classifications, source for data compilation and reporting sheets in the questionnaire."]
[null,null,"The guidelines are available here (left double-click):"]
[]
[]
[null,null,"2.  Legal acts"]
[null,null,"Not applicable"]
[]
[null,null,"3. Data reporting - questionnaire"]
[]
[null,null,"This document assists Member States to report high quality, harmonised and efficient statistics. Detailed instructions can be found in the guidance document referred to above."]
[null,null,"The reporting shall cover a full calendar year."]
[null,null,"The basic instructions sheet consists of some information necessary for filling in this questionnaire correctly, like unit of measure, allowed symbols, metadata, footnotes, and transmission to Eurostat."]
[]
[null,null,"3.1 Data sheets"]
[null,null,"Countries are aked to fill in data in the three data sheets:"]
[null,null,"  3.1.1 PEDS_ESA"]
[null,null,"  3.1.2  Input for ECR-range"]
[null,null,"  3.1.3 Catalogue of measures"]
[null,null,"  3.1.4 The sheet ECR-range is automatically calculated. Please note that the related formulae must not be overwritten. "]
[]
[null,null,"Data related to PEDS_ESA and to Input for ECR-range are requested with the disctinction of the institutional sectors: either households (S.14) or corporations (S.11 + S.12) as recipients and tax payers, and futher by NACE activity when it comes to corporations; S13 general governament as provider of funds anc collector of taxes."]
[]
[null,null,"3.1.1 PEDS_ESA"]
[null,null,"The first table relates to fossil fuels subsidies."]
[null,null,"This tab collects data on ESA explicit transfers supporting fossil fuel production and consumption. Those ESA transfers refer to distributive transactions as in ESA2010 (D3, D6, D7, D9)."]
[null,null,"On the production side, the scope covers the ESA transfers allocated to producers of fossil fuels in all parts of the production cycle."]
[null,null,"On the consumption side, the scope includes ESA transfers that are  supporting consumption either in national currency per physical unit of product or with a fixed amount of money. The consumption of fossil fuels should be clearly liked to the consumption (invoices, purchases' proof, legislator motivation etc.)"]
[null,null,"Fossil fuels are delineated according to the classification of energy products in the Physical Energy Flow Accounts (PEFA) manual. "]
[null,null,"The second table relates to ESA transfers other than fossil fuels."]
[null,null,"The distributive transactions in question are transfers granted for other activities and products, different from fossil fuels, but that are potentially damaging the environment (air, soil, water, biodiversity, etc) and/or putting at risk the maintenance of the stock of natural resources."]
[]
[null,null,"3.1.2 Input for ECR-range"]
[null,null,"This tab collects two sets of data: 1. taxes imposed to fossil fuel combustion and 2. CO² emissions originated from fossil fuel combustion."]
[null,null,"Both datasets should refer to the same tax base. Only the CO² gas is considered here."]
[]
[null,null,"Taxes data to be included here are: carbon-specific taxes where the tax base related to carbon content of fuel, excise taxes on fossil fuels or similar, payments associated to ETS, specific distribution transactions."]
[null,null,"Data on CO² emissions arise from AEA. Emissions are those associated to fuel combustion (use side). From AEA compilation, emissions associated to common reporting format (CRF) code 1.A( ) are allocated to the different activities and households as final consumers. AEA could be compiled also based on the application of emission factors to PEFA, complemented by other ancillary information. In both cases, CO² emissions associated to fuel combustion must be available, by mapping the emissions from CRF 1.A or selecting the emissions coming from the application of the emissions factor to PEFA. "]
[null,null,"The OECD report (see [9]) describes the methodology underlying the effective carbon rate."]
[]
[null,null,"3.1.3 Catalogue of measures"]
[null,null,"The tab catalogue of measures collects data and metadata information on the transfers reported under the two other data sheets. It collects some other data countries would be ready to report such as implicit transfers etc."]
[]
[null,null,"3.1.4 ECR-range"]
[null,null,"This tab ECR-range is automatically calculated. Please note that the related formulae must not be overwritten. "]
[null,null,"The definition of the AECR introduced for PEDS compilation is: the average price paid for CO² emissions (through the amount of actual taxes imposed on fossil fuels combustion divided by CO² emissions associated to fossil fuel combustion)."]
[]
[null,null,"3.2 Classifications"]
[]
[null,null,"For the data reporting in the two tabs PEDS_ESA and Input for ECR-range, the main classifications used are :"]
[null,null,"- The NACE classification to classify corporations according to their main activity. NACE industries covered by this data collection are:"]
[null,null,"A Agriculture, forestry and fishing","    Paid to NACE A Agriculture, forestry and fishing"]
[null,null,"B Mining and quarrying;","    Paid to NACE B Mining and quarrying;"]
[null,null,"C Manufacturing","    Paid to NACE C Manufacturing"]
[null,null,"D Electricity, gas, steam and air conditioning supply ","    Paid to NACE D Electricity, gas, steam and air conditioning supply "]
[null,null,"E Water supply, sewerage, waste management and remedition activities","    Paid to NACE E Water supply, sewerage, waste management and remedition activities"]
[null,null,"F Construction","    Paid to NACE F Construction"]
[null,null,"G Wholesale and retail trade; repair of motor vehicles and motorcycles","    Paid to NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles"]
[null,null,"H Transportation and storage","    Paid to NACE H Transportation and storage"]
[null,null,"I-U Services (except wholosale and retail trade, transportation and storage) ","    Paid to NACE I-U Services (except wholosale and retail trade, transportation and storage) "]
[null,null,"- The classification of institutional sectors (S), see ESA 2010, chapter 23"]
[null,null,"S.1 Total economy"]
[null,null,"S.11 Non-financial corporations"]
[null,null,"S12. Financial corporations"]
[null,null,"S13. General government"]
[null,null,"S14. Households"]
[null,null,"S15. NPISH Non-profit institutions serving households"]
[null,null,"Data collected under the data tabs relate to S.14 when we refer to households and to (S.11 + S.12) when we refer to corporations. "]
[null,null,"- The classification of energy products as defined in PEFA manual, see page 22."]
[null,null,"P08 Hard coal"]
[null,null,"P09 Lignite & Peat"]
[null,null,"P10 Derived gases (= manufactured gases excl. biogas)"]
[null,null,"P11 Secondary coal products (coke, coal tar, patent fuel, BKB and peat products)"]
[null,null,"P12 Crude oil, NGL, and other hydrocarbons incl. Oil shale/sands(excl. bio)"]
[null,null,"P13 Natural gas"]
[null,null,"P14 Motor spirit (without bio)"]
[null,null,"P15 Kerosenes & jet fuels (without bio)"]
[null,null,"P16 Naphtha"]
[null,null,"P17 Transport diesel (without bio)"]
[null,null,"P18 Heating and other gasoil (without bio)"]
[null,null,"P19 Residual Fuel Oil"]
[null,null,"P20 Refinery gas, ethane & LPG"]
[null,null,"P21 Other petroleum products incl. additives/oxygenates and refinery feedstocks"]
[null,null,"P22 Nuclear fuel"]
[null,null,"P23 Wood, wood waste & other solid biomass, charcoa"]
[null,null,"P24 Liquid biofuels"]
[null,null,"P25 Biogas"]
[null,null,"P26 Electrical energy"]
[null,null,"P27 Heat"]
[]
[null,null,"3.3 Data sources"]
[]
[null,null,"To cover ESA explicit transfers on fossil fuels, there are two main set of data sources: one from the supply side (the provider of the subsidies) and the other from the demand side (the recipients of the subsidies)."]
[null,null,"Supply side data sources"]
[null,null,"Providers of the subsides are government structures: general governement or local governements.The most common data sources are national accounts and government statistics. "]
[null,null,"The national accounts ESA 2010 methodology refers to the table 11, Government expenditure by function (see [1], chapter 20 and page L 174/710)."]
[null,null,"Government statistics arise from the national accounts program, as well as specific government expenditure programmes regulated in many countries. However the references for specific government programmes are to be found at national level."]
[null,null,"Other national accounts data could be useful: supply and use tables data (see [1], chapter 9; tables 15 and 16)."]
[null,null,"Demand side data sources"]
[null,null,"Data sources from the demand side should capture the transfers from the perspective of the recipients. Recipients are either households or corporations."]
[null,null,"Main data source to capture subsidies received by households is the household budget survey (HBS). At European level, the household budget survey provides data on a 5-yearly"]
[null,null,"Data related to corporations may be reported in Structural Business Surveys (SBS) and in companies' annual reports. The fossil fuel sector tends to be concentrated. Therefore the number of companies to seek information for should be limited."]
[null,null,"Compilers may find as well data and information in newpapers, environmental advocating groups etc."]
[]
[null,null,"Data sources for ESA transfers covering other PEDS are more scarce. The DG ENV inventory (see [8]) identifies support measures relevant for PEDS for all EU member states."]
[]
[null,null,"Data sources for the average effective carbon rates are ETEA and AEA. The ETEA handbook will give the compilers a useful hint for the data sources related to taxes (see [6], section 4.3). The AEA handbook describes in its chapter 5 (see [7]) some possible data sources to measure the CO² emissions."]
[]
[null,null,"3.4 Confidentiality"]
[]
[null,null,"What is regarded as confidential depends on the national confidentiality policy for statistical data in accordance with existing Community provisions on statistical confidentiality (Regulation N°223/2009) . Confidential data should be submitted in the questionnaire and should be properly flagged as confidential by using a 'c)' flag in the footnote column. The footnote symbol 'd) Secondary confidentiality' is used to hide non-confidential values in order to prevent third parties to indirectly deduce the observation of a cell genuinely flagged as confidential."]
[null,null,"In general, data from public authorities are not regarded as confidential; also the secondary use of public information for statistical purposes will not be regarded as confidential. "]
[]
[]
[null,null,"4. Main references"]
[null,null,"[1] European System of Accounts ESA 2010 \n"]
[null,null,"     Online Eurostat publication"]
[null,null,"[2] System of Environmental-Economic Accounting (SEEA) - Central Framework (2012)"]
[null,null,"[3] NACE, Statistical classification of economic activities"]
[null,null,"[4] Physical Energy Flow Accounts (PEFA) Manual (2014) \n"]
[null,null,"[5] Environmental accounts handbooks"]
[null,null,"[6] Environmental taxes - A statistical guide - 2013 edition"]
[null,null,"[7] Manual for air emissions accounts"]
[null,null,"[8] DG Environment Phasing out Environmentally Harmful Subsidies"]
[null,null,"[9] OECD Effective Carbon Rates report"]
[null,null,"[10] Household Budget Survey"]
[null,null,"[11] Government finance statistics"]

{"sheet":"METADATA","index":6,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[29,2,29,5],[28,1,28,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[5,1,5,5],[7,1,7,5],[8,2,8,5],[9,1,9,5],[20,2,20,5],[22,2,22,5],[24,2,24,5],[26,2,26,5],[19,1,19,5],[21,1,21,5],[23,1,23,5],[25,1,25,5],[10,2,10,5],[12,2,12,5],[14,2,14,5],[16,2,16,5],[18,2,18,5],[11,1,11,5],[13,1,13,5],[15,1,15,5],[17,1,17,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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[null,"1. Statistical description. Please, explain any particularity, concerning statistical units, coverage, statistical population, classification system etc that deviates or complements the general guidance provided for PEDS compilation"]
[]
[null,"2. Please indicate how far back you would be in a position to report? (Currently 2019)"]
[]
[null,"3. Units of measure. Please report any comment/issue concerning the unit of measure [at the moment: PEDS-ESA, MIO_NAC; Taxes, MIO_NAC; Emissions, thousands of tonnes; AECR, NAC/tonne; range of emissions, percentage]"]
[]
[null,"4. Please, explain the general policy applied for confidentiality in PEDS and provide details of the c), d), n) flags that are used, if any"]
[]
[null,"5. Please, explain release policy, if any. Explain also what are the plans for releasing data in the future, if any."]
[]
[null,"6. Please, explain what are the main data sources for the compilation of PEDS-ESA transfers"]
[]
[null,"7. Please, describe in case it was necessary, additional data sources (apart from ETEA and AEA/PEFA) used for delimitating taxes and emissions included for the estimation of the AECR metric."]
[]
[null,"8. Please, provide an assessment of the quality aspects in PEDS [quality management, relevance, accuracy, timeliness and punctuality, coherence and comparability, cost and burden]. Describe in particular, internal validation checks carried out to ensure those aspects"]
[]
[null,"9. Would you be in a position to report tax abatements or any other implicit transfers? If yes, please comment on the possible limitations of such data in terms of comparability, accuracy etc."]
[]
[null,"10. 'n.e.c.' reporting. Please, indicate to which subset of NACEs the value reported in n.e.c. refers (see also basic instructions, Annex 2,  5a-5c)"]
[]
[null,"11. Please provide links to any methodological documentation related to PEDS"]
[]
[]
[null,"12. Provide any other comment"]

{"sheet":"GETTING STARTED","index":7,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,3,17,6],[19,3,19,6],[21,3,21,6],[22,2,22,6],[3,2,3,6],[4,2,4,6],[6,2,6,6],[11,2,11,6],[13,3,13,6],[15,3,15,6]]}
[]
[]
[null,null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ANNUAL REPORTING OF POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):",null,null,null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B41,2,FALSE))","v":""}]
[]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 31st May 2024"}]
[null,null,{"$f":"\"Who is the primary contact point for the data collection '\" &  Lists!K7&\"' in your country?\"","v":"Who is the primary contact point for the data collection 'Annual reporting of Potential Environmentally Damaging Subsidies (PEDS)' in your country?"}]
[]
[null,null,"Name:"]
[]
[null,null,"Institution:"]
[]
[null,null,"Unit:"]
[]
[null,null,"Telephone:"]
[]
[null,null,"Email adress:"]

{"sheet":"Footnotes list","index":8,"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 POTENTIAL ENVIRONMENTALLY DAMAGING SUBSIDIES (PEDS)"}]
[null,null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,null,"EXPLANATORY FOOTNOTES"]
[null,null,null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":""}]
[null,null,null,1,"Type your text here"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]

{"sheet":"PEDS_ESA","index":9,"n_rows":54,"n_cols":26,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,5,4,5],[2,6,4,25],[6,24,6,25],[21,9,21,10],[21,14,21,15],[21,19,21,20],[21,24,21,25],[36,9,36,10],[36,14,36,15],[36,19,36,20],[36,24,36,25],[6,9,6,10],[6,14,6,15],[6,19,6,20]]}
[]
[]
[null,null,null,null,"GEO",{"$f":"IF('GETTING STARTED'!E9=\"\",\"Country not selected\", \"  \" & UPPER( 'GETTING STARTED'!E9))","v":"Country not selected"},"ESA TRANSFERS - Explicit transfers"]
[null,null,null,null,{"$f":"IF('GETTING STARTED'!G9=\"\",\"\",'GETTING STARTED'!G9)","v":""}]
[]
[]
[null,null,"NACE_R2","unit","PEDS"," Fossil fuels\nESA transfers related to fossil fuels paid to institutional sectors \n(In millions national currency)",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","MIO_NAC","PEDS_FF","Total Subsidies on Fossil Fuels paid (Corporations + households)",{"$f":"IF(COUNT(G9,G10)<2,\"\",SUM(G9,G10))","v":""},null,null,null,{"$f":"IF(TRIM(J8)=\"\", \"\", IF(VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(L9,L10)<2,\"\",SUM(L9,L10))","v":""},null,null,null,{"$f":"IF(TRIM(O8)=\"\", \"\", IF(VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(Q9,Q10)<2,\"\",SUM(Q9,Q10))","v":""},null,null,null,{"$f":"IF(TRIM(T8)=\"\", \"\", IF(VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(V9,V10)<2,\"\",SUM(V9,V10))","v":""},null,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","MIO_NAC","PEDS_FF","  Paid to households (Institutional sector as ESA-2010)",null,null,null,null,{"$f":"IF(TRIM(J9)=\"\", \"\", IF(VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O9)=\"\", \"\", IF(VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T9)=\"\", \"\", IF(VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","MIO_NAC","PEDS_FF","  Paid to corporations (Total NACE)",{"$f":"IF(TRIM(G20)=\"\",\"\",SUM(G11,G12,G13,G14,G15,G16,G17,G18,G19,G20))","v":""},null,null,null,{"$f":"IF(TRIM(J10)=\"\", \"\", IF(VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(L20)=\"\",\"\",SUM(L11,L12,L13,L14,L15,L16,L17,L18,L19,L20))","v":""},null,null,null,{"$f":"IF(TRIM(O10)=\"\", \"\", IF(VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(Q20)=\"\",\"\",SUM(Q11,Q12,Q13,Q14,Q15,Q16,Q17,Q18,Q19,Q20))","v":""},null,null,null,{"$f":"IF(TRIM(T10)=\"\", \"\", IF(VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(V20)=\"\",\"\",SUM(V11,V12,V13,V14,V15,V16,V17,V18,V19,V20))","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","MIO_NAC","PEDS_FF","    Paid to NACE A Agriculture, forestry and fishing",null,null,null,null,{"$f":"IF(TRIM(J11)=\"\", \"\", IF(VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O11)=\"\", \"\", IF(VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T11)=\"\", \"\", IF(VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","MIO_NAC","PEDS_FF","    Paid to NACE B Mining and quarrying;",null,null,null,null,{"$f":"IF(TRIM(J12)=\"\", \"\", IF(VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O12)=\"\", \"\", IF(VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T12)=\"\", \"\", IF(VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","MIO_NAC","PEDS_FF","    Paid to NACE C Manufacturing",null,null,null,null,{"$f":"IF(TRIM(J13)=\"\", \"\", IF(VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O13)=\"\", \"\", IF(VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T13)=\"\", \"\", IF(VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","MIO_NAC","PEDS_FF","    Paid to NACE D Electricity, gas, steam and air conditioning supply ",null,null,null,null,{"$f":"IF(TRIM(J14)=\"\", \"\", IF(VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O14)=\"\", \"\", IF(VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T14)=\"\", \"\", IF(VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","MIO_NAC","PEDS_FF","    Paid to NACE E Water supply, sewerage, waste management and remedition activities",null,null,null,null,{"$f":"IF(TRIM(J15)=\"\", \"\", IF(VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O15)=\"\", \"\", IF(VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T15)=\"\", \"\", IF(VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","MIO_NAC","PEDS_FF","    Paid to NACE F Construction",null,null,null,null,{"$f":"IF(TRIM(J16)=\"\", \"\", IF(VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O16)=\"\", \"\", IF(VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T16)=\"\", \"\", IF(VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","MIO_NAC","PEDS_FF","    Paid to NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",null,null,null,null,{"$f":"IF(TRIM(J17)=\"\", \"\", IF(VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O17)=\"\", \"\", IF(VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T17)=\"\", \"\", IF(VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","MIO_NAC","PEDS_FF","    Paid to NACE H Transportation and storage",null,null,null,null,{"$f":"IF(TRIM(J18)=\"\", \"\", IF(VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O18)=\"\", \"\", IF(VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T18)=\"\", \"\", IF(VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","MIO_NAC","PEDS_FF","    Paid to NACE I-U Services (except wholosale and retail trade, transportation and storage) ",null,null,null,null,{"$f":"IF(TRIM(J19)=\"\", \"\", IF(VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O19)=\"\", \"\", IF(VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T19)=\"\", \"\", IF(VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y19)=\"\", \"\", IF(VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","MIO_NAC","PEDS_FF","    Transfers not elsewhere classified ",null,null,null,null,{"$f":"IF(TRIM(J20)=\"\", \"\", IF(VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O20)=\"\", \"\", IF(VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T20)=\"\", \"\", IF(VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y20)=\"\", \"\", IF(VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,"NACE_R2","unit","PEDS","Other PEDS\nESA transfers other than fossil fuels paid to institutional sectors\n(In millions national currency)",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","MIO_NAC","PEDS_OTH","Total Subsidies on Fossil Fuels paid (Corporations + households)",{"$f":"IF(COUNT(G24,G25)<2,\"\",SUM(G24,G25))","v":""},null,null,null,{"$f":"IF(TRIM(J23)=\"\", \"\", IF(VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(L24,L25)<2,\"\",SUM(L24,L25))","v":""},null,null,null,{"$f":"IF(TRIM(O23)=\"\", \"\", IF(VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(Q24,Q25)<2,\"\",SUM(Q24,Q25))","v":""},null,null,null,{"$f":"IF(TRIM(T23)=\"\", \"\", IF(VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(V24,V25)<2,\"\",SUM(V24,V25))","v":""},null,null,null,{"$f":"IF(TRIM(Y23)=\"\", \"\", IF(VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","MIO_NAC","PEDS_OTH","  Paid to households (Institutional sector as ESA-2010)",null,null,null,null,{"$f":"IF(TRIM(J24)=\"\", \"\", IF(VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O24)=\"\", \"\", IF(VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T24)=\"\", \"\", IF(VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y24)=\"\", \"\", IF(VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","MIO_NAC","PEDS_OTH","  Paid to corporations (Total NACE)",{"$f":"IF(TRIM(G35)=\"\",\"\",SUM(G26,G27,G28,G29,G30,G31,G32,G33,G34,G35))","v":""},null,null,null,{"$f":"IF(TRIM(J25)=\"\", \"\", IF(VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(L35)=\"\",\"\",SUM(L26,L27,L28,L29,L30,L31,L32,L33,L34,L35))","v":""},null,null,null,{"$f":"IF(TRIM(O25)=\"\", \"\", IF(VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(Q35)=\"\",\"\",SUM(Q26,Q27,Q28,Q29,Q30,Q31,Q32,Q33,Q34,Q35))","v":""},null,null,null,{"$f":"IF(TRIM(T25)=\"\", \"\", IF(VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(V35)=\"\",\"\",SUM(V26,V27,V28,V29,V30,V31,V32,V33,V34,V35))","v":""},null,null,null,{"$f":"IF(TRIM(Y25)=\"\", \"\", IF(VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","MIO_NAC","PEDS_OTH","    Paid to NACE A Agriculture, forestry and fishing",null,null,null,null,{"$f":"IF(TRIM(J26)=\"\", \"\", IF(VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O26)=\"\", \"\", IF(VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T26)=\"\", \"\", IF(VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y26)=\"\", \"\", IF(VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","MIO_NAC","PEDS_OTH","    Paid to NACE B Mining and quarrying;",null,null,null,null,{"$f":"IF(TRIM(J27)=\"\", \"\", IF(VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O27)=\"\", \"\", IF(VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T27)=\"\", \"\", IF(VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y27)=\"\", \"\", IF(VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","MIO_NAC","PEDS_OTH","    Paid to NACE C Manufacturing",null,null,null,null,{"$f":"IF(TRIM(J28)=\"\", \"\", IF(VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O28)=\"\", \"\", IF(VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T28)=\"\", \"\", IF(VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y28)=\"\", \"\", IF(VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","MIO_NAC","PEDS_OTH","    Paid to NACE D Electricity, gas, steam and air conditioning supply ",null,null,null,null,{"$f":"IF(TRIM(J29)=\"\", \"\", IF(VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O29)=\"\", \"\", IF(VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T29)=\"\", \"\", IF(VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y29)=\"\", \"\", IF(VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","MIO_NAC","PEDS_OTH","    Paid to NACE E Water supply, sewerage, waste management and remedition activities",null,null,null,null,{"$f":"IF(TRIM(J30)=\"\", \"\", IF(VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O30)=\"\", \"\", IF(VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T30)=\"\", \"\", IF(VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y30)=\"\", \"\", IF(VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","MIO_NAC","PEDS_OTH","    Paid to NACE F Construction",null,null,null,null,{"$f":"IF(TRIM(J31)=\"\", \"\", IF(VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O31)=\"\", \"\", IF(VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T31)=\"\", \"\", IF(VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y31)=\"\", \"\", IF(VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","MIO_NAC","PEDS_OTH","    Paid to NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",null,null,null,null,{"$f":"IF(TRIM(J32)=\"\", \"\", IF(VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O32)=\"\", \"\", IF(VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T32)=\"\", \"\", IF(VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y32)=\"\", \"\", IF(VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","MIO_NAC","PEDS_OTH","    Paid to NACE H Transportation and storage",null,null,null,null,{"$f":"IF(TRIM(J33)=\"\", \"\", IF(VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O33)=\"\", \"\", IF(VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T33)=\"\", \"\", IF(VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y33)=\"\", \"\", IF(VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","MIO_NAC","PEDS_OTH","    Paid to NACE I-U Services (except wholosale and retail trade, transportation and storage) ",null,null,null,null,{"$f":"IF(TRIM(J34)=\"\", \"\", IF(VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O34)=\"\", \"\", IF(VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T34)=\"\", \"\", IF(VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y34)=\"\", \"\", IF(VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","MIO_NAC","PEDS_OTH","    Transfers not elsewhere classified ",null,null,null,null,{"$f":"IF(TRIM(J35)=\"\", \"\", IF(VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O35)=\"\", \"\", IF(VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T35)=\"\", \"\", IF(VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y35)=\"\", \"\", IF(VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,"NACE_R2","unit","PEDS"," TOTAL PEDS\nESA transfers related to fossil fuels + other transfers paid to institutional sectors\n(In millions national currency)",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","MIO_NAC","PEDS","Total Subsidies on Fossil Fuels paid (Corporations + households)",{"$f":"IF(COUNT(G8,G23)<2,\"\",SUM(G8,G23))","v":""},null,null,null,{"$f":"IF(TRIM(J38)=\"\", \"\", IF(VLOOKUP(J38,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J38,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(L8,L23)<2,\"\",SUM(L8,L23))","v":""},null,null,null,{"$f":"IF(TRIM(O38)=\"\", \"\", IF(VLOOKUP(O38,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O38,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(Q8,Q23)<2,\"\",SUM(Q8,Q23))","v":""},null,null,null,{"$f":"IF(TRIM(T38)=\"\", \"\", IF(VLOOKUP(T38,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T38,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(V8,V23)<2,\"\",SUM(V8,V23))","v":""},null,null,null,{"$f":"IF(TRIM(Y38)=\"\", \"\", IF(VLOOKUP(Y38,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y38,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","MIO_NAC","PEDS","  Paid to households (Institutional sector as ESA-2010)","",null,null,null,{"$f":"IF(TRIM(J39)=\"\", \"\", IF(VLOOKUP(J39,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J39,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O39)=\"\", \"\", IF(VLOOKUP(O39,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O39,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T39)=\"\", \"\", IF(VLOOKUP(T39,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T39,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y39)=\"\", \"\", IF(VLOOKUP(Y39,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y39,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","MIO_NAC","PEDS","  Paid to corporations (Total NACE)","",null,null,null,{"$f":"IF(TRIM(J40)=\"\", \"\", IF(VLOOKUP(J40,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J40,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O40)=\"\", \"\", IF(VLOOKUP(O40,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O40,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T40)=\"\", \"\", IF(VLOOKUP(T40,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T40,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y40)=\"\", \"\", IF(VLOOKUP(Y40,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y40,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","MIO_NAC","PEDS","    Paid to NACE A Agriculture, forestry and fishing","",null,null,null,{"$f":"IF(TRIM(J41)=\"\", \"\", IF(VLOOKUP(J41,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J41,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O41)=\"\", \"\", IF(VLOOKUP(O41,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O41,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T41)=\"\", \"\", IF(VLOOKUP(T41,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T41,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y41)=\"\", \"\", IF(VLOOKUP(Y41,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y41,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","MIO_NAC","PEDS","    Paid to NACE B Mining and quarrying;","",null,null,null,{"$f":"IF(TRIM(J42)=\"\", \"\", IF(VLOOKUP(J42,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J42,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O42)=\"\", \"\", IF(VLOOKUP(O42,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O42,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T42)=\"\", \"\", IF(VLOOKUP(T42,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T42,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y42)=\"\", \"\", IF(VLOOKUP(Y42,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y42,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","MIO_NAC","PEDS","    Paid to NACE C Manufacturing","",null,null,null,{"$f":"IF(TRIM(J43)=\"\", \"\", IF(VLOOKUP(J43,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J43,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O43)=\"\", \"\", IF(VLOOKUP(O43,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O43,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T43)=\"\", \"\", IF(VLOOKUP(T43,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T43,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y43)=\"\", \"\", IF(VLOOKUP(Y43,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y43,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","MIO_NAC","PEDS","    Paid to NACE D Electricity, gas, steam and air conditioning supply ","",null,null,null,{"$f":"IF(TRIM(J44)=\"\", \"\", IF(VLOOKUP(J44,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J44,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O44)=\"\", \"\", IF(VLOOKUP(O44,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O44,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T44)=\"\", \"\", IF(VLOOKUP(T44,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T44,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y44)=\"\", \"\", IF(VLOOKUP(Y44,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y44,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","MIO_NAC","PEDS","    Paid to NACE E Water supply, sewerage, waste management and remedition activities","",null,null,null,{"$f":"IF(TRIM(J45)=\"\", \"\", IF(VLOOKUP(J45,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J45,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O45)=\"\", \"\", IF(VLOOKUP(O45,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O45,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T45)=\"\", \"\", IF(VLOOKUP(T45,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T45,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y45)=\"\", \"\", IF(VLOOKUP(Y45,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y45,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","MIO_NAC","PEDS","    Paid to NACE F Construction","",null,null,null,{"$f":"IF(TRIM(J46)=\"\", \"\", IF(VLOOKUP(J46,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J46,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O46)=\"\", \"\", IF(VLOOKUP(O46,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O46,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T46)=\"\", \"\", IF(VLOOKUP(T46,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T46,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y46)=\"\", \"\", IF(VLOOKUP(Y46,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y46,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","MIO_NAC","PEDS","    Paid to NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles","",null,null,null,{"$f":"IF(TRIM(J47)=\"\", \"\", IF(VLOOKUP(J47,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J47,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O47)=\"\", \"\", IF(VLOOKUP(O47,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O47,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T47)=\"\", \"\", IF(VLOOKUP(T47,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T47,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y47)=\"\", \"\", IF(VLOOKUP(Y47,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y47,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","MIO_NAC","PEDS","    Paid to NACE H Transportation and storage","",null,null,null,{"$f":"IF(TRIM(J48)=\"\", \"\", IF(VLOOKUP(J48,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J48,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O48)=\"\", \"\", IF(VLOOKUP(O48,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O48,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T48)=\"\", \"\", IF(VLOOKUP(T48,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T48,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y48)=\"\", \"\", IF(VLOOKUP(Y48,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y48,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","MIO_NAC","PEDS","    Paid to NACE I-U Services (except wholosale and retail trade, transportation and storage) ","",null,null,null,{"$f":"IF(TRIM(J49)=\"\", \"\", IF(VLOOKUP(J49,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J49,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O49)=\"\", \"\", IF(VLOOKUP(O49,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O49,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T49)=\"\", \"\", IF(VLOOKUP(T49,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T49,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y49)=\"\", \"\", IF(VLOOKUP(Y49,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y49,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","MIO_NAC","PEDS","    Transfers not elsewhere classified ","",null,null,null,{"$f":"IF(TRIM(J50)=\"\", \"\", IF(VLOOKUP(J50,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J50,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(O50)=\"\", \"\", IF(VLOOKUP(O50,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O50,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(T50)=\"\", \"\", IF(VLOOKUP(T50,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T50,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},"",null,null,null,{"$f":"IF(TRIM(Y50)=\"\", \"\", IF(VLOOKUP(Y50,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y50,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"Dark grey: Automatic calculation. Formula cannot be edited."]
[null,null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]
[null,null,null,null,null,"Cyan voluntary variables"]

{"sheet":"Input for ECR-range","index":10,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,5,4,5],[2,6,4,25],[21,9,21,10],[21,14,21,15],[21,19,21,20],[21,24,21,25],[6,9,6,10],[6,14,6,15],[6,19,6,20],[6,24,6,25]]}
[]
[]
[null,null,null,null,"GEO",{"$f":"IF('GETTING STARTED'!E9=\"\",\"Country not selected\", \"  \" & UPPER( 'GETTING STARTED'!E9))","v":"Country not selected"},"Taxes and CO2 emissions for average Effective Carbon Rates (ECR)"]
[null,null,null,null,{"$f":"IF('GETTING STARTED'!G9=\"\",\"\",'GETTING STARTED'!G9)","v":""}]
[]
[]
[null,null,"NACE_R2","unit","PEDS","Taxes imposed to fossil fuel combustion\nby institutional sector, in million national currency",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","MIO_NAC","NAP","TOTAL taxes paid (Corporations + households)",{"$f":"IF(COUNT(G9,G10)<2,\"\",SUM(G9,G10))","v":""},null,null,null,{"$f":"IF(TRIM(J8)=\"\", \"\", IF(VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(L9,L10)<2,\"\",SUM(L9,L10))","v":""},null,null,null,{"$f":"IF(TRIM(O8)=\"\", \"\", IF(VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(Q9,Q10)<2,\"\",SUM(Q9,Q10))","v":""},null,null,null,{"$f":"IF(TRIM(T8)=\"\", \"\", IF(VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(V9,V10)<2,\"\",SUM(V9,V10))","v":""},null,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","MIO_NAC","NAP","  Households as final consumers",null,null,null,null,{"$f":"IF(TRIM(J9)=\"\", \"\", IF(VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O9)=\"\", \"\", IF(VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T9)=\"\", \"\", IF(VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","MIO_NAC","NAP","  Corporations (Total NACE)",{"$f":"IF(TRIM(G20)=\"\",\"\",SUM(G11,G12,G13,G14,G15,G16,G17,G18,G19,G20))","v":""},null,null,null,{"$f":"IF(TRIM(J10)=\"\", \"\", IF(VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(L20)=\"\",\"\",SUM(L11,L12,L13,L14,L15,L16,L17,L18,L19,L20))","v":""},null,null,null,{"$f":"IF(TRIM(O10)=\"\", \"\", IF(VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(Q20)=\"\",\"\",SUM(Q11,Q12,Q13,Q14,Q15,Q16,Q17,Q18,Q19,Q20))","v":""},null,null,null,{"$f":"IF(TRIM(T10)=\"\", \"\", IF(VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(V20)=\"\",\"\",SUM(V11,V12,V13,V14,V15,V16,V17,V18,V19,V20))","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","MIO_NAC","NAP","    NACE A Agriculture, forestry and fishing",null,null,null,null,{"$f":"IF(TRIM(J11)=\"\", \"\", IF(VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O11)=\"\", \"\", IF(VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T11)=\"\", \"\", IF(VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","MIO_NAC","NAP","    NACE B Mining and quarrying",null,null,null,null,{"$f":"IF(TRIM(J12)=\"\", \"\", IF(VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O12)=\"\", \"\", IF(VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T12)=\"\", \"\", IF(VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","MIO_NAC","NAP","    NACE C Manufacturing",null,null,null,null,{"$f":"IF(TRIM(J13)=\"\", \"\", IF(VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O13)=\"\", \"\", IF(VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T13)=\"\", \"\", IF(VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","MIO_NAC","NAP","    NACE D Electricity, gas, steam and air conditioning supply ",null,null,null,null,{"$f":"IF(TRIM(J14)=\"\", \"\", IF(VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O14)=\"\", \"\", IF(VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T14)=\"\", \"\", IF(VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","MIO_NAC","NAP","    NACE E Water supply, sewerage, waste management and remedition activities",null,null,null,null,{"$f":"IF(TRIM(J15)=\"\", \"\", IF(VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O15)=\"\", \"\", IF(VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T15)=\"\", \"\", IF(VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","MIO_NAC","NAP","    NACE F Construction",null,null,null,null,{"$f":"IF(TRIM(J16)=\"\", \"\", IF(VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O16)=\"\", \"\", IF(VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T16)=\"\", \"\", IF(VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","MIO_NAC","NAP","    NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",null,null,null,null,{"$f":"IF(TRIM(J17)=\"\", \"\", IF(VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O17)=\"\", \"\", IF(VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T17)=\"\", \"\", IF(VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","MIO_NAC","NAP","    NACE H Transportation and storage",null,null,null,null,{"$f":"IF(TRIM(J18)=\"\", \"\", IF(VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O18)=\"\", \"\", IF(VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T18)=\"\", \"\", IF(VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","MIO_NAC","NAP","    NACE I-U Services (except wholosale and retail trade, transportation and storage) ",null,null,null,null,{"$f":"IF(TRIM(J19)=\"\", \"\", IF(VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O19)=\"\", \"\", IF(VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T19)=\"\", \"\", IF(VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y19)=\"\", \"\", IF(VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","MIO_NAC","NAP","    Not elsewhere classified ",null,null,null,null,{"$f":"IF(TRIM(J20)=\"\", \"\", IF(VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O20)=\"\", \"\", IF(VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T20)=\"\", \"\", IF(VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y20)=\"\", \"\", IF(VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,"NACE_R2","unit","PEDS","CO2 emissions originated from fossil fuel combustion\nby institutional sectors, in thousand tonnes of CO2 equivalents",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","THS_T","NAP","TOTAL CO2 (Corporations + households)",{"$f":"IF(COUNT(G24,G25)<2,\"\",SUM(G24,G25))","v":""},null,null,null,{"$f":"IF(TRIM(J23)=\"\", \"\", IF(VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(L24,L25)<2,\"\",SUM(L24,L25))","v":""},null,null,null,{"$f":"IF(TRIM(O23)=\"\", \"\", IF(VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(Q24,Q25)<2,\"\",SUM(Q24,Q25))","v":""},null,null,null,{"$f":"IF(TRIM(T23)=\"\", \"\", IF(VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(V24,V25)<2,\"\",SUM(V24,V25))","v":""},null,null,null,{"$f":"IF(TRIM(Y23)=\"\", \"\", IF(VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","THS_T","NAP","  Households as final consumers",null,null,null,null,{"$f":"IF(TRIM(J24)=\"\", \"\", IF(VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O24)=\"\", \"\", IF(VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T24)=\"\", \"\", IF(VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y24)=\"\", \"\", IF(VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","THS_T","NAP","  Corporations (Total NACE)",{"$f":"IF(TRIM(G35)=\"\",\"\",SUM(G26,G27,G28,G29,G30,G31,G32,G33,G34,G35))","v":""},null,null,null,{"$f":"IF(TRIM(J25)=\"\", \"\", IF(VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(L35)=\"\",\"\",SUM(L26,L27,L28,L29,L30,L31,L32,L33,L34,L35))","v":""},null,null,null,{"$f":"IF(TRIM(O25)=\"\", \"\", IF(VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(Q35)=\"\",\"\",SUM(Q26,Q27,Q28,Q29,Q30,Q31,Q32,Q33,Q34,Q35))","v":""},null,null,null,{"$f":"IF(TRIM(T25)=\"\", \"\", IF(VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(V35)=\"\",\"\",SUM(V26,V27,V28,V29,V30,V31,V32,V33,V34,V35))","v":""},null,null,null,{"$f":"IF(TRIM(Y25)=\"\", \"\", IF(VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","THS_T","NAP","    NACE A Agriculture, forestry and fishing",null,null,null,null,{"$f":"IF(TRIM(J26)=\"\", \"\", IF(VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O26)=\"\", \"\", IF(VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T26)=\"\", \"\", IF(VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y26)=\"\", \"\", IF(VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","THS_T","NAP","    NACE B Mining and quarrying",null,null,null,null,{"$f":"IF(TRIM(J27)=\"\", \"\", IF(VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O27)=\"\", \"\", IF(VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T27)=\"\", \"\", IF(VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y27)=\"\", \"\", IF(VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","THS_T","NAP","    NACE C Manufacturing",null,null,null,null,{"$f":"IF(TRIM(J28)=\"\", \"\", IF(VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O28)=\"\", \"\", IF(VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T28)=\"\", \"\", IF(VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y28)=\"\", \"\", IF(VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","THS_T","NAP","    NACE D Electricity, gas, steam and air conditioning supply ",null,null,null,null,{"$f":"IF(TRIM(J29)=\"\", \"\", IF(VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O29)=\"\", \"\", IF(VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T29)=\"\", \"\", IF(VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y29)=\"\", \"\", IF(VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","THS_T","NAP","    NACE E Water supply, sewerage, waste management and remedition activities",null,null,null,null,{"$f":"IF(TRIM(J30)=\"\", \"\", IF(VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O30)=\"\", \"\", IF(VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T30)=\"\", \"\", IF(VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y30)=\"\", \"\", IF(VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","THS_T","NAP","    NACE F Construction",null,null,null,null,{"$f":"IF(TRIM(J31)=\"\", \"\", IF(VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O31)=\"\", \"\", IF(VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T31)=\"\", \"\", IF(VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y31)=\"\", \"\", IF(VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","THS_T","NAP","    NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",null,null,null,null,{"$f":"IF(TRIM(J32)=\"\", \"\", IF(VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O32)=\"\", \"\", IF(VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T32)=\"\", \"\", IF(VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y32)=\"\", \"\", IF(VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","THS_T","NAP","    NACE H Transportation and storage",null,null,null,null,{"$f":"IF(TRIM(J33)=\"\", \"\", IF(VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O33)=\"\", \"\", IF(VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T33)=\"\", \"\", IF(VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y33)=\"\", \"\", IF(VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","THS_T","NAP","    NACE I-U Services (except wholosale and retail trade, transportation and storage) ",null,null,null,null,{"$f":"IF(TRIM(J34)=\"\", \"\", IF(VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O34)=\"\", \"\", IF(VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T34)=\"\", \"\", IF(VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y34)=\"\", \"\", IF(VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","THS_T","NAP","    Not elsewhere classified ",null,null,null,null,{"$f":"IF(TRIM(J35)=\"\", \"\", IF(VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(O35)=\"\", \"\", IF(VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(T35)=\"\", \"\", IF(VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},null,null,null,null,{"$f":"IF(TRIM(Y35)=\"\", \"\", IF(VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"Dark grey: Automatic calculation. Formula cannot be edited."]
[null,null,null,null,null,"Light orange: Footnotes (only to be filled-in when relevant)"]

{"sheet":"Catalogue of measures","index":11,"n_rows":41,"n_cols":44,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[14,1,14,6],[13,1,13,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[1,1,1,6],[4,1,4,6],[3,1,3,6],[11,1,11,6],[12,1,12,6],[9,1,9,6],[10,1,10,6],[5,1,5,6],[7,1,7,6],[37,17,39,25],[37,28,39,32],[37,35,39,43],[28,1,28,6],[22,1,22,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[37,1,39,10]]}
[]
[null,"CATALOGUE OF MEASURES"]
[]
[null,"This tab might be considered as a hybrid between data reporting and provision of information/metadata. The data tabs \"PEDS_ESA\" represents aggregated measures that are more detailed here."]
[null,"The provision of technical details, described in this tab, are extremely useful for data validation. It will allow Eurostat to gain experience on the transfers existing in your country and, therefore, be able to streamline the methodology and guidance in the future data collections."]
[null,"Eurostat lets countries decide on the level of details they would like to report here."]
[]
[null,"Countries are free to insert new lines if necessary under each table."]
[]
[null,"Eurostat asks countries to report on:"]
[null,"1. Reported ESA TRANSFERS - explicit transfers"]
[null,"    This table should list the ESA explicit transfers that have been reported, in an aggregated way, in the PEDS_ESA data tab."]
[null,"    Eurostat is interested in getting information on:"]
[null,"      - the transactions, specifying national accounts codes"]
[null,"      - the beneficiary of the transfers (whether households or corporations are the target - if corporations, countries are asked to specify which activity/industry is targeted, if any); if the beneficiaies are mixed, please indicate it."]
[null,"      - the category (whether countries reported in under PEDS - fossil fuels subsidies- or other PEDS)"]
[null,"      - the time period: countries can report here either one year or multiple years  if the transfers are valid for a longer period than one year"]
[null,"      - the value of the specific transfer"]
[null,"      - program comments: Eurostat would like countries to explain the program related to the transfer. Links to policy documents are welcome."]
[null,"      - program life span: Eurostat would like to know for which period the program has been put in place; if unlimited but with a starting date, please indicate : YYYY - unlimited"]
[null,"      - data sources: Eurostat would like to know where the data come from? Some ministry data; other regulatory data transmission etc"]
[null,"      - comments: countries are free to report here information evaluated as useful"]
[null,"2. Average effective carbon rate (AECR) - reported taxes"]
[null,"This table is to report the taxes countries have considered for the compilation of the AECR.",null,null,null,null,null,null,null,null,null,null,"Binary Answer","Category ","Availability by"]
[null,"Eurostat will ask here some details on the type of taxes (see columns : specific carbon taxes, excise tax etc…) and on the detail availability by type of fossil fuels/institutional sectors/activity.",null,null,null,null,null,null,null,null,null,null,"YES","FF","Fossil fuel type"]
[null,"3. Average effective carbon rate (AECR) - potential reporting",null,null,null,null,null,null,null,null,null,null,"NO","Other","Institutional sector"]
[null,"This table is to report on taxes countries would be ready to include in the compilation of the AECR.",null,null,null,null,null,null,null,null,null,null,null,"Institutional sector and NACE (for corporations)"]
[null,"information requested is not as detailed as for table 2. but countries are invited to use the comment column to detail the taxes.",null,null,null,null,null,null,null,null,null,null,null,"Fossil fuel type AND institutional sector"]
[null,"4. Implicit transfers available for reporting",null,null,null,null,null,null,null,null,null,null,null,"Fossil fuel type AND institutional sector AND NACE (for corporations)"]
[null,"The scope of the PEDS data collection is restricted to explicit ESA transfers. However countries may compile as well some implicit transfers related to potential environmentally damaging subsidies."]
[null,"Eurostat would like you to report here and to give some detailed information on such transfers."]
[null,"The information requested is similar to the one for 1. ESA transfers."]
[]
[]
[]
[]
[]
[null,"1. Reported ESA TRANSFERS - Explicit transfers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Average effective carbon rate (AECR) - reported taxes",null,null,null,null,null,null,null,null,null,null,"3. Average effective carbon rate (AECR) - potential reporting",null,null,null,null,null,null,"4. Implicit transfers available for reporting"]
[]
[]
[null,"Description of the ESA explicit transfers","National accounts distributive transactions (ex D3x, D7x, D9x)","Beneficiary of the transfer (Households, or NACE activity)","Category (Fossil fuels/ other PEDS)","Time period (year)","Total value of the transfer","Program comments","Program life span (ex 2016-2020)","Data source","Comments",null,null,null,null,null,null,"Description of the tax included in the AECR","Specific carbon taxes or similar (Yes/No)","Excise tax on fossil fuel and similar (Yes/No)","ETS payments (Yes/No)","Other type (please specify)","Time period","Total value of the tax","Availability by ","Comments",null,null,"Description of the tax you could include in the AECR","Time period","Total value of the tax","Availability per ","Comments",null,null,"Description of the implicit transfer","National accounts transactions code (if any)","Beneficiary","Time period","Total value of the transfer","Program comments","Program life span","Data sources","Comment"]

{"sheet":"ECR - range","index":12,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,5,4,5],[2,6,4,25],[21,9,21,10],[21,14,21,15],[21,19,21,20],[21,24,21,25],[6,9,6,10],[6,14,6,15],[6,19,6,20],[6,24,6,25]]}
[]
[]
[null,null,null,null,"GEO",{"$f":"IF('GETTING STARTED'!E9=\"\",\"Country not selected\", \"  \" & UPPER( 'GETTING STARTED'!E9))","v":"Country not selected"},"Average Effective Carbon Rates (AECR)"]
[null,null,null,null,{"$f":"IF('GETTING STARTED'!G9=\"\",\"\",'GETTING STARTED'!G9)","v":""}]
[]
[]
[null,null,"NACE_R2","UNIT","PEDS","Average ECR and emission range\nby institutional sector, in national currency per tonne",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","NAC_T","NAP","Average (Corporations + households)",{"$f":"IF(COUNT('Input for ECR-range'!G8,'Input for ECR-range'!G23)<2,\"\",'Input for ECR-range'!G8*1000/'Input for ECR-range'!G23)","v":""},null,null,null,{"$f":"IF(TRIM(J8)=\"\", \"\", IF(VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L8,'Input for ECR-range'!L23)<2,\"\",'Input for ECR-range'!L8*1000/'Input for ECR-range'!L23)","v":""},null,null,null,{"$f":"IF(TRIM(O8)=\"\", \"\", IF(VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q8,'Input for ECR-range'!Q23)<2,\"\",'Input for ECR-range'!Q8*1000/'Input for ECR-range'!Q23)","v":""},null,null,null,{"$f":"IF(TRIM(T8)=\"\", \"\", IF(VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V8,'Input for ECR-range'!V23)<2,\"\",'Input for ECR-range'!V8*1000/'Input for ECR-range'!V23)","v":""},null,null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","NAC_T","NAP","  Households as final consumers",{"$f":"IF(COUNT('Input for ECR-range'!G9,'Input for ECR-range'!G24)<2,\"\",'Input for ECR-range'!G9*1000/'Input for ECR-range'!G24)","v":""},null,null,null,{"$f":"IF(TRIM(J9)=\"\", \"\", IF(VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L9,'Input for ECR-range'!L24)<2,\"\",'Input for ECR-range'!L9*1000/'Input for ECR-range'!L24)","v":""},null,null,null,{"$f":"IF(TRIM(O9)=\"\", \"\", IF(VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q9,'Input for ECR-range'!Q24)<2,\"\",'Input for ECR-range'!Q9*1000/'Input for ECR-range'!Q24)","v":""},null,null,null,{"$f":"IF(TRIM(T9)=\"\", \"\", IF(VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V9,'Input for ECR-range'!V24)<2,\"\",'Input for ECR-range'!V9*1000/'Input for ECR-range'!V24)","v":""},null,null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","NAC_T","NAP","  Corporations",{"$f":"IF(OR(COUNT('Input for ECR-range'!G10,'Input for ECR-range'!G25)<2,'Input for ECR-range'!G25 =0),\"\",'Input for ECR-range'!G10*1000/'Input for ECR-range'!G25)","v":""},null,null,null,{"$f":"IF(TRIM(J10)=\"\", \"\", IF(VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR(COUNT('Input for ECR-range'!L10,'Input for ECR-range'!L25)<2,'Input for ECR-range'!L25 =0),\"\",'Input for ECR-range'!L10*1000/'Input for ECR-range'!L25)","v":""},null,null,null,{"$f":"IF(TRIM(O10)=\"\", \"\", IF(VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR(COUNT('Input for ECR-range'!Q10,'Input for ECR-range'!Q25)<2,'Input for ECR-range'!Q25 =0),\"\",'Input for ECR-range'!Q10*1000/'Input for ECR-range'!Q25)","v":""},null,null,null,{"$f":"IF(TRIM(T10)=\"\", \"\", IF(VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR(COUNT('Input for ECR-range'!V10,'Input for ECR-range'!V25)<2,'Input for ECR-range'!V25 =0),\"\",'Input for ECR-range'!V10*1000/'Input for ECR-range'!V25)","v":""},null,null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","NAC_T","NAP","    NACE A Agriculture, forestry and fishing",{"$f":"IF(COUNT('Input for ECR-range'!G11,'Input for ECR-range'!G26)<2,\"\",'Input for ECR-range'!G11*1000/'Input for ECR-range'!G26)","v":""},null,null,null,{"$f":"IF(TRIM(J11)=\"\", \"\", IF(VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L11,'Input for ECR-range'!L26)<2,\"\",'Input for ECR-range'!L11*1000/'Input for ECR-range'!L26)","v":""},null,null,null,{"$f":"IF(TRIM(O11)=\"\", \"\", IF(VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q11,'Input for ECR-range'!Q26)<2,\"\",'Input for ECR-range'!Q11*1000/'Input for ECR-range'!Q26)","v":""},null,null,null,{"$f":"IF(TRIM(T11)=\"\", \"\", IF(VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V11,'Input for ECR-range'!V26)<2,\"\",'Input for ECR-range'!V11*1000/'Input for ECR-range'!V26)","v":""},null,null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","NAC_T","NAP","    NACE B Mining and quarrying;",{"$f":"IF(COUNT('Input for ECR-range'!G12,'Input for ECR-range'!G27)<2,\"\",'Input for ECR-range'!G12*1000/'Input for ECR-range'!G27)","v":""},null,null,null,{"$f":"IF(TRIM(J12)=\"\", \"\", IF(VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L12,'Input for ECR-range'!L27)<2,\"\",'Input for ECR-range'!L12*1000/'Input for ECR-range'!L27)","v":""},null,null,null,{"$f":"IF(TRIM(O12)=\"\", \"\", IF(VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q12,'Input for ECR-range'!Q27)<2,\"\",'Input for ECR-range'!Q12*1000/'Input for ECR-range'!Q27)","v":""},null,null,null,{"$f":"IF(TRIM(T12)=\"\", \"\", IF(VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V12,'Input for ECR-range'!V27)<2,\"\",'Input for ECR-range'!V12*1000/'Input for ECR-range'!V27)","v":""},null,null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","NAC_T","NAP","    NACE C Manufacturing",{"$f":"IF(COUNT('Input for ECR-range'!G13,'Input for ECR-range'!G28)<2,\"\",'Input for ECR-range'!G13*1000/'Input for ECR-range'!G28)","v":""},null,null,null,{"$f":"IF(TRIM(J13)=\"\", \"\", IF(VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L13,'Input for ECR-range'!L28)<2,\"\",'Input for ECR-range'!L13*1000/'Input for ECR-range'!L28)","v":""},null,null,null,{"$f":"IF(TRIM(O13)=\"\", \"\", IF(VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q13,'Input for ECR-range'!Q28)<2,\"\",'Input for ECR-range'!Q13*1000/'Input for ECR-range'!Q28)","v":""},null,null,null,{"$f":"IF(TRIM(T13)=\"\", \"\", IF(VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V13,'Input for ECR-range'!V28)<2,\"\",'Input for ECR-range'!V13*1000/'Input for ECR-range'!V28)","v":""},null,null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","NAC_T","NAP","    NACE D Electricity, gas, steam and air conditioning supply ",{"$f":"IF(COUNT('Input for ECR-range'!G14,'Input for ECR-range'!G29)<2,\"\",'Input for ECR-range'!G14*1000/'Input for ECR-range'!G29)","v":""},null,null,null,{"$f":"IF(TRIM(J14)=\"\", \"\", IF(VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L14,'Input for ECR-range'!L29)<2,\"\",'Input for ECR-range'!L14*1000/'Input for ECR-range'!L29)","v":""},null,null,null,{"$f":"IF(TRIM(O14)=\"\", \"\", IF(VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q14,'Input for ECR-range'!Q29)<2,\"\",'Input for ECR-range'!Q14*1000/'Input for ECR-range'!Q29)","v":""},null,null,null,{"$f":"IF(TRIM(T14)=\"\", \"\", IF(VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V14,'Input for ECR-range'!V29)<2,\"\",'Input for ECR-range'!V14*1000/'Input for ECR-range'!V29)","v":""},null,null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","NAC_T","NAP","    NACE E Water supply, sewerage, waste management and remedition activities",{"$f":"IF(COUNT('Input for ECR-range'!G15,'Input for ECR-range'!G30)<2,\"\",'Input for ECR-range'!G15*1000/'Input for ECR-range'!G30)","v":""},null,null,null,{"$f":"IF(TRIM(J15)=\"\", \"\", IF(VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L15,'Input for ECR-range'!L30)<2,\"\",'Input for ECR-range'!L15*1000/'Input for ECR-range'!L30)","v":""},null,null,null,{"$f":"IF(TRIM(O15)=\"\", \"\", IF(VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q15,'Input for ECR-range'!Q30)<2,\"\",'Input for ECR-range'!Q15*1000/'Input for ECR-range'!Q30)","v":""},null,null,null,{"$f":"IF(TRIM(T15)=\"\", \"\", IF(VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V15,'Input for ECR-range'!V30)<2,\"\",'Input for ECR-range'!V15*1000/'Input for ECR-range'!V30)","v":""},null,null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","NAC_T","NAP","    NACE F Construction",{"$f":"IF(COUNT('Input for ECR-range'!G16,'Input for ECR-range'!G31)<2,\"\",'Input for ECR-range'!G16*1000/'Input for ECR-range'!G31)","v":""},null,null,null,{"$f":"IF(TRIM(J16)=\"\", \"\", IF(VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L16,'Input for ECR-range'!L31)<2,\"\",'Input for ECR-range'!L16*1000/'Input for ECR-range'!L31)","v":""},null,null,null,{"$f":"IF(TRIM(O16)=\"\", \"\", IF(VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q16,'Input for ECR-range'!Q31)<2,\"\",'Input for ECR-range'!Q16*1000/'Input for ECR-range'!Q31)","v":""},null,null,null,{"$f":"IF(TRIM(T16)=\"\", \"\", IF(VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V16,'Input for ECR-range'!V31)<2,\"\",'Input for ECR-range'!V16*1000/'Input for ECR-range'!V31)","v":""},null,null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","NAC_T","NAP","    NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",{"$f":"IF(COUNT('Input for ECR-range'!G17,'Input for ECR-range'!G32)<2,\"\",'Input for ECR-range'!G17*1000/'Input for ECR-range'!G32)","v":""},null,null,null,{"$f":"IF(TRIM(J17)=\"\", \"\", IF(VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L17,'Input for ECR-range'!L32)<2,\"\",'Input for ECR-range'!L17*1000/'Input for ECR-range'!L32)","v":""},null,null,null,{"$f":"IF(TRIM(O17)=\"\", \"\", IF(VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q17,'Input for ECR-range'!Q32)<2,\"\",'Input for ECR-range'!Q17*1000/'Input for ECR-range'!Q32)","v":""},null,null,null,{"$f":"IF(TRIM(T17)=\"\", \"\", IF(VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V17,'Input for ECR-range'!V32)<2,\"\",'Input for ECR-range'!V17*1000/'Input for ECR-range'!V32)","v":""},null,null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","NAC_T","NAP","    NACE H Transportation and storage",{"$f":"IF(COUNT('Input for ECR-range'!G18,'Input for ECR-range'!G33)<2,\"\",'Input for ECR-range'!G18*1000/'Input for ECR-range'!G33)","v":""},null,null,null,{"$f":"IF(TRIM(J18)=\"\", \"\", IF(VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L18,'Input for ECR-range'!L33)<2,\"\",'Input for ECR-range'!L18*1000/'Input for ECR-range'!L33)","v":""},null,null,null,{"$f":"IF(TRIM(O18)=\"\", \"\", IF(VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q18,'Input for ECR-range'!Q33)<2,\"\",'Input for ECR-range'!Q18*1000/'Input for ECR-range'!Q33)","v":""},null,null,null,{"$f":"IF(TRIM(T18)=\"\", \"\", IF(VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V18,'Input for ECR-range'!V33)<2,\"\",'Input for ECR-range'!V18*1000/'Input for ECR-range'!V33)","v":""},null,null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","NAC_T","NAP","    NACE I-U Services (except wholosale and retail trade, transportation and storage) ",{"$f":"IF(COUNT('Input for ECR-range'!G19,'Input for ECR-range'!G34)<2,\"\",'Input for ECR-range'!G19*1000/'Input for ECR-range'!G34)","v":""},null,null,null,{"$f":"IF(TRIM(J19)=\"\", \"\", IF(VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L19,'Input for ECR-range'!L34)<2,\"\",'Input for ECR-range'!L19*1000/'Input for ECR-range'!L34)","v":""},null,null,null,{"$f":"IF(TRIM(O19)=\"\", \"\", IF(VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q19,'Input for ECR-range'!Q34)<2,\"\",'Input for ECR-range'!Q19*1000/'Input for ECR-range'!Q34)","v":""},null,null,null,{"$f":"IF(TRIM(T19)=\"\", \"\", IF(VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V19,'Input for ECR-range'!V34)<2,\"\",'Input for ECR-range'!V19*1000/'Input for ECR-range'!V34)","v":""},null,null,null,{"$f":"IF(TRIM(Y19)=\"\", \"\", IF(VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y19,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","NAC_T","NAP","    Not elsewhere classified ",{"$f":"IF(OR((COUNT('Input for ECR-range'!G20,'Input for ECR-range'!G35)<2),('Input for ECR-range'!G35=0)),\"\",'Input for ECR-range'!G20*1000/'Input for ECR-range'!G35)","v":""},null,null,null,{"$f":"IF(TRIM(J20)=\"\", \"\", IF(VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR((COUNT('Input for ECR-range'!L20,'Input for ECR-range'!L35)<2),('Input for ECR-range'!L35=0)),\"\",'Input for ECR-range'!L20*1000/'Input for ECR-range'!L35)","v":""},null,null,null,{"$f":"IF(TRIM(O20)=\"\", \"\", IF(VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR((COUNT('Input for ECR-range'!Q20,'Input for ECR-range'!Q35)<2),('Input for ECR-range'!Q35=0)),\"\",'Input for ECR-range'!Q20*1000/'Input for ECR-range'!Q35)","v":""},null,null,null,{"$f":"IF(TRIM(T20)=\"\", \"\", IF(VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(OR((COUNT('Input for ECR-range'!V20,'Input for ECR-range'!V35)<2),('Input for ECR-range'!V35=0)),\"\",'Input for ECR-range'!V20*1000/'Input for ECR-range'!V35)","v":""},null,null,null,{"$f":"IF(TRIM(Y20)=\"\", \"\", IF(VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y20,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[]
[null,null,"NACE_R2","unit","PEDS","Percentage of total CO2 emissions\nby institutional sector",2019,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2020,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2021,"Standard footnote","Confidentiality footnote","Explanatory footnote",null,2022,"Standard footnote","Confidentiality footnote","Explanatory footnote"]
[null,null,"TOTAL_HH","PC_TOT","NAP","(= 100%)",{"$f":"IF(COUNT('Input for ECR-range'!G23,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G23*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J23)=\"\", \"\", IF(VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L23,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L23*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O23)=\"\", \"\", IF(VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q23,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q23*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T23)=\"\", \"\", IF(VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V23,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V23*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y23)=\"\", \"\", IF(VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y23,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"EP_HH","PC_TOT","NAP","Households as final consumers",{"$f":"IF(COUNT('Input for ECR-range'!G24,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G24*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J24)=\"\", \"\", IF(VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L24,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L24*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O24)=\"\", \"\", IF(VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q24,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q24*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T24)=\"\", \"\", IF(VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V24,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V24*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y24)=\"\", \"\", IF(VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y24,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"TOTAL","PC_TOT","NAP","Corporations",{"$f":"IF(COUNT('Input for ECR-range'!G25,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G25*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J25)=\"\", \"\", IF(VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L25,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L25*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O25)=\"\", \"\", IF(VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q25,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q25*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T25)=\"\", \"\", IF(VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V25,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V25*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y25)=\"\", \"\", IF(VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y25,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"A","PC_TOT","NAP","  NACE A Agriculture, forestry and fishing",{"$f":"IF(COUNT('Input for ECR-range'!G26,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G26*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J26)=\"\", \"\", IF(VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L26,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L26*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O26)=\"\", \"\", IF(VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q26,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q26*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T26)=\"\", \"\", IF(VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V26,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V26*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y26)=\"\", \"\", IF(VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y26,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"B","PC_TOT","NAP","  NACE B Mining and quarrying;",{"$f":"IF(COUNT('Input for ECR-range'!G27,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G27*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J27)=\"\", \"\", IF(VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L27,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L27*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O27)=\"\", \"\", IF(VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q27,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q27*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T27)=\"\", \"\", IF(VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V27,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V27*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y27)=\"\", \"\", IF(VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y27,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"C","PC_TOT","NAP","  NACE C Manufacturing",{"$f":"IF(COUNT('Input for ECR-range'!G28,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G28*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J28)=\"\", \"\", IF(VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L28,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L28*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O28)=\"\", \"\", IF(VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q28,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q28*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T28)=\"\", \"\", IF(VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V28,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V28*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y28)=\"\", \"\", IF(VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y28,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"D","PC_TOT","NAP","  NACE D Electricity, gas, steam and air conditioning supply ",{"$f":"IF(COUNT('Input for ECR-range'!G29,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G29*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J29)=\"\", \"\", IF(VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L29,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L29*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O29)=\"\", \"\", IF(VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q29,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q29*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T29)=\"\", \"\", IF(VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V29,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V29*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y29)=\"\", \"\", IF(VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y29,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"E","PC_TOT","NAP","  NACE E Water supply, sewerage, waste management and remedition activities",{"$f":"IF(COUNT('Input for ECR-range'!G30,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G30*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J30)=\"\", \"\", IF(VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L30,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L30*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O30)=\"\", \"\", IF(VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q30,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q30*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T30)=\"\", \"\", IF(VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V30,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V30*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y30)=\"\", \"\", IF(VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y30,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"F","PC_TOT","NAP","  NACE F Construction",{"$f":"IF(COUNT('Input for ECR-range'!G31,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G31*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J31)=\"\", \"\", IF(VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L31,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L31*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O31)=\"\", \"\", IF(VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q31,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q31*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T31)=\"\", \"\", IF(VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V31,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V31*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y31)=\"\", \"\", IF(VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y31,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"G","PC_TOT","NAP","  NACE G Wholesale and retail trade; repair of motor vehicles and motorcycles",{"$f":"IF(COUNT('Input for ECR-range'!G32,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G32*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J32)=\"\", \"\", IF(VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L32,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L32*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O32)=\"\", \"\", IF(VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q32,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q32*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T32)=\"\", \"\", IF(VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V32,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V32*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y32)=\"\", \"\", IF(VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y32,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"H","PC_TOT","NAP","  NACE H Transportation and storage",{"$f":"IF(COUNT('Input for ECR-range'!G33,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G33*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J33)=\"\", \"\", IF(VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L33,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L33*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O33)=\"\", \"\", IF(VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q33,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q33*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T33)=\"\", \"\", IF(VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V33,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V33*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y33)=\"\", \"\", IF(VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y33,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"I-U","PC_TOT","NAP","  NACE I-U Services (except wholosale and retail trade, transportation and storage) ",{"$f":"IF(COUNT('Input for ECR-range'!G34,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G34*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J34)=\"\", \"\", IF(VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L34,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L34*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O34)=\"\", \"\", IF(VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q34,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q34*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T34)=\"\", \"\", IF(VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V34,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V34*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y34)=\"\", \"\", IF(VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y34,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]
[null,null,"NAL","PC_TOT","NAP","  Not elsewhere classified ",{"$f":"IF(COUNT('Input for ECR-range'!G35,'Input for ECR-range'!G$23)<2,\"\",'Input for ECR-range'!G35*100/'Input for ECR-range'!G$23)","v":""},null,null,null,{"$f":"IF(TRIM(J35)=\"\", \"\", IF(VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(J35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!L35,'Input for ECR-range'!L$23)<2,\"\",'Input for ECR-range'!L35*100/'Input for ECR-range'!L$23)","v":""},null,null,null,{"$f":"IF(TRIM(O35)=\"\", \"\", IF(VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(O35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!Q35,'Input for ECR-range'!Q$23)<2,\"\",'Input for ECR-range'!Q35*100/'Input for ECR-range'!Q$23)","v":""},null,null,null,{"$f":"IF(TRIM(T35)=\"\", \"\", IF(VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(T35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""},{"$f":"IF(COUNT('Input for ECR-range'!V35,'Input for ECR-range'!V$23)<2,\"\",'Input for ECR-range'!V35*100/'Input for ECR-range'!V$23)","v":""},null,null,null,{"$f":"IF(TRIM(Y35)=\"\", \"\", IF(VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE)=0,\"\",VLOOKUP(Y35,'Footnotes list'!$D$9:$E$58,2,FALSE) ) )","v":""}]

{"sheet":"Implicit transfers","index":13,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"Free format for countries to report"]

{"sheet":"ErrorLog","index":14,"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":15,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Change","Changed by","Change","SheetName","Cell","Version","Date","REMARKS"]
["Adapt to Waste questionnaires standards m24.","CDD",null,"Standard macros",null,1,"2022-10-18"]

{"sheet":"Lists","index":16,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,9,1,10],[5,9,5,10],[10,9,10,10],[15,9,15,10]]}
["Country label","Country code",null,"Valid flags (obs_status)","Label",null,"Valid flags (obs_conf)","Label",null,"Textual variables","String",null,"PEDS-2022-DC"]
["Belgium","BE",null,"B","break in time series",null,"C","confidential",null,"Institutional names"]
["Bulgaria","BG",null,"E","estimated data",null,"D","secondary confidentiality set by the sender",null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ",null,"P","provisional",null,"N","Not to be published",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 Title","Annual reporting of Potential Environmentally Damaging Subsidies (PEDS)"]
["Ireland","IE",null,"BEP",null,null,null,null,null,"Data Collection Year",2023]
["Greece","EL",null,null,null,null,null,null,null,"Launching date","December 15th 2023"]
["Spain","ES",null,null,null,null,null,null,null,"Submission deadline","31st May 2024"]
["France","FR",null,null,null,null,null,null,null,"EDAMIS data"]
["Croatia","HR",null,null,null,null,null,null,null,"Domain name","PEDS"]
["Italy","IT",null,null,null,null,null,null,null,"Dataset name","ENVDATA_PEDS_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 31914"]
["Hungary","HU",null,null,null,null,null,null,null,"Contact","ESTAT-ETEA-ESST-1@ec.europa.eu"]
["Malta","MT",null,null,null,null,null,null,null,"Methodology URL","https://ec.europa.eu/eurostat/web/environment/methodology"]
["Netherlands","NL",null,null,null,null,null,null,null,"Legislation URL"]
["Austria","AT"]
["Poland","PL"]
["Portugal","PT"]
["Romania","RO"]
["Slovenia","SI"]
["Slovakia","SK"]
["Finland","FI"]
["Sweden","SE"]
["United Kingdom","UK"]
["Iceland","IS"]
["Liechtenstein","LI"]
["Norway","NO"]
["Switzerland","CH"]
["Montenegro","ME"]
["North Macedonia","MK"]
["Albania","AL"]
["Serbia","RS"]
["Turkey","TR"]
["Bosnia and Herzegovina","BA"]
["Kosovo (UNSCR 1244)","XK"]

{"sheet":"MacroBehaviour","index":17,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["COMMON TO ALL (OR MOST) QUESTIONNAIRE",null,null,null,"SPECIFIC TO THIS QUESTIONNAIRE"]
["Parameter","Value","(Valid values)",null,"Parameter","Value","(Valid values)"]
["DevelopementMode",true,"TRUE (during development)\nFALSE (For real reporting and testing)"]

{"sheet":"x Locks","index":18,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To"]
["PEDS_ESA","G10","V10",999,5,"Formulas","G8"]
["PEDS_ESA","G25","V25",999,5,"Formulas","G8"]
["Input for ECR-range","G10","V10",999,5,"Formulas","G8"]
["Input for ECR-range","G25","V25",999,5,"Formulas","G8"]

{"sheet":"IsFormula","index":19,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Severity","Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step"]
["error","PEDS_ESA","G8","V8",999,5]
["Info","PEDS_ESA","G10","V10",999,5]
["error","PEDS_ESA","G23","V23",999,5]
["Info","PEDS_ESA","G25","V25",999,5]
["error","PEDS_ESA","G38","V50",1,5]
["error","Input for ECR-range","G8","V8",999,5]
["Info","Input for ECR-range","G10","V10",999,5]
["error","Input for ECR-range","G23","V23",999,5]
["Info","Input for ECR-range","G25","V25",999,5]

{"sheet":"StandardFootnotes","index":20,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Footnote type \n(CONF/STATUS)"]
["error","PEDS_ESA","H8","W20",1,5,"STATUS"]
["error","PEDS_ESA","H23","W35",1,5,"STATUS"]
["error","PEDS_ESA","H38","W50",1,5,"STATUS"]
["error","Input for ECR-range","H8","W20",1,5,"STATUS"]
["error","Input for ECR-range","H23","W35",1,5,"STATUS"]
["error","ECR - range","H8","W20",1,5,"STATUS"]
["error","ECR - range","H23","W35",1,5,"STATUS"]
["error","PEDS_ESA","I8","X20",1,5,"CONF"]
["error","PEDS_ESA","I23","X35",1,5,"CONF"]
["error","PEDS_ESA","I38","X50",1,5,"CONF"]
["error","Input for ECR-range","I8","X20",1,5,"CONF"]
["error","Input for ECR-range","I23","X35",1,5,"CONF"]
["error","ECR - range","I8","X20",1,5,"CONF"]
["error","ECR - range","I23","X35",1,5,"CONF"]

{"sheet":"FootnoteContent","index":21,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep","DistanceFromReferenceToText"]
["error","PEDS_ESA","J8","Y20",1,5,1]
["error","PEDS_ESA","J23","Y35",1,5,1]
["error","PEDS_ESA","J38","Y50",1,5,1]
["error","Input for ECR-range","J8","Y20",1,5,1]
["error","Input for ECR-range","J23","Y35",1,5,1]
["error","ECR - range","J8","Y20",1,5,1]
["error","ECR - range","J23","Y35",1,5,1]

{"sheet":"Summations","index":22,"n_rows":111,"n_cols":13,"rows_kept":111,"cut":false,"hidden":true,"merged":[[12,5,12,6]]}
["Severity","Sheet Name","List of Cells\n (first block)","First Total Cell (first block)","Last Total Cell\n(Last block)","Row Block Repetition Step","Column Block Repetition Step","Greater or Equal","Valid Tolerance","Only if all data is available","Non compliance Is Valid If Footnote Exists","Footnote Shift From Value","Display text in error"]
["Error","PEDS_ESA","G11,G12,G13,G14,G15,G16,G17,G18, G19,G20","G10","V10",999,5,"EQ",0.1,"NO","NO",4,"Total paid to corporations (total NACE) not consistent to the sum of NACE Sections (A to I-U)"]
["Error","PEDS_ESA","G26,G27,G28,G29,G30,G31,G32,G33, G34,G35","G25","V25",999,5,"EQ",0.1,"NO","NO",4,"Total paid to corporations (total NACE) not consistent to the sum of NACE Sections (A to I-U)"]
["Error","PEDS_ESA","G9, G10","G8","V8",999,5,"EQ",0.1,"NO","NO",4,"Total subsidies must be equal to subsidies paid to households + subsidies paid to corporations"]
["Error","PEDS_ESA","G24, G25","G23","V23",999,5,"EQ",0.1,"NO","NO",4,"Total subsidies must be equal to subsidies paid to households + subsidies paid to corporations"]
["Error","PEDS_ESA","G8,G23","G38","V50",1,5,"EQ",0.1,"NO","NO",4,"Total PEDS must be equal to transfers related to fossil fuels + other transfers."]
["Error","Input for ECR-range","G11,G12,G13,G14,G15,G16,G17,G18, G19,G20","G10","V10",999,5,"EQ",0.1,"NO","NO",4,"Total taxes paid by corporations (total NACE) not consistent to the sum of NACE Sections (A to I-U)"]
["Error","Input for ECR-range","G26,G27,G28,G29,G30,G31,G32,G33, G34,G35","G25","V25",999,5,"EQ",0.1,"NO","NO",4,"Total CO2 emissions by corporations (total NACE) not consistent to the sum of NACE Sections (A to I-U)"]
["Error","Input for ECR-range","G9, G10","G8","V8",999,5,"EQ",0.1,"NO","NO",4,"Total taxes must be equal to taxes paid by households + taxes paid by corporations"]
["Error","Input for ECR-range","G24, G25","G23","V23",999,5,"EQ",0.1,"NO","NO",4,"Total CO2 emissions  must be equal to CO2 emissions  by households + CO2 emissions by corporations"]
[]
[]
[null,null,null,null,null,"Must be > 0. Else you get an infinite loop. \"999\" is a convention for a not relevant dimension",null,"EQ or GE or GT","GT does not admit Tolerance","NO or YES",null,"Not Applicable if the previous column is \"NO\""]
[]
["DESCRIPTION"]
["This sheet is meant to define the validation for summations in a row or in a column."]
["- A block is defined as a sequence of addendums in the same row or column"]
["- Only the first block must be explicitly defined"]
["- The block can be repeated at regular patterns through rows and columns at the same time"]
[]
[]
["PARAMETRES"]
["SheetName",null,"Name of the sheet to be validated (e.g. Table 1)"]
["List of Cells\n (first block)",null,"First cell in the first block to be validated"]
["First TotalCell (first block)"]
["Last TotalCell (Last block)"]
["Row Block Repetition Step"]
["Column Block Repetition Step"]
["Greater or Equal"]
["Valid Threshold"]
["Only if all data is available"]
["Display text in error",null,"Valid values: EQ (Strictly equal); GE (Greater or Equal); GT (Strictly greater - No threshold will be considered)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(Summations!B3º)","v":{"$error":"#NAME?"}}]

{"sheet":"MustNotBeNegative","index":23,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","PEDS_ESA","G8","V20",1,5]
["Error","PEDS_ESA","G23","V35",1,5]
["Error","PEDS_ESA","G38","J50",1,5]
["Error","Input for ECR-range","G8","V20",1,5]
["Error","Input for ECR-range","G23","V35",1,5]
["Error","ECR - range","G8","V20",1,5]
["Error","ECR - range","G23","V35",1,5]

{"sheet":"IsNumeric","index":24,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","PEDS_ESA","G8","V20",1,5]
["Error","PEDS_ESA","G23","V35",1,5]
["Error","PEDS_ESA","G38","J50",1,5]
["Error","Input for ECR-range","G8","V20",1,5]
["Error","Input for ECR-range","G23","V35",1,5]
["Error","ECR - range","G8","V20",1,5]
["Error","ECR - range","G23","V35",1,5]

{"sheet":"Thresholds","index":25,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lower value","Upper value","Error Is Valid If Footnote Exists","Footnote Shift From Value"]
["Error","ECR - range","G24","V35",1,5,0,100,"NO",999]
["Error","ECR - range","G23","V23",1,5,100,100,"NO",999]

{"sheet":"Mandatory","index":26,"n_rows":3,"n_cols":9,"rows_kept":3,"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","E9",1,999,"NO",999,"STANDARD FOR ALL QUESTIONNAIRES"]
["Error","GETTING STARTED","D14","D22",2,999,"NO",999]