{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["COVER","Basic Instructions","GETTING STARTED","Footnotes list","Table 1 (Level 1 + 2)","Table 2 (Conversion matrix)","Lists","MacroBehaviour","ErrorLog","Locks","MustNotBeNegative","IsNumeric","Summations","xMandatory","Table 3 (Level 3)"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Basic Instructions","index":1,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[[91,2,91,5],[66,2,66,5],[68,2,68,5],[70,2,70,5],[72,2,72,5],[74,2,74,5],[78,2,78,5],[80,2,80,5],[85,2,85,5],[87,2,87,5],[88,2,88,5],[90,2,90,5],[64,2,64,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[49,2,49,5],[50,2,50,5],[51,2,51,5],[54,2,54,5],[55,3,55,5],[61,2,61,5],[62,2,62,5],[43,2,43,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[24,2,24,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[34,2,34,5],[40,2,40,5],[17,2,17,5],[3,2,3,5],[4,2,4,5],[6,2,6,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5]]}
[]
[]
[null,null,null,null,null,{"$f":"UPPER(Lists!K3)","v":"STATISTICAL OFFICE OF THE EUROPEAN UNION"}]
[null,null,{"$f":"UPPER(Lists!K7)","v":"ECOSYSTEM EXTENT ACCOUNTS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null,"BASIC INSTRUCTIONS"]
[]
[null,null,"Before filling in the questionnaire please read carefully the instructions below. "]
[null,null,"This EXCEL workbook is the questionnaire. "]
[null,null,"VERY IMPORTANT: Please do not delete or add rows to any of the tables in this questionnaire"]
[]
[null,null,"Table of contents"]
[null,null,"1. How to fill in the data sheets of the questionnaire"]
[null,null,"    1.1 Priority data"]
[null,null,"    1.2 Reporting conventions"]
[null,null,"    1.3 Built-in consistency checks"]
[null,null,"2. Flags"]
[null,null,"    2.1 Standard footnotes"]
[null,null,"    2.2 Country-specific explanatory footnotes"]
[null,null,"3. Definitions"]
[null,null,"4. Data submission"]
[null,null,"5. Methodology and questions"]
[]
[null,null,"1 -  How to fill in the data sheets of the questionnaire"]
[]
[null,null,"1.1 Priority data"]
[]
[null,null,"Priority data in this questionnaire are datapoints the reporting of which is foreseen mandatory in the Commission proposal to amend Regulation (EU) 691/2011 to add new modules of environmental economic accounts."]
[null,null,"A legend in each worksheet indicated which datapoints are the priority ones. Some of them are calculated automatically if data in input cells are provided."]
[null,null," Please do not modify the formulas provided in the table. "]
[]
[null,null,"1.2 Reporting conventions"]
[]
[null,null,"Report any real zeros and leave cell empty if you have no data. Do not write text in data cells; use footnotes if you need to provide additional context to any reported datapoint. Non-numeric symbols in cells that are designated for data reporting will result in an automated rejection of the questionnaire and a correction will be needed. "]
[null,null,"Description","Symbol"]
[null,null,"Real zero",0]
[null,null,"Not available",null," (blank/empty cell)"]
[]
[null,null,"Report reductions in stock as a positive number (even though they represent decreases) or a 0."]
[null,null,"It is possible to insert decimal numbers. Please notice Eurostat will publish only up top two decimal places."]
[]
[null,null,"1.3 Built-in consistency checks"]
[null,null,"The questionnaire has built-in automated checks to verify internal consistency of reported data (e.g. sums across rows and columns, as applicable), using macro functions."]
[null,null,"The checks are activated separately for each worksheet of the questionnaire, clicking on the button 'Validate questionnaire' in the header of each EFA Table. Cells with consistency issues will be highlighted with red colour and the issues will be explained in the last worksheet 'ErrorLog'. Please run the automated checks and correct any identified consistency issues before submitting the questionnaire to Eurostat. After correcting the values, you may remove the red colour using button 'Restore table colour'."]
[null,null,"To run the consistency checks it is crucial that macros are enabled in the questionnaire. This can be done via button 'Enable Content' in the yellow bar in the top part of the excel file."]
[]
[null,null,"2. Flags"]
[]
[null,null,"Flags (footnote symbols) should be entered in the reporting tables in the footnote columns, next to the value cell. There are two types of footnotes: "]
[null,null,"- Letters for standard footnotes (as defined by Eurostat)"]
[null,null,"- Numbers for country-specific footnotes (to be defined by the data compilers). "]
[]
[null,null,"2.1 Standard footnotes"]
[null,null,"The following footnotes will be used for the automatic data processing and data dissemination. Hence, they cannot be changed:"]
[null,null,"B) break in series","Please use this flag when the reported figure cannot be compared to the data reported for the previous year, e.g. because of new methods or sources being used or when you move from the old calculation rules to the new calculation rules. Please use this flag only when the change in methods, sources or calculation rules has a substantial impact."]
[null,null,"E) estimated data"]
[null,null,"P) provisional"]
[null,null,"To include standard footnotes use the drop-down menu. "]
[]
[null,null,"2.2 Country-specific explanatory footnotes"]
[null,null,"The country-specific footnotes can be used for any meaning beyond the pre-defined footnotes."]
[null,null,"To include a country-specific footnote, please first insert the text in the “Footnote list” sheet starting from number 1. Then in the data table please select the corresponding footnote reference number from the drop-down menu in the footnote column next to the value cell. The text you entered in the “Footnote list” sheet will then appear automatically next to the footnote reference number. The same explanatory footnote can be chosen for all the values for which the same explanation applies. If by mistake a number is chosen from the drop-down menu, it is sufficient to press the key delete to clean the cell."]
[]
[null,null,"3. Definitions"]
[]
[null,null,"EU reporting for ecosystem extent accounts uses the Guidance note on ecosystem extent accounts prepared by the Task force on ecosystem accounting and the Environmental accounts working groups. The Guidance note follows the SEEA - Ecosystem Accounting and Annex IX of the Commission proposal to amend Regulation (EU) 691/2011 on European environmental-economic accounts to add new modules.  "]
[]
[null,null,"The economic and accounting definitions are those of SNA 2008 and ESA 2010.     "]
[]
[null,null,"4. Data submission"]
[]
[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. It may be accessed at: "]
[null,null,null,"https://webgate.ec.europa.eu/edamis4/ "]
[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":"ENVDATA"}]
[null,null,"Dataset name:",{"$f":"Lists!K13","v":"ENVDATA_ECOEXT_3"}]
[]
[null,null,"Please enter in the eDAMIS field 'year' the reference year for which the data are reported for (closing stock), not the current calendar year. \nAfter filling all dataset details, eDAMIS will automatically name submitted files as 'ENVDATA_ECOEXT_3_cc_yyyy_0000_V000x\" where cc is the country code, yyyy the reference year and x the version of the file. \n"]
[]
[null,null,"Should you have any questions regarding data transmission do not hesitate to contact your local eDAMIS coordinator or the Eurostat eDAMIS helpdesk at: "]
[null,null,"   web page:",{"$f":"Lists!K14","v":"https://cros-legacy.ec.europa.eu/content/edamis-general_en"}]
[null,null,"   e-mail address:",{"$f":"Lists!K15","v":"ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"}]
[null,null,"   telephone:",{"$f":"Lists!K17","v":"(+352) 4301 33213"}]
[]
[null,null,"5. Methodology and questions"]
[]
[null,null,{"$f":"CONCATENATE(\"The guidelines to report on \", Lists!K7,\" are available on Eurostat website:\")","v":"The guidelines to report on Ecosystem Extent Accounts are available on Eurostat website:"}]
[null,null,{"$f":"Lists!K19","v":"https://ec.europa.eu/eurostat/web/environment/methodology "}]
[]
[null,null,"If you have questions, please send them to the following email addresses:"]
[null,null,{"$f":"Lists!K18","v":"ESTAT-ECOSYSTEMS@EC.EUROPA.EU"}]

{"sheet":"GETTING STARTED","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,3,14,6],[3,2,3,6],[4,2,4,6],[6,2,6,6],[8,2,8,3],[12,2,12,6],[16,3,16,6],[18,3,18,6],[20,3,20,6],[22,3,22,6],[23,2,23,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":"ECOSYSTEM EXTENT ACCOUNTS"}]
[null,null,{"$f":"CONCATENATE(Lists!K8,\" DATA COLLECTION\")","v":"2023 DATA COLLECTION"}]
[]
[null,null," GETTING STARTED"]
[]
[null,null,"Please select your country (click on the white cell):        ",null,null,null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,Lists!A2:B40,2,FALSE))","v":""}]
[null,null,"Reference year:    "]
[null,null,"Previous reference year:"]
[null,null,{"$f":"CONCATENATE(\"The due date for reporting is \",Lists!K10)","v":"The due date for reporting is 30 April 2024"}]
[null,null,{"$f":"\"Who is the primary contact point for the data collection \" &  \"Ecosystem accounts\"&\"?\"","v":"Who is the primary contact point for the data collection Ecosystem accounts?"}]
[]
[null,null,"Name:"]
[]
[null,null,"Institution:"]
[]
[null,null,"Unit:"]
[]
[null,null,"Telephone:"]
[]
[null,null,"Email adress:"]

{"sheet":"Footnotes list","index":3,"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":"ECOSYSTEM EXTENT ACCOUNTS"}]
[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,"insert explanatory text here"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]

{"sheet":"Table 1 (Level 1 + 2)","index":4,"n_rows":79,"n_cols":26,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,5,1,25],[6,24,6,25],[6,8,6,9],[6,12,6,13],[6,16,6,17],[6,20,6,21]]}
[]
[null,null,"previous_time\n(PROPERTY) =>>",{"$f":"IF('GETTING STARTED'!E11=\"\",\"\",'GETTING STARTED'!E11)","v":""},null,"Table 1 - Ecosystem extent accounts\n(a) Area in 1000 ha"]
[null,null,"GEO =>",{"$f":"'GETTING STARTED'!G9","v":""},null,{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":""}]
[null,null,"TIME=>",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":""},null,{"$f":" \"Reference year: \" &D4","v":"Reference year: "}]
[null,null,"UNIT=>","THS_HA",null,{"$f":" \"(Previous reference year: \" & 'GETTING STARTED'!$E$11 & \")\"","v":"(Previous reference year: )"}]
[null,null,"ECOSYST_C =>","NAP"]
[null,null,"ECOSYST",null,null,"EU ecosystem typology","Opening area (Extent in the previous reference year)","Standard footnotes","Explanatory\nfootnote",null,"Additions","Standard footnotes","Explanatory\nfootnote",null,"Reductions","Standard footnotes","Explanatory\nfootnote",null,"Closing area (Extent in the current reference year)","Standard footnotes","Explanatory\nfootnote",null,"Net changes (additions less reductions; +/-)","Standard footnotes","Explanatory\nfootnote"]
[null,null,"ECO0101",null,null,"1.1  Continuous settlement area",null,null,null,{"$f":"IF(TRIM(I8)=\"\", \"\", IF(VLOOKUP(I8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M8)=\"\", \"\", IF(VLOOKUP(M8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q8)=\"\", \"\", IF(VLOOKUP(Q8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U8)=\"\", \"\", IF(VLOOKUP(U8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K8,O8))=\"\",\"\",K8-O8)","v":""},null,null,{"$f":"IF(TRIM(Y8)=\"\", \"\", IF(VLOOKUP(Y8,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y8,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0102",null,null,"1.2  Discontinuous settlement area",null,null,null,{"$f":"IF(TRIM(I9)=\"\", \"\", IF(VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M9)=\"\", \"\", IF(VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q9)=\"\", \"\", IF(VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U9)=\"\", \"\", IF(VLOOKUP(U9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K9,O9))=\"\",\"\",K9-O9)","v":""},null,null,{"$f":"IF(TRIM(Y9)=\"\", \"\", IF(VLOOKUP(Y9,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y9,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0103",null,null,"1.3  Infrastructure ",null,null,null,{"$f":"IF(TRIM(I10)=\"\", \"\", IF(VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M10)=\"\", \"\", IF(VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q10)=\"\", \"\", IF(VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U10)=\"\", \"\", IF(VLOOKUP(U10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y10)=\"\", \"\", IF(VLOOKUP(Y10,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y10,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0104",null,null,"1.4  Urban greenspace",null,null,null,{"$f":"IF(TRIM(I11)=\"\", \"\", IF(VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M11)=\"\", \"\", IF(VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q11)=\"\", \"\", IF(VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U11)=\"\", \"\", IF(VLOOKUP(U11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y11)=\"\", \"\", IF(VLOOKUP(Y11,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y11,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0105",null,null,"1.5  Other artificial areas",null,null,null,{"$f":"IF(TRIM(I12)=\"\", \"\", IF(VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M12)=\"\", \"\", IF(VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q12)=\"\", \"\", IF(VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U12)=\"\", \"\", IF(VLOOKUP(U12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y12)=\"\", \"\", IF(VLOOKUP(Y12,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y12,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO01",null,null,"1. Settlements and other artificial areas",{"$f":"IF(COUNTA(G8:G12)<5,\"\",SUM(G8:G12))","v":""},null,null,{"$f":"IF(TRIM(I13)=\"\", \"\", IF(VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K8:K12)<5,\"\",SUM(K8:K12))","v":""},null,null,{"$f":"IF(TRIM(M13)=\"\", \"\", IF(VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O8:O12)<5,\"\",SUM(O8:O12))","v":""},null,null,{"$f":"IF(TRIM(Q13)=\"\", \"\", IF(VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S8:S12)<5,\"\",SUM(S8:S12))","v":""},null,null,{"$f":"IF(TRIM(U13)=\"\", \"\", IF(VLOOKUP(U13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W8,W12))=\"\",\"\",SUM(W8:W12))","v":""},null,null,{"$f":"IF(TRIM(Y13)=\"\", \"\", IF(VLOOKUP(Y13,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y13,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0201",null,null,"2.1 Annual cropland ",null,null,null,{"$f":"IF(TRIM(I14)=\"\", \"\", IF(VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M14)=\"\", \"\", IF(VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q14)=\"\", \"\", IF(VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U14)=\"\", \"\", IF(VLOOKUP(U14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K14,O14))=\"\",\"\",K14-O14)","v":""},null,null,{"$f":"IF(TRIM(Y14)=\"\", \"\", IF(VLOOKUP(Y14,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y14,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0202",null,null,"2.2 Rice fields",null,null,null,{"$f":"IF(TRIM(I15)=\"\", \"\", IF(VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M15)=\"\", \"\", IF(VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q15)=\"\", \"\", IF(VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U15)=\"\", \"\", IF(VLOOKUP(U15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K15,O15))=\"\",\"\",K15-O15)","v":""},null,null,{"$f":"IF(TRIM(Y15)=\"\", \"\", IF(VLOOKUP(Y15,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y15,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0203",null,null,"2.3 Permanent crops",null,null,null,{"$f":"IF(TRIM(I16)=\"\", \"\", IF(VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M16)=\"\", \"\", IF(VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q16)=\"\", \"\", IF(VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U16)=\"\", \"\", IF(VLOOKUP(U16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y16)=\"\", \"\", IF(VLOOKUP(Y16,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y16,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0204",null,null,"2.4 Agro-forestry areas",null,null,null,{"$f":"IF(TRIM(I17)=\"\", \"\", IF(VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M17)=\"\", \"\", IF(VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q17)=\"\", \"\", IF(VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U17)=\"\", \"\", IF(VLOOKUP(U17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y17)=\"\", \"\", IF(VLOOKUP(Y17,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y17,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0205",null,null,"2.5 Mixed farmland",null,null,null,{"$f":"IF(TRIM(I18)=\"\", \"\", IF(VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M18)=\"\", \"\", IF(VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q18)=\"\", \"\", IF(VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U18)=\"\", \"\", IF(VLOOKUP(U18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y18)=\"\", \"\", IF(VLOOKUP(Y18,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y18,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0206",null,null,"2.6 Other farmland",null,null,null,{"$f":"IF(TRIM(I19)=\"\", \"\", IF(VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M19)=\"\", \"\", IF(VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q19)=\"\", \"\", IF(VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U19)=\"\", \"\", IF(VLOOKUP(U19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y19)=\"\", \"\", IF(VLOOKUP(Y19,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y19,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO02",null,null,"2. Cropland",{"$f":"IF(COUNTA(G14:G19)<6,\"\",SUM(G14:G19))","v":""},null,null,{"$f":"IF(TRIM(I20)=\"\", \"\", IF(VLOOKUP(I20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K14:K19)<6,\"\",SUM(K14:K19))","v":""},null,null,{"$f":"IF(TRIM(M20)=\"\", \"\", IF(VLOOKUP(M20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O14:O19)<6,\"\",SUM(O14:O19))","v":""},null,null,{"$f":"IF(TRIM(Q20)=\"\", \"\", IF(VLOOKUP(Q20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S14:S19)<6,\"\",SUM(S14:S19))","v":""},null,null,{"$f":"IF(TRIM(U20)=\"\", \"\", IF(VLOOKUP(U20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W14,W19))=\"\",\"\",SUM(W14:W19))","v":""},null,null,{"$f":"IF(TRIM(Y20)=\"\", \"\", IF(VLOOKUP(Y20,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y20,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0301",null,null,"3.1 Sown pastures and grass (modified grasslands) ",null,null,null,{"$f":"IF(TRIM(I21)=\"\", \"\", IF(VLOOKUP(I21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M21)=\"\", \"\", IF(VLOOKUP(M21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q21)=\"\", \"\", IF(VLOOKUP(Q21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U21)=\"\", \"\", IF(VLOOKUP(U21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K21,O21))=\"\",\"\",K21-O21)","v":""},null,null,{"$f":"IF(TRIM(Y21)=\"\", \"\", IF(VLOOKUP(Y21,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y21,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0302",null,null,"3.2 Natural and semi-natural grasslands ",null,null,null,{"$f":"IF(TRIM(I22)=\"\", \"\", IF(VLOOKUP(I22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M22)=\"\", \"\", IF(VLOOKUP(M22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q22)=\"\", \"\", IF(VLOOKUP(Q22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U22)=\"\", \"\", IF(VLOOKUP(U22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K22,O22))=\"\",\"\",K22-O22)","v":""},null,null,{"$f":"IF(TRIM(Y22)=\"\", \"\", IF(VLOOKUP(Y22,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y22,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO03",null,null,"3. Grassland",{"$f":"IF(COUNTA(G21:G22)<2,\"\",SUM(G21,G22))","v":""},null,null,{"$f":"IF(TRIM(I23)=\"\", \"\", IF(VLOOKUP(I23,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I23,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K21:K22)<2,\"\",SUM(K21,K22))","v":""},null,null,{"$f":"IF(TRIM(M23)=\"\", \"\", IF(VLOOKUP(M23,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M23,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O21:O22)<2,\"\",SUM(O21,O22))","v":""},null,null,{"$f":"IF(TRIM(Q23)=\"\", \"\", IF(VLOOKUP(Q23,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q23,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S21:S22)<2,\"\",SUM(S21,S22))","v":""},null,null,{"$f":"IF(TRIM(U23)=\"\", \"\", IF(VLOOKUP(U23,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U23,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W21,W22))=\"\",\"\",SUM(W21,W22))","v":""},null,null,{"$f":"IF(TRIM(Y23)=\"\", \"\", IF(VLOOKUP(Y23,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y23,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0401",null,null,"4.1 Broadleaved deciduous forest ",null,null,null,{"$f":"IF(TRIM(I24)=\"\", \"\", IF(VLOOKUP(I24,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I24,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M24)=\"\", \"\", IF(VLOOKUP(M24,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M24,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q24)=\"\", \"\", IF(VLOOKUP(Q24,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q24,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U24)=\"\", \"\", IF(VLOOKUP(U24,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U24,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K24,O24))=\"\",\"\",K24-O24)","v":""},null,null,{"$f":"IF(TRIM(Y24)=\"\", \"\", IF(VLOOKUP(Y24,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y24,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0402",null,null,"4.2 Coniferous forests ",null,null,null,{"$f":"IF(TRIM(I25)=\"\", \"\", IF(VLOOKUP(I25,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I25,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M25)=\"\", \"\", IF(VLOOKUP(M25,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M25,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q25)=\"\", \"\", IF(VLOOKUP(Q25,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q25,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U25)=\"\", \"\", IF(VLOOKUP(U25,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U25,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K25,O25))=\"\",\"\",K25-O25)","v":""},null,null,{"$f":"IF(TRIM(Y25)=\"\", \"\", IF(VLOOKUP(Y25,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y25,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0403",null,null,"4.3 Broadleaved evergreen forest ",null,null,null,{"$f":"IF(TRIM(I26)=\"\", \"\", IF(VLOOKUP(I26,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I26,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M26)=\"\", \"\", IF(VLOOKUP(M26,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M26,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q26)=\"\", \"\", IF(VLOOKUP(Q26,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q26,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U26)=\"\", \"\", IF(VLOOKUP(U26,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U26,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y26)=\"\", \"\", IF(VLOOKUP(Y26,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y26,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0404",null,null,"4.4 Mixed forests ",null,null,null,{"$f":"IF(TRIM(I27)=\"\", \"\", IF(VLOOKUP(I27,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I27,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M27)=\"\", \"\", IF(VLOOKUP(M27,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M27,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q27)=\"\", \"\", IF(VLOOKUP(Q27,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q27,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U27)=\"\", \"\", IF(VLOOKUP(U27,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U27,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y27)=\"\", \"\", IF(VLOOKUP(Y27,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y27,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0405",null,null,"4.5 Transitional forest and woodland shrub",null,null,null,{"$f":"IF(TRIM(I28)=\"\", \"\", IF(VLOOKUP(I28,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I28,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M28)=\"\", \"\", IF(VLOOKUP(M28,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M28,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q28)=\"\", \"\", IF(VLOOKUP(Q28,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q28,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U28)=\"\", \"\", IF(VLOOKUP(U28,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U28,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y28)=\"\", \"\", IF(VLOOKUP(Y28,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y28,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0406",null,null,"4.6 Plantations",null,null,null,{"$f":"IF(TRIM(I29)=\"\", \"\", IF(VLOOKUP(I29,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I29,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M29)=\"\", \"\", IF(VLOOKUP(M29,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M29,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q29)=\"\", \"\", IF(VLOOKUP(Q29,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q29,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U29)=\"\", \"\", IF(VLOOKUP(U29,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U29,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y29)=\"\", \"\", IF(VLOOKUP(Y29,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y29,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO04",null,null,"4. Forest and woodlands",{"$f":"IF(COUNTA(G24:G29)<6,\"\",SUM(G24:G29))","v":""},null,null,{"$f":"IF(TRIM(I30)=\"\", \"\", IF(VLOOKUP(I30,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I30,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K24:K29)<6,\"\",SUM(K24:K29))","v":""},null,null,{"$f":"IF(TRIM(M30)=\"\", \"\", IF(VLOOKUP(M30,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M30,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O24:O29)<6,\"\",SUM(O24:O29))","v":""},null,null,{"$f":"IF(TRIM(Q30)=\"\", \"\", IF(VLOOKUP(Q30,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q30,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S24:S29)<6,\"\",SUM(S24:S29))","v":""},null,null,{"$f":"IF(TRIM(U30)=\"\", \"\", IF(VLOOKUP(U30,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U30,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W24,W29))=\"\",\"\",SUM(W24:W29))","v":""},null,null,{"$f":"IF(TRIM(Y30)=\"\", \"\", IF(VLOOKUP(Y30,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y30,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0501",null,null,"5.1 Tundra",null,null,null,{"$f":"IF(TRIM(I31)=\"\", \"\", IF(VLOOKUP(I31,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I31,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M31)=\"\", \"\", IF(VLOOKUP(M31,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M31,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q31)=\"\", \"\", IF(VLOOKUP(Q31,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q31,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U31)=\"\", \"\", IF(VLOOKUP(U31,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U31,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K31,O31))=\"\",\"\",K31-O31)","v":""},null,null,{"$f":"IF(TRIM(Y31)=\"\", \"\", IF(VLOOKUP(Y31,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y31,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0502",null,null,"5.2 Scrub and heathland",null,null,null,{"$f":"IF(TRIM(I32)=\"\", \"\", IF(VLOOKUP(I32,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I32,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M32)=\"\", \"\", IF(VLOOKUP(M32,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M32,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q32)=\"\", \"\", IF(VLOOKUP(Q32,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q32,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U32)=\"\", \"\", IF(VLOOKUP(U32,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U32,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K32,O32))=\"\",\"\",K32-O32)","v":""},null,null,{"$f":"IF(TRIM(Y32)=\"\", \"\", IF(VLOOKUP(Y32,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y32,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0503",null,null,"5.3 Sclerophyllous vegetation",null,null,null,{"$f":"IF(TRIM(I33)=\"\", \"\", IF(VLOOKUP(I33,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I33,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M33)=\"\", \"\", IF(VLOOKUP(M33,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M33,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q33)=\"\", \"\", IF(VLOOKUP(Q33,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q33,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U33)=\"\", \"\", IF(VLOOKUP(U33,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U33,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y33)=\"\", \"\", IF(VLOOKUP(Y33,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y33,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO05",null,null,"5. Heathlands and shrub",{"$f":"IF(COUNTA(G31:G33)<3,\"\",SUM(G31:G33))","v":""},null,null,{"$f":"IF(TRIM(I34)=\"\", \"\", IF(VLOOKUP(I34,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I34,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K31:K33)<3,\"\",SUM(K31:K33))","v":""},null,null,{"$f":"IF(TRIM(M34)=\"\", \"\", IF(VLOOKUP(M34,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M34,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O31:O33)<3,\"\",SUM(O31:O33))","v":""},null,null,{"$f":"IF(TRIM(Q34)=\"\", \"\", IF(VLOOKUP(Q34,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q34,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S31:S33)<3,\"\",SUM(S31:S33))","v":""},null,null,{"$f":"IF(TRIM(U34)=\"\", \"\", IF(VLOOKUP(U34,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U34,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W31,W33))=\"\",\"\",SUM(W31:W33))","v":""},null,null,{"$f":"IF(TRIM(Y34)=\"\", \"\", IF(VLOOKUP(Y34,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y34,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0601",null,null,"6.1 Bare rocks",null,null,null,{"$f":"IF(TRIM(I35)=\"\", \"\", IF(VLOOKUP(I35,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I35,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M35)=\"\", \"\", IF(VLOOKUP(M35,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M35,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q35)=\"\", \"\", IF(VLOOKUP(Q35,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q35,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U35)=\"\", \"\", IF(VLOOKUP(U35,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U35,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K35,O35))=\"\",\"\",K35-O35)","v":""},null,null,{"$f":"IF(TRIM(Y35)=\"\", \"\", IF(VLOOKUP(Y35,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y35,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0602",null,null,"6.2 Semi-desert, desert and other sparsely vegetated areas",null,null,null,{"$f":"IF(TRIM(I36)=\"\", \"\", IF(VLOOKUP(I36,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I36,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M36)=\"\", \"\", IF(VLOOKUP(M36,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M36,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q36)=\"\", \"\", IF(VLOOKUP(Q36,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q36,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U36)=\"\", \"\", IF(VLOOKUP(U36,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U36,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K36,O36))=\"\",\"\",K36-O36)","v":""},null,null,{"$f":"IF(TRIM(Y36)=\"\", \"\", IF(VLOOKUP(Y36,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y36,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0603",null,null,"6.3 Ice sheets, glaciers and perennial snowfields",null,null,null,{"$f":"IF(TRIM(I37)=\"\", \"\", IF(VLOOKUP(I37,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I37,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M37)=\"\", \"\", IF(VLOOKUP(M37,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M37,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q37)=\"\", \"\", IF(VLOOKUP(Q37,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q37,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U37)=\"\", \"\", IF(VLOOKUP(U37,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U37,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y37)=\"\", \"\", IF(VLOOKUP(Y37,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y37,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO06",null,null,"6. Sparsely vegetated ecosystems",{"$f":"IF(COUNTA(G35:G37)<3,\"\",SUM(G35:G37))","v":""},null,null,{"$f":"IF(TRIM(I38)=\"\", \"\", IF(VLOOKUP(I38,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I38,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K35:K37)<3,\"\",SUM(K35:K37))","v":""},null,null,{"$f":"IF(TRIM(M38)=\"\", \"\", IF(VLOOKUP(M38,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M38,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O35:O37)<3,\"\",SUM(O35:O37))","v":""},null,null,{"$f":"IF(TRIM(Q38)=\"\", \"\", IF(VLOOKUP(Q38,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q38,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S35:S37)<3,\"\",SUM(S35:S37))","v":""},null,null,{"$f":"IF(TRIM(U38)=\"\", \"\", IF(VLOOKUP(U38,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U38,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W35,W37))=\"\",\"\",SUM(W35:W37))","v":""},null,null,{"$f":"IF(TRIM(Y38)=\"\", \"\", IF(VLOOKUP(Y38,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y38,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0701",null,null,"7.1 Inland marshes and other wetlands on mineral soil",null,null,null,{"$f":"IF(TRIM(I39)=\"\", \"\", IF(VLOOKUP(I39,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I39,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M39)=\"\", \"\", IF(VLOOKUP(M39,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M39,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q39)=\"\", \"\", IF(VLOOKUP(Q39,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q39,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U39)=\"\", \"\", IF(VLOOKUP(U39,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U39,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K39,O39))=\"\",\"\",K39-O39)","v":""},null,null,{"$f":"IF(TRIM(Y39)=\"\", \"\", IF(VLOOKUP(Y39,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y39,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0702",null,null,"7.2 Mires, bogs and fens",null,null,null,{"$f":"IF(TRIM(I40)=\"\", \"\", IF(VLOOKUP(I40,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I40,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M40)=\"\", \"\", IF(VLOOKUP(M40,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M40,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q40)=\"\", \"\", IF(VLOOKUP(Q40,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q40,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U40)=\"\", \"\", IF(VLOOKUP(U40,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U40,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K40,O40))=\"\",\"\",K40-O40)","v":""},null,null,{"$f":"IF(TRIM(Y40)=\"\", \"\", IF(VLOOKUP(Y40,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y40,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO07",null,null,"7. Inland wetlands",{"$f":"IF(COUNTA(G39:G40)<2,\"\",SUM(G39,G40))","v":""},null,null,{"$f":"IF(TRIM(I41)=\"\", \"\", IF(VLOOKUP(I41,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I41,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K39:K40)<2,\"\",SUM(K39,K40))","v":""},null,null,{"$f":"IF(TRIM(M41)=\"\", \"\", IF(VLOOKUP(M41,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M41,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O39:O40)<2,\"\",SUM(O39,O40))","v":""},null,null,{"$f":"IF(TRIM(Q41)=\"\", \"\", IF(VLOOKUP(Q41,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q41,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S39:S40)<2,\"\",SUM(S39,S40))","v":""},null,null,{"$f":"IF(TRIM(U41)=\"\", \"\", IF(VLOOKUP(U41,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U41,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W39,W40))=\"\",\"\",SUM(W39,W40))","v":""},null,null,{"$f":"IF(TRIM(Y41)=\"\", \"\", IF(VLOOKUP(Y41,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y41,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0801",null,null,"8.1 Rivers and streams",null,null,null,{"$f":"IF(TRIM(I42)=\"\", \"\", IF(VLOOKUP(I42,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I42,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M42)=\"\", \"\", IF(VLOOKUP(M42,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M42,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q42)=\"\", \"\", IF(VLOOKUP(Q42,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q42,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U42)=\"\", \"\", IF(VLOOKUP(U42,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U42,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K42,O42))=\"\",\"\",K42-O42)","v":""},null,null,{"$f":"IF(TRIM(Y42)=\"\", \"\", IF(VLOOKUP(Y42,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y42,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0802",null,null,"8.2 Canals, ditches and drains",null,null,null,{"$f":"IF(TRIM(I43)=\"\", \"\", IF(VLOOKUP(I43,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I43,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M43)=\"\", \"\", IF(VLOOKUP(M43,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M43,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q43)=\"\", \"\", IF(VLOOKUP(Q43,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q43,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U43)=\"\", \"\", IF(VLOOKUP(U43,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U43,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K43,O43))=\"\",\"\",K43-O43)","v":""},null,null,{"$f":"IF(TRIM(Y43)=\"\", \"\", IF(VLOOKUP(Y43,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y43,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO08",null,null,"8. Rivers and canals",{"$f":"IF(COUNTA(G42:G43)<2,\"\",SUM(G42,G43))","v":""},null,null,{"$f":"IF(TRIM(I44)=\"\", \"\", IF(VLOOKUP(I44,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I44,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K42:K43)<2,\"\",SUM(K42,K43))","v":""},null,null,{"$f":"IF(TRIM(M44)=\"\", \"\", IF(VLOOKUP(M44,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M44,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O42:O43)<2,\"\",SUM(O42,O43))","v":""},null,null,{"$f":"IF(TRIM(Q44)=\"\", \"\", IF(VLOOKUP(Q44,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q44,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S42:S43)<2,\"\",SUM(S42,S43))","v":""},null,null,{"$f":"IF(TRIM(U44)=\"\", \"\", IF(VLOOKUP(U44,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U44,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W42,W43))=\"\",\"\",SUM(W42,W43))","v":""},null,null,{"$f":"IF(TRIM(Y44)=\"\", \"\", IF(VLOOKUP(Y44,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y44,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0901",null,null,"9.1 Lakes and ponds",null,null,null,{"$f":"IF(TRIM(I45)=\"\", \"\", IF(VLOOKUP(I45,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I45,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M45)=\"\", \"\", IF(VLOOKUP(M45,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M45,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q45)=\"\", \"\", IF(VLOOKUP(Q45,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q45,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U45)=\"\", \"\", IF(VLOOKUP(U45,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U45,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K45,O45))=\"\",\"\",K45-O45)","v":""},null,null,{"$f":"IF(TRIM(Y45)=\"\", \"\", IF(VLOOKUP(Y45,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y45,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0902",null,null,"9.2 Artificial reservoirs",null,null,null,{"$f":"IF(TRIM(I46)=\"\", \"\", IF(VLOOKUP(I46,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I46,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M46)=\"\", \"\", IF(VLOOKUP(M46,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M46,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q46)=\"\", \"\", IF(VLOOKUP(Q46,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q46,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U46)=\"\", \"\", IF(VLOOKUP(U46,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U46,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K46,O46))=\"\",\"\",K46-O46)","v":""},null,null,{"$f":"IF(TRIM(Y46)=\"\", \"\", IF(VLOOKUP(Y46,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y46,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO0903",null,null,"9.3 Geothermal pools and wetlands (Iceland)",null,null,null,{"$f":"IF(TRIM(I47)=\"\", \"\", IF(VLOOKUP(I47,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I47,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M47)=\"\", \"\", IF(VLOOKUP(M47,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M47,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q47)=\"\", \"\", IF(VLOOKUP(Q47,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q47,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U47)=\"\", \"\", IF(VLOOKUP(U47,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U47,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y47)=\"\", \"\", IF(VLOOKUP(Y47,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y47,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO09",null,null,"9. Lakes and reservoirs",{"$f":"IF(COUNTA(G45:G47)<3,\"\",SUM(G45:G47))","v":""},null,null,{"$f":"IF(TRIM(I48)=\"\", \"\", IF(VLOOKUP(I48,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I48,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K45:K47)<3,\"\",SUM(K45:K47))","v":""},null,null,{"$f":"IF(TRIM(M48)=\"\", \"\", IF(VLOOKUP(M48,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M48,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O45:O47)<3,\"\",SUM(O45:O47))","v":""},null,null,{"$f":"IF(TRIM(Q48)=\"\", \"\", IF(VLOOKUP(Q48,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q48,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S45:S47)<3,\"\",SUM(S45:S47))","v":""},null,null,{"$f":"IF(TRIM(U48)=\"\", \"\", IF(VLOOKUP(U48,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U48,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W45,W47))=\"\",\"\",SUM(W45:W47))","v":""},null,null,{"$f":"IF(TRIM(Y48)=\"\", \"\", IF(VLOOKUP(Y48,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y48,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1001",null,null,"10.1 Coastal lagoons",null,null,null,{"$f":"IF(TRIM(I49)=\"\", \"\", IF(VLOOKUP(I49,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I49,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M49)=\"\", \"\", IF(VLOOKUP(M49,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M49,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q49)=\"\", \"\", IF(VLOOKUP(Q49,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q49,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U49)=\"\", \"\", IF(VLOOKUP(U49,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U49,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K49,O49))=\"\",\"\",K49-O49)","v":""},null,null,{"$f":"IF(TRIM(Y49)=\"\", \"\", IF(VLOOKUP(Y49,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y49,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1002",null,null,"10.2 Estuaries and bays ",null,null,null,{"$f":"IF(TRIM(I50)=\"\", \"\", IF(VLOOKUP(I50,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I50,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M50)=\"\", \"\", IF(VLOOKUP(M50,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M50,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q50)=\"\", \"\", IF(VLOOKUP(Q50,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q50,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U50)=\"\", \"\", IF(VLOOKUP(U50,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U50,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K50,O50))=\"\",\"\",K50-O50)","v":""},null,null,{"$f":"IF(TRIM(Y50)=\"\", \"\", IF(VLOOKUP(Y50,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y50,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1003",null,null,"10.3 Intertidal flats",null,null,null,{"$f":"IF(TRIM(I51)=\"\", \"\", IF(VLOOKUP(I51,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I51,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M51)=\"\", \"\", IF(VLOOKUP(M51,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M51,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q51)=\"\", \"\", IF(VLOOKUP(Q51,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q51,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U51)=\"\", \"\", IF(VLOOKUP(U51,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U51,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y51)=\"\", \"\", IF(VLOOKUP(Y51,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y51,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO10",null,null,"10. Marine inlets and transitional waters",{"$f":"IF(COUNTA(G49:G51)<3,\"\",SUM(G49:G51))","v":""},null,null,{"$f":"IF(TRIM(I52)=\"\", \"\", IF(VLOOKUP(I52,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I52,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K49:K51)<3,\"\",SUM(K49:K51))","v":""},null,null,{"$f":"IF(TRIM(M52)=\"\", \"\", IF(VLOOKUP(M52,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M52,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O49:O51)<3,\"\",SUM(O49:O51))","v":""},null,null,{"$f":"IF(TRIM(Q52)=\"\", \"\", IF(VLOOKUP(Q52,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q52,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S49:S51)<3,\"\",SUM(S49:S51))","v":""},null,null,{"$f":"IF(TRIM(U52)=\"\", \"\", IF(VLOOKUP(U52,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U52,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W49,W51))=\"\",\"\",SUM(W49:W51))","v":""},null,null,{"$f":"IF(TRIM(Y52)=\"\", \"\", IF(VLOOKUP(Y52,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y52,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1101",null,null,"11.1 Artificial shorelines ",null,null,null,{"$f":"IF(TRIM(I53)=\"\", \"\", IF(VLOOKUP(I53,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I53,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M53)=\"\", \"\", IF(VLOOKUP(M53,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M53,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q53)=\"\", \"\", IF(VLOOKUP(Q53,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q53,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U53)=\"\", \"\", IF(VLOOKUP(U53,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U53,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K53,O53))=\"\",\"\",K53-O53)","v":""},null,null,{"$f":"IF(TRIM(Y53)=\"\", \"\", IF(VLOOKUP(Y53,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y53,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1102",null,null,"11.2 Coastal dunes, beaches and sandy and muddy shores",null,null,null,{"$f":"IF(TRIM(I54)=\"\", \"\", IF(VLOOKUP(I54,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I54,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M54)=\"\", \"\", IF(VLOOKUP(M54,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M54,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q54)=\"\", \"\", IF(VLOOKUP(Q54,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q54,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U54)=\"\", \"\", IF(VLOOKUP(U54,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U54,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K54,O54))=\"\",\"\",K54-O54)","v":""},null,null,{"$f":"IF(TRIM(Y54)=\"\", \"\", IF(VLOOKUP(Y54,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y54,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1103",null,null,"11.3 Rocky shores",null,null,null,{"$f":"IF(TRIM(I55)=\"\", \"\", IF(VLOOKUP(I55,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I55,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M55)=\"\", \"\", IF(VLOOKUP(M55,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M55,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q55)=\"\", \"\", IF(VLOOKUP(Q55,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q55,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U55)=\"\", \"\", IF(VLOOKUP(U55,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U55,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y55)=\"\", \"\", IF(VLOOKUP(Y55,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y55,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1104",null,null,"11.4 Coastal saltmarshes and salines",null,null,null,{"$f":"IF(TRIM(I56)=\"\", \"\", IF(VLOOKUP(I56,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I56,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M56)=\"\", \"\", IF(VLOOKUP(M56,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M56,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q56)=\"\", \"\", IF(VLOOKUP(Q56,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q56,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U56)=\"\", \"\", IF(VLOOKUP(U56,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U56,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y56)=\"\", \"\", IF(VLOOKUP(Y56,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y56,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO11",null,null,"11. Coastal beaches,  dunes and wetlands",{"$f":"IF(COUNTA(G53:G56)<4,\"\",SUM(G53:G56))","v":""},null,null,{"$f":"IF(TRIM(I57)=\"\", \"\", IF(VLOOKUP(I57,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I57,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K53:K56)<4,\"\",SUM(K53:K56))","v":""},null,null,{"$f":"IF(TRIM(M57)=\"\", \"\", IF(VLOOKUP(M57,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M57,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O53:O56)<4,\"\",SUM(O53:O56))","v":""},null,null,{"$f":"IF(TRIM(Q57)=\"\", \"\", IF(VLOOKUP(Q57,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q57,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S53:S56)<4,\"\",SUM(S53:S56))","v":""},null,null,{"$f":"IF(TRIM(U57)=\"\", \"\", IF(VLOOKUP(U57,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U57,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W53,W56))=\"\",\"\",SUM(W53:W56))","v":""},null,null,{"$f":"IF(TRIM(Y57)=\"\", \"\", IF(VLOOKUP(Y57,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y57,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1201",null,null,"12.1 Marine macrophyte habitats",null,null,null,{"$f":"IF(TRIM(I58)=\"\", \"\", IF(VLOOKUP(I58,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I58,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M58)=\"\", \"\", IF(VLOOKUP(M58,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M58,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q58)=\"\", \"\", IF(VLOOKUP(Q58,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q58,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U58)=\"\", \"\", IF(VLOOKUP(U58,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U58,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(K58,O58))=\"\",\"\",K58-O58)","v":""},null,null,{"$f":"IF(TRIM(Y58)=\"\", \"\", IF(VLOOKUP(Y58,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y58,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1202",null,null,"12.2 Coral reefs ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TRIM(CONCATENATE(K59,O59))=\"\",\"\",K59-O59)","v":""}]
[null,null,"ECO1203",null,null,"12.3 Worm reefs",null,null,null,{"$f":"IF(TRIM(I60)=\"\", \"\", IF(VLOOKUP(I60,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I60,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M60)=\"\", \"\", IF(VLOOKUP(M60,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M60,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q60)=\"\", \"\", IF(VLOOKUP(Q60,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q60,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U60)=\"\", \"\", IF(VLOOKUP(U60,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U60,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y60)=\"\", \"\", IF(VLOOKUP(Y60,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y60,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1204",null,null,"12.4 Shellfish beds and reefs",null,null,null,{"$f":"IF(TRIM(I61)=\"\", \"\", IF(VLOOKUP(I61,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I61,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M61)=\"\", \"\", IF(VLOOKUP(M61,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M61,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q61)=\"\", \"\", IF(VLOOKUP(Q61,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q61,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U61)=\"\", \"\", IF(VLOOKUP(U61,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U61,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y61)=\"\", \"\", IF(VLOOKUP(Y61,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y61,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1205",null,null,"12.5 Subtidal sand beds and mud plains",null,null,null,{"$f":"IF(TRIM(I62)=\"\", \"\", IF(VLOOKUP(I62,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I62,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M62)=\"\", \"\", IF(VLOOKUP(M62,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M62,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q62)=\"\", \"\", IF(VLOOKUP(Q62,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q62,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U62)=\"\", \"\", IF(VLOOKUP(U62,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U62,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y62)=\"\", \"\", IF(VLOOKUP(Y62,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y62,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1206",null,null,"12.6 Subtidal rocky substrates",null,null,null,{"$f":"IF(TRIM(I63)=\"\", \"\", IF(VLOOKUP(I63,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I63,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M63)=\"\", \"\", IF(VLOOKUP(M63,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M63,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q63)=\"\", \"\", IF(VLOOKUP(Q63,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q63,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U63)=\"\", \"\", IF(VLOOKUP(U63,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U63,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y63)=\"\", \"\", IF(VLOOKUP(Y63,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y63,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1207",null,null,"12.7 Continental and island slopes",null,null,null,{"$f":"IF(TRIM(I64)=\"\", \"\", IF(VLOOKUP(I64,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I64,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M64)=\"\", \"\", IF(VLOOKUP(M64,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M64,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q64)=\"\", \"\", IF(VLOOKUP(Q64,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q64,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U64)=\"\", \"\", IF(VLOOKUP(U64,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U64,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y64)=\"\", \"\", IF(VLOOKUP(Y64,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y64,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1208",null,null,"12.8 Deepwater benthic and pelagic ecosystems",null,null,null,{"$f":"IF(TRIM(I65)=\"\", \"\", IF(VLOOKUP(I65,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I65,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M65)=\"\", \"\", IF(VLOOKUP(M65,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M65,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q65)=\"\", \"\", IF(VLOOKUP(Q65,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q65,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U65)=\"\", \"\", IF(VLOOKUP(U65,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U65,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y65)=\"\", \"\", IF(VLOOKUP(Y65,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y65,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO1209",null,null,"12.9 Deepwater coastal inlets (fjords)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"ECO1210",null,null,"12.10 Sea ice",null,null,null,{"$f":"IF(TRIM(I67)=\"\", \"\", IF(VLOOKUP(I67,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I67,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(M67)=\"\", \"\", IF(VLOOKUP(M67,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M67,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Q67)=\"\", \"\", IF(VLOOKUP(Q67,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q67,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(U67)=\"\", \"\", IF(VLOOKUP(U67,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U67,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},"",null,null,{"$f":"IF(TRIM(Y67)=\"\", \"\", IF(VLOOKUP(Y67,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y67,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"ECO12",null,null,"12. Marine ecosystems ",{"$f":"IF(COUNTA(G58:G67)<10,\"\",SUM(G58:G67))","v":""},null,null,{"$f":"IF(TRIM(I68)=\"\", \"\", IF(VLOOKUP(I68,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I68,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(K58:K67)<10,\"\",SUM(K58:K67))","v":""},null,null,{"$f":"IF(TRIM(M68)=\"\", \"\", IF(VLOOKUP(M68,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M68,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(O58:O67)<10,\"\",SUM(O58:O67))","v":""},null,null,{"$f":"IF(TRIM(Q68)=\"\", \"\", IF(VLOOKUP(Q68,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q68,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNTA(S58:S67)<10,\"\",SUM(S58:S67))","v":""},null,null,{"$f":"IF(TRIM(U68)=\"\", \"\", IF(VLOOKUP(U68,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U68,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(TRIM(CONCATENATE(W58,W67))=\"\",\"\",SUM(W58:W67))","v":""},null,null,{"$f":"IF(TRIM(Y68)=\"\", \"\", IF(VLOOKUP(Y68,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y68,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[null,null,"TOTAL",null,null,"TOTAL",{"$f":"IF(COUNT(G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68)<12,\"\",SUM(G13+G20+G23+G30+G34+G38+G41+G44+G48+G52+G57+G68))","v":""},null,null,{"$f":"IF(TRIM(I69)=\"\", \"\", IF(VLOOKUP(I69,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(I69,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(K13,K20,K23,K30,K34,K38,K41,K44,K48,K52,K57,K68)<12,\"\",SUM(K13+K20+K23+K30+K34+K38+K41+K44+K48+K52+K57+K68))","v":""},null,null,{"$f":"IF(TRIM(M69)=\"\", \"\", IF(VLOOKUP(M69,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(M69,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(O13,O20,O23,O30,O34,O38,O41,O44,O48,O52,O57,O68)<12,\"\",SUM(O13+O20+O23+O30+O34+O38+O41+O44+O48+O52+O57+O68))","v":""},null,null,{"$f":"IF(TRIM(Q69)=\"\", \"\", IF(VLOOKUP(Q69,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Q69,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},{"$f":"IF(COUNT(S13,S20,S23,S30,S34,S38,S41,S44,S48,S52,S57,S68)<12,\"\",SUM(S13+S20+S23+S30+S34+S38+S41+S44+S48+S52+S57+S68))","v":""},null,null,{"$f":"IF(TRIM(U69)=\"\", \"\", IF(VLOOKUP(U69,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(U69,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""},null,null,null,{"$f":"IF(TRIM(Y69)=\"\", \"\", IF(VLOOKUP(Y69,'Footnotes list'!$D$9:$E$107,2,FALSE)=0,\"\",VLOOKUP(Y69,'Footnotes list'!$D$9:$E$107,2,FALSE) ) )","v":""}]
[]
[null,null,null,null,null,"STK_FLOW","STK_OP",null,null,null,"INCR",null,null,null,"DECR",null,null,null,"STK_CL",null,null,null,"STK_CHG"]
[]
[]
[]
[null,null,null,null,null,"Cell shading:"]
[null,null,null,null,null,"Light blue (cyan): Lower priority data."]
[null,null,null,null,null,"Light grey: Priority data. The calculation of data is automatic when lower priority data are provided. These cells can be edited after unlocking the cell with the button \"Unlock formulas\"."]
[null,null,null,null,null,"Dark grey: The calculation is automatic when data are provided. These cells cannot be unlocked and  edited."]
[null,null,null,null,null,"Light orange: footnotes (only to be filled in when relevant)"]

{"sheet":"Table 2 (Conversion matrix)","index":5,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,4,1,18],[8,18,9,18],[6,6,6,18],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[28,4,28,5],[30,4,30,5],[29,4,29,5],[8,10,9,10],[8,11,9,11],[9,4,9,5]]}
[]
[null,null,"previous_time\n(PROPERTY) =>>",{"$f":"IF('GETTING STARTED'!E11=\"\",\"\",'GETTING STARTED'!E11)","v":""},"Table 2 - Conversion matrix\n(a) Area in ha"]
[null,null,"GEO =>",{"$f":"'GETTING STARTED'!G9","v":""},{"$f":"IF('GETTING STARTED'!E9=\"\",\"\",'GETTING STARTED'!E9)","v":""}]
[null,null,"TIME=>",{"$f":"IF('GETTING STARTED'!E10=\"\",\"\",'GETTING STARTED'!E10)","v":""},{"$f":" \"Reference year: \" &D4","v":"Reference year: "}]
[null,null,"UNIT=>","HA",{"$f":" \"(Previous reference year: \" & 'GETTING STARTED'!$E$11 & \")\"","v":"(Previous reference year: )"}]
[null,null,"STK_FLOW=>","STK_CHG"]
[null,null,null,null,null,null,"… TO ECOSYSTEM"]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,null,"ECOSYST",null,null,null,"Settlements and other artificial areas","Cropland","Grassland ","Forest and woodland","Heathland and shrub","Sparsely vegetated ecosystems","Inland wetlands","Rivers and canals","Lakes and reservoirs","Marine inlets and transitional waters","Coastal beaches, dunes and wetlands","Marine ecosystems ","TOTAL\nREDUCTIONS"]
[null,null,null,null,"FROM ECOSYSTEM…"]
[null,null,"ECO01",null,1,"Settlements and other artificial areas","@",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(G11:R11))=0,\"\",SUM(G11:R11))","v":""}]
[null,null,"ECO02",null,2,"Cropland",null,"@",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(G12:R12))=0,\"\",SUM(G12:R12))","v":""}]
[null,null,"ECO03",null,3,"Grassland (pastures, semi-natural and natural grasslands)",null,null,"@",null,null,null,null,null,null,null,null,null,""]
[null,null,"ECO04",null,4,"Forest and woodland",null,null,null,"@",null,null,null,null,null,null,null,null,""]
[null,null,"ECO05",null,5,"Heathland and shrub",null,null,null,null,"@",null,null,null,null,null,null,null,""]
[null,null,"ECO06",null,6,"Sparsely vegetated ecosystems",null,null,null,null,null,"@",null,null,null,null,null,null,""]
[null,null,"ECO07",null,7,"Inland wetlands",null,null,null,null,null,null,"@",null,null,null,null,null,""]
[null,null,"ECO08",null,8,"Rivers and canals",null,null,null,null,null,null,null,"@",null,null,null,null,""]
[null,null,"ECO09",null,9,"Lakes and reservoirs",null,null,null,null,null,null,null,null,"@",null,null,null,""]
[null,null,"ECO10",null,10,"Marine inlets and transitional waters",null,null,null,null,null,null,null,null,null,"@",null,null,""]
[null,null,"ECO11",null,11,"Coastal beaches, dunes and wetlands",null,null,null,null,null,null,null,null,null,null,"@",null,""]
[null,null,"ECO12",null,12,"Marine ecosystems (coastal waters, shelf and open ocean)",null,null,null,null,null,null,null,null,null,null,null,"@",""]
[null,null,"TOTAL",null,null,"TOTAL ADDITIONS",{"$f":"IF(COUNT(G11:G22)=0,\"\",SUM(G11:G22))","v":""},{"$f":"IF(COUNT(H11:H22)=0,\"\",SUM(H11:H22))","v":""},"","","","","","","","","","",{"$f":"SUM(G23:R23)-SUM(S11:S22)","v":0}]
[]
[null,null,null,null,null,"ECOSYST_C","ECO01","ECO02","ECO03","ECO04","ECO05","ECO06","ECO07","ECO08","ECO09","ECO10","ECO11","ECO12","TOTAL"]
[]
[]
[null,null,null,null,"Cell shading:"]
[null,null,null,null,"White: Priority data."]
[null,null,null,null,"Dark grey: The calculation is automatic when data are provided. These cells cannot be unlocked and edited."]
[null,null,null,null,"Black: Not applicable."]

{"sheet":"Lists","index":6,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,9,1,10],[5,9,5,10],[10,9,10,10],[15,9,15,10]]}
["Country label","Country code","Currency","Valid flags (obs_status)","Label",null,"Valid flags (obs_conf)","Label",null,"Textual variables","String"]
["Belgium","BE","EUR","B","break in time series",null,"C","confidential",null,"Institutional names"]
["Bulgaria","BG","BGN","E","estimated data",null,"D","secondary confidentiality set by the sender",null,"Eurostat Text","Statistical Office of the European Union"]
["Czechia","CZ","CZK","P","provisional",null,null,null,null,"Directorate Text","Directorate E: Sectoral and regional statistics"]
["Denmark","DK","DKK","BE",null,null,null,null,null,"Unit Text","Unit E-2: Environmental statistics and accounts; sustainable development"]
["Germany","DE","EUR","BP",null,null,null,null,null,"Data collection information"]
["Estonia","EE","EUR","EP",null,null,null,null,null,"Data Collection Title","Ecosystem Extent Accounts"]
["Ireland","IE","EUR","BEP",null,null,null,null,null,"Data Collection Year",2023]
["Greece","EL","EUR",null,null,null,null,null,null,"Launching date","19 December 2023"]
["Spain","ES","EUR",null,null,null,null,null,null,"Submission deadline","30 April 2024"]
["France","FR","EUR",null,null,null,null,null,null,"EDAMIS data"]
["Croatia","HR","EUR",null,null,null,null,null,null,"Domain name","ENVDATA"]
["Italy","IT","EUR",null,null,null,null,null,null,"Dataset name","ENVDATA_ECOEXT_3"]
["Cyprus","CY","EUR",null,null,null,null,null,null,"Web page","https://cros-legacy.ec.europa.eu/content/edamis-general_en"]
["Latvia","LV","EUR",null,null,null,null,null,null,"Functional e-mail","ESTAT-DATA-METADATA-SERVICES@ec.europa.eu"]
["Lithuania","LT","EUR",null,null,null,null,null,null,"E2 information"]
["Luxembourg","LU","EUR",null,null,null,null,null,null,"Telephone","(+352) 4301 33213"]
["Hungary","HU","HUF",null,null,null,null,null,null,"Contact","ESTAT-ECOSYSTEMS@EC.EUROPA.EU"]
["Malta","MT","EUR",null,null,null,null,null,null,"Methodology URL","https://ec.europa.eu/eurostat/web/environment/methodology "]
["Netherlands","NL","EUR",null,null,null,null,null,null,"Legislation URL","NA"]
["Austria","AT","EUR"]
["Poland","PL","PLN"]
["Portugal","PT","EUR"]
["Romania","RO","RON"]
["Slovenia","SI","EUR"]
["Slovakia","SK","EUR"]
["Finland","FI","EUR"]
["Sweden","SE","SEK"]
["United Kingdom","UK","GBP"]
["Iceland","IS","ISK"]
["Liechtenstein","LI","CHF"]
["Norway","NO","NOK"]
["Switzerland","CH","CHF"]
["Montenegro","ME","EUR"]
["North Macedonia","MK","MKD"]
["Albania","AL","ALL"]
["Serbia","RS","RSD"]
["Turkey","TR","TRY"]
["Bosnia and Herzegovina","BA","BAM"]
["Kosovo (UNSCR 1244)","XK","EUR"]
[]
["TEST","CDD"]

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

{"sheet":"ErrorLog","index":8,"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":"Locks","index":9,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Sheet Name","Top Left Cell","Bottom Right Cell","Row Step","Column Step","Lock Type","Focus Back To"]
["Table 1 (Level 1 + 2)","G13","S13",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G20","S20",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G23","S23",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G30","S30",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G34","S34",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G38","S38",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G41","S41",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G44","S44",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G48","S48",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G52","S52",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G57","S57",999,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","G68","S69",1,4,"Formulas","G8"]
["Table 1 (Level 1 + 2)","W8","W69",1,999,"Formulas","G8"]

{"sheet":"MustNotBeNegative","index":10,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 (Level 1 + 2)","G8","S69",1,4]
["Error","Table 2 (Conversion matrix)","H11","S11",999,1]
["Error","Table 2 (Conversion matrix)","I12","S12",999,1]
["Error","Table 2 (Conversion matrix)","J13","S13",999,1]
["Error","Table 2 (Conversion matrix)","K14","S14",999,1]
["Error","Table 2 (Conversion matrix)","L15","S15",999,1]
["Error","Table 2 (Conversion matrix)","M16","S16",999,1]
["Error","Table 2 (Conversion matrix)","N17","S17",999,1]
["Error","Table 2 (Conversion matrix)","O18","S18",999,1]
["Error","Table 2 (Conversion matrix)","P19","S19",999,1]
["Error","Table 2 (Conversion matrix)","Q20","S20",999,1]
["Error","Table 2 (Conversion matrix)","R21","S21",999,1]
["Error","Table 2 (Conversion matrix)","G12","G12",999,999]
["Error","Table 2 (Conversion matrix)","G13","H13",999,1]
["Error","Table 2 (Conversion matrix)","G14","I14",999,1]
["Error","Table 2 (Conversion matrix)","G15","J15",999,1]
["Error","Table 2 (Conversion matrix)","G16","K16",999,1]
["Error","Table 2 (Conversion matrix)","G17","L17",999,1]
["Error","Table 2 (Conversion matrix)","G18","M18",999,1]
["Error","Table 2 (Conversion matrix)","G19","N19",999,1]
["Error","Table 2 (Conversion matrix)","G20","O20",999,1]
["Error","Table 2 (Conversion matrix)","G21","P21",999,1]
["Error","Table 2 (Conversion matrix)","G22","Q22",999,1]
["Error","Table 2 (Conversion matrix)","G23","S23",999,1]

{"sheet":"IsNumeric","index":11,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Severity","SheetName","TopLeftCell","BottomRightCell","RowStep","ColumnStep"]
["Error","Table 1 (Level 1 + 2)","G8","W69",1,4]
["Error","Table 2 (Conversion matrix)","H11","S11",999,1]
["Error","Table 2 (Conversion matrix)","I12","S12",999,1]
["Error","Table 2 (Conversion matrix)","J13","S13",999,1]
["Error","Table 2 (Conversion matrix)","K14","S14",999,1]
["Error","Table 2 (Conversion matrix)","L15","S15",999,1]
["Error","Table 2 (Conversion matrix)","M16","S16",999,1]
["Error","Table 2 (Conversion matrix)","N17","S17",999,1]
["Error","Table 2 (Conversion matrix)","O18","S18",999,1]
["Error","Table 2 (Conversion matrix)","P19","S19",999,1]
["Error","Table 2 (Conversion matrix)","Q20","S20",999,1]
["Error","Table 2 (Conversion matrix)","R21","S21",999,1]
["Error","Table 2 (Conversion matrix)","G12","G12",999,999]
["Error","Table 2 (Conversion matrix)","G13","H13",999,1]
["Error","Table 2 (Conversion matrix)","G14","I14",999,1]
["Error","Table 2 (Conversion matrix)","G15","J15",999,1]
["Error","Table 2 (Conversion matrix)","G16","K16",999,1]
["Error","Table 2 (Conversion matrix)","G17","L17",999,1]
["Error","Table 2 (Conversion matrix)","G18","M18",999,1]
["Error","Table 2 (Conversion matrix)","G19","N19",999,1]
["Error","Table 2 (Conversion matrix)","G20","O20",999,1]
["Error","Table 2 (Conversion matrix)","G21","P21",999,1]
["Error","Table 2 (Conversion matrix)","G22","Q22",999,1]
["Error","Table 2 (Conversion matrix)","G23","S23",999,1]

{"sheet":"Summations","index":12,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":true,"merged":[[24,5,24,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","Table 1 (Level 1 + 2)","G8,G9,G10,G11,G12","G13","W13",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G14,G15,G16,G17,G18,G19","G20","W20",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G21,G22","G23","W23",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 3"]
["Error","Table 1 (Level 1 + 2)","G24,G25,G26,G27,G28,G29","G30","W30",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 4"]
["Error","Table 1 (Level 1 + 2)","G31,G32,G33","G34","W38",4,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 5"]
["Error","Table 1 (Level 1 + 2)","G39,G40","G41","W44",3,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 6"]
["Error","Table 1 (Level 1 + 2)","G45,G46,G47","G48","W52",4,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 7"]
["Error","Table 1 (Level 1 + 2)","G53,G54,G55,G56","G57","W57",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 8"]
["Error","Table 1 (Level 1 + 2)","G58,G59,G60,G61,G62,G63,G64,G65,G66,G67","G68","W58",999,4,"EQ",0.1,"YES","NO",3,"Total ecosystems at level 1 must be equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68","G69","W69",999,4,"EQ",0.1,"YES","NO",3,"TOTAL must be the sum of all 12 ecosystem type"]
["Error","Table 1 (Level 1 + 2)","G8,G9,G10,G11,G12","G13","W13",999,4,"GE",0.1,"NO","YES",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G14,G15,G16,G17,G18,G19","G20","W20",999,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G21,G22","G23","W23",999,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 2"]
["Error","Table 1 (Level 1 + 2)","G24,G25,G26,G27,G28,G29","G30","W30",999,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 3"]
["Error","Table 1 (Level 1 + 2)","G31,G32,G33","G34","W38",4,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 4"]
["Error","Table 1 (Level 1 + 2)","G39,G40","G41","W44",3,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 5"]
["Error","Table 1 (Level 1 + 2)","G45,G46,G47","G48","W52",4,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 6"]
["Error","Table 1 (Level 1 + 2)","G53,G54,G55,G56","G57","W57",999,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 7"]
["Error","Table 1 (Level 1 + 2)","G58,G59,G60,G61,G62,G63,G64,G65,G66,G67","G68","W58",999,4,"GE",0.1,"NO","NO",3,"Total ecosystems at level 1 must be greater or equal to the sum of the subcomponents at level 8"]
["Error","Table 1 (Level 1 + 2)","G13,G20,G23,G30,G34,G38,G41,G44,G48,G52,G57,G68","G69","W69",999,4,"GE",0.1,"NO","NO",3,"TOTAL must be the sum of all 12 ecosystems"]
["Error","Table 2 (Conversion matrix)","G11,G12,G13,G14,G15,G16,G17,G18,G19,G20,G21,G22","G23","R23",999,4,"EQ",1,"NO","NO",3,"TOTAL ADDITIONS must be equal to the sum of additions"]
["Error","Table 2 (Conversion matrix)","G11,H11,I11,J11,K11,L11,M11,N11,O11,P11,Q11,R11","S11","S22",1,999,"EQ",1,"NO","NO",3,"TOTAL REDUCTIONS must be equal to the sum of reductions"]
[]
[null,null,null,null,null,"Must be > 0 for a not relevant dimension. Else you get an infinite loop",null,"EQ or GE or GT","GT does not admit Tolerance","NO or YES",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)"]

{"sheet":"xMandatory","index":13,"n_rows":24,"n_cols":9,"rows_kept":24,"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","E11",1,999,"NO",999]
["Error","GETTING STARTED","D15","D15",999,999,"NO",999]
["Error","GETTING STARTED","D23","D23",999,999,"NO",999]
["Warning","Table 1 (Level 1 + 2)","O10","O10",999,999,"YES",3]
[null,null,null,null,null,null,null,null,"TABEL !: ONLY LEVEL 1"]
[null,null,null,null,null,null,null,null,"TABLE 2: ALL CELLS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Warning","Table_1","AE16","AI18",1,4,"YES",3]
[]
[]
[]
["Warnings will become errors in 2022"]

{"sheet":"Table 3 (Level 3)","index":14,"n_rows":140,"n_cols":8,"rows_kept":140,"cut":false,"hidden":true,"merged":[[134,2,135,2],[98,0,103,0],[104,0,112,0],[113,0,114,0],[128,1,129,1],[130,1,131,1],[130,0,139,0],[134,1,135,1],[104,1,106,1],[107,1,112,1],[115,0,117,0],[118,0,121,0],[122,0,129,0],[123,1,125,1],[126,1,127,1],[50,0,58,0],[50,1,51,1],[52,1,58,1],[7,0,24,0],[7,1,8,1],[9,1,10,1],[11,1,17,1],[18,1,20,1],[21,1,24,1],[25,0,49,0],[25,1,34,1],[36,1,43,1],[44,1,45,1],[47,1,49,1],[59,0,89,0],[59,1,68,1],[69,1,77,1],[78,1,84,1],[85,1,87,1],[90,0,97,0],[91,1,93,1],[94,1,97,1],[98,1,99,1],[100,1,102,1]]}
["Table 3 - Ecosystem extent accounts level 3 only"]
["Reporting unit = ",null,null,"1000 ha"]
["Reference year ="]
["Previous reference year = "]
["Items in bold are mandatory to be reported."]
[]
["EU ecosystem typology: level 1 ","EU ecosystem typology: level 2","EU Ecosystem typology: level 3","Opening area (Extent in the previous reference year)","Additions","Reductions","Net changes (additions less reductions; +/-)","Closing area (Extent in the current reference year)"]
["1. Settlements and other artificial areas","1.1   Continuous settlement area","1.1.1 Continuous residential area"]
[null,null,"1.1.2 Continuous commercial and industrial area"]
[null,"1.2   Discontinuous settlement area","1.2.1 Discontinuous residential area"]
[null,null,"1.2.2 Discontinuous commercial and industrial area"]
[null,"1.3   Infrastructure ","1.3.1 Road and rail networks and associated land "]
[null,null,"1.3.2 Port areas "]
[null,null,"1.3.3 Airports"]
[null,null,"1.3.4 Other infrastructure (e.g. water purification plants, energy plants, transforming stations)."]
[null,null,"1.3.5 Mineral extraction sites (excluding peat extraction sites, see 7.3.1)"]
[null,null,"1.3.6 Dump areas"]
[null,null,"1.3.7 Construction sites"]
[null,"1.4   Urban greenspace","1.4.1 Parks (including Zoos and botanical gardens)"]
[null,null,"1.4.2 Sports and recreation sites"]
[null,null,"1.4.3 Other urban green  "]
[null,"1.5   Other artificial areas","1.5.1. Permanent greenhouses"]
[null,null,"1.5.2 Cemeteries"]
[null,null,"1.5.3 Archaeological sites"]
[null,null,"1.5.4 Urban blue"]
["2. Cropland","2.1 Annual cropland ","2.1.1 Cereals excluding rice (C1000) excluding maize (C1500)"]
[null,null,"2.1.2 Maize (C1500 + G3000)"]
[null,null,"2.1.3 Dry pulses and protein crops (P0000)"]
[null,null,"2.1.4 Root crops (R0000)"]
[null,null,"2.1.5 Vegetables (including melons) and strawberries (V0000_S0000)"]
[null,null,"2.1.6 Industrial crops including annual bioenergy crops (I0000)"]
[null,null,"2.1.7 Flowers and ornamental plants (N0000)"]
[null,null,"2.1.8 Fallow land (Q0000)"]
[null,null,"2.1.9 Temporary grasses and grazing areas (G1000)"]
[null,null,"2.1.10 Other crops (further categories may be added by Member States, depending upon nationally important crop types)."]
[null,"2.2 Rice fields","2.2.1 Rice fields (C2000)"]
[null,"2.3 Permanent crops","2.3.1 Olives (O1000)"]
[null,null,"2.3.2 Grapes (W1000)"]
[null,null,"2.3.3 Pome fruits (F1100) "]
[null,null,"2.3.4 Stone fruits (F1200)  "]
[null,null,"2.3.5 Berries excluding strawberries (F3000)"]
[null,null,"2.3.6 Citrus fruits (T1000)"]
[null,null,"2.3.7 Nuts (F4000)"]
[null,null,"2.3.8 Other perennial crops and orchards"]
[null,"2.4 Agro-forestry areas ","2.4.1 Holm and cork oak forests"]
[null,null,"2.4.2 Other agro-forestry areas"]
[null,"2.5 Mixed farmland","2.5.1 Mosaic farmland (comprising cropland, grassland and (semi-)natural components)"]
[null,"2.6 Other farmland","2.6.1 Nurseries"]
[null,null,"2.6.2 Christmas tree plantations"]
[null,null,"2.6.3 Perennial bioenergy crops"]
["3. Grassland (pastures, semi-natural and natural grasslands)","3.1 Sown pastures and fields (modified grasslands) ","3.1.1 Sown pastures used for grazing"]
[null,null,"3.1.2 Sown grassland mown frequently for fodder or silage"]
[null,"3.2 Natural and semi-natural grasslands ","3.2.1 Dry grasslands "]
[null,null,"3.2.2 Seasonally wet and wet grasslands"]
[null,null,"3.2.3 Alpine and subalpine grasslands"]
[null,null,"3.2.4 Woodland fringes and clearings and tall forb stands"]
[null,null,"3.2.5 Inland salt steppes"]
[null,null,"3.2.6 Sparsely wooded grasslands"]
[null,null,"3.2.7 Mesophilous extensive grassland"]
["4. Forest and woodlands ","4.1 Broadleaved deciduous forest ","4.1.1 Riparian forest and woodland"]
[null,null,"4.1.2 Broadleaved swamp woodland on non-acid and acid"]
[null,null,"peat"]
[null,null,"4.1.3 Fagus dominated forest"]
[null,null,"4.1.4 Submediterranean and Mediterranean thermophilous deciduous forest "]
[null,null,"4.1.5 Acidophilous [Quercus]-"]
[null,null,"dominated woodland"]
[null,null,"4.1.6 Temperate and boreal and Southern European Betula and Populus tremula forest on mineral soils "]
[null,null,"4.1.7 Other broadleaved deciduous forest, excluding highly-modified plantations"]
[null,null,"4.1.8 Highly modified broadleaved deciduous forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.2 Coniferous forests ","4.2.1 Boreal and temperate  fir and spruce forest"]
[null,null,"4.2.2 Mediterranean mountain fir and spruce forest"]
[null,null,"4.2.3 Temperate subalpine Larix, Pinus cembra and Pinus uncinata forest"]
[null,null,"4.2.4 Pine forest (excluding mires, non-thermophilous)"]
[null,null,"4.2.5 Mediterranean thermophilous lowland pine forest  "]
[null,null,"4.2.6 Spruce, pine and larch mire forest "]
[null,null,"4.2.7 Taiga forests"]
[null,null,"4.2.8 Other coniferous forests, excluding plantations"]
[null,null,"4.2.9 Highly modified coniferous forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.3 Broadleaved evergreen forest ","4.3.1 Mediterranean evergreen Quercus forest"]
[null,null,"4.3.2 Mainland laurophyllous forest"]
[null,null,"4.3.3 Macaronesian laurophyllous forest"]
[null,null,"4.3.4 Olea europaea-Ceratonia siliqua forest"]
[null,null,"4.3.5 Palm groves"]
[null,null,"4.3.6 Other broadleaved evergreen forests"]
[null,null,"4.3.7 Highly modified broadleaved evergreen forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.4 Mixed forests","4.4.1 Mixed forests dominated by coniferous species"]
[null,null,"4.4.2 Mixed forests dominated by broadleaved species"]
[null,null,"4.4.3 Other mixed forests including stands of non-native trees species that have long been established in European ecosystems stands"]
[null,"4.5 Transitional forest and woodland shrub ","4.5.1 Transitional woodland/forest land "]
[null,"4.6 Plantations","4.6.1 Monoculture plantations of non-native tree species (note: forest stands of single or mixed species consisting of native and/or non-native trees species that have long been established in European ecosystems and have diverse undergrowth typical for forest ecosystems should be classified as part of types 4.1 to 4.4)"]
["5. Heathland and shrub ","5.1 Tundra","5.1.1 Tundra"]
[null,"5.2 Heathland and (sub-) alpine shrub","5.2.1 Arctic alpine, subalpine and lowland shrub and heathland"]
[null,null,"5.2.2 Temperate and Mediterranean montane and hilly shrub and heathland"]
[null,null,"5.2.3 Temperate and Mediterranean lowland shrub and heathland"]
[null,"5.3 Sclerophyllous vegetation","5.3.1 Maquis, arborescent matorral and thermo-Mediterranean shrub;  "]
[null,null,"5.3.2 Garrigue; "]
[null,null,"5.3.3 Spiny Mediterranean heaths (phrygana, hedgehog-heaths & coastal cliff vegetation);"]
[null,null,"5.3.4 Thermo-Atlantic xerophytic shrub (Madeira and Canary Islands)"]
["6. Sparsely vegetated ecosystems","6.1 Bare rocks","6.1.1 Rocky pavements, outcrops, and screes "]
[null,null,"6.1.2 Lava flows"]
[null,"6.2 Semi-desert, desert and other sparsely vegetated areas","6.2.1 Semi-desert steppes "]
[null,null,"6.2.2 Cool deserts and semi-desert steppes "]
[null,null,"6.2.3 Other sparsely vegetated areas"]
[null,"6.3 Ice sheets, glaciers and perennial snowfields","6.3.1 Ice sheets, glaciers and perennial snowfields"]
["7. Inland wetlands ","7.1 Inland marshes on mineral soil","7.1.1 Reedbeds"]
[null,null,"7.1.2 Inland salt marshes"]
[null,null,"7.1.3 Other marshland and water-fringing ecosystems"]
[null,"7.2 Mires, bogs and fens","7.2.1 Raised bogs "]
[null,null,"7.2.2 Blanket bogs"]
[null,null,"7.2.3 Valley mires, poor fens and transition mires "]
[null,null,"7.2.4 Aapa, palsa and polygon mires"]
[null,null,"7.2.5 Base-rich fens and calcareous spring mires"]
[null,null,"7.2.6 Peat extraction sites"]
["8. Rivers and canals","8.1 Rivers","8.1.1 Rivers"]
[null,"8.2 Canals, ditches and drains","8.2.1 Canals, ditches and drains"]
["9. Lakes and reservoirs","9.1 Lakes","9.1.1 Lakes"]
[null,"9.2 Artificial reservoirs","9.2.1 Artificial reservoirs"]
[null,"9.3 Geothermal pools and wetlands (Iceland)","9.3.1 Geothermal pools and wetlands (Iceland)"]
["10. Marine inlets and transitional waters ","10.1 Coastal lagoons","10.1.1 Coastal lagoons"]
[null,"10.2 Estuaries and bays ","10.2.1 Estuaries and bays "]
[null,"10.3 Intertidal flats","10.3.1 Intertidal flats (e.g., Wadden Sea)"]
[null,"10.4 Deepwater coastal inlets (fjords)","10.4.1 Deepwater coastal inlets (fjords)"]
["11. Coastal beaches, dunes and wetlands ","11.1 Artificial shorelines ","11.1.1 Artificial shorelines "]
[null,"11.2 Coastal dunes, beaches and sandy and muddy shores ","11.2.1 Coastal dunes"]
[null,null,"11.2.2 Beaches and sandy shores"]
[null,null,"11.2.3 Muddy shores"]
[null,"11.3 Rocky shores","11.3.1 Coastal shingle"]
[null,null,"11.3.2 Rock cliffs, ledges and shores"]
[null,"11.4 Coastal saltmarshes and salines","11.4.1 Coastal saltmarshes "]
[null,null,"11.4.2 Salines"]
["12. Marine ecosystems ","12.1 Marine macrophytes","12.1.1 Kelp forests"]
[null,null,"12.1.2 Seagrass meadows"]
[null,"12.2 Coral reefs ","12.2.1 Coral reefs "]
[null,"12.3 Shellfish beds and reefs","12.3.1 Shellfish beds and reefs"]
[null,"12.4 Subtidal sand beds and mud plains","12.4.1 Subtidal sand beds and mud plains"]
[]
[null,"12.5 Subtidal rocky substrates","12.5.1 Subtidal rocky substrates"]
[null,"12.6 Continental and island slopes","12.6.1 Continental and island slopes"]
[null,"12.7 Deepwater benthic and pelagic ecosystems","12.7.1 Deepwater benthic and pelagic ecosystems"]
[null,"12.8 Sea ice","12.8.1 Sea ice"]