{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Data Description","Report","TMF Data","THI & TRI","Metadata","LookupTables"],"not_rendered":{"images":3,"macros":1,"external_links":2,"defined_names":11,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":20,"n_cols":1,"rows_kept":20}
[]
["Safety of the Tailings Management Facilities"]
["Template for data collection and hazard&risk assessment"]
["This template was prepared to serve data collection for developing a database on tailings management facilities (TMFs). The database is suitable to further support the assessment of TMF hazard and risk by the method of Tailing Hazard Index (THI) and Tailings Risk Index (TRI), respectively. These methods are the integral part of the \"Methodology for Comprehensive Evaluation of Tailings Management Facilities Safety\" elaborated by the German Environment Agency (UBA) to support the implementation of the Safety Guidelines and Good Practices for Tailings Management Facilities developed by United Nations Economic Commission for Europe (UNECE). This template is designed to allow the calculation of the THI and TRI for TMFs at country/region/river basin scale, taking into account basic TMF data."]
["The first template version was developed by the International Commission for the Protection of the Danube River (ICPDR) to support regular data collection in the Danube River Basin. Later it was updated and extended in the frame of the project “Capacity development to improve safety conditions of tailings management facilities in the Danube River Basin – Phase I: North-Eastern Danube countries” (Reference number: Z6 - 90 213-51/79, Project number: 118221). The project was funded by the German Federal Environment Ministry’s Advisory Assistance Programme (AAP) for environmental protection in the countries of Central and Eastern Europe, the Caucasus and Central Asia and other countries neighbouring the European Union. It was supervised by the UBA and implemented by the ICPDR. Further information: https://www.umweltbundesamt.de/en/topics/sustainability-strategies-international/cooperation-eeca-centraleastern-european-states/project-database-advisory-assistance-programme/capacity-development-to-improve-safety-conditions"]
["Reporting requirements"]
["▪ Report only TMFs located in the specified national or regional territory.\n▪ Report only TMFs with a total used capacity larger than 1000 m³. Report both, industrial and mining TMFs.\n▪ You can only submit a dataset with all mandatory fields filled in, i.e. all cells in the Check column have to show \"complete\" (or \"empty\", but not \"incomplete\").\n▪ Please provide Metadata, general metadata elements are already prefilled. Mandatory metadata elements (with bold headings) have to be provided."]
["Instructions"]
["▪ The \"Data Description\" sheet provides explanations and examples for the fields on the sheets \"TMF Data\" and \"THI & TRI\".\n▪ An example dataset including three TMFs with complete data records are also provided. Please first delete these example data records before starting a new compilation.\n▪ Then specify your country or region in the sheet \"Report\".\n▪ Next, fill in the cells on the sheet \"TMF Data\" based on the information on TMFs in your country or region. Push the \"+10 Rows\" button accordingly to create the necessary number of new empty rows for the TMFs to be listed.\n▪ If two or more different tailings reservoirs (potentially having different waste type or containing different toxic substances) were identified at the same facility, a separate row in \"TMF Data\" sheet should be filled in for each reservoir. Duplication of the TMF codes is not allowed, each code has to be a unique identifier.\n▪ After filling in the sheet \"TMF Data\" please continue with the sheet \"THI & TRI\" to assess the accident hazard and risk for each listed TMF. \n▪ For your convenience, each record in the \"THI & TRI\" sheet automatically calculates the hazard and risk index parameters based on the records in the \"TMF Data\" sheet; each record in the \"THI & TRI\" sheet shows the linked TMF code and name.\n▪ Push the \"+10 Rows\" button accordingly to assess the TMFs listed on the sheet \"TMF Data\". Check that all TMFs listed on the sheet \"TMF Data\" are also listed on the sheet \"THI & TRI\".\n▪ Fields with bold headings are mandatory (m), others optional (o).\n▪ At fields with italic headings you can use only predefined values, please use the drop-down list to choose a valid option (other options are not allowed).\n▪ Fields with grey shading are automatically filled.\n▪ Create new table rows only by pressing the \"+10 Rows\" button. Remove all empty table rows by pressing the \"Purge\" button. For both functions, macros must be enabled (Press \"Enable content\" in the Security Warning).\n▪ If you copy data from the clipboard, please paste values only! Take care not to insert formatting or formulas!\n▪ The Metadata sheet uses values (longitude, latitude) of the TMF_Data sheet, as well as the file name of the worksheet.\n▪ You can save the filled template (=dataset) as macro-free (XLSX) or macro-enabled (XLSM) workbook.\n▪ The completeness is indicated in the check column of the template (\"empty\": no values are added, \"duplicate\": the same TMF code is used for more sites, \"incomplete\": some mandatory data are missing, \"complete\": all mandatory fields are filled in, ready for submission."]
["Further recommended resources"]
["▪ To find out coordinates, you can use http://www.gps-coordinates.net/: find the location on the map (you can search for a place by name) and press \"Get GPS coordinates\". The coordinates (latitude and longitude in decimal degrees) will appear on the map and in a box below."]
["▪ To find out the Water Hazard Class (WHC, in German: WGK) of a substance, please go to http://webrigoletto.uba.de/rigoletto/public/searchRequest.do?event=request and enter the substance name or CAS-number and submit the search. The WGK value in the search result is the Water Hazard Class."]
["▪ To find out the Reference Peak Ground Acceleration (PGA), please look at the Global Seismic Hazard Map Data of the German Research Centre for Geosciences at http://gmo.gfz-potsdam.de/pub/download_data/download_data_frame.html"]
["▪ To find out the Flood Hazard (HQ-500), please look at the Flood Hazard Map for Europe with 500-year return period of EU Joint Research Centre at https://data.jrc.ec.europa.eu/dataset/jrc-floods-floodmapgl_rp500y-tif"]
["▪ To find out the Factor of Safety calculated by the Shear-Friction method, please consult the publication \"Eurocode 7: Geotechnical Design Worked examples\" available at http://eurocodes.jrc.ec.europa.eu/doc/2013_06_WS_GEO/report/2013_06_WS_GEO.pdf"]
["▪ Detailed description of the THI and TRI methodologies can be found at https://www.umweltbundesamt.de/publikationen/safety-of-the-tailings-management-facilities-in-the"]
["Contact"]
["Adam Kovacs: adam.kovacs@icpdr.org"]
["Gerhard Winkelmann-Oei: gerhard.winkelmann-oei@uba.de"]
["© ICPDR & UBA"]

