{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Welcome to NWE-MESIS","General PMSD ID-card","Surrounding and site","Deposit 1","Deposit 2","Deposit 3","Deposit 4","Deposit 5","Data sources","SMART PHOENIX","données (à masquer)","Smart-Phoenix_Calculation_mask"],"not_rendered":{"charts":1,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":7,"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":"Welcome to NWE-MESIS","index":0,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[[50,2,53,11],[30,2,31,11],[66,8,69,12],[59,8,61,12],[63,9,63,11]]}
[null,null,null,null,null,null,null,"NWE-MESIS"]
[null,null,null,null,null,null,null,"MEtallurgical Site Inventory Structure"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Welcome to NWE-MESIS! "]
[]
[null,null,null,null,null,null,"The NWE-MESIS was developed as part of the NWE-REGENERATIS project. "]
[null,null,null,null,null,null,"It provides a structure that captures environmental, economic and social risk issues along key parameters needed for"]
[null,null,null,null,null,null," assessing resource recovery potential of PMSD"]
[]
[]
[null,null,"The targeted sites are Past Metallurgical Sites and Deposits (PMSD). Each spreadsheet focuses on a specific inventory aspect:"]
[]
[null,null,null,"General PMSD ID-card:",null,"General identification, owner and permits information"]
[null,null,null,"Surrounding and site:",null,"Surrounding and site information, including historical information, social and risk aspects"]
[null,null,null,"Deposit x",null,"Deposit (homogenous volumes) information"]
[null,null,null,null,null,"Up to 5 deposit sheets can be automatically created by selecting the number of deposits in \"Surrounding and site\""]
[null,null,null,"Data sources",null,"Information sources, tracing of encoding process and site visits"]
[]
[null,null,null,"SMART PHOENIX: ",null,"An independant tool that scores your site in terms of potential for ressource recovery."]
[]
[null,null,"You will find a definition of the various fields as well as description of guidelines to fill the NWE-MESIS in the NWE-MESIS guidebook, "]
[null,null,"accessible via the folowing link: ",null,null,"Guidebook"]
[]
[]
[]
[null,null,null,null,null,null,"SMART PHOENIX : Is your site suitable for resource recovery?"]
[]
[null,null,"The SMART PHOENIX allows in 16 questions to estimate the potential for ressource recovery of a Past Metallurgical Site Deposit"]
[]
[]
[null,null,null,null,null,null,"It can be used independently from the NWE-MESIS, as a standalone tool."]
[null,null,null,null,null,null,"Filling in the adequate fields in NWE-MESIS (identified by ①) will automatically result in a score computed by the SMART PHOENIX"]
[]
[null,null,"Ressources evaluated by the SMART PHOENIX are:"]
[null,null,null,"Metal:",null,null,"potential for recovery of metallic elements from metallurgical waste materials."]
[null,null,null,"Mineral:",null,null,"recovery potential of mineral elements, after mineral processing or initially present on the site."]
[null,null,null,"Soil improvement for eco-catalyst: ",null,null,"initial potential for cost-effective improvement of soil fertility, with a view "]
[null,null,null,null,null,null,"to producing ecocatalysis."]
[null,null,null,"Eco-catalyst production:",null,null,"use of plants that can naturally accumulate metal elements in the soil (e.g. zinc)"]
[null,null,null,null,null,null,"and then transform them into useful compounds for chemistry"]
[]
[null,null,null,null,null,null,"In addition to its clear link to the SMART PHOENIX, NWE-MESIS also contains some fields that are common to the input parameters"]
[null,null,null,null,null,null," for the NWE-SMARTX tool. These are identified with the symbol ② for your information only."]
[]
[]
[null,null,null,null,null,null,"Green light on your SMART PHOENIX?"]
[]
[null,null,"For green light results sites, additional tools to help you go further in the process have been developped. Please visit the results sections of the project website to learn more about business cases, methodologies and the NWE-SMARTX tool, a smart decision support tool that helps you target the most profitable valorisation routes for your identified ressources. "]
[]
[]
[]
[null,null,null,null,null,null,"Project website link"]
[]
[]
[null,"The NWE-MESIS tool was developed in the framework of the NWE-REGENERATIS project, funded by the Interreg NWE program and the Walloon region."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\nPlease visit the NWE-REGENERATIS website : \n\n\n"]
[null,null,null,null,null,null,null,null,"Interested to know more about the project?\nPlease visit the project website:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"NWE-REGENERATIS"]
[]
[]
[null,null,null,null,null,null,null,null,"To report a malfunction of the software or for technical assistance, please contact: xxxx"]

{"sheet":"General PMSD ID-card","index":1,"n_rows":57,"n_cols":15,"rows_kept":57,"cut":false,"hidden":false,"merged":[[6,1,6,3],[18,10,20,10],[24,10,25,10],[9,1,9,5],[1,8,1,9],[2,8,2,9],[3,8,3,9]]}
[]
[null,null,null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[]
[null,"Is your site a PMSD*? ①",null,null,{"$f":"IF(C6=\"No\",\"WARNING: This inventory is only relevant for PMSD! We recommend not to use it for other sites.\",\"\")","v":""}]
[null,"*Past Metallurgical Sites and Deposits (PMSD) are either 1) sites where a metallurgical activity took place at some time, or 2) sites that contain a deposit of metallurgical origin."]
[]
[]
[null,"General PMSD Information"]
[]
[null,"Name:"]
[null,"Other name 1:"]
[null,"Other name 2:"]
[null,"Other name 3:"]
[null,"Ref:"]
[null,"Country:"]
[null,"City:"]
[null,"Postal Code:"]
[null,"Street:"]
[null,"Code NUTS:"]
[null,"X / Longitude (WGS 84):",null,"°"]
[null,"Y / Latitude (WGS 84):",null,"°"]
[null,"Site area (m²):"]
[null,"Administration in charge:"]
[null,"Administration adress:"]
[]
[]
[]
[null,null,null,"Current/ past ownership and operation",null,null,null,null,null,null,"Permits and authorisations list"]
[]
["N°","Name","Owner or operator","Public/private","Start date (year)","End date (year)","NACE code",null,"N°","Reference","Date (year) of autorisation","Expiration date (year)","Nature of permit","Permit description","Permit/ Authorisation Holder"]
[1,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,25]

{"sheet":"Surrounding and site","index":2,"n_rows":125,"n_cols":16,"rows_kept":125,"cut":false,"hidden":false,"merged":[[102,3,102,5],[94,3,94,5],[95,3,95,5],[96,3,96,5],[97,3,97,5],[98,3,98,5],[56,1,56,6],[70,1,70,3],[99,3,99,5],[100,3,100,5],[101,3,101,5],[92,1,92,8],[90,0,90,9],[116,3,116,5],[103,3,103,5],[112,3,112,5],[113,3,113,5],[114,3,114,5],[115,3,115,5],[109,3,109,5],[110,3,110,5],[111,3,111,5],[106,3,106,5],[107,3,107,5],[108,3,108,5],[105,1,105,8],[124,3,124,5],[118,1,118,5],[119,3,119,5],[121,3,121,5],[120,3,120,5],[122,3,122,5],[123,3,123,5],[16,1,16,3],[20,1,20,3],[19,1,19,3],[93,3,93,5],[46,4,46,5],[41,1,41,6],[42,1,42,6],[45,1,45,2],[48,4,48,5],[24,1,24,3],[34,1,34,2],[26,1,26,3],[47,4,47,5],[75,1,75,16],[71,4,71,5],[52,1,52,2],[1,3,3,7],[2,8,2,9],[44,4,44,5],[45,4,45,5],[32,1,32,3],[17,1,17,3],[8,1,8,7],[10,3,10,4],[13,1,13,3],[9,1,9,7],[35,1,35,3],[27,1,27,3],[29,1,29,3],[28,1,28,3],[22,1,22,7],[11,1,11,3]]}
[]
[null,null,null,"SURROUNDING AND SITE"]
[null,null,null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[null,"Key information: "]
[null,"How many deposits (homogeneous volumes) are there on the site?",null,null,1]
[]
[null,"General site and surrounding information"]
[null,"Before investigations"]
[null,null,null,null,null,"Answer","Confidence level"]
[null,"Does the site contain a landfill, deposit or backfill with possible metallic residues (mainly Pb, Cu, Zn and Fe)?①"]
[null,"Must the site / an area of the site be rehabilitated? ①"]
[null,"Is there a known interest for the reconversion of the site (public or private projects/interests) ?①"]
[null,"Is the site registered in a database?①"]
[null,"Is there historical data available?①"]
[null,"Surface occupied by low vegetation:①"]
[null,"Surface occupied by constructions:①"]
[null,"Surface occupied by trees:①"]
[null,"Is the site easy to access for trucks and heavy equipment?①"]
[null,"Is the site considered as hazardous?①"]
[]
[null,"Complementary information on the site"]
[]
[null,"Total site area (m²) occupied by residues from metallurgical origin (before investigation):"]
[null,"Total estimated volume (m³) of all the deposits (before investigation):"]
[null,"Soil and groundwater restriction (related to the presence of hazard):"]
[null,"Have any soil pollution investigations happened on the site?"]
[null,"Have any remediation actions happened on the site?"]
[null,"Does the site still need to be remediated?"]
[null,"Urgency of need for remedial actions:"]
[null,"Did the site receive metallurgical waste from other industries?"]
[null,"Does the site have any infrastructure of historical, architectural or aesthetic (or potential) heritage interest?"]
[null,"Presence of a wastewater treatment plant:"]
[null,"Presence of a railway access nearby (loading dock):"]
[null,"Presence of a waterway nearby (loading dock):"]
[null,"Area of bare land (ha) : ②"]
[null,"Bare land fertility aspects ②"]
[null,"Sealed area (ha) : ②"]
[null,null,null,null,null,"WARNING: are you sure you don't have any deposit?"]
[]
[null,"Social aspects"]
[null,"Current use"]
[]
[null,"Current status (legal use) of the site:"]
[null,"Current use of the site, regardless of its official use:"]
[null,"Which activities?"]
[null,"Territorial strategy aspects:"]
[null,"Intended future site use:"]
[]
[null,"General risk evaluation"]
[]
[null,"Severe risk for human health:"]
[null,"Olfactory pollution:"]
[null,"Distance from the nearest housing (m):"]
[]
[null,"Surrounding"]
[]
[null,"1. Artificial surfaces"]
[null,"    1.1. Urban"]
[null,"    1.2. Industrial, commercial"]
[null,"    1.3. Mine, dump and construction sites"]
[null,"    1.4. Artificial, non-agricultural vegetated areas"]
[null,"2. Agricultural areas"]
[null,"3. Forest and semi natural areas"]
[null,"4. Wetlands"]
[null,"5. Water bodies"]
[]
[null,"Social support"]
[]
[null,"Wishes of local residents or associations to see the site rehabilitated"]
[null,"Description of the social support"]
[]
[]
[]
[null,"Description of industrial processes (historical information)"]
[]
["N°","Operator Name","Begining year date","End year date","Public/ Private","Processing details and description ","Type of industry","Technologies  and processes related to infrastructures and activities","List of inputs ","List of outputs (products, coproducts and waste)","Degree of output hazard ","Were the outputs valorised in the past?","Waste management","Estimated volume of waste deposit","Presumed pollutants/ Estimation of soil pollution","If there is a risk of suspected pollutants, which ones?"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[]
["Soil pollution investigations and remedial actions"]
[]
[null,"Soil pollutions investigations done in the past (e.g. studies investigating and delimiting the presence of pollution, risk studies, …) "]
["N°","Name/ Reference of the soil pollution investigation","Date (year)","Summary",null,null,"Did the investigation uncover any (potential) metallic soil contamination?","Which one (please list among Zn, Cu, Fe, Co, Cd, Pb, Hq, As, Ni, Al, Sb, Se, Cr, Mn, Mo, Rare earth, other) ?"," Contamination area (m²)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[null,"Remedial actions done in the past"]
["N°","Main type of remediation","Date (year)","Remediation strategy: summary of decisions taken ",null,null,"Residual main metallic soil contamination?","Which one (please list among Zn, Cu, Fe, Co, Cd, Pb, Hq, As, Ni, Al, Sb, Se, Cr, Mn, Mo, Rare earth, other) ?"," Contamination area (m²)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[null,"Remedial actions planned"]
["N°","Main type of remediation","Date (year)","Remediation strategy: summary of decisions taken"]
[1]
[2]
[3]
[4]
[5]

{"sheet":"Deposit 1","index":3,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":false,"merged":[[144,2,144,6],[145,2,145,6],[149,5,149,6],[139,5,139,6],[60,0,60,9],[120,5,120,6],[112,5,112,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[138,5,138,6],[121,5,121,6],[7,0,7,3],[23,0,23,4],[9,0,9,9],[10,0,10,9],[6,2,6,10],[24,0,24,3],[14,2,19,2],[109,0,109,9],[42,0,42,9],[43,0,43,9],[54,5,54,7],[50,0,50,2],[56,0,56,2],[56,5,56,7],[55,5,55,7],[55,8,55,9],[153,5,153,6],[52,6,52,9],[1,9,1,10],[158,4,158,6],[80,3,80,6],[26,0,26,3],[122,5,122,6],[135,5,135,6],[136,5,136,6],[151,5,151,6],[140,5,140,6],[150,5,150,6],[152,5,152,6],[137,5,137,6],[28,0,28,9],[33,0,33,9]]}
[]
[null,null,null,"DEPOSIT (Homogeneous volume) 1",null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[]
["Name of deposit 1"]
["Description of deposit 1"]
["Current occupation of deposit 1 compared to all volume of deposit (%)"]
[]
["Main description"]
["General information "]
[]
["Type of  residues from metallurgical origin","Presence in deposit 1 ①","Confidence ①","Main Physical state","% (weight)","Total estimated weight (T) ②","Estimated volume (m³)","Bulk Density (T/m³) ②","Waste hazardness (Heavy metals, PAHs, Hydrocarbons) ② "]
["Slag",null,null,null,null,{"$f":"IF('Deposit 1'!G14>0,'Deposit 1'!H14*'Deposit 1'!G14,\"\")","v":""}]
["Metal scraps",null,"↑ please only indicate confidence just above for all types of residues",null,null,{"$f":"IF('Deposit 1'!G15>0,'Deposit 1'!H15*'Deposit 1'!G15,\"\")","v":""}]
["Ashes",null,null,null,null,{"$f":"IF('Deposit 1'!G16>0,'Deposit 1'!H16*'Deposit 1'!G16,\"\")","v":""}]
["Dust",null,null,null,null,{"$f":"IF('Deposit 1'!G17>0,'Deposit 1'!H17*'Deposit 1'!G17,\"\")","v":""}]
["Sludges",null,null,null,null,{"$f":"IF('Deposit 1'!G18>0,'Deposit 1'!H18*'Deposit 1'!G18,\"\")","v":""}]
["Refractories",null,null,null,null,{"$f":"IF('Deposit 1'!G19>0,'Deposit 1'!H19*'Deposit 1'!G19,\"\")","v":""}]
["None from the list",null,null,null,null,{"$f":"IF('Deposit 1'!G20>0,'Deposit 1'!H20*'Deposit 1'!G20,\"\")","v":""}]
["Total",null,null,null,{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,{"$f":"_xlfn.IFS(OR(I14:I20=\"Yes\"),\"Yes\",AND(I14:I20=\"\"),\"\",TRUE,\"No\")","v":""}]
[]
[null,null,null,null,null,"Answer","Confidence level"]
["Estimated total volume of the residues from metallurgical origin (m³) in deposit 1 ①"]
["Estimated surface occupied by deposit 1 (m²) ①"]
["Are the residues clearly separated from each other, or mixed? ①"]
["Current use of this surface, regardless of the official use of deposit 1 ①"]
[]
["Exploitation/production period"]
[]
["Beginning date"]
["End date"]
[]
["Waste deposit location:*"]
[]
["Point 1","x coord ",null,null,"y coord"]
["Point 2","x coord",null,null,"y coord"]
["Point 3","x coord",null,null,"y coord"]
["Point 4","x coord",null,null,"y coord"]
["*Estimated GPS coordinates (WGS) of deposit zone (4 points)"]
[]
[]
["Deposit 1 technical information "]
["Specific deposit characteristics "]
[]
["Origin of the metallurgical waste"]
["Estimated average thickness (m) ②"]
["Estimated average height (above ground) (m)"]
["Estimated average depth (below ground) (m)"]
["Main water content of the excavated materials (above water table) (%)"]
["Estimated proportion of large and hard exogenous material in the deposit",null,null," ②"]
[]
["Estimated homogeneity ②",null,null,null,null,null,"Warning: \"Heterogeneous at small scale\" is linked to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Proportion of hard material (IS>3MPa) in the heterogeneous mass ",null,null,"②"]
["Maximum slope ②"]
["Water table ②",null,null,null,null,null,null,null,"Warning: the presence of water is linked to a weaker stability, and therefore it correspond to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Osha classification before excavation (linked with stability, type of material and water table) ②",null,null,null,null,null,null,null,"←"]
["Rock masses hardness ","②"]
["GSI classification","②"]
[]
["Rehabilitation status "]
[]
["Rehabilitation status of the surface occupied by deposit 1"]
["Sampling results"]
["Visually observable contamination"]
["Odour perception"]
["Presence of physical barriers to prevent pollutant dispersal"]
["Which physical barrier?"]
["Top layer"]
["Presence of a cover layer at the top "]
["Type of cover layer ","②"]
["Watertightness layer"]
["Rainwater drainage"]
["Gas drainage"]
[]
["Bottom layer"]
["Presence of a bottom layer"]
["Watertightness layer"]
["Leachate drainage layer"]
[]
["Describe any changes in cover over time"]
[]
["Leachates and drainage"]
[]
["Presence of  water/ leachates table that can freely flow during works"]
["Water table depth (m)"]
["Presence of a drainage system"]
["Presence of a leachates treatment plant on site"]
["Presence of a leachates treatment plant nearby"]
[]
["Monitoring, gas and other technical information"]
[]
["Presence of a monitoring system still in use?"]
["Specify what is monitored (e.g. air, groundwater, surface water, biodiversity)"]
["Presence of biogas ②"]
["Presence of venting system"]
["Presence of monitoring wells"]
[]
["Presence of pipes"]
["Presence of tanks"]
["Presence of cables"]
["Presence of aerial electric lines "]
["Presence of large structure, foundations or underground building (infrastructure)"]
["Presence of sewers"]
["Presence of canals"]
["Presence of available access roads (for trucks)"]
["Nature and condition of the pavement:"]
[]
[]
["Environmental context"]
["Risk evaluation"]
[]
["Flood risk"]
["Fire risk"]
["Risk of collapse"]
["Risk of person accident"]
["Risk of direct exposition to hazardous substances, leachates or waste"]
["Erosion risk"]
["Air emission risk (e.g. biogas, industrial gas, dust) ②"]
["Other risk"]
["Which type of risk?"]
["Specific environmental issue (if it exist)"]
["Impact of the rehabilitation project on the environment"]
[]
["Type of waste",null,"Presence in deposit 1  ②","Main Physical state","% (weight)","Total weight (T)","Estimated volume (m³)","Bulk Density (T/m³)"]
["Hazardous waste","Radioactive waste",null,null,null,null,null,{"$f":"IF(G126>0,F126/G126,\"\")","v":""}]
[null,"Hospital waste",null,null,null,null,null,{"$f":"IF(G127>0,F127/G127,\"\")","v":""}]
[null,"Military waste",null,null,null,null,null,""]
[null,"Asbestos",null,null,null,null,null,""]
[null,"Tanks containing liquids",null,null,null,null,null,""]
[null,"Other: please specify here",null,null,null,null,null,""]
[null,"TOTAL",{"$f":"_xlfn.IFS(OR(C126:C131=\"Assessed\"),\"Assessed\",AND(AND(C126:C131<>\"Assessed\"),OR(C126:C131=\"Possible\")),\"Possible\",AND(C126:C131=\"\"),\"\",TRUE,\"None\")","v":""},null,{"$f":"SUM(E126:E131)","v":0},{"$f":"SUM(F126:F131)","v":0},{"$f":"SUM(G126:G131)","v":0},{"$f":"IF(ISERROR(AVERAGE(H126:H131)),0,AVERAGE(H126:H131))","v":0}]
[]
["Surface water and groundwater vulnerability"]
[]
["Surface water vulnerability"]
["Groundwater vulnerability"]
["Groundwater exploitation"]
["Drinking water protection zone"]
["Level of upper groundwater table (meter below ground level)"]
["Leachates production"]
[]
["Geological information"]
[]
["Bedrock description"]
["Geological context"]
[]
["Soil and topsoil information"]
[]
["Presence of a topsoil layer on the top of the deposit ②"]
["Thickness of the topsoil layer (m) ",null,"②"]
["Main soil texture ","②"]
["Permeability"]
["Free description"]
[]
["Biodiversity"]
[]
["Valuable biodiversity on site"]
["Description of the valuable biodiversity"]
["Is the site located in a Natura 2000 zone?"]

{"sheet":"Deposit 2","index":4,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":true,"merged":[[42,0,42,9],[1,9,1,10],[7,0,7,3],[9,0,9,9],[10,0,10,9],[14,2,19,2],[23,0,23,4],[24,0,24,3],[26,0,26,3],[28,0,28,9],[33,0,33,9],[6,2,6,10],[112,5,112,6],[43,0,43,9],[50,0,50,2],[52,6,52,9],[54,5,54,7],[55,5,55,7],[55,8,55,9],[56,0,56,2],[56,5,56,7],[60,0,60,9],[80,3,80,6],[109,0,109,9],[136,5,136,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[135,5,135,6],[158,4,158,6],[137,5,137,6],[138,5,138,6],[139,5,139,6],[140,5,140,6],[144,2,144,6],[145,2,145,6],[149,5,149,6],[152,5,152,6],[153,5,153,6],[150,5,150,6],[151,5,151,6]]}
[]
[null,null,null,"DEPOSIT (Homogeneous volume) 2",null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[]
["Name of deposit 2"]
["Description of deposit 2"]
["Current occupation of deposit 2 compared to all volume of deposit (%)"]
[]
["Main description"]
["General information "]
[]
["Type of  residues from metallurgical origin","Presence in deposit 2 ①","Confidence ①","Main Physical state","% (weight)","Total weight (T) ②","Estimated volume (m³)","Bulk Density (T/m³) ②","Waste hazardness (Heavy metals, PAHs, Hydrocarbons) ② "]
["Slag",null,null,null,null,{"$f":"IF('Deposit 2'!G14>0,'Deposit 2'!H14*'Deposit 2'!G14,\"\")","v":""},null,""]
["Metal scraps",null,"↑ please only indicate confidence just above for all types of residues",null,null,{"$f":"IF('Deposit 2'!G15>0,'Deposit 2'!H15*'Deposit 2'!G15,\"\")","v":""}]
["Ashes",null,null,null,null,{"$f":"IF('Deposit 2'!G16>0,'Deposit 2'!H16*'Deposit 2'!G16,\"\")","v":""}]
["Dust",null,null,null,null,{"$f":"IF('Deposit 2'!G17>0,'Deposit 2'!H17*'Deposit 2'!G17,\"\")","v":""}]
["Sludges",null,null,null,null,{"$f":"IF('Deposit 2'!G18>0,'Deposit 2'!H18*'Deposit 2'!G18,\"\")","v":""}]
["Refractories",null,null,null,null,{"$f":"IF('Deposit 2'!G19>0,'Deposit 2'!H19*'Deposit 2'!G19,\"\")","v":""},null,""]
["None from the list",null,null,null,null,{"$f":"IF('Deposit 2'!G20>0,'Deposit 2'!H20*'Deposit 2'!G20,\"\")","v":""},null,""]
["Total",null,null,null,{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,{"$f":"_xlfn.IFS(OR(I14:I20=\"Yes\"),\"Yes\",AND(I14:I20=\"\"),\"\",TRUE,\"No\")","v":""}]
[]
[null,null,null,null,null,"Answer","Confidence level"]
["Estimated total volume of the residues from metallurgical origin (m³) in deposit 2 ①"]
["Estimated surface occupied by deposit 2 (m²) ①"]
["Are the residues clearly separated from each other, or mixed? ①"]
["Current use of this surface, regardless of the official use of deposit 2 ①"]
[]
["Exploitation/production period"]
[]
["Beginning date"]
["End date"]
[]
["Waste deposit location:*"]
[]
["Point 1","x coord",null,null,"y coord"]
["Point 2","x coord",null,null,"y coord"]
["Point 3","x coord",null,null,"y coord"]
["Point 4","x coord",null,null,"y coord"]
["*Estimated GPS coordinates (WGS) of deposit zone (4 points)"]
[]
[]
["Deposit 2 technical information "]
["Specific deposit characteristics "]
[]
["Origin of the metallurgical waste"]
["Estimated average thickness (m) ②"]
["Estimated average height (above ground) (m)"]
["Estimated average depth (below ground) (m)"]
["Main water content of the excavated materials (above water table) (%)"]
["Estimated proportion of large and hard exogenous material in the deposit",null,null," ②"]
[]
["Estimated homogeneity ②",null,null,null,null,null,"Warning: \"Heterogeneous at small scale\" is linked to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Proportion of hard material (IS>3MPa) in the heterogeneous mass ",null,null,"②"]
["Maximum slope ②"]
["Water table ②",null,null,null,null,null,null,null,"Warning: the presence of water is linked to a weaker stability, and therefore it correspond to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Osha classification before excavation (linked with stability, type of material and water table) ②",null,null,null,null,null,null,null,"←"]
["Rock masses hardness ","②"]
["GSI classification","②"]
[]
["Rehabilitation status "]
[]
["Rehabilitation status of the surface occupied by deposit 2"]
["Sampling results"]
["Visually observable contamination"]
["Odour perception"]
["Presence of physical barriers to prevent pollutant dispersal"]
["Which physical barrier?"]
["Top layer"]
["Presence of a cover layer at the top "]
["Type of cover layer ","②",null,null,null,"Mineral cover"]
["Watertightness layer"]
["Rainwater drainage"]
["Gas drainage"]
[]
["Bottom layer"]
["Presence of a bottom layer"]
["Watertightness layer"]
["Leachate drainage layer"]
[]
["Describe any changes in cover over time"]
[]
["Leachates and drainage"]
[]
["Presence of  water/ leachates table that can freely flow during works"]
["Water table depth (m)"]
["Presence of a drainage system"]
["Presence of a leachates treatment plant on site"]
["Presence of a leachates treatment plant nearby"]
[]
["Monitoring, gas and other technical information"]
[]
["Presence of a monitoring system still in use?"]
["Specify what is monitored (e.g. air, groundwater, surface water, biodiversity)"]
["Presence of biogas ②"]
["Presence of venting system"]
["Presence of monitoring wells"]
[]
["Presence of pipes"]
["Presence of tanks"]
["Presence of cables"]
["Presence of aerial electric lines "]
["Presence of large structure, foundations or underground building (infrastructure)"]
["Presence of sewers"]
["Presence of canals"]
["Presence of available access roads (for trucks)"]
["Nature and condition of the pavement:"]
[]
[]
["Environmental context"]
["Risk evaluation"]
[]
["Flood risk"]
["Fire risk"]
["Risk of collapse"]
["Risk of person accident"]
["Risk of direct exposition to hazardous substances, leachates or waste"]
["Erosion risk"]
["Air emission risk (e.g. biogas, industrial gas, dust) ②"]
["Other risk"]
["Which type of risk?"]
["Specific environmental issue (if it exist)"]
["Impact of the rehabilitation project on the environment"]
[]
["Type of waste",null,"Presence in deposit 2  ②","Main Physical state","% (weight)","Total weight (T)","Estimated volume (m³)","Bulk Density (T/m³)"]
["Hazardous waste","Radioactive waste",null,null,null,null,null,{"$f":"IF(G126>0,F126/G126,\"\")","v":""}]
[null,"Hospital waste",null,null,null,null,null,{"$f":"IF(G127>0,F127/G127,\"\")","v":""}]
[null,"Military waste",null,null,null,null,null,""]
[null,"Asbestos",null,null,null,null,null,""]
[null,"Tanks containing liquids",null,null,null,null,null,""]
[null,"Other: please specify here",null,null,null,null,null,""]
[null,"TOTAL",{"$f":"_xlfn.IFS(OR(C126:C131=\"Assessed\"),\"Assessed\",AND(AND(C126:C131<>\"Assessed\"),OR(C126:C131=\"Possible\")),\"Possible\",AND(C126:C131=\"\"),\"\",TRUE,\"None\")","v":""},null,{"$f":"SUM(E126:E131)","v":0},{"$f":"SUM(F126:F131)","v":0},{"$f":"SUM(G126:G131)","v":0},{"$f":"IF(ISERROR(AVERAGE(H126:H131)),0,AVERAGE(H126:H131))","v":0}]
[]
["Surface water and groundwater vulnerability"]
[]
["Surface water vulnerability"]
["Groundwater vulnerability"]
["Groundwater exploitation"]
["Drinking water protection zone"]
["Level of upper groundwater table (meter below ground level)"]
["Leachates production"]
[]
["Geological information"]
[]
["Bedrock description"]
["Geological context"]
[]
["Soil and topsoil information"]
[]
["Presence of a topsoil layer on the top of the deposit ②"]
["Thickness of the topsoil layer (m) ",null,"②"]
["Main soil texture ","②"]
["Permeability"]
["Free description"]
[]
["Biodiversity"]
[]
["Valuable biodiversity on site"]
["Description of the valuable biodiversity"]
["Is the site located in a Natura 2000 zone?"]

{"sheet":"Deposit 3","index":5,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":true,"merged":[[42,0,42,9],[1,9,1,10],[7,0,7,3],[9,0,9,9],[10,0,10,9],[14,2,19,2],[23,0,23,4],[24,0,24,3],[26,0,26,3],[28,0,28,9],[33,0,33,9],[6,2,6,10],[112,5,112,6],[43,0,43,9],[50,0,50,2],[52,6,52,9],[54,5,54,7],[55,5,55,7],[55,8,55,9],[56,0,56,2],[56,5,56,7],[60,0,60,9],[80,3,80,6],[109,0,109,9],[136,5,136,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[135,5,135,6],[158,4,158,6],[137,5,137,6],[138,5,138,6],[139,5,139,6],[140,5,140,6],[144,2,144,6],[145,2,145,6],[149,5,149,6],[152,5,152,6],[153,5,153,6],[150,5,150,6],[151,5,151,6]]}
[]
[null,null,null,"DEPOSIT (Homogeneous volume) 3",null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[]
["Name of deposit 3"]
["Description of deposit 3"]
["Current occupation of deposit 3 compared to all volume of deposit (%)"]
[]
["Main description"]
["General information "]
[]
["Type of  residues from metallurgical origin","Presence in deposit 3 ①","Confidence ①","Main Physical state","% (weight)","Total weight (T) ②","Estimated volume (m³)","Bulk Density (T/m³) ②","Waste hazardness (Heavy metals, PAHs, Hydrocarbons) ② "]
["Slag",null,null,null,null,{"$f":"IF('Deposit 3'!G14>0,'Deposit 3'!H14*'Deposit 3'!G14,\"\")","v":""},null,""]
["Metal scraps",null,"↑ please only indicate confidence just above for all types of residues",null,null,{"$f":"IF('Deposit 3'!G15>0,'Deposit 3'!H15*'Deposit 3'!G15,\"\")","v":""}]
["Ashes",null,null,null,null,{"$f":"IF('Deposit 3'!G16>0,'Deposit 3'!H16*'Deposit 3'!G16,\"\")","v":""}]
["Dust",null,null,null,null,{"$f":"IF('Deposit 3'!G17>0,'Deposit 3'!H17*'Deposit 3'!G17,\"\")","v":""}]
["Sludges",null,null,null,null,{"$f":"IF('Deposit 3'!G18>0,'Deposit 3'!H18*'Deposit 3'!G18,\"\")","v":""}]
["Refractories",null,null,null,null,{"$f":"IF('Deposit 3'!G19>0,'Deposit 3'!H19*'Deposit 3'!G19,\"\")","v":""},null,""]
["None from the list",null,null,null,null,{"$f":"IF('Deposit 3'!G20>0,'Deposit 3'!H20*'Deposit 3'!G20,\"\")","v":""},null,""]
["Total",null,null,null,{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,{"$f":"_xlfn.IFS(OR(I14:I20=\"Yes\"),\"Yes\",AND(I14:I20=\"\"),\"\",TRUE,\"No\")","v":""}]
[]
[null,null,null,null,null,"Answer","Confidence level"]
["Estimated total volume of the residues from metallurgical origin (m³) in deposit 3 ①"]
["Estimated surface occupied by deposit 3 (m²) ①"]
["Are the residues clearly separated from each other, or mixed? ①"]
["Current use of this surface, regardless of the official use of deposit 3 ①"]
[]
["Exploitation/production period"]
[]
["Beginning date"]
["End date"]
[]
["Waste deposit location:*"]
[]
["Point 1","x coord",null,null,"y coord"]
["Point 2","x coord",null,null,"y coord"]
["Point 3","x coord",null,null,"y coord"]
["Point 4","x coord",null,null,"y coord"]
["*Estimated GPS coordinates (WGS) of deposit zone (4 points)"]
[]
[]
["Deposit 3 technical information "]
["Specific deposit characteristics "]
[]
["Origin of the metallurgical waste"]
["Estimated average thickness (m) ②"]
["Estimated average height (above ground) (m)"]
["Estimated average depth (below ground) (m)"]
["Main water content of the excavated materials (above water table) (%)"]
["Estimated proportion of large and hard exogenous material in the deposit",null,null," ②"]
[]
["Estimated homogeneity ②",null,null,null,null,null,"Warning: \"Heterogeneous at small scale\" is linked to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Proportion of hard material (IS>3MPa) in the heterogeneous mass ",null,null,"②"]
["Maximum slope ②"]
["Water table ②",null,null,null,null,null,null,null,"Warning: the presence of water is linked to a weaker stability, and therefore it correspond to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Osha classification before excavation (linked with stability, type of material and water table) ②",null,null,null,null,null,null,null,"←"]
["Rock masses hardness ","②"]
["GSI classification","②"]
[]
["Rehabilitation status "]
[]
["Rehabilitation status of the surface occupied by deposit 3"]
["Sampling results"]
["Visually observable contamination"]
["Odour perception"]
["Presence of physical barriers to prevent pollutant dispersal"]
["Which physical barrier?"]
["Top layer"]
["Presence of a cover layer at the top "]
["Type of cover layer ","②",null,null,null,"Mineral cover"]
["Watertightness layer"]
["Rainwater drainage"]
["Gas drainage"]
[]
["Bottom layer"]
["Presence of a bottom layer"]
["Watertightness layer"]
["Leachate drainage layer"]
[]
["Describe any changes in cover over time"]
[]
["Leachates and drainage"]
[]
["Presence of  water/ leachates table that can freely flow during works"]
["Water table depth (m)"]
["Presence of a drainage system"]
["Presence of a leachates treatment plant on site"]
["Presence of a leachates treatment plant nearby"]
[]
["Monitoring, gas and other technical information"]
[]
["Presence of a monitoring system still in use?"]
["Specify what is monitored (e.g. air, groundwater, surface water, biodiversity)"]
["Presence of biogas ②"]
["Presence of venting system"]
["Presence of monitoring wells"]
[]
["Presence of pipes"]
["Presence of tanks"]
["Presence of cables"]
["Presence of aerial electric lines "]
["Presence of large structure, foundations or underground building (infrastructure)"]
["Presence of sewers"]
["Presence of canals"]
["Presence of available access roads (for trucks)"]
["Nature and condition of the pavement:"]
[]
[]
["Environmental context"]
["Risk evaluation"]
[]
["Flood risk"]
["Fire risk"]
["Risk of collapse"]
["Risk of person accident"]
["Risk of direct exposition to hazardous substances, leachates or waste"]
["Erosion risk"]
["Air emission risk (e.g. biogas, industrial gas, dust) ②"]
["Other risk"]
["Which type of risk?"]
["Specific environmental issue (if it exist)"]
["Impact of the rehabilitation project on the environment"]
[]
["Type of waste",null,"Presence in deposit 3 ②","Main Physical state","% (weight)","Total weight (T)","Estimated volume (m³)","Bulk Density (T/m³)"]
["Hazardous waste","Radioactive waste",null,null,null,null,null,{"$f":"IF(G126>0,F126/G126,\"\")","v":""}]
[null,"Hospital waste",null,null,null,null,null,{"$f":"IF(G127>0,F127/G127,\"\")","v":""}]
[null,"Military waste",null,null,null,null,null,""]
[null,"Asbestos",null,null,null,null,null,""]
[null,"Tanks containing liquids",null,null,null,null,null,""]
[null,"Other: please specify here",null,null,null,null,null,""]
[null,"TOTAL",{"$f":"_xlfn.IFS(OR(C126:C131=\"Assessed\"),\"Assessed\",AND(AND(C126:C131<>\"Assessed\"),OR(C126:C131=\"Possible\")),\"Possible\",AND(C126:C131=\"\"),\"\",TRUE,\"None\")","v":""},null,{"$f":"SUM(E126:E131)","v":0},{"$f":"SUM(F126:F131)","v":0},{"$f":"SUM(G126:G131)","v":0},{"$f":"IF(ISERROR(AVERAGE(H126:H131)),0,AVERAGE(H126:H131))","v":0}]
[]
["Surface water and groundwater vulnerability"]
[]
["Surface water vulnerability"]
["Groundwater vulnerability"]
["Groundwater exploitation"]
["Drinking water protection zone"]
["Level of upper groundwater table (meter below ground level)"]
["Leachates production"]
[]
["Geological information"]
[]
["Bedrock description"]
["Geological context"]
[]
["Soil and topsoil information"]
[]
["Presence of a topsoil layer on the top of the deposit ②"]
["Thickness of the topsoil layer (m) ",null,"②"]
["Main soil texture ","②"]
["Permeability"]
["Free description"]
[]
["Biodiversity"]
[]
["Valuable biodiversity on site"]
["Description of the valuable biodiversity"]
["Is the site located in a Natura 2000 zone?"]

{"sheet":"Deposit 4","index":6,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":true,"merged":[[42,0,42,9],[1,9,1,10],[7,0,7,3],[9,0,9,9],[10,0,10,9],[14,2,19,2],[23,0,23,4],[24,0,24,3],[26,0,26,3],[28,0,28,9],[33,0,33,9],[6,2,6,10],[112,5,112,6],[43,0,43,9],[50,0,50,2],[52,6,52,9],[54,5,54,7],[55,5,55,7],[55,8,55,9],[56,0,56,2],[56,5,56,7],[60,0,60,9],[80,3,80,6],[109,0,109,9],[136,5,136,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[135,5,135,6],[158,4,158,6],[137,5,137,6],[138,5,138,6],[139,5,139,6],[140,5,140,6],[144,2,144,6],[145,2,145,6],[149,5,149,6],[152,5,152,6],[153,5,153,6],[150,5,150,6],[151,5,151,6]]}
[]
[null,null,null,"DEPOSIT (Homogeneous volume) 4",null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,null,"②NWE-SMARTX questions"]
[]
["Name of deposit 4"]
["Description of deposit 4"]
["Current occupation of deposit 4 compared to all volume of deposit (%)"]
[]
["Main description"]
["General information "]
[]
["Type of  residues from metallurgical origin","Presence in deposit 4 ①","Confidence ①","Main Physical state","% (weight)","Total weight (T) ②","Estimated volume (m³)","Bulk Density (T/m³) ②","Waste hazardness (Heavy metals, PAHs, Hydrocarbons) ② "]
["Slag",null,null,null,null,{"$f":"IF('Deposit 4'!G14>0,'Deposit 4'!H14*'Deposit 4'!G14,\"\")","v":""},null,""]
["Metal scraps",null,"↑ please only indicate confidence just above for all types of residues",null,null,{"$f":"IF('Deposit 4'!G15>0,'Deposit 4'!H15*'Deposit 4'!G15,\"\")","v":""}]
["Ashes",null,null,null,null,{"$f":"IF('Deposit 4'!G16>0,'Deposit 4'!H16*'Deposit 4'!G16,\"\")","v":""}]
["Dust",null,null,null,null,{"$f":"IF('Deposit 4'!G17>0,'Deposit 4'!H17*'Deposit 4'!G17,\"\")","v":""}]
["Sludges",null,null,null,null,{"$f":"IF('Deposit 4'!G18>0,'Deposit 4'!H18*'Deposit 4'!G18,\"\")","v":""}]
["Refractories",null,null,null,null,{"$f":"IF('Deposit 4'!G19>0,'Deposit 4'!H19*'Deposit 4'!G19,\"\")","v":""},null,""]
["None from the list",null,null,null,null,{"$f":"IF('Deposit 4'!G20>0,'Deposit 4'!H20*'Deposit 4'!G20,\"\")","v":""},null,""]
["Total",null,null,null,{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,{"$f":"_xlfn.IFS(OR(I14:I20=\"Yes\"),\"Yes\",AND(I14:I20=\"\"),\"\",TRUE,\"No\")","v":""}]
[]
[null,null,null,null,null,"Answer","Confidence level"]
["Estimated total volume of the residues from metallurgical origin (m³) in deposit 4 ①"]
["Estimated surface occupied by deposit 4 (m²) ①"]
["Are the residues clearly separated from each other, or mixed? ①"]
["Current use of this surface, regardless of the official use of deposit 4 ①"]
[]
["Exploitation/production period"]
[]
["Beginning date"]
["End date"]
[]
["Waste deposit location:*"]
[]
["Point 1","x coord",null,null,"y coord"]
["Point 2","x coord",null,null,"y coord"]
["Point 3","x coord",null,null,"y coord"]
["Point 4","x coord",null,null,"y coord"]
["*Estimated GPS coordinates (WGS) of deposit zone (4 points)"]
[]
[]
["Deposit 4 technical information "]
["Specific deposit characteristics "]
[]
["Origin of the metallurgical waste"]
["Estimated average thickness (m) ②"]
["Estimated average height (above ground) (m)"]
["Estimated average depth (below ground) (m)"]
["Main water content of the excavated materials (above water table) (%)"]
["Estimated proportion of large and hard exogenous material in the deposit",null,null," ②"]
[]
["Estimated homogeneity ②",null,null,null,null,null,"Warning: \"Heterogeneous at small scale\" is linked to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Proportion of hard material (IS>3MPa) in the heterogeneous mass ",null,null,"②"]
["Maximum slope ②"]
["Water table ②",null,null,null,null,null,null,null,"Warning: the presence of water is linked to a weaker stability, and therefore it correspond to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Osha classification before excavation (linked with stability, type of material and water table) ②",null,null,null,null,null,null,null,"←"]
["Rock masses hardness ","②"]
["GSI classification","②"]
[]
["Rehabilitation status "]
[]
["Rehabilitation status of the surface occupied by deposit 4"]
["Sampling results"]
["Visually observable contamination"]
["Odour perception"]
["Presence of physical barriers to prevent pollutant dispersal"]
["Which physical barrier?"]
["Top layer"]
["Presence of a cover layer at the top "]
["Type of cover layer ","②",null,null,null,"Mineral cover"]
["Watertightness layer"]
["Rainwater drainage"]
["Gas drainage"]
[]
["Bottom layer"]
["Presence of a bottom layer"]
["Watertightness layer"]
["Leachate drainage layer"]
[]
["Describe any changes in cover over time"]
[]
["Leachates and drainage"]
[]
["Presence of  water/ leachates table that can freely flow during works"]
["Water table depth (m)"]
["Presence of a drainage system"]
["Presence of a leachates treatment plant on site"]
["Presence of a leachates treatment plant nearby"]
[]
["Monitoring, gas and other technical information"]
[]
["Presence of a monitoring system still in use?"]
["Specify what is monitored (e.g. air, groundwater, surface water, biodiversity)"]
["Presence of biogas ②"]
["Presence of venting system"]
["Presence of monitoring wells"]
[]
["Presence of pipes"]
["Presence of tanks"]
["Presence of cables"]
["Presence of aerial electric lines "]
["Presence of large structure, foundations or underground building (infrastructure)"]
["Presence of sewers"]
["Presence of canals"]
["Presence of available access roads (for trucks)"]
["Nature and condition of the pavement:"]
[]
[]
["Environmental context"]
["Risk evaluation"]
[]
["Flood risk"]
["Fire risk"]
["Risk of collapse"]
["Risk of person accident"]
["Risk of direct exposition to hazardous substances, leachates or waste"]
["Erosion risk"]
["Air emission risk (e.g. biogas, industrial gas, dust) ②"]
["Other risk"]
["Which type of risk?"]
["Specific environmental issue (if it exist)"]
["Impact of the rehabilitation project on the environment"]
[]
["Type of waste",null,"Presence in deposit 4  ②","Main Physical state","% (weight)","Total weight (T)","Estimated volume (m³)","Bulk Density (T/m³)"]
["Hazardous waste","Radioactive waste",null,null,null,null,null,{"$f":"IF(G126>0,F126/G126,\"\")","v":""}]
[null,"Hospital waste",null,null,null,null,null,{"$f":"IF(G127>0,F127/G127,\"\")","v":""}]
[null,"Military waste",null,null,null,null,null,""]
[null,"Asbestos",null,null,null,null,null,""]
[null,"Tanks containing liquids",null,null,null,null,null,""]
[null,"Other: please specify here",null,null,null,null,null,""]
[null,"TOTAL",{"$f":"_xlfn.IFS(OR(C126:C131=\"Assessed\"),\"Assessed\",AND(AND(C126:C131<>\"Assessed\"),OR(C126:C131=\"Possible\")),\"Possible\",AND(C126:C131=\"\"),\"\",TRUE,\"None\")","v":""},null,{"$f":"SUM(E126:E131)","v":0},{"$f":"SUM(F126:F131)","v":0},{"$f":"SUM(G126:G131)","v":0},{"$f":"IF(ISERROR(AVERAGE(H126:H131)),0,AVERAGE(H126:H131))","v":0}]
[]
["Surface water and groundwater vulnerability"]
[]
["Surface water vulnerability"]
["Groundwater vulnerability"]
["Groundwater exploitation"]
["Drinking water protection zone"]
["Level of upper groundwater table (meter below ground level)"]
["Leachates production"]
[]
["Geological information"]
[]
["Bedrock description"]
["Geological context"]
[]
["Soil and topsoil information"]
[]
["Presence of a topsoil layer on the top of the deposit ②"]
["Thickness of the topsoil layer (m) ",null,"②"]
["Main soil texture ","②"]
["Permeability"]
["Free description"]
[]
["Biodiversity"]
[]
["Valuable biodiversity on site"]
["Description of the valuable biodiversity"]
["Is the site located in a Natura 2000 zone?"]

{"sheet":"Deposit 5","index":7,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":true,"merged":[[42,0,42,9],[1,9,1,10],[7,0,7,3],[9,0,9,9],[10,0,10,9],[14,2,19,2],[23,0,23,4],[24,0,24,3],[26,0,26,3],[28,0,28,9],[33,0,33,9],[6,2,6,10],[112,5,112,6],[43,0,43,9],[50,0,50,2],[52,6,52,9],[54,5,54,7],[55,5,55,7],[55,8,55,9],[56,0,56,2],[56,5,56,7],[60,0,60,9],[80,3,80,6],[109,0,109,9],[136,5,136,6],[113,5,113,6],[114,5,114,6],[115,5,115,6],[116,5,116,6],[117,5,117,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[121,5,121,6],[122,5,122,6],[135,5,135,6],[158,4,158,6],[137,5,137,6],[138,5,138,6],[139,5,139,6],[140,5,140,6],[144,2,144,6],[145,2,145,6],[149,5,149,6],[152,5,152,6],[153,5,153,6],[150,5,150,6],[151,5,151,6]]}
[]
[null,null,null,"DEPOSIT (Homogeneous volume) 5",null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,"①SMART PHOENIX questions"]
[null,null,null,null,null,null,null,null,null,"②NWE-SMARTIX questions"]
[]
["Name of deposit 5"]
["Description of deposit 5"]
["Current occupation of deposit 5 compared to all volume of deposit (%)"]
[]
["Main description"]
["General information "]
[]
["Type of  residues from metallurgical origin","Presence in deposit 5 ①","Confidence ①","Main Physical state","% (weight)","Total weight (T) ②","Estimated volume (m³)","Bulk Density (T/m³) ②","Waste hazardness (Heavy metals, PAHs, Hydrocarbons) ② "]
["Slag",null,null,null,null,{"$f":"IF('Deposit 5'!G14>0,'Deposit 5'!H14*'Deposit 5'!G14,\"\")","v":""},null,""]
["Metal scraps",null,"↑ please only indicate confidence just above for all types of residues",null,null,{"$f":"IF('Deposit 5'!G15>0,'Deposit 5'!H15*'Deposit 5'!G15,\"\")","v":""}]
["Ashes",null,null,null,null,{"$f":"IF('Deposit 5'!G16>0,'Deposit 5'!H16*'Deposit 5'!G16,\"\")","v":""}]
["Dust",null,null,null,null,{"$f":"IF('Deposit 5'!G17>0,'Deposit 5'!H17*'Deposit 5'!G17,\"\")","v":""}]
["Sludges",null,null,null,null,{"$f":"IF('Deposit 5'!G18>0,'Deposit 5'!H18*'Deposit 5'!G18,\"\")","v":""}]
["Refractories",null,null,null,null,{"$f":"IF('Deposit 5'!G19>0,'Deposit 5'!H19*'Deposit 5'!G19,\"\")","v":""},null,""]
["None from the list",null,null,null,null,{"$f":"IF('Deposit 5'!G20>0,'Deposit 5'!H20*'Deposit 5'!G20,\"\")","v":""},null,""]
["Total",null,null,null,{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,{"$f":"_xlfn.IFS(OR(I14:I20=\"Yes\"),\"Yes\",AND(I14:I20=\"\"),\"\",TRUE,\"No\")","v":""}]
[]
[null,null,null,null,null,"Answer","Confidence level"]
["Estimated total volume of the residues from metallurgical origin (m³) in deposit 5 ①"]
["Estimated surface occupied by deposit 5 (m²) ①"]
["Are the residues clearly separated from each other, or mixed? ①"]
["Current use of this surface, regardless of the official use of deposit 5 ①"]
[]
["Exploitation/production period"]
[]
["Beginning date"]
["End date"]
[]
["Waste deposit location:*"]
[]
["Point 1","x coord",null,null,"y coord"]
["Point 2","x coord",null,null,"y coord"]
["Point 3","x coord",null,null,"y coord"]
["Point 4","x coord",null,null,"y coord"]
["*Estimated GPS coordinates (WGS) of deposit zone (4 points)"]
[]
[]
["Deposit 5 technical information "]
["Specific deposit characteristics "]
[]
["Origin of the metallurgical waste"]
["Estimated average thickness (m) ②"]
["Estimated average height (above ground) (m)"]
["Estimated average depth (below ground) (m)"]
["Main water content of the excavated materials (above water table) (%)"]
["Estimated proportion of large and hard exogenous material in the deposit",null,null," ②"]
[]
["Estimated homogeneity ②",null,null,null,null,null,"Warning: \"Heterogeneous at small scale\" is linked to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Proportion of hard material (IS>3MPa) in the heterogeneous mass ",null,null,"②"]
["Maximum slope ②"]
["Water table ②",null,null,null,null,null,null,null,"Warning: the presence of water is linked to a weaker stability, and therefore it correspond to an Osha type C classification. Please answer accordingly in the proper space (marqued by ←)"]
["Osha classification before excavation (linked with stability, type of material and water table) ②",null,null,null,null,null,null,null,"←"]
["Rock masses hardness ","②"]
["GSI classification","②"]
[]
["Rehabilitation status "]
[]
["Rehabilitation status of the surface occupied by deposit 5"]
["Sampling results"]
["Visually observable contamination"]
["Odour perception"]
["Presence of physical barriers to prevent pollutant dispersal"]
["Which physical barrier?"]
["Top layer"]
["Presence of a cover layer at the top "]
["Type of cover layer ","②"]
["Watertightness layer"]
["Rainwater drainage"]
["Gas drainage"]
[]
["Bottom layer"]
["Presence of a bottom layer"]
["Watertightness layer"]
["Leachate drainage layer"]
[]
["Describe any changes in cover over time"]
[]
["Leachates and drainage"]
[]
["Presence of  water/ leachates table that can freely flow during works"]
["Water table depth (m)"]
["Presence of a drainage system"]
["Presence of a leachates treatment plant on site"]
["Presence of a leachates treatment plant nearby"]
[]
["Monitoring, gas and other technical information"]
[]
["Presence of a monitoring system still in use?"]
["Specify what is monitored (e.g. air, groundwater, surface water, biodiversity)"]
["Presence of biogas ②"]
["Presence of venting system"]
["Presence of monitoring wells"]
[]
["Presence of pipes"]
["Presence of tanks"]
["Presence of cables"]
["Presence of aerial electric lines "]
["Presence of large structure, foundations or underground building (infrastructure)"]
["Presence of sewers"]
["Presence of canals"]
["Presence of available access roads (for trucks)"]
["Nature and condition of the pavement:"]
[]
[]
["Environmental context"]
["Risk evaluation"]
[]
["Flood risk"]
["Fire risk"]
["Risk of collapse"]
["Risk of person accident"]
["Risk of direct exposition to hazardous substances, leachates or waste"]
["Erosion risk"]
["Air emission risk (e.g. biogas, industrial gas, dust) ②"]
["Other risk"]
["Which type of risk?"]
["Specific environmental issue (if it exist)"]
["Impact of the rehabilitation project on the environment"]
[]
["Type of waste",null,"Presence in deposit 5  ②","Main Physical state","% (weight)","Total weight (T)","Estimated volume (m³)","Bulk Density (T/m³)"]
["Hazardous waste","Radioactive waste",null,null,null,null,null,{"$f":"IF(G126>0,F126/G126,\"\")","v":""}]
[null,"Hospital waste",null,null,null,null,null,{"$f":"IF(G127>0,F127/G127,\"\")","v":""}]
[null,"Military waste",null,null,null,null,null,""]
[null,"Asbestos",null,null,null,null,null,""]
[null,"Tanks containing liquids",null,null,null,null,null,""]
[null,"Other: please specify here",null,null,null,null,null,""]
[null,"TOTAL",{"$f":"_xlfn.IFS(OR(C126:C131=\"Assessed\"),\"Assessed\",AND(AND(C126:C131<>\"Assessed\"),OR(C126:C131=\"Possible\")),\"Possible\",AND(C126:C131=\"\"),\"\",TRUE,\"None\")","v":""},null,{"$f":"SUM(E126:E131)","v":0},{"$f":"SUM(F126:F131)","v":0},{"$f":"SUM(G126:G131)","v":0},{"$f":"IF(ISERROR(AVERAGE(H126:H131)),0,AVERAGE(H126:H131))","v":0}]
[]
["Surface water and groundwater vulnerability"]
[]
["Surface water vulnerability"]
["Groundwater vulnerability"]
["Groundwater exploitation"]
["Drinking water protection zone"]
["Level of upper groundwater table (meter below ground level)"]
["Leachates production"]
[]
["Geological information"]
[]
["Bedrock description"]
["Geological context"]
[]
["Soil and topsoil information"]
[]
["Presence of a topsoil layer on the top of the deposit ②"]
["Thickness of the topsoil layer (m) ",null,"②"]
["Main soil texture ","②"]
["Permeability"]
["Free description"]
[]
["Biodiversity"]
[]
["Valuable biodiversity on site"]
["Description of the valuable biodiversity"]
["Is the site located in a Natura 2000 zone?"]

{"sheet":"Data sources","index":8,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[39,0,44,0],[45,0,49,0],[20,0,38,0],[25,1,38,1]]}
[]
[null,"Data sources"]
[]
[]
["This page regroups information on encoding processes and lists the documents and other sources of informations used to complete the NWE-MESIS"]
[]
[]
["Encoding data informations"]
["Date of encoding","Name of encoder/affiliation","Date of most recent document used"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Source documents informations"]
["Name","Content","Content type and sources ","Document 1 name","Link 1","Document name 2","Link2"]
["Historical information","Plan of the site (historical and present)","Historical cartographic or photo-cartographic documents, historical cadastral documents (ancient maps and matrices)"]
[null,"Location of activities on site (past and present)","Historical cartographic or photo-cartographic documents, historical cadastral documents (ancient maps and matrices), in situ visit"]
[null,"\nVisible infrastructure in situ\n","Maps, iconographic documents, in situ visit"]
[null,"\nLocation and/or description of previous excavation\n","Maps, reports"]
[null,"\nExisting databases and inventories\n","Database"]
[null,"Any useful other documentation and archives about the site","Internal oral testimonies (executives, workers, employees)"]
[null,null,"External oral testimonies (residents, subcontractors)"]
[null,null,"Internal factory's archives (company, parent company, subsidiary, business buyer, liquidator)"]
[null,null,"Primary literatures (industrial catalogues, exhibition catalogues, ancient technical publications)"]
[null,null,"Secondary literatures (books or articles about industrial archaeology or local history)"]
[null,null,"Iconographic documents (photos)"]
[null,null,"Other media supports (films, videos..)"]
[null,null,"In situ visit"]
[null,null,"Administrations' archives (DAO [SAR], OWD, DPA, BDES, MET, VH)"]
[null,null,"Municipal archives"]
[null,null,"Environment Police files (DPC)"]
[null,null,"War damages files"]
[null,null,"Mines and Careers Administration files (DRIGM)"]
[null,null,"Other public archives (SNCB, MDN)"]
["Soil investigation","\nDate of soil investigation fieldwork\n","Date"]
[null,"\nType of soil investigation\n","Text"]
[null,"\nLocation of the samples\n","Maps, coord X,Y"]
[null,"\nBorehole description\n","Text"]
[null,"\nLab analysis performed\n","Datasheet"]
[null,"\nResults and interpretation\n","Report"]
["Geotechnical tests","\nDate of geotechnical test on site\n","Date"]
[null,"\nType of geotechnical test\n","Text"]
[null,"\nLocation of the testing\n","Maps, coord X,Y"]
[null,"\nLab analysis performed (if any)\n","Datasheet"]
[null,"\nResults and interpretation\n","Report"]
["Risk assessment","\nLocation of hazardous waste\n","Maps, "]

{"sheet":"SMART PHOENIX","index":9,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[36,16,36,19],[41,17,42,18],[35,1,35,3],[31,1,31,6],[30,1,30,6],[40,2,40,4],[29,1,29,6],[27,1,27,6],[7,0,8,0],[23,1,23,6],[24,1,24,6],[14,10,19,10],[26,1,26,6],[9,1,9,6],[20,1,20,6],[21,1,21,6],[7,7,7,8],[7,9,7,10],[7,1,8,6],[7,15,7,16],[7,11,7,12],[7,13,7,14],[14,12,19,12],[14,14,19,14],[14,16,19,16],[14,18,19,18],[7,17,7,18]]}
[null,null,null,null,null,null,null,null,null,"SMART PHOENIX "]
[null,null,null,null,null,null,null,null,null,"Is your site suitable for resource recovery?"]
[null,"To know what is the estimated value of your site and deposit before investigation, please answer the 16 questions accompanied by \"①\", available either on this excel sheet or dispersed in the entire excel."]
[null,"Note: The default score for an unanswered question is set automatically to 0. To ensure that the score obtained is as representative as possible, please complete all questions and confidence before taking it into account."]
[]
[null,"How many deposit (homogeneous volume) are there on the site?",null,null,null,null,1]
[]
["N°","QUESTIONS",null,null,null,null,null,"SITE",null,"DEPOSIT 1",null,"DEPOSIT 2",null,"DEPOSIT 3",null,"DEPOSIT 4",null,"DEPOSIT 5"]
[null,null,null,null,null,null,null,"Answer","Confidence","Answer","Confidence","Answer","Confidence","Answer","Confidence","Answer","Confidence","Answer","Confidence"]
[1,"Does the site contain a landfill, deposit or backfill with significant amount of metallic residues (mainly Pb, Cu, Zn and Fe)? ①"]
[2,"Is the site a PMSD*?①"]
[3,"Is the site registered in a database?①"]
[4,"What main kind of residues (from metallurgical origin) are present? ①"]
[null,"Slag"]
[null,"Metal scraps",null,null,null,null,null,null,null,null,"↑ please only indicate confidence just above for all types of residues",null,"↑ please only indicate confidence just above for all types of residues",null,"↑ please only indicate confidence just above for all types of residues",null,"↑ please only indicate confidence just above for all types of residues",null,"↑ please only indicate confidence just above for all types of residues"]
[null,"Ashes"]
[null,"Dust"]
[null,"Sludges"]
[null,"Refractories"]
[null,"None from the list"]
[5,"Estimated total volume of the residues from metallurgical origin (m³) in the deposit  ①"]
[6,"Estimated surface occupied by the deposit (m²) ①"]
[7,"Are the residues clearly separated from each other, or mixed? ①"]
[8,"Surface occupied by constructions:①"]
[9,"Surface occupied by trees:①"]
[10,"Is there historical data available?①"]
[11,"Is the site easy to access for trucks and heavy equipment?①"]
[12,"Is the site considered as hazardous?①"]
[13,"Must the site / an area of the site be rehabilitated?①"]
[14,"Is there a known interest for the reconversion of the site (public or private projects/interests) ?①"]
[15,"Surface occupied by low vegetation:①"]
[16,"Current use of this surface, regardless of the official use of the deposit ①"]
[]
[null,"*Past Metallurgical Sites and Deposits (PMSD) are either 1) sites where a metallurgical activity took place at some time, or 2) sites that contain a deposit of metallurgical origin."]
[]
[null,"YOUR SCORE: "]
[null,null,null,null,null,"DEPOSIT 1 ",null,"DEPOSIT 2",null,"DEPOSIT 3",null,"DEPOSIT 4",null,"DEPOSIT 5",null,null,"LEGEND : Score above which the site has an interesting recovery potential"]
[null,null,null,null,null,"SCORE","RATING (%)","SCORE","RATING (%)","SCORE","RATING (%)","SCORE","RATING (%)","SCORE","RATING (%)",null,null,"Metal",">450"]
[null,null,"METAL recovery potential score",null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!$CS$10","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!$CU$10","v":0},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CS15,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>1,'Smart-Phoenix_Calculation_mask'!$CU15,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CS20,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>2,'Smart-Phoenix_Calculation_mask'!$CU20,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CS25,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>3,'Smart-Phoenix_Calculation_mask'!$CU25,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CS30,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>4,'Smart-Phoenix_Calculation_mask'!$CU30,\"\")","v":""},null,null,"Mineral ",">450"]
[null,null,"MINERAL recovery potential score",null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!$CS$11","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!$CU$11","v":0},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CS16,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>1,'Smart-Phoenix_Calculation_mask'!$CU16,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CS21,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>2,'Smart-Phoenix_Calculation_mask'!$CU21,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CS26,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>3,'Smart-Phoenix_Calculation_mask'!$CU26,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CS31,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>4,'Smart-Phoenix_Calculation_mask'!$CU31,\"\")","v":""},null,null,"Soil ",">100"]
[null,null,"SOIL improvement (for the growing of ecocatalyst) potential score",null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!$CS$12","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!$CU$12","v":0},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CS17,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>1,'Smart-Phoenix_Calculation_mask'!$CU17,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CS22,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>2,'Smart-Phoenix_Calculation_mask'!$CU22,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CS27,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>3,'Smart-Phoenix_Calculation_mask'!$CU27,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CS32,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>4,'Smart-Phoenix_Calculation_mask'!$CU32,\"\")","v":""},null,null,"Ecocatalyst",">200"]
[null,null,"ECOCATALYST production potential score",null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!$CS$13","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!$CU$13","v":0},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CS18,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>1,'Smart-Phoenix_Calculation_mask'!$CU18,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CS23,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>2,'Smart-Phoenix_Calculation_mask'!$CU23,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CS28,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>3,'Smart-Phoenix_Calculation_mask'!$CU28,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CS33,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7>4,'Smart-Phoenix_Calculation_mask'!$CU33,\"\")","v":""},null,null,"TOTAL SCORE"]
[]
[null,null,"TOTAL SCORE",null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!$CS$9","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!$CU$9","v":0},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CS$14,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >1,'Smart-Phoenix_Calculation_mask'!$CU$14,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CS$19,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >2,'Smart-Phoenix_Calculation_mask'!$CU$19,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CS$24,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >3,'Smart-Phoenix_Calculation_mask'!$CU$24,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CS$29,\"\")","v":""},{"$f":"IF('Surrounding and site'!$E$7 >4,'Smart-Phoenix_Calculation_mask'!$CU$29,\"\")","v":""},null,null,"Bad","0 - 2100"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medium",">2100"]
[null,null,null,null,"CONFIDENCE LEVEL",null,{"$f":"'Smart-Phoenix_Calculation_mask'!CT9","v":0},null,{"$f":"IF('Surrounding and site'!$E$7>1,'Smart-Phoenix_Calculation_mask'!CT14,\"\")","v":""},null,{"$f":"IF('Surrounding and site'!$E$7>2,'Smart-Phoenix_Calculation_mask'!CT19,\"\")","v":""},null,{"$f":"IF('Surrounding and site'!$E$7>3,'Smart-Phoenix_Calculation_mask'!CT24,\"\")","v":""},null,{"$f":"IF('Surrounding and site'!$E$7>4,'Smart-Phoenix_Calculation_mask'!CT29,\"\")","v":""},null,null,"Good",">3000"]
[]
[null,null,"WARNING: Make sure your confidence level is high enough in order to ensure your score is meaningful!"]
[null,null,null,null,null,null,null,"DEPOSIT 1","DEPOSIT 2","DEPOSIT 3","DEPOSIT 4","DEPOSIT 5"]
[null,null,"number of questions whose confidence is below or equal to 50%",null,null,null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!DA10","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!DA15","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!DA20","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!DA25","v":0},{"$f":"'Smart-Phoenix_Calculation_mask'!DA30","v":0}]
[null,null,"number of questions whose confidence is not indicated",null,null,null,null,{"$f":"'Smart-Phoenix_Calculation_mask'!DA11","v":15},{"$f":"'Smart-Phoenix_Calculation_mask'!DA16","v":15},{"$f":"'Smart-Phoenix_Calculation_mask'!DA21","v":15},{"$f":"'Smart-Phoenix_Calculation_mask'!DA26","v":15},{"$f":"'Smart-Phoenix_Calculation_mask'!DA31","v":15}]

{"sheet":"données (à masquer)","index":10,"n_rows":126,"n_cols":4,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
["General","sheet1 PMSD ID","Surrounding and site","Deposit "]
[null,"use"]
["Yes","Abandoned (without protected area)","Yes, from environmental/ legal aspects","Separated"]
["No","Abandoned (with protected area)","Yes, from others aspects (urban planning, biodiversity, etc.)","Mixed"]
["Unknown","Activities still present (industry, use by people, etc.)","No","Physical state"]
["confidence","Activities",null,"Solids (rock, gravel)"]
["Very high (100%)","Residential use","0 to 50% ","Powdered (fine particles)"]
["High (75%)","Recreational use","50 to 75%","Ashes"]
["Medium (50%)","Commercial use",">75%","Liquids"]
["Low (25%)","Industrial use","vegetation","Sludge"]
["I do not know (0%)","Natural reforestation with added value","0 to 25%","Presence"]
[null,"Natural reforestation without added value","25 to 50%","Assessed"]
[null,"Cultivation (crop, biomass)",">50%","Possible"]
[null,"Use for renewable energies","access to truck and heavy equipment","None"]
[null,"Others","Easy to access to the site and on the site","Unknown"]
[null,"public or private","Easy to access to the site but not on the site"]
[null,"Public","Not easy to access to the site but accessible on the site","Low"]
[null,"Private","Not accessible","Medium "]
[null,"Both","Hazardous","High"]
[null,"Unknown","Low risk (no industrial activity identified and no pollution)","Unknown"]
[null,"owner or operator","Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)","Risk assessment"]
[null,"Owner","High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)","High"]
[null,"Operator","Unknown","Serious"]
[null,"Both owner and operator","Remediation type","Medium "]
[null,null,"Total dig and dump/ total excavation and ex situ remediation","Low"]
[null,null,"Partial dig and dump/ partial excavation","Eliminated"]
[null,null,"Capping (watertight)","impact"]
[null,null,"Hydraulic capping","Positive "]
[null,null,"Special on-site or in-situ techniques (bio, physico-chemical, thermal)","Negative"]
[null,null,"Other","Neutral"]
[null,null,"industry","Unknown"]
[null,null,"Metallurgy","groundwater"]
[null,null,"Steel industry","Exploited"]
[null,null,"Iron factory","Not exploited"]
[null,null,"Blast furnace","water"]
[null,null,"Foundry","Contaminated (estimated)"]
[null,null,"Steelworks","Contaminated (measured)"]
[null,null,"Forges","High risk of contamination"]
[null,null,"Rolling mill","Medium risk of contamination"]
[null,null,"Coke oven","Low risk of contamination"]
[null,null,"Coke factory","No risk of contamination"]
[null,null,"Pyrometallurgy","Unknown"]
[null,null,"Hydrometallurgy","drinking water area"]
[null,null,"Metal preparation","Yes (close protection zone)"]
[null,null,"Metal transformation","Yes (extended protection zone"]
[null,null,"Other","No"]
[]
[null,null,"Zn","Rehabilitated"]
[null,null,"Cu","Necessary to rehabilitate"]
[null,null,"Fe","Not necessary to rehabilitate"]
[null,null,"Co"]
[null,null,"Cd","Highly permeable soil/rock"]
[null,null,"Pb","Medium"]
[null,null,"Hg","Low"]
[null,null,"As","Watertight layer"]
[null,null,"Ni","erosion"]
[null,null,"Al","None"]
[null,null,"Sb","Weak"]
[null,null,"Se","Severe"]
[null,null,"Cr","Potential"]
[null,null,"Mn"]
[null,null,"Mo","Steep slopes (more than 25% (≈15°))"]
[null,null,"Rare earth","Gentle slopes (less than 25% (≈15°))"]
[null,null,"Other"]
[null,null,null,"Deposit >1m above the water table"]
[null,null,"Existence of a redevelopment project nearby","Deposit fairly submerged (<5m) by the water table or just above the water table (<1m)"]
[null,null,"No project","Deposit partially (≥5m height) or totally submerged by the water table"]
[null,null,"Unknown","Osha"]
[null,null,null,"Stable rocks, e.g. rock masses"]
[null,null,"Present","Type A, e.g. clay, silty clay, sandy clay, and clay loam type of soil"]
[null,null,"Not present","Type B, e.g. unstable rocks, silt, silt loam, sandy loam and medium clays type of soil"]
[null,null,"Potential","Type C, e.g. granular soils (gravel, sand and loamy sand), submerged soil, soil from which water is freely seeping, submerged rocks that are not stable"]
[null,null,"Not potential","exogenous"]
[null,null,"urgency remediation","≤5%"]
[null,null,"High",">5%"]
[null,null,"Medium","layers"]
[null,null,"Low","Presence of a watertightness layer"]
[null,null,null,"No specific watertightness layer "]
[null,null,0]
[null,null,1,"Presence of a rainwater drainage layer"]
[null,null,2,"No specific rainwater drainage layer"]
[null,null,3]
[null,null,4,"Presence of a gas drainage layer"]
[null,null,5,"No specific gas drainage layer"]
[null,null,">5"]
[null,null,null,"Presence of a leachate drainage layer"]
[null,null,"Rare vegetation","No specific leachate drainage layer"]
[null,null,"Medium vegetation"]
[null,null,"Dense vegetation","Geomembrane"]
[null,null,null,"Mineral cover"]
[null,null,null,"Soil "]
[null,null,null,"Waste"]
[null,null,null,"Other"]
[]
[null,null,null,"External "]
[null,null,null,"Produced on site"]
[null,null,null,"Other"]
[]
[null,null,null,"Impervious vertical wall"]
[null,null,null,"Drainage vertical wall"]
[null,null,null,"Subhorizontal layer (mineral, geosynthetic, mixed)"]
[null,null,null,"Several types"]
[null,null,null,"Other"]
[]
[null,null,null,"Sampling results available"]
[null,null,null,"No sampling results available"]
[]
[null,null,null,"Homogeneous at small scale "]
[null,null,null,"Heterogeneous at small scale"]
[null,null,null,"Homogeneous "]
[null,null,null,"Soil"]
[null,null,null,"Gravel"]
[null,null,null,"Rock masses"]
[null,null,null,"Heterogeneous "]
[null,null,null,">50% hard material (IS>3MPa)"]
[null,null,null,"<50% hard material (IS>3MPa)"]
[]
[null,null,null,"IS>3MPa"]
[null,null,null,"IS≤3MPa"]
[]
[null,null,null,"Clay"]
[null,null,null,"Sandy"]
[null,null,null,"Silty"]
[null,null,null,"Peaty"]
[null,null,null,"Chalky "]
[null,null,null,"Loamy"]

{"sheet":"Smart-Phoenix_Calculation_mask","index":11,"n_rows":33,"n_cols":109,"rows_kept":33,"cut":false,"hidden":true,"merged":[[6,2,6,6],[6,10,6,14],[6,15,6,24],[6,25,6,30],[0,96,0,97],[6,31,6,36],[6,37,6,41],[6,42,6,47],[6,48,6,53],[6,54,6,58],[6,59,6,65],[6,7,6,9],[6,66,6,71],[6,72,6,77],[6,78,6,82],[6,83,6,88],[0,98,0,99],[0,101,0,104],[0,105,0,107],[1,95,3,95],[6,89,6,94]]}
[null,"Weight metals",null,null,120,20,null,200,0,null,null,null,10,0,null,null,null,100,400,0,75,50,0,0,null,null,null,0,50,100,null,null,null,10,10,10,null,null,null,20,-10,null,null,null,20,-10,-20,null,null,null,20,-10,-20,null,null,null,20,-20,null,null,null,null,null,20,0,null,null,null,20,20,-20,null,null,null,20,20,10,null,null,null,10,0,null,null,null,0,0,0,null,null,null,20,-10,-20,null,null,"Threshold total score",null,"Threshold by category of mat",null,null,"color legend for fictive sites (number 1 to 8)",null,null,null,"color legend for real sites (Spaque",null,null,"For real sites: Justification based on imagination/estimation"]
[null,"Weight minerals",null,null,120,20,null,200,0,null,null,null,10,0,null,null,null,100,0,75,75,25,400,0,null,null,null,0,50,100,null,null,null,10,10,10,null,null,null,20,-10,null,null,null,20,-10,-20,null,null,null,20,-10,-20,null,null,null,20,-20,null,null,null,null,null,20,0,null,null,null,20,20,-20,null,null,null,20,20,10,null,null,null,10,0,null,null,null,0,0,0,null,null,null,20,-10,-20,null,"Potentially","Bad","0 - 2100","Metal",">450",null,null,"totally bad for all 4 categories of materials",null,null,null,"relatively good (in general)"]
[null,"Weight soil",null,null,0,0,null,0,0,null,null,null,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,0,0,0,null,null,null,10,10,10,null,null,null,0,0,null,null,null,20,-10,-20,null,null,null,20,-10,-20,null,null,null,20,-20,null,null,null,null,null,20,0,null,null,null,20,20,0,null,null,null,10,10,20,null,null,null,0,10,null,null,null,30,45,60,null,null,null,20,-10,-20,null,null,"Medium",">2100","Minerals",">450",null,null,"good for 1 category of material",null,null,null,"medium good (in general)"]
[null,"Weight ecocat",null,null,0,0,null,200,0,null,null,null,0,0,null,null,null,0,0,0,0,0,0,0,null,null,null,0,0,0,null,null,null,0,20,20,null,null,null,0,0,null,null,null,20,-10,-20,null,null,null,20,-10,-20,null,null,null,20,-20,null,null,null,null,null,20,0,null,null,null,20,20,0,null,null,null,10,10,20,null,null,null,0,10,null,null,null,30,45,60,null,null,null,20,-10,-20,null,null,"Good",">3000","Soil",">100",null,null,"good for 2 categories of materials",null,null,null,"relatively bad (in general)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecocatalyst",">200",null,null,"good for 3 categories of materials"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"good for all categories of materials"]
[null,"N° question","1. Does it contain a landfill, a  deposit or a backfill with significant amount of metallic residues (Pb, Cu, Zn, Fe)?",null,null,null,null,"2. Is the site a PMSD?",null,null,"3. Is the site registered in a database/ inventory?",null,null,null,null,"4. What main kind of residues are stored?",null,null,null,null,null,null,null,null,null,"5. Volume of residues (m3)?",null,null,null,null,null,"6. Site area occupied by residues (m2)?",null,null,null,null,null,"7. residues separated?",null,null,null,null,"8. what is the surface still occupied by constructions?",null,null,null,null,null,"9. What is the surface still occupied by trees?",null,null,null,null,null,"10. Is there historical data easily available?",null,null,null,null,"11. easy to access for trucks and heavy equipments?",null,null,null,null,null,null,"12. hazardous/high risk site?",null,null,null,null,null,"13. Must the site be rehabilitated?",null,null,null,null,null,"14. known interest for reconversion?",null,null,null,null,"15. What is the surface still occupied by low vegetation ",null,null,null,null,null,"16. current use?",null,null,null,null,null,null,"Score","Confidence (%)","Rating (%)"]
[null,"Answers","Confidence","Confidence2","Yes","No","Score","Yes","No","Score","Confidence","Confidence2","Yes","No","Score","Confidence","Confidence2","slags","metal scraps","ashes","dust","sludge","refractories","none from the list","Score","Confidence","Confidence2","0-200000","200000-500000",">500000","Score","Confidence","Confidence2","0-10000","10000-100000",">100000","Score","Confidence","Confidence2","separated","mixed","Score","Confidence","Confidence2","0-50","50-75",">75","Score","Confidence","Confidence2","0-50","50-75",">75","Score","Confidence","Confidence2","Yes","No","Score","Confidence","Confidence2","to the site but not on the site","on the site but not to the site","both to the site and on the site","not accessible","Score","Confidence","Confidence2","low","moderated","high","Score","Confidence","Confidence2","Yes, from environmental/legal point of view","Yes, from other point of view (urban planning, biodiversity,…)","No","Score","Confidence","Confidence2","Yes","No","Score","Confidence","Confidence2","0-25","25-50",">50","Score","Confidence","Confidence2","abandoned (no protected area)","abandonned (protected area)","activities still present","Score"]
["Site 1","Deposit 1",{"$f":"_xlfn.IFS('Surrounding and site'!$G$12=\"Very high (100%)\",100,'Surrounding and site'!$G$12=\"High (75%)\",75,'Surrounding and site'!$G$12=\"Medium (50%)\",50,'Surrounding and site'!$G$12=\"Low (25%)\",25,'Surrounding and site'!$G$12=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(C9=\"\",0,TRUE,C9)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"No\",1,0)","v":0},{"$f":"G10+G11+G12+G13","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"Yes\",1,0)","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"No\",1,0)","v":0},{"$f":"J10+J11+J12+J13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$15=\"Very high (100%)\",100,'Surrounding and site'!$G$15=\"High (75%)\",75,'Surrounding and site'!$G$15=\"Medium (50%)\",50,'Surrounding and site'!$G$15=\"Low (25%)\",25,'Surrounding and site'!$G$15=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(K9=\"\",0,TRUE,K9)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"No\",1,0)","v":0},{"$f":"O10+O11+O12+O13","v":0},{"$f":"_xlfn.IFS('Deposit 1'!$C$14=\"Very high (100%)\",100,'Deposit 1'!$C$14=\"High (75%)\",75,'Deposit 1'!$C$14=\"Medium (50%)\",50,'Deposit 1'!$C$14=\"Low (25%)\",25,'Deposit 1'!$C$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(P9=\"\",0,TRUE,P9)","v":0},{"$f":"IF('Deposit 1'!$B$14=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$15=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$16=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$17=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$18=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$19=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 1'!$B$20=\"Yes\",1,0)","v":0},{"$f":"Y10+Y11+Y12+Y13","v":0},{"$f":"_xlfn.IFS('Deposit 1'!$G$24=\"Very high (100%)\",100,'Deposit 1'!$G$24=\"High (75%)\",75,'Deposit 1'!$G$24=\"Medium (50%)\",50,'Deposit 1'!$G$24=\"Low (25%)\",25,'Deposit 1'!$G$24=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(Z9=\"\",0,TRUE,Z9)","v":0},{"$f":"IF(AND('Deposit 1'!$F$24>0,'Deposit 1'!$F$24<=200000),1,0)","v":0},{"$f":"IF(AND('Deposit 1'!$F$24>=200000,'Deposit 1'!$F$24<=500000),1,0)","v":0},{"$f":"IF('Deposit 1'!$F$24>500000,1,0)","v":0},{"$f":"AE10+AE11+AE12+AE13","v":0},{"$f":"_xlfn.IFS('Deposit 1'!$G$25=\"Very high (100%)\",100,'Deposit 1'!$G$25=\"High (75%)\",75,'Deposit 1'!$G$25=\"Medium (50%)\",50,'Deposit 1'!$G$25=\"Low (25%)\",25,'Deposit 1'!$G$25=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AF9=\"\",0,TRUE,AF9)","v":0},{"$f":"IF(AND('Deposit 1'!$F$25>0,'Deposit 1'!$F$25<=10000),1,0)","v":0},{"$f":"IF(AND('Deposit 1'!$F$25>=10000,'Deposit 1'!$F$25<=100000),1,0)","v":0},{"$f":"IF('Deposit 1'!$F$25>100000,1,0)","v":0},{"$f":"AK10+AK11+AK12+AK13","v":0},{"$f":"_xlfn.IFS('Deposit 1'!$G$26=\"Very high (100%)\",100,'Deposit 1'!$G$26=\"High (75%)\",75,'Deposit 1'!$G$26=\"Medium (50%)\",50,'Deposit 1'!$G$26=\"Low (25%)\",25,'Deposit 1'!$G$26=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AL9=\"\",0,TRUE,AL9)","v":0},{"$f":"IF('Deposit 1'!$F$26=\"Separated\",1,0)","v":0},{"$f":"IF('Deposit 1'!$F$26=\"Mixed\",1,0)","v":0},{"$f":"AP10+AP11+AP12+AP13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$18=\"Very high (100%)\",100,'Surrounding and site'!$G$18=\"High (75%)\",75,'Surrounding and site'!$G$18=\"Medium (50%)\",50,'Surrounding and site'!$G$18=\"Low (25%)\",25,'Surrounding and site'!$G$18=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AQ9=\"\",0,TRUE,AQ9)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\">75%\",1,0)","v":0},{"$f":"AV10+AV11+AV12+AV13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$19=\"Very high (100%)\",100,'Surrounding and site'!$G$19=\"High (75%)\",75,'Surrounding and site'!$G$19=\"Medium (50%)\",50,'Surrounding and site'!$G$19=\"Low (25%)\",25,'Surrounding and site'!$G$19=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AW9=\"\",0,TRUE,AW9)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\">75%\",1,0)","v":0},{"$f":"BB10+BB11+BB12+BB13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$16=\"Very high (100%)\",100,'Surrounding and site'!$G$16=\"High (75%)\",75,'Surrounding and site'!$G$16=\"Medium (50%)\",50,'Surrounding and site'!$G$16=\"Low (25%)\",25,'Surrounding and site'!$G$16=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BC9=\"\",0,TRUE,BC9)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"No\",1,0)","v":0},{"$f":"BG10+BG11+BG12+BG13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$20=\"Very high (100%)\",100,'Surrounding and site'!$G$20=\"High (75%)\",75,'Surrounding and site'!$G$20=\"Medium (50%)\",50,'Surrounding and site'!$G$20=\"Low (25%)\",25,'Surrounding and site'!$G$20=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BH9=\"\",0,TRUE,BH9)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site but not on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not easy to access to the site but accessible on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site and on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not accessible\",1,0)","v":0},{"$f":"BN10+BN11+BN12+BN13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$21=\"Very high (100%)\",100,'Surrounding and site'!$G$21=\"High (75%)\",75,'Surrounding and site'!$G$21=\"Medium (50%)\",50,'Surrounding and site'!$G$21=\"Low (25%)\",25,'Surrounding and site'!$G$21=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BO9=\"\",0,TRUE,BO9)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Low risk (no industrial activity identified and no pollution)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)\",1,0)","v":0},{"$f":"BT10+BT11+BT12+BT13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$13=\"Very high (100%)\",100,'Surrounding and site'!$G$13=\"High (75%)\",75,'Surrounding and site'!$G$13=\"Medium (50%)\",50,'Surrounding and site'!$G$13=\"Low (25%)\",25,'Surrounding and site'!$G$13=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BU9=\"\",0,TRUE,BU9)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from environmental/ legal aspects\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from others aspects (urban planning, biodiversity, etc.)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"No\",1,0)","v":0},{"$f":"BZ10+BZ11+BZ12+BZ13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$14=\"Very high (100%)\",100,'Surrounding and site'!$G$14=\"High (75%)\",75,'Surrounding and site'!$G$14=\"Medium (50%)\",50,'Surrounding and site'!$G$14=\"Low (25%)\",25,'Surrounding and site'!$G$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CA9=\"\",0,TRUE,CA9)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"No\",1,0)","v":0},{"$f":"CE10+CE11+CE12+CE13","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$17=\"Very high (100%)\",100,'Surrounding and site'!$G$17=\"High (75%)\",75,'Surrounding and site'!$G$17=\"Medium (50%)\",50,'Surrounding and site'!$G$17=\"Low (25%)\",25,'Surrounding and site'!$G$17=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CF9=\"\",0,TRUE,CF9)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"0 to 25%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"25 to 50%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\">50%\",1,0)","v":0},{"$f":"CK10+CK11+CK12+CK13","v":0},{"$f":"_xlfn.IFS('Deposit 1'!$G$27=\"Very high (100%)\",100,'Deposit 1'!$G$27=\"High (75%)\",75,'Deposit 1'!$G$27=\"Medium (50%)\",50,'Deposit 1'!$G$27=\"Low (25%)\",25,'Deposit 1'!$G$27=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CL9=\"\",0,TRUE,CL9)","v":0},{"$f":"IF('Deposit 1'!$F$27=\"Abandoned (without protected area)\",1,0)","v":0},{"$f":"IF('Deposit 1'!$F$27=\"Abandoned (with protected area)\",1,0)","v":0},{"$f":"IF('Deposit 1'!$F$27=\"Activities still present (industry, use by people, etc.)\",1,0)","v":0},{"$f":"CQ10+CQ11+CQ12+CQ13","v":0},null,{"$f":"2*(CS10+CS11)+1*CS12+0.5*CS13","v":0},{"$f":"(CM9+CG9+CB9+BV9+BP9+BI9+BD9+AX9+AR9+AM9+AG9+AA9+Q9+L9+D9)/1500","v":0},{"$f":"MIN(4200,MAX(CS9,0))/4200","v":0}]
[null,"metals",null,null,{"$f":"E9*$E$1","v":0},{"$f":"F9*$F$1","v":0},{"$f":"(E10+F10)*1","v":0},{"$f":"H9*$H$1","v":0},{"$f":"I9*$I$1","v":0},{"$f":"(H10+I10)*1","v":0},null,null,{"$f":"M9*$M$1","v":0},{"$f":"N9*$N$1","v":0},{"$f":"(M10+N10)*1","v":0},null,null,{"$f":"R9*$R$1","v":0},{"$f":"S9*$S$1","v":0},{"$f":"T9*$T$1","v":0},{"$f":"U9*$U$1","v":0},{"$f":"V9*$V$1","v":0},{"$f":"W9*$W$1","v":0},{"$f":"X9*$X$1","v":0},{"$f":"(MAX(R10:X10))*1","v":0},null,null,{"$f":"AB9*$AB$1","v":0},{"$f":"AC9*$AC$1","v":0},{"$f":"AD9*$AD$1","v":0},{"$f":"(AB10+AC10+AD10)*1","v":0},null,null,{"$f":"AH9*$AH$1","v":0},{"$f":"AI9*$AI$1","v":0},{"$f":"AJ9*$AJ$1","v":0},{"$f":"(AH10+AI10+AJ10)*1","v":0},null,null,{"$f":"AN9*$AN$1","v":0},{"$f":"AO9*$AO$1","v":0},{"$f":"(AN10+AO10)*1","v":0},null,null,{"$f":"AS9*$AS$1","v":0},{"$f":"AT9*$AT$1","v":0},{"$f":"AU9*$AU$1","v":0},{"$f":"(AS10+AT10+AU10)*1","v":0},null,null,{"$f":"AY9*$AY$1","v":0},{"$f":"AZ9*$AZ$1","v":0},{"$f":"BA9*$BA$1","v":0},{"$f":"(AY10+AZ10+BA10)*1","v":0},null,null,{"$f":"BE9*$BE$1","v":0},{"$f":"BF9*$BF$1","v":0},{"$f":"(BE10+BF10)*1","v":0},null,null,{"$f":"BJ9*$BJ$1","v":0},{"$f":"BK9*$BK$1","v":0},{"$f":"BL9*$BL$1","v":0},{"$f":"BM9*$BM$1","v":0},{"$f":"(BL10+BM10)*1","v":0},null,null,{"$f":"BQ9*$BQ$1","v":0},{"$f":"BR9*$BR$1","v":0},{"$f":"BS9*$BS$1","v":0},{"$f":"(BQ10+BR10+BS10)*1","v":0},null,null,{"$f":"BW9*$BW$1","v":0},{"$f":"BX9*$BX$1","v":0},{"$f":"BY9*$BY$1","v":0},{"$f":"(BX10+BY10)*1","v":0},null,null,{"$f":"CC9*$CC$1","v":0},{"$f":"CD9*$CD$1","v":0},{"$f":"(CC10+CD10)*1","v":0},null,null,{"$f":"CH9*$CH$1","v":0},{"$f":"CI9*$CI$1","v":0},{"$f":"CJ9*$CJ$1","v":0},{"$f":"(CH10+CI10+CJ10)*1","v":0},null,null,{"$f":"CN9*$CN$1","v":0},{"$f":"CO9*$CO$1","v":0},{"$f":"CP9*$CP$1","v":0},{"$f":"(CN10+CO10+CP10)*1","v":0},null,{"$f":"SUM(G10,J10,O10,AE10,AK10,Y10,AP10,AV10,BB10,BG10,BN10,BT10,BZ10,CE10,CK10,CQ10)","v":0},null,{"$f":"MIN(900,MAX(CS10,0))/900","v":0},null,"number of questions whose confidence <=50    ==>",null,null,null,{"$f":"SUM(COUNTIF(C9,\"<=50\"),COUNTIF(K9,\"<=50\"),COUNTIF(P9,\"<=50\"),COUNTIF(Z9,\"<=50\"),COUNTIF(AF9,\"<=50\"),COUNTIF(AL9,\"<=50\"),COUNTIF(AQ9,\"<=50\"),COUNTIF(AW9,\"<=50\"),COUNTIF(BC9,\"<=50\"),COUNTIF(BH9,\"<=50\"),COUNTIF(BO9,\"=<=50\"),COUNTIF(BU9,\"<=50\"),COUNTIF(CA9,\"<=50\"),COUNTIF(CF9,\"<=50\"),COUNTIF(CL9,\"<=50\"))","v":0}]
[null,"minerals",null,null,{"$f":"E9*$E$2","v":0},{"$f":"F9*$F$2","v":0},{"$f":"(E11+F11)*1","v":0},{"$f":"H9*$H$2","v":0},{"$f":"I9*$I$2","v":0},{"$f":"(H11+I11)*1","v":0},null,null,{"$f":"M9*$M$2","v":0},{"$f":"N9*$N$2","v":0},{"$f":"(M11+N11)*1","v":0},null,null,{"$f":"R9*$R$2","v":0},{"$f":"S9*$S$2","v":0},{"$f":"T9*$T$2","v":0},{"$f":"U9*$U$2","v":0},{"$f":"V9*$V$2","v":0},{"$f":"W9*$W$2","v":0},{"$f":"X9*$X$2","v":0},{"$f":"(MAX(R11:X11))*1","v":0},null,null,{"$f":"AB9*$AB$2","v":0},{"$f":"AC9*$AC$2","v":0},{"$f":"AD9*$AD$2","v":0},{"$f":"(AB11+AC11+AD11)*1","v":0},null,null,{"$f":"AH9*$AH$2","v":0},{"$f":"AI9*$AI$2","v":0},{"$f":"AJ9*$AJ$2","v":0},{"$f":"(AH11+AI11+AJ11)*1","v":0},null,null,{"$f":"AN9*$AN$2","v":0},{"$f":"AO9*$AO$2","v":0},{"$f":"(AN11+AO11)*1","v":0},null,null,{"$f":"AS9*$AS$2","v":0},{"$f":"AT9*$AT$2","v":0},{"$f":"AU9*$AU$2","v":0},{"$f":"(AS11+AT11+AU11)*1","v":0},null,null,{"$f":"AY9*$AY$2","v":0},{"$f":"AZ9*$AZ$2","v":0},{"$f":"BA9*$BA$2","v":0},{"$f":"(AY11+AZ11+BA11)*1","v":0},null,null,{"$f":"BE9*$BE$2","v":0},{"$f":"BF9*$BF$2","v":0},{"$f":"(BE11+BF11)*1","v":0},null,null,{"$f":"BJ9*$BJ$2","v":0},{"$f":"BK9*$BK$2","v":0},{"$f":"BL9*$BL$2","v":0},{"$f":"BM9*$BM$2","v":0},{"$f":"(BL11+BM11)*1","v":0},null,null,{"$f":"BQ9*$BQ$2","v":0},{"$f":"BR9*$BR$2","v":0},{"$f":"BS9*$BS$2","v":0},{"$f":"(BQ11+BR11+BS11)*1","v":0},null,null,{"$f":"BW9*$BW$2","v":0},{"$f":"BX9*$BX$2","v":0},{"$f":"BY9*$BY$2","v":0},{"$f":"(BX11+BY11)*1","v":0},null,null,{"$f":"CC9*$CC$2","v":0},{"$f":"CD9*$CD$2","v":0},{"$f":"(CC11+CD11)*1","v":0},null,null,{"$f":"CH9*$CH$2","v":0},{"$f":"CI9*$CI$2","v":0},{"$f":"CJ9*$CJ$2","v":0},{"$f":"(CH11+CI11+CJ11)*1","v":0},null,null,{"$f":"CN9*$CN$2","v":0},{"$f":"CO9*$CO$2","v":0},{"$f":"CP9*$CP$2","v":0},{"$f":"(CN11+CO11+CP11)*1","v":0},null,{"$f":"SUM(G11,J11,O11,AE11,AK11,Y11,AP11,AV11,BB11,BG11,BN11,BT11,BZ11,CE11,CK11,CQ11)","v":0},null,{"$f":"MIN(900,MAX(CS11,0))/900","v":0},null,"number of questions whose confidence =\"\"       ==>",null,null,null,{"$f":"SUM(COUNTIF(C9,\"\"),COUNTIF(K9,\"\"),COUNTIF(P9,\"\"),COUNTIF(Z9,\"\"),COUNTIF(AF9,\"\"),COUNTIF(AL9,\"\"),COUNTIF(AQ9,\"\"),COUNTIF(AW9,\"\"),COUNTIF(BC9,\"\"),COUNTIF(BH9,\"\"),COUNTIF(BO9,\"\"),COUNTIF(BU9,\"\"),COUNTIF(CA9,\"\"),COUNTIF(CF9,\"\"),COUNTIF(CL9,\"\"))","v":15}]
[null,"soil",null,null,{"$f":"E9*$E$3","v":0},{"$f":"F9*$F$3","v":0},{"$f":"(E12+F12)*1","v":0},{"$f":"H9*$H$3","v":0},{"$f":"I9*$I$3","v":0},{"$f":"(H12+I12)*1","v":0},null,null,{"$f":"M9*$M$3","v":0},{"$f":"N9*$N$3","v":0},{"$f":"(M12+N12)*1","v":0},null,null,{"$f":"R9*$R$3","v":0},{"$f":"S9*$S$3","v":0},{"$f":"T9*$T$3","v":0},{"$f":"U9*$U$3","v":0},{"$f":"V9*$V$3","v":0},{"$f":"W9*$W$3","v":0},{"$f":"X9*$X$3","v":0},{"$f":"(MAX(R12:X12))*1","v":0},null,null,{"$f":"AB9*$AB$3","v":0},{"$f":"AC9*$AC$3","v":0},{"$f":"AD9*$AD$3","v":0},{"$f":"(AB12+AC12+AD12)*1","v":0},null,null,{"$f":"AH9*$AH$3","v":0},{"$f":"AI9*$AI$3","v":0},{"$f":"AJ9*$AJ$3","v":0},{"$f":"(AH12+AI12+AJ12)*1","v":0},null,null,{"$f":"AN9*$AN$3","v":0},{"$f":"AO9*$AO$3","v":0},{"$f":"(AN12+AO12)*1","v":0},null,null,{"$f":"AS9*$AS$3","v":0},{"$f":"AT9*$AT$3","v":0},{"$f":"AU9*$AU$3","v":0},{"$f":"(AS12+AT12+AU12)*1","v":0},null,null,{"$f":"AY9*$AY$3","v":0},{"$f":"AZ9*$AZ$3","v":0},{"$f":"BA9*$BA$3","v":0},{"$f":"(AY12+AZ12+BA12)*1","v":0},null,null,{"$f":"BE9*$BE$3","v":0},{"$f":"BF9*$BF$3","v":0},{"$f":"(BE12+BF12)*1","v":0},null,null,{"$f":"BJ9*$BJ$3","v":0},{"$f":"BK9*$BK$3","v":0},{"$f":"BL9*$BL$3","v":0},{"$f":"BM9*$BM$3","v":0},{"$f":"(BL12+BM12)*1","v":0},null,null,{"$f":"BQ9*$BQ$3","v":0},{"$f":"BR9*$BR$3","v":0},{"$f":"BS9*$BS$3","v":0},{"$f":"(BQ12+BR12+BS12)*1","v":0},null,null,{"$f":"BW9*$BW$3","v":0},{"$f":"BX9*$BX$3","v":0},{"$f":"BY9*$BY$3","v":0},{"$f":"(BX12+BY12)*1","v":0},null,null,{"$f":"CC9*$CC$3","v":0},{"$f":"CD9*$CD$3","v":0},{"$f":"(CC12+CD12)*1","v":0},null,null,{"$f":"CH9*$CH$3","v":0},{"$f":"CI9*$CI$3","v":0},{"$f":"CJ9*$CJ$3","v":0},{"$f":"(CH12+CI12+CJ12)*1","v":0},null,null,{"$f":"CN9*$CN$3","v":0},{"$f":"CO9*$CO$3","v":0},{"$f":"CP9*$CP$3","v":0},{"$f":"(CN12+CO12+CP12)*1","v":0},null,{"$f":"SUM(G12,J12,O12,AE12,AK12,Y12,AP12,AV12,BB12,BG12,BN12,BT12,BZ12,CE12,CK12,CQ12)","v":0},null,{"$f":"MIN(200,MAX(CS12,0))/200","v":0}]
[null,"ecocat",null,null,{"$f":"E9*$E$4","v":0},{"$f":"F9*$F$4","v":0},{"$f":"(E13+F13)*1","v":0},{"$f":"H9*$H$4","v":0},{"$f":"I9*$I$4","v":0},{"$f":"(H13+I13)*1","v":0},null,null,{"$f":"M9*$M$4","v":0},{"$f":"N9*$N$4","v":0},{"$f":"(M13+N13)*1","v":0},null,null,{"$f":"R9*$R$4","v":0},{"$f":"S9*$S$4","v":0},{"$f":"T9*$T$4","v":0},{"$f":"U9*$U$4","v":0},{"$f":"V9*$V$4","v":0},{"$f":"W9*$W$4","v":0},{"$f":"X9*$X$4","v":0},{"$f":"(MAX(R13:X13))*1","v":0},null,null,{"$f":"AB9*$AB$4","v":0},{"$f":"AC9*$AC$4","v":0},{"$f":"AD9*$AD$4","v":0},{"$f":"(AB13+AC13+AD13)*1","v":0},null,null,{"$f":"AH9*$AH$4","v":0},{"$f":"AI9*$AI$4","v":0},{"$f":"AJ9*$AJ$4","v":0},{"$f":"(AH13+AI13+AJ13)*1","v":0},null,null,{"$f":"AN9*$AN$4","v":0},{"$f":"AO9*$AO$4","v":0},{"$f":"(AN13+AO13)*1","v":0},null,null,{"$f":"AS9*$AS$4","v":0},{"$f":"AT9*$AT$4","v":0},{"$f":"AU9*$AU$4","v":0},{"$f":"(AS13+AT13+AU13)*1","v":0},null,null,{"$f":"AY9*$AY$4","v":0},{"$f":"AZ9*$AZ$4","v":0},{"$f":"BA9*$BA$4","v":0},{"$f":"(AY13+AZ13+BA13)*1","v":0},null,null,{"$f":"BE9*$BE$4","v":0},{"$f":"BF9*$BF$4","v":0},{"$f":"(BE13+BF13)*1","v":0},null,null,{"$f":"BJ9*$BJ$4","v":0},{"$f":"BK9*$BK$4","v":0},{"$f":"BL9*$BL$4","v":0},{"$f":"BM9*$BM$4","v":0},{"$f":"(BL13+BM13)*1","v":0},null,null,{"$f":"BQ9*$BQ$4","v":0},{"$f":"BR9*$BR$4","v":0},{"$f":"BS9*$BS$4","v":0},{"$f":"(BQ13+BR13+BS13)*1","v":0},null,null,{"$f":"BW9*$BW$4","v":0},{"$f":"BX9*$BX$4","v":0},{"$f":"BY9*$BY$4","v":0},{"$f":"(BX13+BY13)*1","v":0},null,null,{"$f":"CC9*$CC$4","v":0},{"$f":"CD9*$CD$4","v":0},{"$f":"(CC13+CD13)*1","v":0},null,null,{"$f":"CH9*$CH$4","v":0},{"$f":"CI9*$CI$4","v":0},{"$f":"CJ9*$CJ$4","v":0},{"$f":"(CH13+CI13+CJ13)*1","v":0},null,null,{"$f":"CN9*$CN$4","v":0},{"$f":"CO9*$CO$4","v":0},{"$f":"CP9*$CP$4","v":0},{"$f":"(CN13+CO13+CP13)*1","v":0},null,{"$f":"SUM(G13,J13,O13,AE13,AK13,Y13,AP13,AV13,BB13,BG13,BN13,BT13,BZ13,CE13,CK13,CQ13)","v":0},null,{"$f":"MIN(400,MAX(CS13,0))/400","v":0}]
[null,"Deposit 2",{"$f":"_xlfn.IFS('Surrounding and site'!$G$12=\"Very high (100%)\",100,'Surrounding and site'!$G$12=\"High (75%)\",75,'Surrounding and site'!$G$12=\"Medium (50%)\",50,'Surrounding and site'!$G$12=\"Low (25%)\",25,'Surrounding and site'!$G$12=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(C14=\"\",0,TRUE,C14)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"No\",1,0)","v":0},{"$f":"G15+G16+G17+G18","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"Yes\",1,0)","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"No\",1,0)","v":0},{"$f":"J15+J16+J17+J18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$15=\"Very high (100%)\",100,'Surrounding and site'!$G$15=\"High (75%)\",75,'Surrounding and site'!$G$15=\"Medium (50%)\",50,'Surrounding and site'!$G$15=\"Low (25%)\",25,'Surrounding and site'!$G$15=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(K14=\"\",0,TRUE,K14)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"No\",1,0)","v":0},{"$f":"O15+O16+O17+O18","v":0},{"$f":"_xlfn.IFS('Deposit 2'!$C$14=\"Very high (100%)\",100,'Deposit 2'!$C$14=\"High (75%)\",75,'Deposit 2'!$C$14=\"Medium (50%)\",50,'Deposit 2'!$C$14=\"Low (25%)\",25,'Deposit 2'!$C$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(P14=\"\",0,TRUE,P14)","v":0},{"$f":"IF('Deposit 2'!$B$14=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$15=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$16=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$17=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$18=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$19=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 2'!$B$20=\"Yes\",1,0)","v":0},{"$f":"Y15+Y16+Y17+Y18","v":0},{"$f":"_xlfn.IFS('Deposit 2'!$G$24=\"Very high (100%)\",100,'Deposit 2'!$G$24=\"High (75%)\",75,'Deposit 2'!$G$24=\"Medium (50%)\",50,'Deposit 2'!$G$24=\"Low (25%)\",25,'Deposit 2'!$G$24=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(Z14=\"\",0,TRUE,Z14)","v":0},{"$f":"IF(AND('Deposit 2'!$F$24>0,'Deposit 2'!$F$24<=200000),1,0)","v":0},{"$f":"IF(AND('Deposit 2'!$F$24>=200000,'Deposit 2'!$F$24<=500000),1,0)","v":0},{"$f":"IF('Deposit 2'!$F$24>500000,1,0)","v":0},{"$f":"AE15+AE16+AE17+AE18","v":0},{"$f":"_xlfn.IFS('Deposit 2'!$G$25=\"Very high (100%)\",100,'Deposit 2'!$G$25=\"High (75%)\",75,'Deposit 2'!$G$25=\"Medium (50%)\",50,'Deposit 2'!$G$25=\"Low (25%)\",25,'Deposit 2'!$G$25=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AF14=\"\",0,TRUE,AF14)","v":0},{"$f":"IF(AND('Deposit 2'!$F$25>0,'Deposit 2'!$F$25<=10000),1,0)","v":0},{"$f":"IF(AND('Deposit 2'!$F$25>=10000,'Deposit 2'!$F$25<=100000),1,0)","v":0},{"$f":"IF('Deposit 2'!$F$25>100000,1,0)","v":0},{"$f":"AK15+AK16+AK17+AK18","v":0},{"$f":"_xlfn.IFS('Deposit 2'!$G$26=\"Very high (100%)\",100,'Deposit 2'!$G$26=\"High (75%)\",75,'Deposit 2'!$G$26=\"Medium (50%)\",50,'Deposit 2'!$G$26=\"Low (25%)\",25,'Deposit 2'!$G$26=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AL14=\"\",0,TRUE,AL14)","v":0},{"$f":"IF('Deposit 2'!$F$26=\"Separated\",1,0)","v":0},{"$f":"IF('Deposit 2'!$F$26=\"Mixed\",1,0)","v":0},{"$f":"AP15+AP16+AP17+AP18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$18=\"Very high (100%)\",100,'Surrounding and site'!$G$18=\"High (75%)\",75,'Surrounding and site'!$G$18=\"Medium (50%)\",50,'Surrounding and site'!$G$18=\"Low (25%)\",25,'Surrounding and site'!$G$18=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AQ14=\"\",0,TRUE,AQ14)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\">75%\",1,0)","v":0},{"$f":"AV15+AV16+AV17+AV18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$19=\"Very high (100%)\",100,'Surrounding and site'!$G$19=\"High (75%)\",75,'Surrounding and site'!$G$19=\"Medium (50%)\",50,'Surrounding and site'!$G$19=\"Low (25%)\",25,'Surrounding and site'!$G$19=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AW14=\"\",0,TRUE,AW14)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\">75%\",1,0)","v":0},{"$f":"BB15+BB16+BB17+BB18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$16=\"Very high (100%)\",100,'Surrounding and site'!$G$16=\"High (75%)\",75,'Surrounding and site'!$G$16=\"Medium (50%)\",50,'Surrounding and site'!$G$16=\"Low (25%)\",25,'Surrounding and site'!$G$16=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BC14=\"\",0,TRUE,BC14)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"No\",1,0)","v":0},{"$f":"BG15+BG16+BG17+BG18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$20=\"Very high (100%)\",100,'Surrounding and site'!$G$20=\"High (75%)\",75,'Surrounding and site'!$G$20=\"Medium (50%)\",50,'Surrounding and site'!$G$20=\"Low (25%)\",25,'Surrounding and site'!$G$20=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BH14=\"\",0,TRUE,BH14)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site but not on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not easy to access to the site but accessible on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site and on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not accessible\",1,0)","v":0},{"$f":"BN15+BN16+BN17+BN18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$21=\"Very high (100%)\",100,'Surrounding and site'!$G$21=\"High (75%)\",75,'Surrounding and site'!$G$21=\"Medium (50%)\",50,'Surrounding and site'!$G$21=\"Low (25%)\",25,'Surrounding and site'!$G$21=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BO14=\"\",0,TRUE,BO14)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Low risk (no industrial activity identified and no pollution)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)\",1,0)","v":0},{"$f":"BT15+BT16+BT17+BT18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$13=\"Very high (100%)\",100,'Surrounding and site'!$G$13=\"High (75%)\",75,'Surrounding and site'!$G$13=\"Medium (50%)\",50,'Surrounding and site'!$G$13=\"Low (25%)\",25,'Surrounding and site'!$G$13=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BU14=\"\",0,TRUE,BU14)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from environmental/ legal aspects\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from others aspects (urban planning, biodiversity, etc.)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"No\",1,0)","v":0},{"$f":"BZ15+BZ16+BZ17+BZ18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$14=\"Very high (100%)\",100,'Surrounding and site'!$G$14=\"High (75%)\",75,'Surrounding and site'!$G$14=\"Medium (50%)\",50,'Surrounding and site'!$G$14=\"Low (25%)\",25,'Surrounding and site'!$G$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CA14=\"\",0,TRUE,CA14)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"No\",1,0)","v":0},{"$f":"CE15+CE16+CE17+CE18","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$17=\"Very high (100%)\",100,'Surrounding and site'!$G$17=\"High (75%)\",75,'Surrounding and site'!$G$17=\"Medium (50%)\",50,'Surrounding and site'!$G$17=\"Low (25%)\",25,'Surrounding and site'!$G$17=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CF14=\"\",0,TRUE,CF14)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"0 to 25%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"25 to 50%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\">50%\",1,0)","v":0},{"$f":"CK15+CK16+CK17+CK18","v":0},{"$f":"_xlfn.IFS('Deposit 2'!$G$27=\"Very high (100%)\",100,'Deposit 2'!$G$27=\"High (75%)\",75,'Deposit 2'!$G$27=\"Medium (50%)\",50,'Deposit 2'!$G$27=\"Low (25%)\",25,'Deposit 2'!$G$27=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CL14=\"\",0,TRUE,CL14)","v":0},{"$f":"IF('Deposit 2'!$F$27=\"Abandoned (without protected area)\",1,0)","v":0},{"$f":"IF('Deposit 2'!$F$27=\"Abandoned (with protected area)\",1,0)","v":0},{"$f":"IF('Deposit 2'!$F$27=\"Activities still present (industry, use by people, etc.)\",1,0)","v":0},{"$f":"CQ15+CQ16+CQ17+CQ18","v":0},null,{"$f":"2*(CS15+CS16)+1*CS17+0.5*CS18","v":0},{"$f":"(CM14+CG14+CB14+BV14+BP14+BI14+BD14+AX14+AR14+AM14+AG14+AA14+Q14+L14+D14)/1500","v":0},{"$f":"MIN(4200,MAX(CS14,0))/4200","v":0}]
[null,"metals",null,null,{"$f":"E14*$E$1","v":0},{"$f":"F14*$F$1","v":0},{"$f":"(E15+F15)*1","v":0},{"$f":"H14*$H$1","v":0},{"$f":"I14*$I$1","v":0},{"$f":"(H15+I15)*1","v":0},null,null,{"$f":"M14*$M$1","v":0},{"$f":"N14*$N$1","v":0},{"$f":"(M15+N15)*1","v":0},null,null,{"$f":"R14*$R$1","v":0},{"$f":"S14*$S$1","v":0},{"$f":"T14*$T$1","v":0},{"$f":"U14*$U$1","v":0},{"$f":"V14*$V$1","v":0},{"$f":"W14*$W$1","v":0},{"$f":"X14*$X$1","v":0},{"$f":"(MAX(R15:X15))*1","v":0},null,null,{"$f":"AB14*$AB$1","v":0},{"$f":"AC14*$AC$1","v":0},{"$f":"AD14*$AD$1","v":0},{"$f":"(AB15+AC15+AD15)*1","v":0},null,null,{"$f":"AH14*$AH$1","v":0},{"$f":"AI14*$AI$1","v":0},{"$f":"AJ14*$AJ$1","v":0},{"$f":"(AH15+AI15+AJ15)*1","v":0},null,null,{"$f":"AN14*$AN$1","v":0},{"$f":"AO14*$AO$1","v":0},{"$f":"(AN15+AO15)*1","v":0},null,null,{"$f":"AS14*$AS$1","v":0},{"$f":"AT14*$AT$1","v":0},{"$f":"AU14*$AU$1","v":0},{"$f":"(AS15+AT15+AU15)*1","v":0},null,null,{"$f":"AY14*$AY$1","v":0},{"$f":"AZ14*$AZ$1","v":0},{"$f":"BA14*$BA$1","v":0},{"$f":"(AY15+AZ15+BA15)*1","v":0},null,null,{"$f":"BE14*$BE$1","v":0},{"$f":"BF14*$BF$1","v":0},{"$f":"(BE15+BF15)*1","v":0},null,null,{"$f":"BJ14*$BJ$1","v":0},{"$f":"BK14*$BK$1","v":0},{"$f":"BL14*$BL$1","v":0},{"$f":"BM14*$BM$1","v":0},{"$f":"(BL15+BM15)*1","v":0},null,null,{"$f":"BQ14*$BQ$1","v":0},{"$f":"BR14*$BR$1","v":0},{"$f":"BS14*$BS$1","v":0},{"$f":"(BQ15+BR15+BS15)*1","v":0},null,null,{"$f":"BW14*$BW$1","v":0},{"$f":"BX14*$BX$1","v":0},{"$f":"BY14*$BY$1","v":0},{"$f":"(BX15+BY15)*1","v":0},null,null,{"$f":"CC14*$CC$1","v":0},{"$f":"CD14*$CD$1","v":0},{"$f":"(CC15+CD15)*1","v":0},null,null,{"$f":"CH14*$CH$1","v":0},{"$f":"CI14*$CI$1","v":0},{"$f":"CJ14*$CJ$1","v":0},{"$f":"(CH15+CI15+CJ15)*1","v":0},null,null,{"$f":"CN14*$CN$1","v":0},{"$f":"CO14*$CO$1","v":0},{"$f":"CP14*$CP$1","v":0},{"$f":"(CN15+CO15+CP15)*1","v":0},null,{"$f":"SUM(G15,J15,O15,AE15,AK15,Y15,AP15,AV15,BB15,BG15,BN15,BT15,BZ15,CE15,CK15,CQ15)","v":0},null,{"$f":"MIN(900,MAX(CS15,0))/900","v":0},null,"number of questions whose confidence <=50    ==>",null,null,null,{"$f":"SUM(COUNTIF(C14,\"<=50\"),COUNTIF(K14,\"<=50\"),COUNTIF(P14,\"<=50\"),COUNTIF(Z14,\"<=50\"),COUNTIF(AF14,\"<=50\"),COUNTIF(AL14,\"<=50\"),COUNTIF(AQ14,\"<=50\"),COUNTIF(AW14,\"<=50\"),COUNTIF(BC14,\"<=50\"),COUNTIF(BH14,\"<=50\"),COUNTIF(BO14,\"=<=50\"),COUNTIF(BU14,\"<=50\"),COUNTIF(CA14,\"<=50\"),COUNTIF(CF14,\"<=50\"),COUNTIF(CL14,\"<=50\"))","v":0}]
[null,"minerals",null,null,{"$f":"E14*$E$2","v":0},{"$f":"F14*$F$2","v":0},{"$f":"(E16+F16)*1","v":0},{"$f":"H14*$H$2","v":0},{"$f":"I14*$I$2","v":0},{"$f":"(H16+I16)*1","v":0},null,null,{"$f":"M14*$M$2","v":0},{"$f":"N14*$N$2","v":0},{"$f":"(M16+N16)*1","v":0},null,null,{"$f":"R14*$R$2","v":0},{"$f":"S14*$S$2","v":0},{"$f":"T14*$T$2","v":0},{"$f":"U14*$U$2","v":0},{"$f":"V14*$V$2","v":0},{"$f":"W14*$W$2","v":0},{"$f":"X14*$X$2","v":0},{"$f":"(MAX(R16:X16))*1","v":0},null,null,{"$f":"AB14*$AB$2","v":0},{"$f":"AC14*$AC$2","v":0},{"$f":"AD14*$AD$2","v":0},{"$f":"(AB16+AC16+AD16)*1","v":0},null,null,{"$f":"AH14*$AH$2","v":0},{"$f":"AI14*$AI$2","v":0},{"$f":"AJ14*$AJ$2","v":0},{"$f":"(AH16+AI16+AJ16)*1","v":0},null,null,{"$f":"AN14*$AN$2","v":0},{"$f":"AO14*$AO$2","v":0},{"$f":"(AN16+AO16)*1","v":0},null,null,{"$f":"AS14*$AS$2","v":0},{"$f":"AT14*$AT$2","v":0},{"$f":"AU14*$AU$2","v":0},{"$f":"(AS16+AT16+AU16)*1","v":0},null,null,{"$f":"AY14*$AY$2","v":0},{"$f":"AZ14*$AZ$2","v":0},{"$f":"BA14*$BA$2","v":0},{"$f":"(AY16+AZ16+BA16)*1","v":0},null,null,{"$f":"BE14*$BE$2","v":0},{"$f":"BF14*$BF$2","v":0},{"$f":"(BE16+BF16)*1","v":0},null,null,{"$f":"BJ14*$BJ$2","v":0},{"$f":"BK14*$BK$2","v":0},{"$f":"BL14*$BL$2","v":0},{"$f":"BM14*$BM$2","v":0},{"$f":"(BL16+BM16)*1","v":0},null,null,{"$f":"BQ14*$BQ$2","v":0},{"$f":"BR14*$BR$2","v":0},{"$f":"BS14*$BS$2","v":0},{"$f":"(BQ16+BR16+BS16)*1","v":0},null,null,{"$f":"BW14*$BW$2","v":0},{"$f":"BX14*$BX$2","v":0},{"$f":"BY14*$BY$2","v":0},{"$f":"(BX16+BY16)*1","v":0},null,null,{"$f":"CC14*$CC$2","v":0},{"$f":"CD14*$CD$2","v":0},{"$f":"(CC16+CD16)*1","v":0},null,null,{"$f":"CH14*$CH$2","v":0},{"$f":"CI14*$CI$2","v":0},{"$f":"CJ14*$CJ$2","v":0},{"$f":"(CH16+CI16+CJ16)*1","v":0},null,null,{"$f":"CN14*$CN$2","v":0},{"$f":"CO14*$CO$2","v":0},{"$f":"CP14*$CP$2","v":0},{"$f":"(CN16+CO16+CP16)*1","v":0},null,{"$f":"SUM(G16,J16,O16,AE16,AK16,Y16,AP16,AV16,BB16,BG16,BN16,BT16,BZ16,CE16,CK16,CQ16)","v":0},null,{"$f":"MIN(900,MAX(CS16,0))/900","v":0},null,"number of questions whose confidence =\"\"       ==>",null,null,null,{"$f":"SUM(COUNTIF(C14,\"\"),COUNTIF(K14,\"\"),COUNTIF(P14,\"\"),COUNTIF(Z14,\"\"),COUNTIF(AF14,\"\"),COUNTIF(AL14,\"\"),COUNTIF(AQ14,\"\"),COUNTIF(AW14,\"\"),COUNTIF(BC14,\"\"),COUNTIF(BH14,\"\"),COUNTIF(BO14,\"\"),COUNTIF(BU14,\"\"),COUNTIF(CA14,\"\"),COUNTIF(CF14,\"\"),COUNTIF(CL14,\"\"))","v":15}]
[null,"soil",null,null,{"$f":"E14*$E$3","v":0},{"$f":"F14*$F$3","v":0},{"$f":"(E17+F17)*1","v":0},{"$f":"H14*$H$3","v":0},{"$f":"I14*$I$3","v":0},{"$f":"(H17+I17)*1","v":0},null,null,{"$f":"M14*$M$3","v":0},{"$f":"N14*$N$3","v":0},{"$f":"(M17+N17)*1","v":0},null,null,{"$f":"R14*$R$3","v":0},{"$f":"S14*$S$3","v":0},{"$f":"T14*$T$3","v":0},{"$f":"U14*$U$3","v":0},{"$f":"V14*$V$3","v":0},{"$f":"W14*$W$3","v":0},{"$f":"X14*$X$3","v":0},{"$f":"(MAX(R17:X17))*1","v":0},null,null,{"$f":"AB14*$AB$3","v":0},{"$f":"AC14*$AC$3","v":0},{"$f":"AD14*$AD$3","v":0},{"$f":"(AB17+AC17+AD17)*1","v":0},null,null,{"$f":"AH14*$AH$3","v":0},{"$f":"AI14*$AI$3","v":0},{"$f":"AJ14*$AJ$3","v":0},{"$f":"(AH17+AI17+AJ17)*1","v":0},null,null,{"$f":"AN14*$AN$3","v":0},{"$f":"AO14*$AO$3","v":0},{"$f":"(AN17+AO17)*1","v":0},null,null,{"$f":"AS14*$AS$3","v":0},{"$f":"AT14*$AT$3","v":0},{"$f":"AU14*$AU$3","v":0},{"$f":"(AS17+AT17+AU17)*1","v":0},null,null,{"$f":"AY14*$AY$3","v":0},{"$f":"AZ14*$AZ$3","v":0},{"$f":"BA14*$BA$3","v":0},{"$f":"(AY17+AZ17+BA17)*1","v":0},null,null,{"$f":"BE14*$BE$3","v":0},{"$f":"BF14*$BF$3","v":0},{"$f":"(BE17+BF17)*1","v":0},null,null,{"$f":"BJ14*$BJ$3","v":0},{"$f":"BK14*$BK$3","v":0},{"$f":"BL14*$BL$3","v":0},{"$f":"BM14*$BM$3","v":0},{"$f":"(BL17+BM17)*1","v":0},null,null,{"$f":"BQ14*$BQ$3","v":0},{"$f":"BR14*$BR$3","v":0},{"$f":"BS14*$BS$3","v":0},{"$f":"(BQ17+BR17+BS17)*1","v":0},null,null,{"$f":"BW14*$BW$3","v":0},{"$f":"BX14*$BX$3","v":0},{"$f":"BY14*$BY$3","v":0},{"$f":"(BX17+BY17)*1","v":0},null,null,{"$f":"CC14*$CC$3","v":0},{"$f":"CD14*$CD$3","v":0},{"$f":"(CC17+CD17)*1","v":0},null,null,{"$f":"CH14*$CH$3","v":0},{"$f":"CI14*$CI$3","v":0},{"$f":"CJ14*$CJ$3","v":0},{"$f":"(CH17+CI17+CJ17)*1","v":0},null,null,{"$f":"CN14*$CN$3","v":0},{"$f":"CO14*$CO$3","v":0},{"$f":"CP14*$CP$3","v":0},{"$f":"(CN17+CO17+CP17)*1","v":0},null,{"$f":"SUM(G17,J17,O17,AE17,AK17,Y17,AP17,AV17,BB17,BG17,BN17,BT17,BZ17,CE17,CK17,CQ17)","v":0},null,{"$f":"MIN(200,MAX(CS17,0))/200","v":0}]
[null,"ecocat",null,null,{"$f":"E14*$E$4","v":0},{"$f":"F14*$F$4","v":0},{"$f":"(E18+F18)*1","v":0},{"$f":"H14*$H$4","v":0},{"$f":"I14*$I$4","v":0},{"$f":"(H18+I18)*1","v":0},null,null,{"$f":"M14*$M$4","v":0},{"$f":"N14*$N$4","v":0},{"$f":"(M18+N18)*1","v":0},null,null,{"$f":"R14*$R$4","v":0},{"$f":"S14*$S$4","v":0},{"$f":"T14*$T$4","v":0},{"$f":"U14*$U$4","v":0},{"$f":"V14*$V$4","v":0},{"$f":"W14*$W$4","v":0},{"$f":"X14*$X$4","v":0},{"$f":"(MAX(R18:X18))*1","v":0},null,null,{"$f":"AB14*$AB$4","v":0},{"$f":"AC14*$AC$4","v":0},{"$f":"AD14*$AD$4","v":0},{"$f":"(AB18+AC18+AD18)*1","v":0},null,null,{"$f":"AH14*$AH$4","v":0},{"$f":"AI14*$AI$4","v":0},{"$f":"AJ14*$AJ$4","v":0},{"$f":"(AH18+AI18+AJ18)*1","v":0},null,null,{"$f":"AN14*$AN$4","v":0},{"$f":"AO14*$AO$4","v":0},{"$f":"(AN18+AO18)*1","v":0},null,null,{"$f":"AS14*$AS$4","v":0},{"$f":"AT14*$AT$4","v":0},{"$f":"AU14*$AU$4","v":0},{"$f":"(AS18+AT18+AU18)*1","v":0},null,null,{"$f":"AY14*$AY$4","v":0},{"$f":"AZ14*$AZ$4","v":0},{"$f":"BA14*$BA$4","v":0},{"$f":"(AY18+AZ18+BA18)*1","v":0},null,null,{"$f":"BE14*$BE$4","v":0},{"$f":"BF14*$BF$4","v":0},{"$f":"(BE18+BF18)*1","v":0},null,null,{"$f":"BJ14*$BJ$4","v":0},{"$f":"BK14*$BK$4","v":0},{"$f":"BL14*$BL$4","v":0},{"$f":"BM14*$BM$4","v":0},{"$f":"(BL18+BM18)*1","v":0},null,null,{"$f":"BQ14*$BQ$4","v":0},{"$f":"BR14*$BR$4","v":0},{"$f":"BS14*$BS$4","v":0},{"$f":"(BQ18+BR18+BS18)*1","v":0},null,null,{"$f":"BW14*$BW$4","v":0},{"$f":"BX14*$BX$4","v":0},{"$f":"BY14*$BY$4","v":0},{"$f":"(BX18+BY18)*1","v":0},null,null,{"$f":"CC14*$CC$4","v":0},{"$f":"CD14*$CD$4","v":0},{"$f":"(CC18+CD18)*1","v":0},null,null,{"$f":"CH14*$CH$4","v":0},{"$f":"CI14*$CI$4","v":0},{"$f":"CJ14*$CJ$4","v":0},{"$f":"(CH18+CI18+CJ18)*1","v":0},null,null,{"$f":"CN14*$CN$4","v":0},{"$f":"CO14*$CO$4","v":0},{"$f":"CP14*$CP$4","v":0},{"$f":"(CN18+CO18+CP18)*1","v":0},null,{"$f":"SUM(G18,J18,O18,AE18,AK18,Y18,AP18,AV18,BB18,BG18,BN18,BT18,BZ18,CE18,CK18,CQ18)","v":0},null,{"$f":"MIN(400,MAX(CS18,0))/400","v":0}]
[null,"Deposit 3",{"$f":"_xlfn.IFS('Surrounding and site'!$G$12=\"Very high (100%)\",100,'Surrounding and site'!$G$12=\"High (75%)\",75,'Surrounding and site'!$G$12=\"Medium (50%)\",50,'Surrounding and site'!$G$12=\"Low (25%)\",25,'Surrounding and site'!$G$12=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(C19=\"\",0,TRUE,C19)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"No\",1,0)","v":0},{"$f":"G20+G21+G22+G23","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"Yes\",1,0)","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"No\",1,0)","v":0},{"$f":"J20+J21+J22+J23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$15=\"Very high (100%)\",100,'Surrounding and site'!$G$15=\"High (75%)\",75,'Surrounding and site'!$G$15=\"Medium (50%)\",50,'Surrounding and site'!$G$15=\"Low (25%)\",25,'Surrounding and site'!$G$15=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(K19=\"\",0,TRUE,K19)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"No\",1,0)","v":0},{"$f":"O20+O21+O22+O23","v":0},{"$f":"_xlfn.IFS('Deposit 3'!$C$14=\"Very high (100%)\",100,'Deposit 3'!$C$14=\"High (75%)\",75,'Deposit 3'!$C$14=\"Medium (50%)\",50,'Deposit 3'!$C$14=\"Low (25%)\",25,'Deposit 3'!$C$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(P19=\"\",0,TRUE,P19)","v":0},{"$f":"IF('Deposit 3'!$B$14=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$15=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$16=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$17=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$18=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$19=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 3'!$B$20=\"Yes\",1,0)","v":0},{"$f":"Y20+Y21+Y22+Y23","v":0},{"$f":"_xlfn.IFS('Deposit 3'!$G$24=\"Very high (100%)\",100,'Deposit 3'!$G$24=\"High (75%)\",75,'Deposit 3'!$G$24=\"Medium (50%)\",50,'Deposit 3'!$G$24=\"Low (25%)\",25,'Deposit 3'!$G$24=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(Z19=\"\",0,TRUE,Z19)","v":0},{"$f":"IF(AND('Deposit 3'!$F$24>0,'Deposit 3'!$F$24<=200000),1,0)","v":0},{"$f":"IF(AND('Deposit 3'!$F$24>=200000,'Deposit 3'!$F$24<=500000),1,0)","v":0},{"$f":"IF('Deposit 3'!$F$24>500000,1,0)","v":0},{"$f":"AE20+AE21+AE22+AE23","v":0},{"$f":"_xlfn.IFS('Deposit 3'!$G$25=\"Very high (100%)\",100,'Deposit 3'!$G$25=\"High (75%)\",75,'Deposit 3'!$G$25=\"Medium (50%)\",50,'Deposit 3'!$G$25=\"Low (25%)\",25,'Deposit 3'!$G$25=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AF19=\"\",0,TRUE,AF19)","v":0},{"$f":"IF(AND('Deposit 3'!$F$25>0,'Deposit 3'!$F$25<=10000),1,0)","v":0},{"$f":"IF(AND('Deposit 3'!$F$25>=10000,'Deposit 3'!$F$25<=100000),1,0)","v":0},{"$f":"IF('Deposit 3'!$F$25>100000,1,0)","v":0},{"$f":"AK20+AK21+AK22+AK23","v":0},{"$f":"_xlfn.IFS('Deposit 3'!$G$26=\"Very high (100%)\",100,'Deposit 3'!$G$26=\"High (75%)\",75,'Deposit 3'!$G$26=\"Medium (50%)\",50,'Deposit 3'!$G$26=\"Low (25%)\",25,'Deposit 3'!$G$26=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AL19=\"\",0,TRUE,AL19)","v":0},{"$f":"IF('Deposit 3'!$F$26=\"Separated\",1,0)","v":0},{"$f":"IF('Deposit 3'!$F$26=\"Mixed\",1,0)","v":0},{"$f":"AP20+AP21+AP22+AP23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$18=\"Very high (100%)\",100,'Surrounding and site'!$G$18=\"High (75%)\",75,'Surrounding and site'!$G$18=\"Medium (50%)\",50,'Surrounding and site'!$G$18=\"Low (25%)\",25,'Surrounding and site'!$G$18=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AQ19=\"\",0,TRUE,AQ19)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\">75%\",1,0)","v":0},{"$f":"AV20+AV21+AV22+AV23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$19=\"Very high (100%)\",100,'Surrounding and site'!$G$19=\"High (75%)\",75,'Surrounding and site'!$G$19=\"Medium (50%)\",50,'Surrounding and site'!$G$19=\"Low (25%)\",25,'Surrounding and site'!$G$19=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AW19=\"\",0,TRUE,AW19)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\">75%\",1,0)","v":0},{"$f":"BB20+BB21+BB22+BB23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$16=\"Very high (100%)\",100,'Surrounding and site'!$G$16=\"High (75%)\",75,'Surrounding and site'!$G$16=\"Medium (50%)\",50,'Surrounding and site'!$G$16=\"Low (25%)\",25,'Surrounding and site'!$G$16=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BC19=\"\",0,TRUE,BC19)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"No\",1,0)","v":0},{"$f":"BG20+BG21+BG22+BG23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$20=\"Very high (100%)\",100,'Surrounding and site'!$G$20=\"High (75%)\",75,'Surrounding and site'!$G$20=\"Medium (50%)\",50,'Surrounding and site'!$G$20=\"Low (25%)\",25,'Surrounding and site'!$G$20=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BH19=\"\",0,TRUE,BH19)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site but not on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not easy to access to the site but accessible on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site and on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not accessible\",1,0)","v":0},{"$f":"BN20+BN21+BN22+BN23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$21=\"Very high (100%)\",100,'Surrounding and site'!$G$21=\"High (75%)\",75,'Surrounding and site'!$G$21=\"Medium (50%)\",50,'Surrounding and site'!$G$21=\"Low (25%)\",25,'Surrounding and site'!$G$21=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BO19=\"\",0,TRUE,BO19)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Low risk (no industrial activity identified and no pollution)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)\",1,0)","v":0},{"$f":"BT20+BT21+BT22+BT23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$13=\"Very high (100%)\",100,'Surrounding and site'!$G$13=\"High (75%)\",75,'Surrounding and site'!$G$13=\"Medium (50%)\",50,'Surrounding and site'!$G$13=\"Low (25%)\",25,'Surrounding and site'!$G$13=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BU19=\"\",0,TRUE,BU19)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from environmental/ legal aspects\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from others aspects (urban planning, biodiversity, etc.)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"No\",1,0)","v":0},{"$f":"BZ20+BZ21+BZ22+BZ23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$14=\"Very high (100%)\",100,'Surrounding and site'!$G$14=\"High (75%)\",75,'Surrounding and site'!$G$14=\"Medium (50%)\",50,'Surrounding and site'!$G$14=\"Low (25%)\",25,'Surrounding and site'!$G$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CA19=\"\",0,TRUE,CA19)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"No\",1,0)","v":0},{"$f":"CE20+CE21+CE22+CE23","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$17=\"Very high (100%)\",100,'Surrounding and site'!$G$17=\"High (75%)\",75,'Surrounding and site'!$G$17=\"Medium (50%)\",50,'Surrounding and site'!$G$17=\"Low (25%)\",25,'Surrounding and site'!$G$17=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CF19=\"\",0,TRUE,CF19)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"0 to 25%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"25 to 50%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\">50%\",1,0)","v":0},{"$f":"CK20+CK21+CK22+CK23","v":0},{"$f":"_xlfn.IFS('Deposit 3'!$G$27=\"Very high (100%)\",100,'Deposit 3'!$G$27=\"High (75%)\",75,'Deposit 3'!$G$27=\"Medium (50%)\",50,'Deposit 3'!$G$27=\"Low (25%)\",25,'Deposit 3'!$G$27=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CL19=\"\",0,TRUE,CL19)","v":0},{"$f":"IF('Deposit 3'!$F$27=\"Abandoned (without protected area)\",1,0)","v":0},{"$f":"IF('Deposit 3'!$F$27=\"Abandoned (with protected area)\",1,0)","v":0},{"$f":"IF('Deposit 3'!$F$27=\"Activities still present (industry, use by people, etc.)\",1,0)","v":0},{"$f":"CQ20+CQ21+CQ22+CQ23","v":0},null,{"$f":"2*(CS20+CS21)+1*CS22+0.5*CS23","v":0},{"$f":"(CM19+CG19+CB19+BV19+BP19+BI19+BD19+AX19+AR19+AM19+AG19+AA19+Q19+L19+D19)/1500","v":0},{"$f":"MIN(4200,MAX(CS19,0))/4200","v":0}]
[null,"metals",null,null,{"$f":"E19*$E$1","v":0},{"$f":"F19*$F$1","v":0},{"$f":"(E20+F20)*1","v":0},{"$f":"H19*$H$1","v":0},{"$f":"I19*$I$1","v":0},{"$f":"(H20+I20)*1","v":0},null,null,{"$f":"M19*$M$1","v":0},{"$f":"N19*$N$1","v":0},{"$f":"(M20+N20)*1","v":0},null,null,{"$f":"R19*$R$1","v":0},{"$f":"S19*$S$1","v":0},{"$f":"T19*$T$1","v":0},{"$f":"U19*$U$1","v":0},{"$f":"V19*$V$1","v":0},{"$f":"W19*$W$1","v":0},{"$f":"X19*$X$1","v":0},{"$f":"(MAX(R20:X20))*1","v":0},null,null,{"$f":"AB19*$AB$1","v":0},{"$f":"AC19*$AC$1","v":0},{"$f":"AD19*$AD$1","v":0},{"$f":"(AB20+AC20+AD20)*1","v":0},null,null,{"$f":"AH19*$AH$1","v":0},{"$f":"AI19*$AI$1","v":0},{"$f":"AJ19*$AJ$1","v":0},{"$f":"(AH20+AI20+AJ20)*1","v":0},null,null,{"$f":"AN19*$AN$1","v":0},{"$f":"AO19*$AO$1","v":0},{"$f":"(AN20+AO20)*1","v":0},null,null,{"$f":"AS19*$AS$1","v":0},{"$f":"AT19*$AT$1","v":0},{"$f":"AU19*$AU$1","v":0},{"$f":"(AS20+AT20+AU20)*1","v":0},null,null,{"$f":"AY19*$AY$1","v":0},{"$f":"AZ19*$AZ$1","v":0},{"$f":"BA19*$BA$1","v":0},{"$f":"(AY20+AZ20+BA20)*1","v":0},null,null,{"$f":"BE19*$BE$1","v":0},{"$f":"BF19*$BF$1","v":0},{"$f":"(BE20+BF20)*1","v":0},null,null,{"$f":"BJ19*$BJ$1","v":0},{"$f":"BK19*$BK$1","v":0},{"$f":"BL19*$BL$1","v":0},{"$f":"BM19*$BM$1","v":0},{"$f":"(BL20+BM20)*1","v":0},null,null,{"$f":"BQ19*$BQ$1","v":0},{"$f":"BR19*$BR$1","v":0},{"$f":"BS19*$BS$1","v":0},{"$f":"(BQ20+BR20+BS20)*1","v":0},null,null,{"$f":"BW19*$BW$1","v":0},{"$f":"BX19*$BX$1","v":0},{"$f":"BY19*$BY$1","v":0},{"$f":"(BX20+BY20)*1","v":0},null,null,{"$f":"CC19*$CC$1","v":0},{"$f":"CD19*$CD$1","v":0},{"$f":"(CC20+CD20)*1","v":0},null,null,{"$f":"CH19*$CH$1","v":0},{"$f":"CI19*$CI$1","v":0},{"$f":"CJ19*$CJ$1","v":0},{"$f":"(CH20+CI20+CJ20)*1","v":0},null,null,{"$f":"CN19*$CN$1","v":0},{"$f":"CO19*$CO$1","v":0},{"$f":"CP19*$CP$1","v":0},{"$f":"(CN20+CO20+CP20)*1","v":0},null,{"$f":"SUM(G20,J20,O20,AE20,AK20,Y20,AP20,AV20,BB20,BG20,BN20,BT20,BZ20,CE20,CK20,CQ20)","v":0},null,{"$f":"MIN(900,MAX(CS20,0))/900","v":0},null,"number of questions whose confidence <=50    ==>",null,null,null,{"$f":"SUM(COUNTIF(C19,\"<=50\"),COUNTIF(K19,\"<=50\"),COUNTIF(P19,\"<=50\"),COUNTIF(Z19,\"<=50\"),COUNTIF(AF19,\"<=50\"),COUNTIF(AL19,\"<=50\"),COUNTIF(AQ19,\"<=50\"),COUNTIF(AW19,\"<=50\"),COUNTIF(BC19,\"<=50\"),COUNTIF(BH19,\"<=50\"),COUNTIF(BO19,\"=<=50\"),COUNTIF(BU19,\"<=50\"),COUNTIF(CA19,\"<=50\"),COUNTIF(CF19,\"<=50\"),COUNTIF(CL19,\"<=50\"))","v":0}]
[null,"minerals",null,null,{"$f":"E19*$E$2","v":0},{"$f":"F19*$F$2","v":0},{"$f":"(E21+F21)*1","v":0},{"$f":"H19*$H$2","v":0},{"$f":"I19*$I$2","v":0},{"$f":"(H21+I21)*1","v":0},null,null,{"$f":"M19*$M$2","v":0},{"$f":"N19*$N$2","v":0},{"$f":"(M21+N21)*1","v":0},null,null,{"$f":"R19*$R$2","v":0},{"$f":"S19*$S$2","v":0},{"$f":"T19*$T$2","v":0},{"$f":"U19*$U$2","v":0},{"$f":"V19*$V$2","v":0},{"$f":"W19*$W$2","v":0},{"$f":"X19*$X$2","v":0},{"$f":"(MAX(R21:X21))*1","v":0},null,null,{"$f":"AB19*$AB$2","v":0},{"$f":"AC19*$AC$2","v":0},{"$f":"AD19*$AD$2","v":0},{"$f":"(AB21+AC21+AD21)*1","v":0},null,null,{"$f":"AH19*$AH$2","v":0},{"$f":"AI19*$AI$2","v":0},{"$f":"AJ19*$AJ$2","v":0},{"$f":"(AH21+AI21+AJ21)*1","v":0},null,null,{"$f":"AN19*$AN$2","v":0},{"$f":"AO19*$AO$2","v":0},{"$f":"(AN21+AO21)*1","v":0},null,null,{"$f":"AS19*$AS$2","v":0},{"$f":"AT19*$AT$2","v":0},{"$f":"AU19*$AU$2","v":0},{"$f":"(AS21+AT21+AU21)*1","v":0},null,null,{"$f":"AY19*$AY$2","v":0},{"$f":"AZ19*$AZ$2","v":0},{"$f":"BA19*$BA$2","v":0},{"$f":"(AY21+AZ21+BA21)*1","v":0},null,null,{"$f":"BE19*$BE$2","v":0},{"$f":"BF19*$BF$2","v":0},{"$f":"(BE21+BF21)*1","v":0},null,null,{"$f":"BJ19*$BJ$2","v":0},{"$f":"BK19*$BK$2","v":0},{"$f":"BL19*$BL$2","v":0},{"$f":"BM19*$BM$2","v":0},{"$f":"(BL21+BM21)*1","v":0},null,null,{"$f":"BQ19*$BQ$2","v":0},{"$f":"BR19*$BR$2","v":0},{"$f":"BS19*$BS$2","v":0},{"$f":"(BQ21+BR21+BS21)*1","v":0},null,null,{"$f":"BW19*$BW$2","v":0},{"$f":"BX19*$BX$2","v":0},{"$f":"BY19*$BY$2","v":0},{"$f":"(BX21+BY21)*1","v":0},null,null,{"$f":"CC19*$CC$2","v":0},{"$f":"CD19*$CD$2","v":0},{"$f":"(CC21+CD21)*1","v":0},null,null,{"$f":"CH19*$CH$2","v":0},{"$f":"CI19*$CI$2","v":0},{"$f":"CJ19*$CJ$2","v":0},{"$f":"(CH21+CI21+CJ21)*1","v":0},null,null,{"$f":"CN19*$CN$2","v":0},{"$f":"CO19*$CO$2","v":0},{"$f":"CP19*$CP$2","v":0},{"$f":"(CN21+CO21+CP21)*1","v":0},null,{"$f":"SUM(G21,J21,O21,AE21,AK21,Y21,AP21,AV21,BB21,BG21,BN21,BT21,BZ21,CE21,CK21,CQ21)","v":0},null,{"$f":"MIN(900,MAX(CS21,0))/900","v":0},null,"number of questions whose confidence =\"\"       ==>",null,null,null,{"$f":"SUM(COUNTIF(C19,\"\"),COUNTIF(K19,\"\"),COUNTIF(P19,\"\"),COUNTIF(Z19,\"\"),COUNTIF(AF19,\"\"),COUNTIF(AL19,\"\"),COUNTIF(AQ19,\"\"),COUNTIF(AW19,\"\"),COUNTIF(BC19,\"\"),COUNTIF(BH19,\"\"),COUNTIF(BO19,\"\"),COUNTIF(BU19,\"\"),COUNTIF(CA19,\"\"),COUNTIF(CF19,\"\"),COUNTIF(CL19,\"\"))","v":15}]
[null,"soil",null,null,{"$f":"E19*$E$3","v":0},{"$f":"F19*$F$3","v":0},{"$f":"(E22+F22)*1","v":0},{"$f":"H19*$H$3","v":0},{"$f":"I19*$I$3","v":0},{"$f":"(H22+I22)*1","v":0},null,null,{"$f":"M19*$M$3","v":0},{"$f":"N19*$N$3","v":0},{"$f":"(M22+N22)*1","v":0},null,null,{"$f":"R19*$R$3","v":0},{"$f":"S19*$S$3","v":0},{"$f":"T19*$T$3","v":0},{"$f":"U19*$U$3","v":0},{"$f":"V19*$V$3","v":0},{"$f":"W19*$W$3","v":0},{"$f":"X19*$X$3","v":0},{"$f":"(MAX(R22:X22))*1","v":0},null,null,{"$f":"AB19*$AB$3","v":0},{"$f":"AC19*$AC$3","v":0},{"$f":"AD19*$AD$3","v":0},{"$f":"(AB22+AC22+AD22)*1","v":0},null,null,{"$f":"AH19*$AH$3","v":0},{"$f":"AI19*$AI$3","v":0},{"$f":"AJ19*$AJ$3","v":0},{"$f":"(AH22+AI22+AJ22)*1","v":0},null,null,{"$f":"AN19*$AN$3","v":0},{"$f":"AO19*$AO$3","v":0},{"$f":"(AN22+AO22)*1","v":0},null,null,{"$f":"AS19*$AS$3","v":0},{"$f":"AT19*$AT$3","v":0},{"$f":"AU19*$AU$3","v":0},{"$f":"(AS22+AT22+AU22)*1","v":0},null,null,{"$f":"AY19*$AY$3","v":0},{"$f":"AZ19*$AZ$3","v":0},{"$f":"BA19*$BA$3","v":0},{"$f":"(AY22+AZ22+BA22)*1","v":0},null,null,{"$f":"BE19*$BE$3","v":0},{"$f":"BF19*$BF$3","v":0},{"$f":"(BE22+BF22)*1","v":0},null,null,{"$f":"BJ19*$BJ$3","v":0},{"$f":"BK19*$BK$3","v":0},{"$f":"BL19*$BL$3","v":0},{"$f":"BM19*$BM$3","v":0},{"$f":"(BL22+BM22)*1","v":0},null,null,{"$f":"BQ19*$BQ$3","v":0},{"$f":"BR19*$BR$3","v":0},{"$f":"BS19*$BS$3","v":0},{"$f":"(BQ22+BR22+BS22)*1","v":0},null,null,{"$f":"BW19*$BW$3","v":0},{"$f":"BX19*$BX$3","v":0},{"$f":"BY19*$BY$3","v":0},{"$f":"(BX22+BY22)*1","v":0},null,null,{"$f":"CC19*$CC$3","v":0},{"$f":"CD19*$CD$3","v":0},{"$f":"(CC22+CD22)*1","v":0},null,null,{"$f":"CH19*$CH$3","v":0},{"$f":"CI19*$CI$3","v":0},{"$f":"CJ19*$CJ$3","v":0},{"$f":"(CH22+CI22+CJ22)*1","v":0},null,null,{"$f":"CN19*$CN$3","v":0},{"$f":"CO19*$CO$3","v":0},{"$f":"CP19*$CP$3","v":0},{"$f":"(CN22+CO22+CP22)*1","v":0},null,{"$f":"SUM(G22,J22,O22,AE22,AK22,Y22,AP22,AV22,BB22,BG22,BN22,BT22,BZ22,CE22,CK22,CQ22)","v":0},null,{"$f":"MIN(200,MAX(CS22,0))/200","v":0}]
[null,"ecocat",null,null,{"$f":"E19*$E$4","v":0},{"$f":"F19*$F$4","v":0},{"$f":"(E23+F23)*1","v":0},{"$f":"H19*$H$4","v":0},{"$f":"I19*$I$4","v":0},{"$f":"(H23+I23)*1","v":0},null,null,{"$f":"M19*$M$4","v":0},{"$f":"N19*$N$4","v":0},{"$f":"(M23+N23)*1","v":0},null,null,{"$f":"R19*$R$4","v":0},{"$f":"S19*$S$4","v":0},{"$f":"T19*$T$4","v":0},{"$f":"U19*$U$4","v":0},{"$f":"V19*$V$4","v":0},{"$f":"W19*$W$4","v":0},{"$f":"X19*$X$4","v":0},{"$f":"(MAX(R23:X23))*1","v":0},null,null,{"$f":"AB19*$AB$4","v":0},{"$f":"AC19*$AC$4","v":0},{"$f":"AD19*$AD$4","v":0},{"$f":"(AB23+AC23+AD23)*1","v":0},null,null,{"$f":"AH19*$AH$4","v":0},{"$f":"AI19*$AI$4","v":0},{"$f":"AJ19*$AJ$4","v":0},{"$f":"(AH23+AI23+AJ23)*1","v":0},null,null,{"$f":"AN19*$AN$4","v":0},{"$f":"AO19*$AO$4","v":0},{"$f":"(AN23+AO23)*1","v":0},null,null,{"$f":"AS19*$AS$4","v":0},{"$f":"AT19*$AT$4","v":0},{"$f":"AU19*$AU$4","v":0},{"$f":"(AS23+AT23+AU23)*1","v":0},null,null,{"$f":"AY19*$AY$4","v":0},{"$f":"AZ19*$AZ$4","v":0},{"$f":"BA19*$BA$4","v":0},{"$f":"(AY23+AZ23+BA23)*1","v":0},null,null,{"$f":"BE19*$BE$4","v":0},{"$f":"BF19*$BF$4","v":0},{"$f":"(BE23+BF23)*1","v":0},null,null,{"$f":"BJ19*$BJ$4","v":0},{"$f":"BK19*$BK$4","v":0},{"$f":"BL19*$BL$4","v":0},{"$f":"BM19*$BM$4","v":0},{"$f":"(BL23+BM23)*1","v":0},null,null,{"$f":"BQ19*$BQ$4","v":0},{"$f":"BR19*$BR$4","v":0},{"$f":"BS19*$BS$4","v":0},{"$f":"(BQ23+BR23+BS23)*1","v":0},null,null,{"$f":"BW19*$BW$4","v":0},{"$f":"BX19*$BX$4","v":0},{"$f":"BY19*$BY$4","v":0},{"$f":"(BX23+BY23)*1","v":0},null,null,{"$f":"CC19*$CC$4","v":0},{"$f":"CD19*$CD$4","v":0},{"$f":"(CC23+CD23)*1","v":0},null,null,{"$f":"CH19*$CH$4","v":0},{"$f":"CI19*$CI$4","v":0},{"$f":"CJ19*$CJ$4","v":0},{"$f":"(CH23+CI23+CJ23)*1","v":0},null,null,{"$f":"CN19*$CN$4","v":0},{"$f":"CO19*$CO$4","v":0},{"$f":"CP19*$CP$4","v":0},{"$f":"(CN23+CO23+CP23)*1","v":0},null,{"$f":"SUM(G23,J23,O23,AE23,AK23,Y23,AP23,AV23,BB23,BG23,BN23,BT23,BZ23,CE23,CK23,CQ23)","v":0},null,{"$f":"MIN(400,MAX(CS23,0))/400","v":0}]
[null,"Deposit 4",{"$f":"_xlfn.IFS('Surrounding and site'!$G$12=\"Very high (100%)\",100,'Surrounding and site'!$G$12=\"High (75%)\",75,'Surrounding and site'!$G$12=\"Medium (50%)\",50,'Surrounding and site'!$G$12=\"Low (25%)\",25,'Surrounding and site'!$G$12=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(C24=\"\",0,TRUE,C24)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"No\",1,0)","v":0},{"$f":"G25+G26+G27+G28","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"Yes\",1,0)","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"No\",1,0)","v":0},{"$f":"J25+J26+J27+J28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$15=\"Very high (100%)\",100,'Surrounding and site'!$G$15=\"High (75%)\",75,'Surrounding and site'!$G$15=\"Medium (50%)\",50,'Surrounding and site'!$G$15=\"Low (25%)\",25,'Surrounding and site'!$G$15=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(K24=\"\",0,TRUE,K24)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"No\",1,0)","v":0},{"$f":"O25+O26+O27+O28","v":0},{"$f":"_xlfn.IFS('Deposit 4'!$C$14=\"Very high (100%)\",100,'Deposit 4'!$C$14=\"High (75%)\",75,'Deposit 4'!$C$14=\"Medium (50%)\",50,'Deposit 4'!$C$14=\"Low (25%)\",25,'Deposit 4'!$C$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(P24=\"\",0,TRUE,P24)","v":0},{"$f":"IF('Deposit 4'!$B$14=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$15=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$16=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$17=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$18=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$19=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 4'!$B$20=\"Yes\",1,0)","v":0},{"$f":"Y25+Y26+Y27+Y28","v":0},{"$f":"_xlfn.IFS('Deposit 4'!$G$24=\"Very high (100%)\",100,'Deposit 4'!$G$24=\"High (75%)\",75,'Deposit 4'!$G$24=\"Medium (50%)\",50,'Deposit 4'!$G$24=\"Low (25%)\",25,'Deposit 4'!$G$24=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(Z24=\"\",0,TRUE,Z24)","v":0},{"$f":"IF(AND('Deposit 4'!$F$24>0,'Deposit 4'!$F$24<=200000),1,0)","v":0},{"$f":"IF(AND('Deposit 4'!$F$24>=200000,'Deposit 4'!$F$24<=500000),1,0)","v":0},{"$f":"IF('Deposit 4'!$F$24>500000,1,0)","v":0},{"$f":"AE25+AE26+AE27+AE28","v":0},{"$f":"_xlfn.IFS('Deposit 4'!$G$25=\"Very high (100%)\",100,'Deposit 4'!$G$25=\"High (75%)\",75,'Deposit 4'!$G$25=\"Medium (50%)\",50,'Deposit 4'!$G$25=\"Low (25%)\",25,'Deposit 4'!$G$25=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AF24=\"\",0,TRUE,AF24)","v":0},{"$f":"IF(AND('Deposit 4'!$F$25>0,'Deposit 4'!$F$25<=10000),1,0)","v":0},{"$f":"IF(AND('Deposit 4'!$F$25>=10000,'Deposit 4'!$F$25<=100000),1,0)","v":0},{"$f":"IF('Deposit 4'!$F$25>100000,1,0)","v":0},{"$f":"AK25+AK26+AK27+AK28","v":0},{"$f":"_xlfn.IFS('Deposit 4'!$G$26=\"Very high (100%)\",100,'Deposit 4'!$G$26=\"High (75%)\",75,'Deposit 4'!$G$26=\"Medium (50%)\",50,'Deposit 4'!$G$26=\"Low (25%)\",25,'Deposit 4'!$G$26=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AL24=\"\",0,TRUE,AL24)","v":0},{"$f":"IF('Deposit 4'!$F$26=\"Separated\",1,0)","v":0},{"$f":"IF('Deposit 4'!$F$26=\"Mixed\",1,0)","v":0},{"$f":"AP25+AP26+AP27+AP28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$18=\"Very high (100%)\",100,'Surrounding and site'!$G$18=\"High (75%)\",75,'Surrounding and site'!$G$18=\"Medium (50%)\",50,'Surrounding and site'!$G$18=\"Low (25%)\",25,'Surrounding and site'!$G$18=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AQ24=\"\",0,TRUE,AQ24)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\">75%\",1,0)","v":0},{"$f":"AV25+AV26+AV27+AV28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$19=\"Very high (100%)\",100,'Surrounding and site'!$G$19=\"High (75%)\",75,'Surrounding and site'!$G$19=\"Medium (50%)\",50,'Surrounding and site'!$G$19=\"Low (25%)\",25,'Surrounding and site'!$G$19=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AW24=\"\",0,TRUE,AW24)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\">75%\",1,0)","v":0},{"$f":"BB25+BB26+BB27+BB28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$16=\"Very high (100%)\",100,'Surrounding and site'!$G$16=\"High (75%)\",75,'Surrounding and site'!$G$16=\"Medium (50%)\",50,'Surrounding and site'!$G$16=\"Low (25%)\",25,'Surrounding and site'!$G$16=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BC24=\"\",0,TRUE,BC24)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"No\",1,0)","v":0},{"$f":"BG25+BG26+BG27+BG28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$20=\"Very high (100%)\",100,'Surrounding and site'!$G$20=\"High (75%)\",75,'Surrounding and site'!$G$20=\"Medium (50%)\",50,'Surrounding and site'!$G$20=\"Low (25%)\",25,'Surrounding and site'!$G$20=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BH24=\"\",0,TRUE,BH24)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site but not on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not easy to access to the site but accessible on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site and on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not accessible\",1,0)","v":0},{"$f":"BN25+BN26+BN27+BN28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$21=\"Very high (100%)\",100,'Surrounding and site'!$G$21=\"High (75%)\",75,'Surrounding and site'!$G$21=\"Medium (50%)\",50,'Surrounding and site'!$G$21=\"Low (25%)\",25,'Surrounding and site'!$G$21=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BO24=\"\",0,TRUE,BO24)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Low risk (no industrial activity identified and no pollution)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)\",1,0)","v":0},{"$f":"BT25+BT26+BT27+BT28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$13=\"Very high (100%)\",100,'Surrounding and site'!$G$13=\"High (75%)\",75,'Surrounding and site'!$G$13=\"Medium (50%)\",50,'Surrounding and site'!$G$13=\"Low (25%)\",25,'Surrounding and site'!$G$13=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BU24=\"\",0,TRUE,BU24)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from environmental/ legal aspects\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from others aspects (urban planning, biodiversity, etc.)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"No\",1,0)","v":0},{"$f":"BZ25+BZ26+BZ27+BZ28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$14=\"Very high (100%)\",100,'Surrounding and site'!$G$14=\"High (75%)\",75,'Surrounding and site'!$G$14=\"Medium (50%)\",50,'Surrounding and site'!$G$14=\"Low (25%)\",25,'Surrounding and site'!$G$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CA24=\"\",0,TRUE,CA24)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"No\",1,0)","v":0},{"$f":"CE25+CE26+CE27+CE28","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$17=\"Very high (100%)\",100,'Surrounding and site'!$G$17=\"High (75%)\",75,'Surrounding and site'!$G$17=\"Medium (50%)\",50,'Surrounding and site'!$G$17=\"Low (25%)\",25,'Surrounding and site'!$G$17=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CF24=\"\",0,TRUE,CF24)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"0 to 25%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"25 to 50%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\">50%\",1,0)","v":0},{"$f":"CK25+CK26+CK27+CK28","v":0},{"$f":"_xlfn.IFS('Deposit 4'!$G$27=\"Very high (100%)\",100,'Deposit 4'!$G$27=\"High (75%)\",75,'Deposit 4'!$G$27=\"Medium (50%)\",50,'Deposit 4'!$G$27=\"Low (25%)\",25,'Deposit 4'!$G$27=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CL24=\"\",0,TRUE,CL24)","v":0},{"$f":"IF('Deposit 4'!$F$27=\"Abandoned (without protected area)\",1,0)","v":0},{"$f":"IF('Deposit 4'!$F$27=\"Abandoned (with protected area)\",1,0)","v":0},{"$f":"IF('Deposit 4'!$F$27=\"Activities still present (industry, use by people, etc.)\",1,0)","v":0},{"$f":"CQ25+CQ26+CQ27+CQ28","v":0},null,{"$f":"2*(CS25+CS26)+1*CS27+0.5*CS28","v":0},{"$f":"(CM24+CG24+CB24+BV24+BP24+BI24+BD24+AX24+AR24+AM24+AG24+AA24+Q24+L24+D24)/1500","v":0},{"$f":"MIN(4200,MAX(CS24,0))/4200","v":0}]
[null,"metals",null,null,{"$f":"E24*$E$1","v":0},{"$f":"F24*$F$1","v":0},{"$f":"(E25+F25)*1","v":0},{"$f":"H24*$H$1","v":0},{"$f":"I24*$I$1","v":0},{"$f":"(H25+I25)*1","v":0},null,null,{"$f":"M24*$M$1","v":0},{"$f":"N24*$N$1","v":0},{"$f":"(M25+N25)*1","v":0},null,null,{"$f":"R24*$R$1","v":0},{"$f":"S24*$S$1","v":0},{"$f":"T24*$T$1","v":0},{"$f":"U24*$U$1","v":0},{"$f":"V24*$V$1","v":0},{"$f":"W24*$W$1","v":0},{"$f":"X24*$X$1","v":0},{"$f":"(MAX(R25:X25))*1","v":0},null,null,{"$f":"AB24*$AB$1","v":0},{"$f":"AC24*$AC$1","v":0},{"$f":"AD24*$AD$1","v":0},{"$f":"(AB25+AC25+AD25)*1","v":0},null,null,{"$f":"AH24*$AH$1","v":0},{"$f":"AI24*$AI$1","v":0},{"$f":"AJ24*$AJ$1","v":0},{"$f":"(AH25+AI25+AJ25)*1","v":0},null,null,{"$f":"AN24*$AN$1","v":0},{"$f":"AO24*$AO$1","v":0},{"$f":"(AN25+AO25)*1","v":0},null,null,{"$f":"AS24*$AS$1","v":0},{"$f":"AT24*$AT$1","v":0},{"$f":"AU24*$AU$1","v":0},{"$f":"(AS25+AT25+AU25)*1","v":0},null,null,{"$f":"AY24*$AY$1","v":0},{"$f":"AZ24*$AZ$1","v":0},{"$f":"BA24*$BA$1","v":0},{"$f":"(AY25+AZ25+BA25)*1","v":0},null,null,{"$f":"BE24*$BE$1","v":0},{"$f":"BF24*$BF$1","v":0},{"$f":"(BE25+BF25)*1","v":0},null,null,{"$f":"BJ24*$BJ$1","v":0},{"$f":"BK24*$BK$1","v":0},{"$f":"BL24*$BL$1","v":0},{"$f":"BM24*$BM$1","v":0},{"$f":"(BL25+BM25)*1","v":0},null,null,{"$f":"BQ24*$BQ$1","v":0},{"$f":"BR24*$BR$1","v":0},{"$f":"BS24*$BS$1","v":0},{"$f":"(BQ25+BR25+BS25)*1","v":0},null,null,{"$f":"BW24*$BW$1","v":0},{"$f":"BX24*$BX$1","v":0},{"$f":"BY24*$BY$1","v":0},{"$f":"(BX25+BY25)*1","v":0},null,null,{"$f":"CC24*$CC$1","v":0},{"$f":"CD24*$CD$1","v":0},{"$f":"(CC25+CD25)*1","v":0},null,null,{"$f":"CH24*$CH$1","v":0},{"$f":"CI24*$CI$1","v":0},{"$f":"CJ24*$CJ$1","v":0},{"$f":"(CH25+CI25+CJ25)*1","v":0},null,null,{"$f":"CN24*$CN$1","v":0},{"$f":"CO24*$CO$1","v":0},{"$f":"CP24*$CP$1","v":0},{"$f":"(CN25+CO25+CP25)*1","v":0},null,{"$f":"SUM(G25,J25,O25,AE25,AK25,Y25,AP25,AV25,BB25,BG25,BN25,BT25,BZ25,CE25,CK25,CQ25)","v":0},null,{"$f":"MIN(900,MAX(CS25,0))/900","v":0},null,"number of questions whose confidence <=50    ==>",null,null,null,{"$f":"SUM(COUNTIF(C24,\"<=50\"),COUNTIF(K24,\"<=50\"),COUNTIF(P24,\"<=50\"),COUNTIF(Z24,\"<=50\"),COUNTIF(AF24,\"<=50\"),COUNTIF(AL24,\"<=50\"),COUNTIF(AQ24,\"<=50\"),COUNTIF(AW24,\"<=50\"),COUNTIF(BC24,\"<=50\"),COUNTIF(BH24,\"<=50\"),COUNTIF(BO24,\"=<=50\"),COUNTIF(BU24,\"<=50\"),COUNTIF(CA24,\"<=50\"),COUNTIF(CF24,\"<=50\"),COUNTIF(CL24,\"<=50\"))","v":0}]
[null,"minerals",null,null,{"$f":"E24*$E$2","v":0},{"$f":"F24*$F$2","v":0},{"$f":"(E26+F26)*1","v":0},{"$f":"H24*$H$2","v":0},{"$f":"I24*$I$2","v":0},{"$f":"(H26+I26)*1","v":0},null,null,{"$f":"M24*$M$2","v":0},{"$f":"N24*$N$2","v":0},{"$f":"(M26+N26)*1","v":0},null,null,{"$f":"R24*$R$2","v":0},{"$f":"S24*$S$2","v":0},{"$f":"T24*$T$2","v":0},{"$f":"U24*$U$2","v":0},{"$f":"V24*$V$2","v":0},{"$f":"W24*$W$2","v":0},{"$f":"X24*$X$2","v":0},{"$f":"(MAX(R26:X26))*1","v":0},null,null,{"$f":"AB24*$AB$2","v":0},{"$f":"AC24*$AC$2","v":0},{"$f":"AD24*$AD$2","v":0},{"$f":"(AB26+AC26+AD26)*1","v":0},null,null,{"$f":"AH24*$AH$2","v":0},{"$f":"AI24*$AI$2","v":0},{"$f":"AJ24*$AJ$2","v":0},{"$f":"(AH26+AI26+AJ26)*1","v":0},null,null,{"$f":"AN24*$AN$2","v":0},{"$f":"AO24*$AO$2","v":0},{"$f":"(AN26+AO26)*1","v":0},null,null,{"$f":"AS24*$AS$2","v":0},{"$f":"AT24*$AT$2","v":0},{"$f":"AU24*$AU$2","v":0},{"$f":"(AS26+AT26+AU26)*1","v":0},null,null,{"$f":"AY24*$AY$2","v":0},{"$f":"AZ24*$AZ$2","v":0},{"$f":"BA24*$BA$2","v":0},{"$f":"(AY26+AZ26+BA26)*1","v":0},null,null,{"$f":"BE24*$BE$2","v":0},{"$f":"BF24*$BF$2","v":0},{"$f":"(BE26+BF26)*1","v":0},null,null,{"$f":"BJ24*$BJ$2","v":0},{"$f":"BK24*$BK$2","v":0},{"$f":"BL24*$BL$2","v":0},{"$f":"BM24*$BM$2","v":0},{"$f":"(BL26+BM26)*1","v":0},null,null,{"$f":"BQ24*$BQ$2","v":0},{"$f":"BR24*$BR$2","v":0},{"$f":"BS24*$BS$2","v":0},{"$f":"(BQ26+BR26+BS26)*1","v":0},null,null,{"$f":"BW24*$BW$2","v":0},{"$f":"BX24*$BX$2","v":0},{"$f":"BY24*$BY$2","v":0},{"$f":"(BX26+BY26)*1","v":0},null,null,{"$f":"CC24*$CC$2","v":0},{"$f":"CD24*$CD$2","v":0},{"$f":"(CC26+CD26)*1","v":0},null,null,{"$f":"CH24*$CH$2","v":0},{"$f":"CI24*$CI$2","v":0},{"$f":"CJ24*$CJ$2","v":0},{"$f":"(CH26+CI26+CJ26)*1","v":0},null,null,{"$f":"CN24*$CN$2","v":0},{"$f":"CO24*$CO$2","v":0},{"$f":"CP24*$CP$2","v":0},{"$f":"(CN26+CO26+CP26)*1","v":0},null,{"$f":"SUM(G26,J26,O26,AE26,AK26,Y26,AP26,AV26,BB26,BG26,BN26,BT26,BZ26,CE26,CK26,CQ26)","v":0},null,{"$f":"MIN(900,MAX(CS26,0))/900","v":0},null,"number of questions whose confidence =\"\"       ==>",null,null,null,{"$f":"SUM(COUNTIF(C24,\"\"),COUNTIF(K24,\"\"),COUNTIF(P24,\"\"),COUNTIF(Z24,\"\"),COUNTIF(AF24,\"\"),COUNTIF(AL24,\"\"),COUNTIF(AQ24,\"\"),COUNTIF(AW24,\"\"),COUNTIF(BC24,\"\"),COUNTIF(BH24,\"\"),COUNTIF(BO24,\"\"),COUNTIF(BU24,\"\"),COUNTIF(CA24,\"\"),COUNTIF(CF24,\"\"),COUNTIF(CL24,\"\"))","v":15}]
[null,"soil",null,null,{"$f":"E24*$E$3","v":0},{"$f":"F24*$F$3","v":0},{"$f":"(E27+F27)*1","v":0},{"$f":"H24*$H$3","v":0},{"$f":"I24*$I$3","v":0},{"$f":"(H27+I27)*1","v":0},null,null,{"$f":"M24*$M$3","v":0},{"$f":"N24*$N$3","v":0},{"$f":"(M27+N27)*1","v":0},null,null,{"$f":"R24*$R$3","v":0},{"$f":"S24*$S$3","v":0},{"$f":"T24*$T$3","v":0},{"$f":"U24*$U$3","v":0},{"$f":"V24*$V$3","v":0},{"$f":"W24*$W$3","v":0},{"$f":"X24*$X$3","v":0},{"$f":"(MAX(R27:X27))*1","v":0},null,null,{"$f":"AB24*$AB$3","v":0},{"$f":"AC24*$AC$3","v":0},{"$f":"AD24*$AD$3","v":0},{"$f":"(AB27+AC27+AD27)*1","v":0},null,null,{"$f":"AH24*$AH$3","v":0},{"$f":"AI24*$AI$3","v":0},{"$f":"AJ24*$AJ$3","v":0},{"$f":"(AH27+AI27+AJ27)*1","v":0},null,null,{"$f":"AN24*$AN$3","v":0},{"$f":"AO24*$AO$3","v":0},{"$f":"(AN27+AO27)*1","v":0},null,null,{"$f":"AS24*$AS$3","v":0},{"$f":"AT24*$AT$3","v":0},{"$f":"AU24*$AU$3","v":0},{"$f":"(AS27+AT27+AU27)*1","v":0},null,null,{"$f":"AY24*$AY$3","v":0},{"$f":"AZ24*$AZ$3","v":0},{"$f":"BA24*$BA$3","v":0},{"$f":"(AY27+AZ27+BA27)*1","v":0},null,null,{"$f":"BE24*$BE$3","v":0},{"$f":"BF24*$BF$3","v":0},{"$f":"(BE27+BF27)*1","v":0},null,null,{"$f":"BJ24*$BJ$3","v":0},{"$f":"BK24*$BK$3","v":0},{"$f":"BL24*$BL$3","v":0},{"$f":"BM24*$BM$3","v":0},{"$f":"(BL27+BM27)*1","v":0},null,null,{"$f":"BQ24*$BQ$3","v":0},{"$f":"BR24*$BR$3","v":0},{"$f":"BS24*$BS$3","v":0},{"$f":"(BQ27+BR27+BS27)*1","v":0},null,null,{"$f":"BW24*$BW$3","v":0},{"$f":"BX24*$BX$3","v":0},{"$f":"BY24*$BY$3","v":0},{"$f":"(BX27+BY27)*1","v":0},null,null,{"$f":"CC24*$CC$3","v":0},{"$f":"CD24*$CD$3","v":0},{"$f":"(CC27+CD27)*1","v":0},null,null,{"$f":"CH24*$CH$3","v":0},{"$f":"CI24*$CI$3","v":0},{"$f":"CJ24*$CJ$3","v":0},{"$f":"(CH27+CI27+CJ27)*1","v":0},null,null,{"$f":"CN24*$CN$3","v":0},{"$f":"CO24*$CO$3","v":0},{"$f":"CP24*$CP$3","v":0},{"$f":"(CN27+CO27+CP27)*1","v":0},null,{"$f":"SUM(G27,J27,O27,AE27,AK27,Y27,AP27,AV27,BB27,BG27,BN27,BT27,BZ27,CE27,CK27,CQ27)","v":0},null,{"$f":"MIN(200,MAX(CS27,0))/200","v":0}]
[null,"ecocat",null,null,{"$f":"E24*$E$4","v":0},{"$f":"F24*$F$4","v":0},{"$f":"(E28+F28)*1","v":0},{"$f":"H24*$H$4","v":0},{"$f":"I24*$I$4","v":0},{"$f":"(H28+I28)*1","v":0},null,null,{"$f":"M24*$M$4","v":0},{"$f":"N24*$N$4","v":0},{"$f":"(M28+N28)*1","v":0},null,null,{"$f":"R24*$R$4","v":0},{"$f":"S24*$S$4","v":0},{"$f":"T24*$T$4","v":0},{"$f":"U24*$U$4","v":0},{"$f":"V24*$V$4","v":0},{"$f":"W24*$W$4","v":0},{"$f":"X24*$X$4","v":0},{"$f":"(MAX(R28:X28))*1","v":0},null,null,{"$f":"AB24*$AB$4","v":0},{"$f":"AC24*$AC$4","v":0},{"$f":"AD24*$AD$4","v":0},{"$f":"(AB28+AC28+AD28)*1","v":0},null,null,{"$f":"AH24*$AH$4","v":0},{"$f":"AI24*$AI$4","v":0},{"$f":"AJ24*$AJ$4","v":0},{"$f":"(AH28+AI28+AJ28)*1","v":0},null,null,{"$f":"AN24*$AN$4","v":0},{"$f":"AO24*$AO$4","v":0},{"$f":"(AN28+AO28)*1","v":0},null,null,{"$f":"AS24*$AS$4","v":0},{"$f":"AT24*$AT$4","v":0},{"$f":"AU24*$AU$4","v":0},{"$f":"(AS28+AT28+AU28)*1","v":0},null,null,{"$f":"AY24*$AY$4","v":0},{"$f":"AZ24*$AZ$4","v":0},{"$f":"BA24*$BA$4","v":0},{"$f":"(AY28+AZ28+BA28)*1","v":0},null,null,{"$f":"BE24*$BE$4","v":0},{"$f":"BF24*$BF$4","v":0},{"$f":"(BE28+BF28)*1","v":0},null,null,{"$f":"BJ24*$BJ$4","v":0},{"$f":"BK24*$BK$4","v":0},{"$f":"BL24*$BL$4","v":0},{"$f":"BM24*$BM$4","v":0},{"$f":"(BL28+BM28)*1","v":0},null,null,{"$f":"BQ24*$BQ$4","v":0},{"$f":"BR24*$BR$4","v":0},{"$f":"BS24*$BS$4","v":0},{"$f":"(BQ28+BR28+BS28)*1","v":0},null,null,{"$f":"BW24*$BW$4","v":0},{"$f":"BX24*$BX$4","v":0},{"$f":"BY24*$BY$4","v":0},{"$f":"(BX28+BY28)*1","v":0},null,null,{"$f":"CC24*$CC$4","v":0},{"$f":"CD24*$CD$4","v":0},{"$f":"(CC28+CD28)*1","v":0},null,null,{"$f":"CH24*$CH$4","v":0},{"$f":"CI24*$CI$4","v":0},{"$f":"CJ24*$CJ$4","v":0},{"$f":"(CH28+CI28+CJ28)*1","v":0},null,null,{"$f":"CN24*$CN$4","v":0},{"$f":"CO24*$CO$4","v":0},{"$f":"CP24*$CP$4","v":0},{"$f":"(CN28+CO28+CP28)*1","v":0},null,{"$f":"SUM(G28,J28,O28,AE28,AK28,Y28,AP28,AV28,BB28,BG28,BN28,BT28,BZ28,CE28,CK28,CQ28)","v":0},null,{"$f":"MIN(400,MAX(CS28,0))/400","v":0}]
[null,"Deposit 5",{"$f":"_xlfn.IFS('Surrounding and site'!$G$12=\"Very high (100%)\",100,'Surrounding and site'!$G$12=\"High (75%)\",75,'Surrounding and site'!$G$12=\"Medium (50%)\",50,'Surrounding and site'!$G$12=\"Low (25%)\",25,'Surrounding and site'!$G$12=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(C29=\"\",0,TRUE,C29)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$12=\"No\",1,0)","v":0},{"$f":"G30+G31+G32+G33","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"Yes\",1,0)","v":0},{"$f":"IF('General PMSD ID-card'!$C$6=\"No\",1,0)","v":0},{"$f":"J30+J31+J32+J33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$15=\"Very high (100%)\",100,'Surrounding and site'!$G$15=\"High (75%)\",75,'Surrounding and site'!$G$15=\"Medium (50%)\",50,'Surrounding and site'!$G$15=\"Low (25%)\",25,'Surrounding and site'!$G$15=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(K29=\"\",0,TRUE,K29)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$15=\"No\",1,0)","v":0},{"$f":"O30+O31+O32+O33","v":0},{"$f":"_xlfn.IFS('Deposit 5'!$C$14=\"Very high (100%)\",100,'Deposit 5'!$C$14=\"High (75%)\",75,'Deposit 5'!$C$14=\"Medium (50%)\",50,'Deposit 5'!$C$14=\"Low (25%)\",25,'Deposit 5'!$C$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(P29=\"\",0,TRUE,P29)","v":0},{"$f":"IF('Deposit 5'!$B$14=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$15=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$16=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$17=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$18=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$19=\"Yes\",1,0)","v":0},{"$f":"IF('Deposit 5'!$B$20=\"Yes\",1,0)","v":0},{"$f":"Y30+Y31+Y32+Y33","v":0},{"$f":"_xlfn.IFS('Deposit 5'!$G$24=\"Very high (100%)\",100,'Deposit 5'!$G$24=\"High (75%)\",75,'Deposit 5'!$G$24=\"Medium (50%)\",50,'Deposit 5'!$G$24=\"Low (25%)\",25,'Deposit 5'!$G$24=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(Z29=\"\",0,TRUE,Z29)","v":0},{"$f":"IF(AND('Deposit 5'!$F$24>0,'Deposit 5'!$F$24<=200000),1,0)","v":0},{"$f":"IF(AND('Deposit 5'!$F$24>=200000,'Deposit 5'!$F$24<=500000),1,0)","v":0},{"$f":"IF('Deposit 5'!$F$24>500000,1,0)","v":0},{"$f":"AE30+AE31+AE32+AE33","v":0},{"$f":"_xlfn.IFS('Deposit 5'!$G$25=\"Very high (100%)\",100,'Deposit 5'!$G$25=\"High (75%)\",75,'Deposit 5'!$G$25=\"Medium (50%)\",50,'Deposit 5'!$G$25=\"Low (25%)\",25,'Deposit 5'!$G$25=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AF29=\"\",0,TRUE,AF29)","v":0},{"$f":"IF(AND('Deposit 5'!$F$25>0,'Deposit 5'!$F$25<=10000),1,0)","v":0},{"$f":"IF(AND('Deposit 5'!$F$25>=10000,'Deposit 5'!$F$25<=100000),1,0)","v":0},{"$f":"IF('Deposit 5'!$F$25>100000,1,0)","v":0},{"$f":"AK30+AK31+AK32+AK33","v":0},{"$f":"_xlfn.IFS('Deposit 5'!$G$26=\"Very high (100%)\",100,'Deposit 5'!$G$26=\"High (75%)\",75,'Deposit 5'!$G$26=\"Medium (50%)\",50,'Deposit 5'!$G$26=\"Low (25%)\",25,'Deposit 5'!$G$26=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AL29=\"\",0,TRUE,AL29)","v":0},{"$f":"IF('Deposit 5'!$F$26=\"Separated\",1,0)","v":0},{"$f":"IF('Deposit 5'!$F$26=\"Mixed\",1,0)","v":0},{"$f":"AP30+AP31+AP32+AP33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$18=\"Very high (100%)\",100,'Surrounding and site'!$G$18=\"High (75%)\",75,'Surrounding and site'!$G$18=\"Medium (50%)\",50,'Surrounding and site'!$G$18=\"Low (25%)\",25,'Surrounding and site'!$G$18=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AQ29=\"\",0,TRUE,AQ29)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$18=\">75%\",1,0)","v":0},{"$f":"AV30+AV31+AV32+AV33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$19=\"Very high (100%)\",100,'Surrounding and site'!$G$19=\"High (75%)\",75,'Surrounding and site'!$G$19=\"Medium (50%)\",50,'Surrounding and site'!$G$19=\"Low (25%)\",25,'Surrounding and site'!$G$19=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(AW29=\"\",0,TRUE,AW29)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"0 to 50% \",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\"50 to 75%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$19=\">75%\",1,0)","v":0},{"$f":"BB30+BB31+BB32+BB33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$16=\"Very high (100%)\",100,'Surrounding and site'!$G$16=\"High (75%)\",75,'Surrounding and site'!$G$16=\"Medium (50%)\",50,'Surrounding and site'!$G$16=\"Low (25%)\",25,'Surrounding and site'!$G$16=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BC29=\"\",0,TRUE,BC29)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$16=\"No\",1,0)","v":0},{"$f":"BG30+BG31+BG32+BG33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$20=\"Very high (100%)\",100,'Surrounding and site'!$G$20=\"High (75%)\",75,'Surrounding and site'!$G$20=\"Medium (50%)\",50,'Surrounding and site'!$G$20=\"Low (25%)\",25,'Surrounding and site'!$G$20=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BH29=\"\",0,TRUE,BH29)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site but not on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not easy to access to the site but accessible on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Easy to access to the site and on the site\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$20=\"Not accessible\",1,0)","v":0},{"$f":"BN30+BN31+BN32+BN33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$21=\"Very high (100%)\",100,'Surrounding and site'!$G$21=\"High (75%)\",75,'Surrounding and site'!$G$21=\"Medium (50%)\",50,'Surrounding and site'!$G$21=\"Low (25%)\",25,'Surrounding and site'!$G$21=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BO29=\"\",0,TRUE,BO29)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Low risk (no industrial activity identified and no pollution)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"Moderate risk (usual risk, e.g. moderately hazardous contamination such as heavy metals)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$21=\"High risk (contamination that requires the use of special measures or equipment, e.g. asbestos, tar, toxic chemical products)\",1,0)","v":0},{"$f":"BT30+BT31+BT32+BT33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$13=\"Very high (100%)\",100,'Surrounding and site'!$G$13=\"High (75%)\",75,'Surrounding and site'!$G$13=\"Medium (50%)\",50,'Surrounding and site'!$G$13=\"Low (25%)\",25,'Surrounding and site'!$G$13=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(BU29=\"\",0,TRUE,BU29)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from environmental/ legal aspects\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"Yes, from others aspects (urban planning, biodiversity, etc.)\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$13=\"No\",1,0)","v":0},{"$f":"BZ30+BZ31+BZ32+BZ33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$14=\"Very high (100%)\",100,'Surrounding and site'!$G$14=\"High (75%)\",75,'Surrounding and site'!$G$14=\"Medium (50%)\",50,'Surrounding and site'!$G$14=\"Low (25%)\",25,'Surrounding and site'!$G$14=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CA29=\"\",0,TRUE,CA29)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"Yes\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$14=\"No\",1,0)","v":0},{"$f":"CE30+CE31+CE32+CE33","v":0},{"$f":"_xlfn.IFS('Surrounding and site'!$G$17=\"Very high (100%)\",100,'Surrounding and site'!$G$17=\"High (75%)\",75,'Surrounding and site'!$G$17=\"Medium (50%)\",50,'Surrounding and site'!$G$17=\"Low (25%)\",25,'Surrounding and site'!$G$17=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CF29=\"\",0,TRUE,CF29)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"0 to 25%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\"25 to 50%\",1,0)","v":0},{"$f":"IF('Surrounding and site'!$F$17=\">50%\",1,0)","v":0},{"$f":"CK30+CK31+CK32+CK33","v":0},{"$f":"_xlfn.IFS('Deposit 5'!$G$27=\"Very high (100%)\",100,'Deposit 5'!$G$27=\"High (75%)\",75,'Deposit 5'!$G$27=\"Medium (50%)\",50,'Deposit 5'!$G$27=\"Low (25%)\",25,'Deposit 5'!$G$27=\"I do not know (0%)\",0,TRUE,\"\")","v":""},{"$f":"_xlfn.IFS(CL29=\"\",0,TRUE,CL29)","v":0},{"$f":"IF('Deposit 5'!$F$27=\"Abandoned (without protected area)\",1,0)","v":0},{"$f":"IF('Deposit 5'!$F$27=\"Abandoned (with protected area)\",1,0)","v":0},{"$f":"IF('Deposit 5'!$F$27=\"Activities still present (industry, use by people, etc.)\",1,0)","v":0},{"$f":"CQ30+CQ31+CQ32+CQ33","v":0},null,{"$f":"2*(CS30+CS31)+1*CS32+0.5*CS33","v":0},{"$f":"(CM29+CG29+CB29+BV29+BP29+BI29+BD29+AX29+AR29+AM29+AG29+AA29+Q29+L29+D29)/1500","v":0},{"$f":"MIN(4200,MAX(CS29,0))/4200","v":0}]
[null,"metals",null,null,{"$f":"E29*$E$1","v":0},{"$f":"F29*$F$1","v":0},{"$f":"(E30+F30)*1","v":0},{"$f":"H29*$H$1","v":0},{"$f":"I29*$I$1","v":0},{"$f":"(H30+I30)*1","v":0},null,null,{"$f":"M29*$M$1","v":0},{"$f":"N29*$N$1","v":0},{"$f":"(M30+N30)*1","v":0},null,null,{"$f":"R29*$R$1","v":0},{"$f":"S29*$S$1","v":0},{"$f":"T29*$T$1","v":0},{"$f":"U29*$U$1","v":0},{"$f":"V29*$V$1","v":0},{"$f":"W29*$W$1","v":0},{"$f":"X29*$X$1","v":0},{"$f":"(MAX(R30:X30))*1","v":0},null,null,{"$f":"AB29*$AB$1","v":0},{"$f":"AC29*$AC$1","v":0},{"$f":"AD29*$AD$1","v":0},{"$f":"(AB30+AC30+AD30)*1","v":0},null,null,{"$f":"AH29*$AH$1","v":0},{"$f":"AI29*$AI$1","v":0},{"$f":"AJ29*$AJ$1","v":0},{"$f":"(AH30+AI30+AJ30)*1","v":0},null,null,{"$f":"AN29*$AN$1","v":0},{"$f":"AO29*$AO$1","v":0},{"$f":"(AN30+AO30)*1","v":0},null,null,{"$f":"AS29*$AS$1","v":0},{"$f":"AT29*$AT$1","v":0},{"$f":"AU29*$AU$1","v":0},{"$f":"(AS30+AT30+AU30)*1","v":0},null,null,{"$f":"AY29*$AY$1","v":0},{"$f":"AZ29*$AZ$1","v":0},{"$f":"BA29*$BA$1","v":0},{"$f":"(AY30+AZ30+BA30)*1","v":0},null,null,{"$f":"BE29*$BE$1","v":0},{"$f":"BF29*$BF$1","v":0},{"$f":"(BE30+BF30)*1","v":0},null,null,{"$f":"BJ29*$BJ$1","v":0},{"$f":"BK29*$BK$1","v":0},{"$f":"BL29*$BL$1","v":0},{"$f":"BM29*$BM$1","v":0},{"$f":"(BL30+BM30)*1","v":0},null,null,{"$f":"BQ29*$BQ$1","v":0},{"$f":"BR29*$BR$1","v":0},{"$f":"BS29*$BS$1","v":0},{"$f":"(BQ30+BR30+BS30)*1","v":0},null,null,{"$f":"BW29*$BW$1","v":0},{"$f":"BX29*$BX$1","v":0},{"$f":"BY29*$BY$1","v":0},{"$f":"(BX30+BY30)*1","v":0},null,null,{"$f":"CC29*$CC$1","v":0},{"$f":"CD29*$CD$1","v":0},{"$f":"(CC30+CD30)*1","v":0},null,null,{"$f":"CH29*$CH$1","v":0},{"$f":"CI29*$CI$1","v":0},{"$f":"CJ29*$CJ$1","v":0},{"$f":"(CH30+CI30+CJ30)*1","v":0},null,null,{"$f":"CN29*$CN$1","v":0},{"$f":"CO29*$CO$1","v":0},{"$f":"CP29*$CP$1","v":0},{"$f":"(CN30+CO30+CP30)*1","v":0},null,{"$f":"SUM(G30,J30,O30,AE30,AK30,Y30,AP30,AV30,BB30,BG30,BN30,BT30,BZ30,CE30,CK30,CQ30)","v":0},null,{"$f":"MIN(900,MAX(CS30,0))/900","v":0},null,"number of questions whose confidence <=50    ==>",null,null,null,{"$f":"SUM(COUNTIF(C29,\"<=50\"),COUNTIF(K29,\"<=50\"),COUNTIF(P29,\"<=50\"),COUNTIF(Z29,\"<=50\"),COUNTIF(AF29,\"<=50\"),COUNTIF(AL29,\"<=50\"),COUNTIF(AQ29,\"<=50\"),COUNTIF(AW29,\"<=50\"),COUNTIF(BC29,\"<=50\"),COUNTIF(BH29,\"<=50\"),COUNTIF(BO29,\"=<=50\"),COUNTIF(BU29,\"<=50\"),COUNTIF(CA29,\"<=50\"),COUNTIF(CF29,\"<=50\"),COUNTIF(CL29,\"<=50\"))","v":0}]
[null,"minerals",null,null,{"$f":"E29*$E$2","v":0},{"$f":"F29*$F$2","v":0},{"$f":"(E31+F31)*1","v":0},{"$f":"H29*$H$2","v":0},{"$f":"I29*$I$2","v":0},{"$f":"(H31+I31)*1","v":0},null,null,{"$f":"M29*$M$2","v":0},{"$f":"N29*$N$2","v":0},{"$f":"(M31+N31)*1","v":0},null,null,{"$f":"R29*$R$2","v":0},{"$f":"S29*$S$2","v":0},{"$f":"T29*$T$2","v":0},{"$f":"U29*$U$2","v":0},{"$f":"V29*$V$2","v":0},{"$f":"W29*$W$2","v":0},{"$f":"X29*$X$2","v":0},{"$f":"(MAX(R31:X31))*1","v":0},null,null,{"$f":"AB29*$AB$2","v":0},{"$f":"AC29*$AC$2","v":0},{"$f":"AD29*$AD$2","v":0},{"$f":"(AB31+AC31+AD31)*1","v":0},null,null,{"$f":"AH29*$AH$2","v":0},{"$f":"AI29*$AI$2","v":0},{"$f":"AJ29*$AJ$2","v":0},{"$f":"(AH31+AI31+AJ31)*1","v":0},null,null,{"$f":"AN29*$AN$2","v":0},{"$f":"AO29*$AO$2","v":0},{"$f":"(AN31+AO31)*1","v":0},null,null,{"$f":"AS29*$AS$2","v":0},{"$f":"AT29*$AT$2","v":0},{"$f":"AU29*$AU$2","v":0},{"$f":"(AS31+AT31+AU31)*1","v":0},null,null,{"$f":"AY29*$AY$2","v":0},{"$f":"AZ29*$AZ$2","v":0},{"$f":"BA29*$BA$2","v":0},{"$f":"(AY31+AZ31+BA31)*1","v":0},null,null,{"$f":"BE29*$BE$2","v":0},{"$f":"BF29*$BF$2","v":0},{"$f":"(BE31+BF31)*1","v":0},null,null,{"$f":"BJ29*$BJ$2","v":0},{"$f":"BK29*$BK$2","v":0},{"$f":"BL29*$BL$2","v":0},{"$f":"BM29*$BM$2","v":0},{"$f":"(BL31+BM31)*1","v":0},null,null,{"$f":"BQ29*$BQ$2","v":0},{"$f":"BR29*$BR$2","v":0},{"$f":"BS29*$BS$2","v":0},{"$f":"(BQ31+BR31+BS31)*1","v":0},null,null,{"$f":"BW29*$BW$2","v":0},{"$f":"BX29*$BX$2","v":0},{"$f":"BY29*$BY$2","v":0},{"$f":"(BX31+BY31)*1","v":0},null,null,{"$f":"CC29*$CC$2","v":0},{"$f":"CD29*$CD$2","v":0},{"$f":"(CC31+CD31)*1","v":0},null,null,{"$f":"CH29*$CH$2","v":0},{"$f":"CI29*$CI$2","v":0},{"$f":"CJ29*$CJ$2","v":0},{"$f":"(CH31+CI31+CJ31)*1","v":0},null,null,{"$f":"CN29*$CN$2","v":0},{"$f":"CO29*$CO$2","v":0},{"$f":"CP29*$CP$2","v":0},{"$f":"(CN31+CO31+CP31)*1","v":0},null,{"$f":"SUM(G31,J31,O31,AE31,AK31,Y31,AP31,AV31,BB31,BG31,BN31,BT31,BZ31,CE31,CK31,CQ31)","v":0},null,{"$f":"MIN(900,MAX(CS31,0))/900","v":0},null,"number of questions whose confidence =\"\"       ==>",null,null,null,{"$f":"SUM(COUNTIF(C29,\"\"),COUNTIF(K29,\"\"),COUNTIF(P29,\"\"),COUNTIF(Z29,\"\"),COUNTIF(AF29,\"\"),COUNTIF(AL29,\"\"),COUNTIF(AQ29,\"\"),COUNTIF(AW29,\"\"),COUNTIF(BC29,\"\"),COUNTIF(BH29,\"\"),COUNTIF(BO29,\"\"),COUNTIF(BU29,\"\"),COUNTIF(CA29,\"\"),COUNTIF(CF29,\"\"),COUNTIF(CL29,\"\"))","v":15}]
[null,"soil",null,null,{"$f":"E29*$E$3","v":0},{"$f":"F29*$F$3","v":0},{"$f":"(E32+F32)*1","v":0},{"$f":"H29*$H$3","v":0},{"$f":"I29*$I$3","v":0},{"$f":"(H32+I32)*1","v":0},null,null,{"$f":"M29*$M$3","v":0},{"$f":"N29*$N$3","v":0},{"$f":"(M32+N32)*1","v":0},null,null,{"$f":"R29*$R$3","v":0},{"$f":"S29*$S$3","v":0},{"$f":"T29*$T$3","v":0},{"$f":"U29*$U$3","v":0},{"$f":"V29*$V$3","v":0},{"$f":"W29*$W$3","v":0},{"$f":"X29*$X$3","v":0},{"$f":"(MAX(R32:X32))*1","v":0},null,null,{"$f":"AB29*$AB$3","v":0},{"$f":"AC29*$AC$3","v":0},{"$f":"AD29*$AD$3","v":0},{"$f":"(AB32+AC32+AD32)*1","v":0},null,null,{"$f":"AH29*$AH$3","v":0},{"$f":"AI29*$AI$3","v":0},{"$f":"AJ29*$AJ$3","v":0},{"$f":"(AH32+AI32+AJ32)*1","v":0},null,null,{"$f":"AN29*$AN$3","v":0},{"$f":"AO29*$AO$3","v":0},{"$f":"(AN32+AO32)*1","v":0},null,null,{"$f":"AS29*$AS$3","v":0},{"$f":"AT29*$AT$3","v":0},{"$f":"AU29*$AU$3","v":0},{"$f":"(AS32+AT32+AU32)*1","v":0},null,null,{"$f":"AY29*$AY$3","v":0},{"$f":"AZ29*$AZ$3","v":0},{"$f":"BA29*$BA$3","v":0},{"$f":"(AY32+AZ32+BA32)*1","v":0},null,null,{"$f":"BE29*$BE$3","v":0},{"$f":"BF29*$BF$3","v":0},{"$f":"(BE32+BF32)*1","v":0},null,null,{"$f":"BJ29*$BJ$3","v":0},{"$f":"BK29*$BK$3","v":0},{"$f":"BL29*$BL$3","v":0},{"$f":"BM29*$BM$3","v":0},{"$f":"(BL32+BM32)*1","v":0},null,null,{"$f":"BQ29*$BQ$3","v":0},{"$f":"BR29*$BR$3","v":0},{"$f":"BS29*$BS$3","v":0},{"$f":"(BQ32+BR32+BS32)*1","v":0},null,null,{"$f":"BW29*$BW$3","v":0},{"$f":"BX29*$BX$3","v":0},{"$f":"BY29*$BY$3","v":0},{"$f":"(BX32+BY32)*1","v":0},null,null,{"$f":"CC29*$CC$3","v":0},{"$f":"CD29*$CD$3","v":0},{"$f":"(CC32+CD32)*1","v":0},null,null,{"$f":"CH29*$CH$3","v":0},{"$f":"CI29*$CI$3","v":0},{"$f":"CJ29*$CJ$3","v":0},{"$f":"(CH32+CI32+CJ32)*1","v":0},null,null,{"$f":"CN29*$CN$3","v":0},{"$f":"CO29*$CO$3","v":0},{"$f":"CP29*$CP$3","v":0},{"$f":"(CN32+CO32+CP32)*1","v":0},null,{"$f":"SUM(G32,J32,O32,AE32,AK32,Y32,AP32,AV32,BB32,BG32,BN32,BT32,BZ32,CE32,CK32,CQ32)","v":0},null,{"$f":"MIN(200,MAX(CS32,0))/200","v":0}]
[null,"ecocat",null,null,{"$f":"E29*$E$4","v":0},{"$f":"F29*$F$4","v":0},{"$f":"(E33+F33)*1","v":0},{"$f":"H29*$H$4","v":0},{"$f":"I29*$I$4","v":0},{"$f":"(H33+I33)*1","v":0},null,null,{"$f":"M29*$M$4","v":0},{"$f":"N29*$N$4","v":0},{"$f":"(M33+N33)*1","v":0},null,null,{"$f":"R29*$R$4","v":0},{"$f":"S29*$S$4","v":0},{"$f":"T29*$T$4","v":0},{"$f":"U29*$U$4","v":0},{"$f":"V29*$V$4","v":0},{"$f":"W29*$W$4","v":0},{"$f":"X29*$X$4","v":0},{"$f":"(MAX(R33:X33))*1","v":0},null,null,{"$f":"AB29*$AB$4","v":0},{"$f":"AC29*$AC$4","v":0},{"$f":"AD29*$AD$4","v":0},{"$f":"(AB33+AC33+AD33)*1","v":0},null,null,{"$f":"AH29*$AH$4","v":0},{"$f":"AI29*$AI$4","v":0},{"$f":"AJ29*$AJ$4","v":0},{"$f":"(AH33+AI33+AJ33)*1","v":0},null,null,{"$f":"AN29*$AN$4","v":0},{"$f":"AO29*$AO$4","v":0},{"$f":"(AN33+AO33)*1","v":0},null,null,{"$f":"AS29*$AS$4","v":0},{"$f":"AT29*$AT$4","v":0},{"$f":"AU29*$AU$4","v":0},{"$f":"(AS33+AT33+AU33)*1","v":0},null,null,{"$f":"AY29*$AY$4","v":0},{"$f":"AZ29*$AZ$4","v":0},{"$f":"BA29*$BA$4","v":0},{"$f":"(AY33+AZ33+BA33)*1","v":0},null,null,{"$f":"BE29*$BE$4","v":0},{"$f":"BF29*$BF$4","v":0},{"$f":"(BE33+BF33)*1","v":0},null,null,{"$f":"BJ29*$BJ$4","v":0},{"$f":"BK29*$BK$4","v":0},{"$f":"BL29*$BL$4","v":0},{"$f":"BM29*$BM$4","v":0},{"$f":"(BL33+BM33)*1","v":0},null,null,{"$f":"BQ29*$BQ$4","v":0},{"$f":"BR29*$BR$4","v":0},{"$f":"BS29*$BS$4","v":0},{"$f":"(BQ33+BR33+BS33)*1","v":0},null,null,{"$f":"BW29*$BW$4","v":0},{"$f":"BX29*$BX$4","v":0},{"$f":"BY29*$BY$4","v":0},{"$f":"(BX33+BY33)*1","v":0},null,null,{"$f":"CC29*$CC$4","v":0},{"$f":"CD29*$CD$4","v":0},{"$f":"(CC33+CD33)*1","v":0},null,null,{"$f":"CH29*$CH$4","v":0},{"$f":"CI29*$CI$4","v":0},{"$f":"CJ29*$CJ$4","v":0},{"$f":"(CH33+CI33+CJ33)*1","v":0},null,null,{"$f":"CN29*$CN$4","v":0},{"$f":"CO29*$CO$4","v":0},{"$f":"CP29*$CP$4","v":0},{"$f":"(CN33+CO33+CP33)*1","v":0},null,{"$f":"SUM(G33,J33,O33,AE33,AK33,Y33,AP33,AV33,BB33,BG33,BN33,BT33,BZ33,CE33,CK33,CQ33)","v":0},null,{"$f":"MIN(400,MAX(CS33,0))/400","v":0}]