{"sheet":"Data Description","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"merged":[[0,6,0,7],[1,0,1,10],[4,0,4,10],[27,0,27,10]]}
["Attribute name","Description of the attribute","Obligation","Example value","Instructions","Field name","Field type",null,"Codelist or format","Linked table","Linked field"]
["Report"]
["Country name","Name of the country.","m","Romania",null,"COUNTRY_NAME","string","100"]
["Country code","Code of the country.","m","RO","Please use the ISO3166 country codes. ","COUNTRY","string","3"]
["TMF data"]
["Country code","Code of the country (automatically generated).","m","RO","Automatically filled from Report.","COUNTRY","string","3"]
["National TMF code","National unique code of the tailings management facility.","m","TMF1","Please use the national unique identifier for this TMF.","NATCD_TMF","string","50"]
["International TMF code","International code of the tailing management facility (automatically generated).","m","ROTMF1","Automatically generated.","INTCD_TMF","string","53","[COUNTRY] & [NATCD_TMF]"]
["TMF name","The locally used name of the tailing management facility, which may contain an abbreviated or coded name (or an acronym) used to identify the tailings owner.","m","Anonymus1",null,"NAME","string","100"]
["Nearest settlement","The nearest town or village where the site is located.","o","Settlement 2",null,"NEAR_SETTL","string","100"]
["Longitude","Longitude (decimal degree) that represents the TMF.","m",22.856297,null,"LONGITUDE","double","9,6"]
["Latitude","Latitude (decimal degree) that represents the TMF.","m",45.90065,null,"LATITUDE","double","9,6"]
["Location type","Indication if location (longitude and latitude) refers to the facility, nearest settlement or municipality (LAU 2).","m","facility","Please select an available value from the drop-down list.","LOC_TYPE","string",25,"Location Domain"]
["Used capacity (Mio m³)","The total amount of tailing materials in Million m³ stored in the facility.","m",{"v":5.1,"d":"5.100"},null,"USED_CAP","double","7,3"]
["Material category","The category of the tailings materials containing toxic substance(s) stored in the TMF.","m","red mud","Please select an available value from the drop-down list.","MAT_CAT","string","25","Material Domain"]
["Toxic substances","Name or symbolic name for chemical elements of the toxic substance(s) contained in the specified tailings materials (comma-separated).","o","Cyanides, Au, Cu",null,"TOXIC_SUBS","string","200"]
["Substance toxicity (WHC)","The class of toxicity of the substances in the stored tailings material is determined according to the Water Hazard Class (WHC) classification scheme of hazardous/dangerous substances: 0 = no hazard (\"nwg\"), 1 = low hazard, 2 = medium hazard, 3 = high hazard. For radioactive waste, the value of 4 is to be applied.","m",3,"Please select an available value from the drop-down list. If there are no data on the materials stored, their Hazard Class should be the possible maximum value. If the TMF contains a known material but with no additional information on its toxicity, Hazard Class is defined by accepting the typical value for this substance/material. If more toxic substances are in the tailings material, the highest Hazard Class of those substances should be applied. ","SUBS_TOX","integer","1","WHC Domain"]
["TMF status","The \"active\" TMF is under operation and cared by the operator. The \"closed\" TMF is not in operation but cared and maintained by the operator. The \"rehabilitated\" TMF is not in operation but restored to natural conditions. The \"abandoned\" TMF is an area formerly used for mine waste storage operations (an idle/inactive site) that is neglected.","m","closed","Please select an available value from the drop-down list.","TMF_STATUS","string",25,"Status Domain"]
["Flood occurence (HQ-500)","Defined as \"within HQ-500\" if the TMF site is located in a flood prone area with five-hundred-year return period flood event frequency (HQ-500) , or \"beyond HQ-500\" if the site is beyond the HQ-500 flood prone area borders.","m","within HQ-500","Please select an available value from the drop-down list.","FLOOD_OCC","string",10,"HQ-500 Domain"]
["Seismic activity (Reference PGA, m/s2)","The seismic activity is to be defined as either low or moderate/high, expressed by the reference peak ground acceleration (PGA) being below or above 1.0 m/s2, respectively.",null,"≤1","Please select an available value from the drop-down list.","SEISM_ACT","string",10,"PGA Domain"]
["Dam stability (FoS)","The dam stability is to be evaluated as either acceptable or unacceptable, expressed by the geotechnical criterion of Factor of Safety (Fos) being above or below 1.5, respectively.","m",">1.5","Please select an available value from the drop-down list.","DAM_STAB","string","10","FoS Domain"]
["Settlements at risk","Name of the settlements within 10 km zone downstream of the TMF that can be possibly affected by an accident.","o","Settlement 1, Settlement 2",null,"SETTL_10KM","string",200]
["Total Population at Risk","Total population of the settlements at risk.","m",33400,null,"TOT_PAR","integer","9"]
["Closest surface water body at risk","Name of the closest river or lake downstream of the TMF in 10 km zone that can be possibly affected by an accident.","o","River 1","In case there are more streams or lakes at similar distance from the TMF, the highest range value should be selected (see the next row).","WB_10KM","string","100"]
["Mean stream flow rate (m3/s) or Lake surface area (km2)","Mean flow rate range of the closest river at risk or surface area range of the closest lake at risk.","m","100-1000","Please select an available value from the drop-down list.","FLOW_AREA","string","25","SWB Domain"]
["Reference year","The year for which the data have been assessed.","m",2018,null,"REF_YEAR","integer","4"]
["Additional information","Additional important details that can be useful for determinining the accident hazard and risk of the TMF.","o","Under rehabilitation",null,"ADD_INFO","string","1000"]
["THI & TRI"]
["International TMF code","Reference to the facility via the International TMF code.","m","ROTMF1","Automatically displayed from TMF Data.","INTCD_TMF","string","52","[COUNTRY] & [NATCD_TMF]"]
["TMF name","Reference to the facility via the TMF name.","m","Anonymus1","Automatically displayed from TMF Data.","NAME","string","100"]
["Hazard index for capacity","It is the base 10 logarithm of the Used capacity.","m",{"v":6.707570176097937,"d":"6.7"},"Automatically calculated from TMF Data.","THI_CAP","double","2,1"]
["Hazard index for toxicity","The value is equal to the Water Hazard Class.","m",{"v":3,"d":"3.0"},"Automatically calculated from TMF Data.","THI_TOX","double","2,1"]
["Hazard index for management conditions","It is related to the TMF status and is 0 for \"rehabilitated\", 1 for \"closed\", 3 for \"active\" and 3 for \"abandoned\" sites.","m",{"v":1,"d":"1.0"},"Automatically calculated from TMF Data.","THI_MAN","double","2,1"]
["Hazard index for natural conditions","It combines the hazard index for flood probability and seismic conditions. The flood probability index is 0 if Flood occurence is \"beyond HQ-500\", 1 otherwise. The seismic conditions index is 0 if Seismic activity is \"≤1\", 1 otherwise. Thus, the Natural conditions index can be 0, 1 or 2.","m",{"v":1,"d":"1.0"},"Automatically calculated from TMF Data.","THI_NAT","double","2,1"]
["Hazard index for dam stability","It is related to the Dam stability and is 0 if FoS is \">1.5\", 1 otherwise.","m",{"v":0,"d":"0.0"},"Automatically calculated from TMF Data.","THI_DAM","double","2,1"]
["Tailings Hazard Index","Sum of the Hazard indexes for capacity, toxicity, management conditions, natural conditions and dam stability. Applied on logarithmic scale.","m",{"v":11.707570176097937,"d":"11.7"},"Automatically calculated.","THI ","double","3,1"]
["Exposure index for population","It is related to the Total Population at Risk and is 1 for PAR=0, 2 for PAR≤100, 3 for 100<PAR≤1000, 4 for 1000<PAR≤10000, 5 for 10000<PAR≤100000 and 6 for PAR≥100000.","m",{"v":5,"d":"5.0"},"Automatically calculated from TMF Data.","TEI_POP","double","2,1"]
["Exposure index for environment","It is related to the Main stream flow rate or Lake surface area and is 1 for \"no water body\", 2 for \"≤100\", 3 for \"100-1000\" and 4 for \">1000\" category.","m",{"v":3,"d":"3.0"},"Automatically calculated from TMF Data.","TEI_ENV","double","2,1"]
["Tailings Exposure Index","Sum of the Exposure indexes for population and environment. Applied on logarithmic scale.","m",{"v":8,"d":"8.0"},"Automatically calculated.","TEI","double","2,1"]
["Tailings Risk Index","Sum of the Tailings Hazard Index and the Tailings Exposure Index. Applied on logarithmic scale.","m",{"v":19.70757017609794,"d":"19.7"},"Automatically calculated.","TRI","double","3,1"]

{"sheet":"Report","index":2,"n_rows":3,"n_cols":3,"rows_kept":3}
[null,"Country name","Country code"]
["Check","COUNTRY_NAME","COUNTRY"]
[{"$f":"IF(OR(Table_Report[COUNTRY_NAME]=\"\",Table_Report[COUNTRY]=\"\"), \"incomplete\", \"complete\")","v":"complete"},"Romania","RO"]

{"sheet":"TMF Data","index":3,"n_rows":5,"n_cols":23,"rows_kept":5}
[null,"Country code","National TMF code","International TMFcode","TMF name","Nearest settlement","Longitude","Latitude","Location type","Used capacity (Mio m³)","Material category","Toxic substances","Substance toxicity (WHC)","TMF status","Flood occurence (HQ-500)","Seismic activity (Reference PGA, m/s2)","Dam stability (FoS)","Settlements at risk","Total Population at Risk","Closest surface water body at risk","Mean stream flow rate (m3/s) or Lake surface area (km2)","Reference year","Additional information"]
["Check","COUNTRY","NATCD_TMF","INTCD_TMF","NAME","NEAR_SETTL","LONGITUDE","LATITUDE","LOC_TYPE","USED_CAP","MAT_CAT","TOXIC_SUBS","SUBS_TOX","TMF_STATUS","FLOOD_OCC","SEISM_ACT","DAM_STAB","SETTL_10KM","TOT_PAR","WB_10KM","FLOW_AREA","REF_YEAR","ADD_INFO"]
[{"$f":"IF(COUNTBLANK(Table_TMFData[[#This Row],[NATCD_TMF]:[ADD_INFO]])=21,\"empty\",\n  IF(COUNTIF(Table_TMFData[NATCD_TMF],Table_TMFData[[#This Row],[NATCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_TMFData[[#This Row],[NATCD_TMF]]=\"\",Table_TMFData[[#This Row],[NAME]]=\"\",Table_TMFData[[#This Row],[LONGITUDE]]=\"\",Table_TMFData[[#This Row],[LATITUDE]]=\"\",Table_TMFData[[#This Row],[LOC_TYPE]]=\"\",Table_TMFData[[#This Row],[USED_CAP]]=\"\",Table_TMFData[[#This Row],[MAT_CAT]]=\"\",Table_TMFData[[#This Row],[SUBS_TOX]]=\"\",Table_TMFData[[#This Row],[TMF_STATUS]]=\"\",Table_TMFData[[#This Row],[FLOOD_OCC]]=\"\",Table_TMFData[[#This Row],[SEISM_ACT]]=\"\",Table_TMFData[[#This Row],[DAM_STAB]]=\"\",Table_TMFData[[#This Row],[TOT_PAR]]=\"\",Table_TMFData[[#This Row],[FLOW_AREA]]=\"\",Table_TMFData[[#This Row],[REF_YEAR]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},{"$f":"CountryCode","v":"RO"},"TMF1",{"$f":"IF(Table_TMFData[[#This Row],[NATCD_TMF]]<>\"\",Table_TMFData[[#This Row],[COUNTRY]]&Table_TMFData[[#This Row],[NATCD_TMF]],\"\")","v":"ROTMF1"},"Anonymus1","Settlement 2",22.856297,{"v":45.90065,"d":"45.900650"},"facility",{"v":5.1,"d":"5.100"},"red mud","Cyanides, Au, Cu",3,"closed","within HQ-500","≤1",">1.5","Settlement 1, Settlement 2",{"v":33400,"d":"33,400"},"River 1","100-1000",2018,"Under rehabilitation"]
[{"$f":"IF(COUNTBLANK(Table_TMFData[[#This Row],[NATCD_TMF]:[ADD_INFO]])=21,\"empty\",\n  IF(COUNTIF(Table_TMFData[NATCD_TMF],Table_TMFData[[#This Row],[NATCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_TMFData[[#This Row],[NATCD_TMF]]=\"\",Table_TMFData[[#This Row],[NAME]]=\"\",Table_TMFData[[#This Row],[LONGITUDE]]=\"\",Table_TMFData[[#This Row],[LATITUDE]]=\"\",Table_TMFData[[#This Row],[LOC_TYPE]]=\"\",Table_TMFData[[#This Row],[USED_CAP]]=\"\",Table_TMFData[[#This Row],[MAT_CAT]]=\"\",Table_TMFData[[#This Row],[SUBS_TOX]]=\"\",Table_TMFData[[#This Row],[TMF_STATUS]]=\"\",Table_TMFData[[#This Row],[FLOOD_OCC]]=\"\",Table_TMFData[[#This Row],[SEISM_ACT]]=\"\",Table_TMFData[[#This Row],[DAM_STAB]]=\"\",Table_TMFData[[#This Row],[TOT_PAR]]=\"\",Table_TMFData[[#This Row],[FLOW_AREA]]=\"\",Table_TMFData[[#This Row],[REF_YEAR]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},{"$f":"CountryCode","v":"RO"},"TMF2",{"$f":"IF(Table_TMFData[[#This Row],[NATCD_TMF]]<>\"\",Table_TMFData[[#This Row],[COUNTRY]]&Table_TMFData[[#This Row],[NATCD_TMF]],\"\")","v":"ROTMF2"},"Anonymus2","Settlement 3",23.070782,46.290028,"settlement",{"v":4,"d":"4.000"},"sludge",null,2,"active","unknown","unknown","unknown","Settlement 3, Settlement 4, Settlement 5",800,null,"no water body",2016]
[{"$f":"IF(COUNTBLANK(Table_TMFData[[#This Row],[NATCD_TMF]:[ADD_INFO]])=21,\"empty\",\n  IF(COUNTIF(Table_TMFData[NATCD_TMF],Table_TMFData[[#This Row],[NATCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_TMFData[[#This Row],[NATCD_TMF]]=\"\",Table_TMFData[[#This Row],[NAME]]=\"\",Table_TMFData[[#This Row],[LONGITUDE]]=\"\",Table_TMFData[[#This Row],[LATITUDE]]=\"\",Table_TMFData[[#This Row],[LOC_TYPE]]=\"\",Table_TMFData[[#This Row],[USED_CAP]]=\"\",Table_TMFData[[#This Row],[MAT_CAT]]=\"\",Table_TMFData[[#This Row],[SUBS_TOX]]=\"\",Table_TMFData[[#This Row],[TMF_STATUS]]=\"\",Table_TMFData[[#This Row],[FLOOD_OCC]]=\"\",Table_TMFData[[#This Row],[SEISM_ACT]]=\"\",Table_TMFData[[#This Row],[DAM_STAB]]=\"\",Table_TMFData[[#This Row],[TOT_PAR]]=\"\",Table_TMFData[[#This Row],[FLOW_AREA]]=\"\",Table_TMFData[[#This Row],[REF_YEAR]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},"RO","TMF3",{"$f":"IF(Table_TMFData[[#This Row],[NATCD_TMF]]<>\"\",Table_TMFData[[#This Row],[COUNTRY]]&Table_TMFData[[#This Row],[NATCD_TMF]],\"\")","v":"ROTMF3"},"Anonymus3",null,{"v":25.8082489698,"d":"25.808249"},{"v":46.6530214644,"d":"46.653021"},"municipality",{"v":11.2,"d":"11.200"},"slurry","Cu, Fe, S, Zn, Pb",1,"rehabilitated","beyond HQ-500","≤1","≤1.5",null,{"v":4600,"d":"4,600"},"River 2","≤100",1995]

{"sheet":"THI & TRI","index":4,"n_rows":5,"n_cols":13,"rows_kept":5}
[null,"International TMF code","TMF name","Hazard index for capacity","Hazard index for toxicity","Hazard index for management conditions","Hazard index for natural conditions","Hazard index for dam stability","Tailings Hazard Index","Exposure index for population","Exposure index for environment","Tailings Exposure Index","Tailings Risk Index"]
["Check","INTCD_TMF","NAME","THI_CAP","THI_TOX","THI_MAN","THI_NAT","THI_DAM","THI ","TEI_POP","TEI_ENV","TEI","TRI"]
[{"$f":"IF(COUNTBLANK(Table_THITRI[[#This Row],[INTCD_TMF]:[TRI]])=12,\"empty\",\n  IF(COUNTIF(Table_THITRI[INTCD_TMF],Table_THITRI[[#This Row],[INTCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_THITRI[[#This Row],[INTCD_TMF]]=\"\",Table_THITRI[[#This Row],[NAME]]=\"\",Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=\"\",Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\",Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\",Table_THITRI[[#This Row],[TRI]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[INTCD_TMF]]),\"\",Table_TMFData[[#This Row],[INTCD_TMF]])","v":"ROTMF1"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[NAME]]),\"\",Table_TMFData[[#This Row],[NAME]])","v":"Anonymus1"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[USED_CAP]]),\"\",LOG10(Table_TMFData[[#This Row],[USED_CAP]]*1000000))","v":{"v":6.707570176097937,"d":"6.7"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[SUBS_TOX]]),\"\",Table_TMFData[[#This Row],[SUBS_TOX]])","v":{"v":3,"d":"3.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TMF_STATUS]]),\"\",IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"rehabilitated\",0,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"closed\",1,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"active\",3,3))))","v":{"v":1,"d":"1.0"}},{"$f":"IF(OR(ISBLANK(Table_TMFData[[#This Row],[FLOOD_OCC]]),ISBLANK(Table_TMFData[[#This Row],[SEISM_ACT]])),\"\",IF(Table_TMFData[[#This Row],[FLOOD_OCC]]=\"beyond HQ-500\",0,1)+IF(Table_TMFData[[#This Row],[SEISM_ACT]]=\"≤1\",0,1))","v":{"v":1,"d":"1.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[DAM_STAB]]),\"\",IF(Table_TMFData[[#This Row],[DAM_STAB]]=\">1.5\",0,1))","v":{"v":0,"d":"0.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=0,Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\"),\"\",SUM(Table_THITRI[[#This Row],[THI_CAP]:[THI_DAM]]))","v":{"v":11.707570176097937,"d":"11.7"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TOT_PAR]]),\"\",IF(Table_TMFData[[#This Row],[TOT_PAR]]=0,1,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100,2,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=1000,3,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=10000,4,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100000,5,6))))))","v":{"v":5,"d":"5.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[FLOW_AREA]]),\"\",IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"no water body\",1,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"≤100\",2,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"100-1000\",3,4))))","v":{"v":3,"d":"3.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\"),\"\",Table_THITRI[[#This Row],[TEI_POP]]+Table_THITRI[[#This Row],[TEI_ENV]])","v":{"v":8,"d":"8.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\"),\"\",Table_THITRI[[#This Row],[THI ]]+Table_THITRI[[#This Row],[TEI]])","v":{"v":19.70757017609794,"d":"19.7"}}]
[{"$f":"IF(COUNTBLANK(Table_THITRI[[#This Row],[INTCD_TMF]:[TRI]])=12,\"empty\",\n  IF(COUNTIF(Table_THITRI[INTCD_TMF],Table_THITRI[[#This Row],[INTCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_THITRI[[#This Row],[INTCD_TMF]]=\"\",Table_THITRI[[#This Row],[NAME]]=\"\",Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=\"\",Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\",Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\",Table_THITRI[[#This Row],[TRI]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[INTCD_TMF]]),\"\",Table_TMFData[[#This Row],[INTCD_TMF]])","v":"ROTMF2"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[NAME]]),\"\",Table_TMFData[[#This Row],[NAME]])","v":"Anonymus2"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[USED_CAP]]),\"\",LOG10(Table_TMFData[[#This Row],[USED_CAP]]*1000000))","v":{"v":6.6020599913279625,"d":"6.6"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[SUBS_TOX]]),\"\",Table_TMFData[[#This Row],[SUBS_TOX]])","v":{"v":2,"d":"2.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TMF_STATUS]]),\"\",IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"rehabilitated\",0,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"closed\",1,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"active\",3,3))))","v":{"v":3,"d":"3.0"}},{"$f":"IF(OR(ISBLANK(Table_TMFData[[#This Row],[FLOOD_OCC]]),ISBLANK(Table_TMFData[[#This Row],[SEISM_ACT]])),\"\",IF(Table_TMFData[[#This Row],[FLOOD_OCC]]=\"beyond HQ-500\",0,1)+IF(Table_TMFData[[#This Row],[SEISM_ACT]]=\"≤1\",0,1))","v":{"v":2,"d":"2.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[DAM_STAB]]),\"\",IF(Table_TMFData[[#This Row],[DAM_STAB]]=\">1.5\",0,1))","v":{"v":1,"d":"1.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=0,Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\"),\"\",SUM(Table_THITRI[[#This Row],[THI_CAP]:[THI_DAM]]))","v":{"v":14.602059991327963,"d":"14.6"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TOT_PAR]]),\"\",IF(Table_TMFData[[#This Row],[TOT_PAR]]=0,1,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100,2,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=1000,3,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=10000,4,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100000,5,6))))))","v":{"v":3,"d":"3.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[FLOW_AREA]]),\"\",IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"no water body\",1,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"≤100\",2,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"100-1000\",3,4))))","v":{"v":1,"d":"1.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\"),\"\",Table_THITRI[[#This Row],[TEI_POP]]+Table_THITRI[[#This Row],[TEI_ENV]])","v":{"v":4,"d":"4.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\"),\"\",Table_THITRI[[#This Row],[THI ]]+Table_THITRI[[#This Row],[TEI]])","v":{"v":18.602059991327963,"d":"18.6"}}]
[{"$f":"IF(COUNTBLANK(Table_THITRI[[#This Row],[INTCD_TMF]:[TRI]])=12,\"empty\",\n  IF(COUNTIF(Table_THITRI[INTCD_TMF],Table_THITRI[[#This Row],[INTCD_TMF]])>1, \"duplicate\",\n  IF(OR(Table_THITRI[[#This Row],[INTCD_TMF]]=\"\",Table_THITRI[[#This Row],[NAME]]=\"\",Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=\"\",Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\",Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\",Table_THITRI[[#This Row],[TRI]]=\"\"),\"incomplete\",\n  \"complete\")))","v":"complete"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[INTCD_TMF]]),\"\",Table_TMFData[[#This Row],[INTCD_TMF]])","v":"ROTMF3"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[NAME]]),\"\",Table_TMFData[[#This Row],[NAME]])","v":"Anonymus3"},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[USED_CAP]]),\"\",LOG10(Table_TMFData[[#This Row],[USED_CAP]]*1000000))","v":{"v":7.049218022670182,"d":"7.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[SUBS_TOX]]),\"\",Table_TMFData[[#This Row],[SUBS_TOX]])","v":{"v":1,"d":"1.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TMF_STATUS]]),\"\",IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"rehabilitated\",0,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"closed\",1,IF(Table_TMFData[[#This Row],[TMF_STATUS]]=\"active\",3,3))))","v":{"v":0,"d":"0.0"}},{"$f":"IF(OR(ISBLANK(Table_TMFData[[#This Row],[FLOOD_OCC]]),ISBLANK(Table_TMFData[[#This Row],[SEISM_ACT]])),\"\",IF(Table_TMFData[[#This Row],[FLOOD_OCC]]=\"beyond HQ-500\",0,1)+IF(Table_TMFData[[#This Row],[SEISM_ACT]]=\"≤1\",0,1))","v":{"v":0,"d":"0.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[DAM_STAB]]),\"\",IF(Table_TMFData[[#This Row],[DAM_STAB]]=\">1.5\",0,1))","v":{"v":1,"d":"1.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI_CAP]]=\"\",Table_THITRI[[#This Row],[THI_TOX]]=0,Table_THITRI[[#This Row],[THI_MAN]]=\"\",Table_THITRI[[#This Row],[THI_NAT]]=\"\",Table_THITRI[[#This Row],[THI_DAM]]=\"\"),\"\",SUM(Table_THITRI[[#This Row],[THI_CAP]:[THI_DAM]]))","v":{"v":9.049218022670182,"d":"9.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[TOT_PAR]]),\"\",IF(Table_TMFData[[#This Row],[TOT_PAR]]=0,1,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100,2,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=1000,3,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=10000,4,IF(Table_TMFData[[#This Row],[TOT_PAR]]<=100000,5,6))))))","v":{"v":4,"d":"4.0"}},{"$f":"IF(ISBLANK(Table_TMFData[[#This Row],[FLOW_AREA]]),\"\",IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"no water body\",1,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"≤100\",2,IF(Table_TMFData[[#This Row],[FLOW_AREA]]=\"100-1000\",3,4))))","v":{"v":2,"d":"2.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[TEI_POP]]=\"\",Table_THITRI[[#This Row],[TEI_ENV]]=\"\"),\"\",Table_THITRI[[#This Row],[TEI_POP]]+Table_THITRI[[#This Row],[TEI_ENV]])","v":{"v":6,"d":"6.0"}},{"$f":"IF(OR(Table_THITRI[[#This Row],[THI ]]=\"\",Table_THITRI[[#This Row],[TEI]]=\"\"),\"\",Table_THITRI[[#This Row],[THI ]]+Table_THITRI[[#This Row],[TEI]])","v":{"v":15.049218022670182,"d":"15.0"}}]

{"sheet":"Metadata","index":5,"n_rows":80,"n_cols":5,"rows_kept":80,"merged":[[1,0,6,0],[8,0,10,0],[11,0,14,0],[15,0,18,0],[19,0,20,0],[21,0,24,0],[25,0,28,0],[29,0,31,0],[32,0,36,0]]}
["Group","Element","Value","Value2","Value3"]
["Identification","Resource title",{"$f":"\"Tailings management facilities (TMF) in the DRBD in \"&Table_Report[COUNTRY_NAME]","v":"Tailings management facilities (TMF) in the DRBD in Romania"}]
[null,"Resource abstract","This dataset contains information on the tailings management facilities (TMF) within the specified national or regional territory."]
[null,"Resource type","dataset"]
[null,"Resource locator"]
[null,"Unique resource identifier - code",{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"ICPDRUBA_TMF_Template.xlsm"}]
[null,"Resource language","English"]
["Classification","Topic category","inlandWaters"]
["Keyword","Keyword value","hazardous substance","hazard of pollutants","tailings pond"]
[null,"Originating controlled vocabulary","GEMET - Concepts, version 4.1","GEMET - Concepts, version 4.1","GEMET - Concepts, version 4.1"]
[null,"Publication date","2018-07-12","2018-07-12","2018-07-12"]
["Geographic location","Bounding box - South",{"$f":"IF(MIN(Table_TMFData[LATITUDE])=0,\"\",MIN(Table_TMFData[LATITUDE]))","v":{"v":45.90065,"d":"45.9007"}}]
[null,"Bounding box - North",{"$f":"IF(MAX(Table_TMFData[LATITUDE])=0,\"\",MAX(Table_TMFData[LATITUDE]))","v":{"v":46.6530214644,"d":"46.6530"}}]
[null,"Bounding box - East",{"$f":"IF(MAX(Table_TMFData[LONGITUDE])=0,\"\",MAX(Table_TMFData[LONGITUDE]))","v":{"v":25.8082489698,"d":"25.8082"}}]
[null,"Bounding box - West",{"$f":"IF(MIN(Table_TMFData[LONGITUDE])=0,\"\",MIN(Table_TMFData[LONGITUDE]))","v":{"v":22.856297,"d":"22.8563"}}]
["Temporal reference","Temporal extend - begin"]
[null,"Temporal extend - end"]
[null,"Date of publication"]
[null,"Date of last revision",{"$f":"LastSavedTimeStamp()","v":"2021-02-10T00:38:16"}]
["Quality Validity","Lineage"]
[null,"Spatial resolution - equivalent scale"]
["Conformity","Specification - Title","COMMISSION REGULATION (EU) No 1253/2013 of 21 October 2013 amending Regulation (EU) No 1089/2010 implementing Directive 2007/2/EC as regards interoperability of spatial data sets and services"]
[null,"Specification - Date type","publication"]
[null,"Specification - Date","2013-10-21"]
[null,"Degree","notEvaluated"]
["Constraints related to acces & use","Conditions applying to access and use"]
[null,"Type of limitation"]
[null,"Other constraints"]
[null,"Classification",null,{"$f":"IF(C29=\"\",\"\",INDEX(Table_Classification[name], MATCH(C29,Table_Classification[code])))","v":""}]
["Responsible organisations","Responsible party Name"]
[null,"Responsible party Role"]
[null,"Responsible party EMail"]
["Metadata","Metadata point of contact Name"]
[null,"Metadata point of contact Role"]
[null,"Metadata point of contact EMail"]
[null,"Metadata date",{"$f":"LastSavedTimeStamp()","v":"2021-02-10T00:38:16"}]
[null,"Metadata language","eng"]
["WISE Metadata","Distribution format Name","Excel file"]
[null,"Distribution format Version","Excel 2007 (xlsx)"]
[null,"Distributor Name"]
[null,"Distributor Role"]
[null,"Distributor EMail"]
[null,"Metadata standard name","ISO 19115 Geographic information - Metadata; WISE Metadata profile (2009)"]
[null,"Metadata standard version","ISO 19115:2003"]
[null,"Reference system code","GCS_ETRS_1989"]
[null,"Spatial representation type","textTable"]
[null,"Purpose"]
[null,"Specific usage"]
[]
["RestrictionCode"]
["code","name"]
["copyright","exclusive right to publication, production, or sale of the rights to a literary, dramatic, musical or artistic work, or to the use of a commercial print or label, granted by law for a specified period of time to an author, composer, artist, distributor"]
["patent","government has granted exclusive rights to make, sell, use or license an invention or discovery"]
["patentPending","produced or sold information awaiting a patent"]
["trademark","a name, symbol, or other device identifying a product, officially registered and legally restricted to the use of the owner or manufacturer"]
["license","formal permission to do something"]
["intellectualPropertyRights","rights to financial benefit from and control of distribution of non-tangible property that is a result of creativity"]
["restricted","withheld from general circulation or disclosure"]
["otherRestrictions","limitation not listed"]
[]
["Classification"]
["code","name"]
["confidential","available for someone who can be entrusted with information"]
["restricted","not for general disclosure"]
["secret","kept or meant to be kept private, or hidden from all but a select group of people"]
["unclassified","available for general disclosure"]
[]
["Roles"]
["code","name"]
["resourceProvider","party that supplies the resource"]
["custodian","party that accepts accountability and responsibility for the data and ensures appropriate care and maintenance of the resource"]
["owner","party that owns the resource"]
["user","party who uses the resource"]
["distributor","party who distributes the resource"]
["originator","party who created the resource"]
["pointOfContact","party who can be contacted for acquiring knowledge about or acquisition of the resource"]
["principalInvestigator","key party responsible for gathering information and conducting research"]
["processor","party who has processed the data in a manner such that the resource has been modified"]
["publisher","party who published the resource"]
["author","party who authored the resource"]

{"sheet":"LookupTables","index":6,"n_rows":65,"n_cols":2,"rows_kept":65}
["Location Domain"]
["code","name"]
["facility","facility"]
["settlement","settlement"]
["municipality","municipality"]
[]
[]
["Material Domain"]
["code","name"]
["brine","brine"]
["calx","calx"]
["fly ash","fly ash"]
["mine water","mine water"]
["red mud","red mud"]
["residual oil","residual oil"]
["sludge","sludge"]
["slurry","slurry"]
["other","other"]
["unknown","unknown"]
[]
[]
["WHC Domain"]
["code","name"]
[0,0]
[1,1]
[2,2]
[3,3]
[4,4]
[]
[]
["Status Domain"]
["code","name"]
["active","active"]
["closed","closed"]
["abandoned","abandoned"]
["rehabilitated","rehabilitated"]
[]
[]
["HQ-500 Domain"]
["code","name"]
["within HQ-500","within HQ-500"]
["beyond HQ-500","beyond HQ-500"]
["unknown","unknown"]
[]
[]
["PGA Domain"]
["code","name"]
["≤1","≤1"]
[">1",">1"]
["unknown","unknown"]
[]
[]
["FoS Domain"]
["code","name"]
["≤1.5","≤1.5"]
[">1.5",">1.5"]
["unknown","unknown"]
[]
[]
["SWB Domain"]
["code","name"]
["no water body","no water body"]
["≤100","≤100"]
["100-1000","100-1000"]
[">1000",">1000"]