{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Lisez-moi","Input Project","Input Variants","Indirect cost","Criterion #1","Criterion #2","Criterion #3","Criterion #4","Output","Blad7"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lisez-moi","index":0,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
["Mode d'emploi de l'outil BATNEEC_tool (pour Excel 2007 et versions ultérieures)"]
[]
["Note préalable"]
["Le présent document utilise des macros. Pour une utilisation optimale, le niveau de sécurité doit être mis au plus faible (menu extra - macro - sécurité)."]
[]
["Le présent outil est à utiliser en combinaison avec l'info-fiche 'ANALYSE BATNEEC'."]
["Différents onglets sont à utiliser pour l'encodage des données. Une fois cela fait, un output est généré, destiné à être placé en annexe du projet d'assainissement."]
[]
["En général"]
["Les champs en jaune sont les champs à compléter. "]
["Si une valeur non valide est introduite, un message d'erreur apparait."]
["Les cellules ne devant pas être complétées sont protégées."]
[]
["Input Project"]
["L'encodage commence au niveau de l'onglet 'input project'."]
["Si différentes taches de contamination sont présentes sur le terrain, chaque tache doit fait l'objet d'une analyse distincte, dans un fichier distinct. La tache évaluée doit être identifiée dans la cellule prévue à cet effet."]
["Concernant les variantes, les champs non applicables doivent rester vides (si 3 variantes, les champs concernant les variantes 4 et suivantes doivent rester vides)."]
["Le nombre maximal de variantes pouvant être introduites est de 7."]
["Le nombre de caractères pour l'intitulé des variantes est limité à 20."]
[]
["Une fois complété, passer à l'onglet 'input variants'."]
[]
["Input Variants"]
["Cet onglet permet d'encoder les données concernant les différentes variantes."]
["Les coûts directs et l'élimination attendue de charge polluante sont à encoder directement dans cet onglet."]
["Les données à introduire sont des nombres positifs, dans le cas contraire les caractères deviennent rouge."]
["Les données devant être justifiées (coûts indirects, différents critères du bonus environnemental) sont à encoder dans les onglets suivants, accessibles notamment via les hyperlinks."]
[]
["Indirect cost"]
["Le coût indirect éventuellement lié à chaque variante (nombre positif ou nul) doit être complété ici. La justification est obligatoire."]
[]
["Criterion #1"]
["Dans cet onglet, l'expert indique pour chaque variante les processus consommateurs d'énergie ou émetteurs de gaz à effet de serre d'application."]
["Si l'expert utilise un calculateur, les résultats de ce dernier sont renseignés ici."]
["Un score est ensuite attribué à chaque variante pour le critère, la valeur étant à choisir dans le menu déroulant (0-5-10-15-20-25)."]
["Ce score doit ensuite obligatoirement être justifié."]
["Ensuite, l'expert peut retourner au tableau général des variantes, où le score est automatiquement copié."]
[]
["Criterion #2"]
["Dans cet onglet, l'expert indique pour chaque variante les gênes pouvant être occasionnées par les travaux d'assainissement."]
["Un score est ensuite attribué à chaque variante pour le critère, la valeur étant à choisir dans le menu déroulant (0-5-10-15-20-25)."]
["Ce score doit ensuite obligatoirement être justifié."]
["Ensuite, l'expert peut retourner au tableau général des variantes, où le score est automatiquement copié."]
[]
["Criterion #3"]
["Dans cet onglet, l'expert indique pour chaque variante les incertitudes d'application."]
["Un score est ensuite attribué à chaque variante pour le critère, la valeur étant à choisir dans le menu déroulant (0-5-10-15-20-25)."]
["Ce score doit ensuite obligatoirement être justifié."]
["Ensuite, l'expert peut retourner au tableau général des variantes, où le score est automatiquement copié."]
[]
["Criterion #4"]
["Dans cet onglet, l'expert complète pour chaque variante les champs concernant les différents aspects connexes, et est libre d'ajouter d'autres aspects si nécessaire."]
["Un score est ensuite attribué à chaque variante pour le critère, la valeur étant à choisir dans le menu déroulant (0-5-10-15-20-25)."]
["Ce score doit ensuite obligatoirement être justifié."]
["Ensuite, l'expert peut retourner au tableau général des variantes, où le score est automatiquement copié."]
[]
["Une fois l'ensemble des données encodées, l'expert peut générer l'output de l'analyse via le bouton 'generate output'."]
[]
["Output"]
["L'output met en graphique les différentes variantes, et permet de visualiser la variante ayant le rendement environnemental (R+) le plus élevé. Cette variante est reprise comme variante préférée."]
["Il reprend également un résumé de l'ensemble des données encodées."]
["Si des données sont modifiées dans l'input après générayion de l'output, le bouton 'generate output' doit à nouveau être actionné."]
[]
["L'output peut être imprimé (sur papier ou fichier pdf) et est à joindre en annexe du PA. Pour la lisibilité, le format A3 est préconisé.",null,null,null,null,null,null,null,null,null,null,null,null,"VERS INPUT PROJECTS"]

{"sheet":"Input Project","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2],[10,1,10,2],[15,1,15,2],[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,15]
[null,"Données du projet"]
[null,"Nom du projet"]
[null,"Références"]
[null,"Expert en pollution du sol"]
[null,"Date de réalisation de l'analyse BATNEEC"]
[null,"Identifiant de la contamination"]
[null,"Charge polluante"]
[null,"Charge polluante calculée dans le sol en kg"]
[null,"Charge polluante calculée dans l'eau souterraine en kg (hors phase libre éventuelle, sauf exception §7.2)"]
[null,"Charge polluante au niveau de la phase libre éventuelle en kg",null,null,null," "]
[null,"Charge polluante totale en kg (hors phase libre éventuelle, sauf exception §7.2)",{"$f":"C12+C13","v":0},null,null,null,null,null,null,null,25]
[null,"Variantes d'assainissement"]
[null,"Intitulé de la variante 1 (V1)"]
[null,"Description de la variante 1 (V1)"]
[null,"Intitulé de la variante 2 (V2)"]
[null,"Description de la variante 2 (V2)"]
[null,"Intitulé de la variante 3 (V3)"]
[null,"Description de la variante 3 (V3)"]
[null,"Intitulé de la variante 4 (V4)"]
[null,"Description de la variante 4 (V4)"]
[null,"Intitulé de la variante 5 (V5)"]
[null,"Description de la variante 5 (V5)"]
[null,"Intitulé de la variante 6 (V6)"]
[null,"Description de la variante 6 (V6)"]
[null,"Intitulé de la variante 7 (V7)"]
[null,"Description de la variante 7 (V7)"]
[]
[]
[null,null,"Vers Input Variants"]

{"sheet":"Input Variants","index":2,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[]
[]
[]
[]
[null,"Critères","Unités","Explication",{"$f":"'Input Project'!C17","v":0},{"$f":"'Input Project'!C19","v":0},{"$f":"'Input Project'!C21","v":0},{"$f":"'Input Project'!C23","v":0},{"$f":"'Input Project'!C25","v":0},{"$f":"'Input Project'!C27","v":0},{"$f":"'Input Project'!C29","v":0},null,{"$f":"'Input Project'!C15","v":0}]
[null,"Coûts d'assainissement"]
[null,"Coûts directs (cf tableau en annexe 3 du PA)"," €"]
[null,"Coûts indirects"," €","Vers onglet couts indirects",{"$f":"'Indirect cost'!C7","v":0},{"$f":"'Indirect cost'!D7","v":0},{"$f":"'Indirect cost'!E7","v":0},{"$f":"'Indirect cost'!F7","v":0},{"$f":"'Indirect cost'!G7","v":0},{"$f":"'Indirect cost'!H7","v":0},{"$f":"'Indirect cost'!I7","v":0}]
[null,"Coûts totaux"," €",null,{"$f":"SUM(E7:E8)","v":0},0,0,0,0,0,0]
[null,"Bilan environnemental"]
[null,"Elimination de charge polluante"]
[null,"Elimination prévue de charge polluante (hors phase libre, sauf exception §7.2)","kg"]
[null,"Elimination de charge polluante en %",null,null,{"$f":"IF(ISERROR(E12/'Input Project'!$C$15*100),\"\",E12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(F12/'Input Project'!$C$15*100),\"\",F12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(G12/'Input Project'!$C$15*100),\"\",G12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(H12/'Input Project'!$C$15*100),\"\",H12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(I12/'Input Project'!$C$15*100),\"\",I12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(J12/'Input Project'!$C$15*100),\"\",J12/'Input Project'!$C$15*100)","v":""},{"$f":"IF(ISERROR(K12/'Input Project'!$C$15*100),\"\",K12/'Input Project'!$C$15*100)","v":""}]
[null,"Bonus environnemental",null,null,null,null,{"$f":"IF(ISERROR(H12/'Input Project'!$C$15*100),\"\",H12/'Input Project'!$C$15*100)","v":""}]
[null,"Critère n°1: Consommation énergétique et émissions de gaz à effet de serre","pts","Vers onglet critère n°1",{"$f":"'Criterion #1'!C9","v":0},{"$f":"'Criterion #1'!D9","v":0},{"$f":"'Criterion #1'!E9","v":0},{"$f":"'Criterion #1'!F9","v":0},{"$f":"'Criterion #1'!G9","v":0},{"$f":"'Criterion #1'!H9","v":0},{"$f":"'Criterion #1'!I9","v":0}]
[null,"Critère n°2: Gêne occasionnée par les travaux d'assainissement","pts","Vers onglet critère n°2",{"$f":"'Criterion #2'!C9","v":0},{"$f":"'Criterion #2'!D9","v":0},{"$f":"'Criterion #2'!E9","v":0},{"$f":"'Criterion #2'!F9","v":0},{"$f":"'Criterion #2'!G9","v":0},{"$f":"'Criterion #2'!H9","v":0},{"$f":"'Criterion #2'!I9","v":0}]
[null,"Critère n°3: Incertitudes","pts","Vers onglet critère n°3",{"$f":"'Criterion #3'!C9","v":0},{"$f":"'Criterion #3'!D9","v":0},{"$f":"'Criterion #3'!E9","v":0},{"$f":"'Criterion #3'!F9","v":0},{"$f":"'Criterion #3'!G9","v":0},{"$f":"'Criterion #3'!H9","v":0},{"$f":"'Criterion #3'!I9","v":0}]
[null,"Critère n°4: Aspects connexes","pts","Vers onglet critère n°4",{"$f":"'Criterion #4'!C14","v":0},{"$f":"'Criterion #4'!D14","v":0},{"$f":"'Criterion #4'!E14","v":0},{"$f":"'Criterion #4'!F14","v":0},{"$f":"'Criterion #4'!G14","v":0},{"$f":"'Criterion #4'!H14","v":0},{"$f":"'Criterion #4'!I14","v":0}]
[null,"Bonus environnemental total","pts",null,{"$f":"SUM(E15:E18)","v":0},{"$f":"SUM(F15:F18)","v":0},0,0,0,0,0]
[null,"Bilan environnemental","pts","Somme de l'élimination de charge polluante et du bonus environnemental",{"$f":"IF(ISERROR(E19+E13),\"\",E19+E13)","v":""},"","","","","",""]
[null,"Rendement environnemental",null,"Rapport élimination de charge polluante sur coûts directs",{"$f":"IF(ISERROR(E13/E7*1000),\"\",E13/E7*1000)","v":""},"","","","","",""]
[null,"Rendement environnemental +",null,"Rapport bilan environnemental sur coûts totaux",{"$f":"IF(ISERROR(E20/E9*1000),\"\",E20/E9*1000)","v":""},"","","","","",""]

{"sheet":"Indirect cost","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,20]
[null,"Coûts indirects",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},25]
[null,"Coûts indirects en euros"]
[null,"Justification"]
[]
[]
[null,"Retour au tableau des variantes"]

{"sheet":"Criterion #1","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[6,1,6,8]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,20]
[null,"Critère n°1",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},25]
[null,"Consommation énergétique et émissions de gaz à effet de serre"]
[null,"Enumération des processus consommateurs d'énergie et/ou émetteurs de gaz à effet de serre (si utilisation d'un calculateur, résultats à joindre en annexe)"]
[null,"Score critère n°1 en points"]
[null,"Justification du score attribué pour le critère n°1"]
[]
[]
[null,"Retour au tableau des variantes"]

{"sheet":"Criterion #2","index":5,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,6,8],[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,20]
[null,"Critère n°2",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},25]
[null,"Gêne occasionnée par les travaux d'assainissement"]
[null,"Enumération des différentes gênes occasionnées par les travaux d'assainissement"]
[null,"Score critère n°2 en points"]
[null,"Justification du score attribué pour le critère n°2"]
[]
[]
[null,"Retour au tableau des variantes"]

{"sheet":"Criterion #3","index":6,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,6,8],[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,20]
[null,"Critère n°3",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},25]
[null,"Incertitudes"]
[null,"Quel est le degré d'incertitudes à considérer pour l'atteinte/la contrôlabilité des résultats par la mise en oeuvre de la variante? "]
[null,"Score critère n°3 en points"]
[null,"Justification du score attribué pour le critère n°3"]
[]
[]
[null,"Retour au tableau des variantes"]

{"sheet":"Criterion #4","index":7,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,1,6,8],[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,20]
[null,"Critère n°4",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},25]
[null,"Aspects connexes"]
[null,"Durée de l'assainissement en jours, mois ou années (hors monitoring)"]
[null,"Conséquences suite à la présence d'une pollution résiduelle: La perte de valeur du terrain est-elle sensible? Les terrains voisins sont-ils impactés? Des restrictions d'usage sont-elles d'application?"]
[null,"Risques sécurité pendant travaux: Y a-t-il des risques spécifiques à considérer concernant l'aspect sécurité pendant les travaux?"]
[null,"Emissions vers d'autres milieux (eau souterraine, atmosphère ) - hors CO2: Des émissions vers d'autres milieux sont-elles d'application pour la variante? Si oui, lesquelles?"]
[null,"Déchets non récupérables: Des déchets non récupérables vont-ils être produits par les travaux? Si oui, à énumérer."]
[null,"Autres aspects éventuels: D'autres aspects environnementaux, économiques ou sociétaux sont-ils à considérer? Si oui, lesquels?"]
[null,"Score critère n°4 en points"]
[null,"Justification du score attribué pour le critère n°4"]
[]
[]
[null,"Retour au tableau des variantes"]

{"sheet":"Output","index":8,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[75,16,77,16],[75,17,77,17],[75,18,77,18],[75,19,77,19],[75,12,77,12],[75,13,77,13],[75,14,77,14],[75,15,77,15],[79,16,82,16],[79,17,82,17],[79,18,82,18],[79,19,82,19],[79,12,82,12],[79,13,82,13],[79,14,82,14],[79,15,82,15],[69,16,71,16],[69,17,71,17],[69,18,71,18],[69,19,71,19],[69,12,71,12],[69,13,71,13],[69,14,71,14],[69,15,71,15],[72,16,74,16],[72,17,74,17],[72,18,74,18],[72,19,74,19],[72,12,74,12],[72,13,74,13],[72,14,74,14],[72,15,74,15],[63,12,65,12],[63,13,65,13],[63,14,65,14],[63,15,65,15],[63,16,65,16],[63,17,65,17],[63,18,65,18],[63,19,65,19],[66,16,68,16],[66,17,68,17],[66,18,68,18],[66,19,68,19],[66,12,68,12],[66,13,68,13],[66,14,68,14],[66,15,68,15],[46,16,49,16],[46,17,49,17],[46,18,49,18],[46,19,49,19],[46,12,49,12],[46,13,49,13],[46,14,49,14],[46,15,49,15],[61,12,61,19],[52,12,52,15],[33,18,36,18],[33,19,36,19],[40,12,40,19],[41,12,44,12],[41,13,44,13],[41,14,44,14],[41,15,44,15],[41,16,44,16],[41,17,44,17],[41,18,44,18],[33,14,36,14],[33,15,36,15],[33,16,36,16],[33,17,36,17],[27,12,27,19],[28,12,31,12],[28,13,31,13],[28,14,31,14],[28,15,31,15],[28,16,31,16],[28,17,31,17],[28,18,31,18],[28,19,31,19],[16,18,19,18],[16,19,19,19],[21,12,24,12],[21,13,24,13],[21,14,24,14],[21,15,24,15],[21,16,24,16],[21,17,24,17],[21,18,24,18],[21,19,24,19],[3,2,3,9],[4,2,4,9],[57,2,57,9],[58,2,58,9],[51,2,51,9],[52,2,52,9],[53,2,53,9],[54,2,54,9],[47,2,47,9],[48,2,48,9],[49,2,49,9],[50,2,50,9],[55,2,55,9],[56,2,56,9],[46,2,46,9],[42,2,42,9],[43,2,43,9],[44,1,44,9],[45,2,45,9],[15,12,15,19],[16,12,19,12],[16,13,19,13],[16,14,19,14],[41,2,41,9],[5,2,5,9],[6,2,6,9],[7,2,7,9],[39,1,39,9],[40,2,40,9],[16,15,19,15],[16,16,19,16],[33,12,36,12],[33,13,36,13],[41,19,44,19],[7,16,10,16],[7,17,10,17],[7,18,10,18],[7,19,10,19],[7,12,10,12],[7,13,10,13],[7,14,10,14],[7,15,10,15],[16,17,19,17]]}
[]
[]
[]
[null,"Nom du projet",{"$f":"'Input Project'!C6","v":0},null,null,null,null,null,null,null,null,null,"Justification des coûts indirects"]
[null,"Références",{"$f":"'Input Project'!C7","v":0}]
[null,"Expert en pollution du sol",{"$f":"'Input Project'!C8","v":0},null,null,null,null,null,null,null,null,null,"Coûts indirects",{"$f":"'Indirect cost'!C6","v":0},{"$f":"'Indirect cost'!D6","v":0},{"$f":"'Indirect cost'!E6","v":0},{"$f":"'Indirect cost'!F6","v":0},{"$f":"'Indirect cost'!G6","v":0},{"$f":"'Indirect cost'!H6","v":0},{"$f":"'Indirect cost'!I6","v":0}]
[null,"Date de réalisation de l'analyse BATNEEC",{"$f":"'Input Project'!C9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,"Coûts indirects en euros",{"$f":"'Indirect cost'!C7","v":0},{"$f":"'Indirect cost'!D7","v":0},{"$f":"'Indirect cost'!E7","v":0},{"$f":"'Indirect cost'!F7","v":0},{"$f":"'Indirect cost'!G7","v":0},{"$f":"'Indirect cost'!H7","v":0},{"$f":"'Indirect cost'!I7","v":0}]
[null,"Identifiant de la contamination",{"$f":"'Input Project'!C10","v":0},null,null,null,null,null,null,null,null,null,"Justification",{"$f":"'Indirect cost'!C8","v":0},{"$f":"'Indirect cost'!D8","v":0},{"$f":"'Indirect cost'!E8","v":0},{"$f":"'Indirect cost'!F8","v":0},{"$f":"'Indirect cost'!G8","v":0},{"$f":"'Indirect cost'!H8","v":0},{"$f":"'Indirect cost'!I8","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Détermination du bonus environnemental"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Critère n°1",{"$f":"'Criterion #1'!C6","v":0},{"$f":"'Criterion #1'!D6","v":0},{"$f":"'Criterion #1'!E6","v":0},{"$f":"'Criterion #1'!F6","v":0},{"$f":"'Criterion #1'!G6","v":0},{"$f":"'Criterion #1'!H6","v":0},{"$f":"'Criterion #1'!I6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consommation énergétique et émissions de gaz à effet de serre"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enumération des processus consommateurs d'énergie et/ou émetteurs de gaz à effet de serre (si utilisation d'un calculateur, résultats à joindre en annexe)",{"$f":"'Criterion #1'!C8","v":0},{"$f":"'Criterion #1'!D8","v":0},{"$f":"'Criterion #1'!E8","v":0},{"$f":"'Criterion #1'!F8","v":0},{"$f":"'Criterion #1'!G8","v":0},{"$f":"'Criterion #1'!H8","v":0},{"$f":"'Criterion #1'!I8","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Score critère n°1 en points",{"$f":"'Criterion #1'!C9","v":0},{"$f":"'Criterion #1'!D9","v":0},{"$f":"'Criterion #1'!E9","v":0},{"$f":"'Criterion #1'!F9","v":0},{"$f":"'Criterion #1'!G9","v":0},{"$f":"'Criterion #1'!H9","v":0},{"$f":"'Criterion #1'!I9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Justification du score attribué pour le critère n°1",{"$f":"'Criterion #1'!C10","v":0},{"$f":"'Criterion #1'!D10","v":0},{"$f":"'Criterion #1'!E10","v":0},{"$f":"'Criterion #1'!F10","v":0},{"$f":"'Criterion #1'!G10","v":0},{"$f":"'Criterion #1'!H10","v":0},{"$f":"'Criterion #1'!I10","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Critère n°2",{"$f":"'Criterion #2'!C6","v":0},{"$f":"'Criterion #2'!D6","v":0},{"$f":"'Criterion #2'!E6","v":0},{"$f":"'Criterion #2'!F6","v":0},{"$f":"'Criterion #2'!G6","v":0},{"$f":"'Criterion #2'!H6","v":0},{"$f":"'Criterion #2'!I6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gêne occasionnée par les travaux d'assainissement"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enumération des différentes gênes occasionnées par les travaux d'assainissement",{"$f":"'Criterion #2'!C8","v":0},{"$f":"'Criterion #2'!D8","v":0},{"$f":"'Criterion #2'!E8","v":0},{"$f":"'Criterion #2'!F8","v":0},{"$f":"'Criterion #2'!G8","v":0},{"$f":"'Criterion #2'!H8","v":0},{"$f":"'Criterion #2'!I8","v":0}]
[]
[null,"Variante préférée:"]
[null,{"$f":"Blad7!G13","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Score critère n°2 en points",{"$f":"'Criterion #2'!C9","v":0},{"$f":"'Criterion #2'!D9","v":0},{"$f":"'Criterion #2'!E9","v":0},{"$f":"'Criterion #2'!F9","v":0},{"$f":"'Criterion #2'!G9","v":0},{"$f":"'Criterion #2'!H9","v":0},{"$f":"'Criterion #2'!I9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Justification du score attribué pour le critère n°2",{"$f":"'Criterion #2'!C10","v":0},{"$f":"'Criterion #2'!D10","v":0},{"$f":"'Criterion #2'!E10","v":0},{"$f":"'Criterion #2'!F10","v":0},{"$f":"'Criterion #2'!G10","v":0},{"$f":"'Criterion #2'!H10","v":0},{"$f":"'Criterion #2'!I10","v":0}]
[]
[]
[]
[null,"Charge polluante et variantes considérées"]
[]
[null,"Charge polluante",null,null,null,null,null,null,null,null,null,null,"Critère n°3",{"$f":"'Criterion #3'!C6","v":0},{"$f":"'Criterion #3'!D6","v":0},{"$f":"'Criterion #3'!E6","v":0},{"$f":"'Criterion #3'!F6","v":0},{"$f":"'Criterion #3'!G6","v":0},{"$f":"'Criterion #3'!H6","v":0},{"$f":"'Criterion #3'!I6","v":0}]
[null,"Charge polluante calculée dans le sol en kg",{"$f":"'Input Project'!C12","v":0},null,null,null,null,null,null,null,null,null,"Incertitudes"]
[null,"Charge polluante calculée dans l'eau souterraine en kg (hors phase libre éventuelle, sauf exception §7.2)",{"$f":"'Input Project'!C13","v":0},null,null,null,null,null,null,null,null,null,"Quel est le degré d'incertitudes à considérer pour l'atteinte/la contrôlabilité des résultats par la mise en oeuvre de la variante? ",{"$f":"'Criterion #3'!C8","v":0},{"$f":"'Criterion #3'!D8","v":0},{"$f":"'Criterion #3'!E8","v":0},{"$f":"'Criterion #3'!F8","v":0},{"$f":"'Criterion #3'!G8","v":0},{"$f":"'Criterion #3'!H8","v":0},{"$f":"'Criterion #3'!I8","v":0}]
[null,"Charge polluante au niveau de la phase libre éventuelle en kg",{"$f":"'Input Project'!C14","v":0}]
[null,"Charge polluante totale en kg (hors phase libre éventuelle, sauf exception §7.2)",{"$f":"'Input Project'!C15","v":0}]
[null,"Variantes d'assainissement"]
[null,"Intitulé de la variante 1 (V1)",{"$f":"'Input Project'!C17","v":0},null,null,null,null,null,null,null,null,null,"Score critère n°3 en points",{"$f":"'Criterion #3'!C9","v":0},{"$f":"'Criterion #3'!D9","v":0},{"$f":"'Criterion #3'!E9","v":0},{"$f":"'Criterion #3'!F9","v":0},{"$f":"'Criterion #3'!G9","v":0},{"$f":"'Criterion #3'!H9","v":0},{"$f":"'Criterion #3'!I9","v":0}]
[null,"Description de la variante 1 (V1)",{"$f":"'Input Project'!C18","v":0},null,null,null,null,null,null,null,null,null,"Justification du score attribué pour le critère n°3",{"$f":"'Criterion #3'!C10","v":0},{"$f":"'Criterion #3'!D10","v":0},{"$f":"'Criterion #3'!E10","v":0},{"$f":"'Criterion #3'!F10","v":0},{"$f":"'Criterion #3'!G10","v":0},{"$f":"'Criterion #3'!H10","v":0},{"$f":"'Criterion #3'!I10","v":0}]
[null,"Intitulé de la variante 2 (V2)",{"$f":"'Input Project'!C19","v":0}]
[null,"Description de la variante 2 (V2)",{"$f":"'Input Project'!C20","v":0}]
[null,"Intitulé de la variante 3 (V3)",{"$f":"'Input Project'!C21","v":0}]
[null,"Description de la variante 3 (V3)",{"$f":"'Input Project'!C22","v":0}]
[null,"Intitulé de la variante 4 (V4)",{"$f":"'Input Project'!C23","v":0}]
[null,"Description de la variante 4 (V4)",{"$f":"'Input Project'!C24","v":0}]
[null,"Intitulé de la variante 5 (V5)",{"$f":"'Input Project'!C25","v":0}]
[null,"Description de la variante 5 (V5)",{"$f":"'Input Project'!C26","v":0}]
[null,"Intitulé de la variante 6 (V6)",{"$f":"'Input Project'!C27","v":0}]
[null,"Description de la variante 6 (V6)",{"$f":"'Input Project'!C28","v":0}]
[null,"Intitulé de la variante 7 (V7)",{"$f":"'Input Project'!C29","v":0}]
[null,"Description de la variante 7 (V7)",{"$f":"'Input Project'!C30","v":0}]
[]
[null,"Détails des variantes",null,null,null,null,null,null,null,null,null,null,"Critère n°4",{"$f":"'Criterion #4'!C6","v":0},{"$f":"'Criterion #4'!D6","v":0},{"$f":"'Criterion #4'!E6","v":0},{"$f":"'Criterion #4'!F6","v":0},{"$f":"'Criterion #4'!G6","v":0},{"$f":"'Criterion #4'!H6","v":0},{"$f":"'Criterion #4'!I6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Aspects connexes"]
[null,"Critères","Unités",{"$f":"'Input Variants'!E5","v":0},{"$f":"'Input Variants'!F5","v":0},{"$f":"'Input Variants'!G5","v":0},{"$f":"'Input Variants'!H5","v":0},{"$f":"'Input Variants'!I5","v":0},{"$f":"'Input Variants'!J5","v":0},{"$f":"'Input Variants'!K5","v":0},null,null,"Durée de l'assainissement en jours, mois ou années (hors monitoring)",{"$f":"'Criterion #4'!C8","v":0},{"$f":"'Criterion #4'!D8","v":0},{"$f":"'Criterion #4'!E8","v":0},{"$f":"'Criterion #4'!F8","v":0},{"$f":"'Criterion #4'!G8","v":0},{"$f":"'Criterion #4'!H8","v":0},{"$f":"'Criterion #4'!I8","v":0}]
[null,"Coûts d'assainissement",null,null,null,null,null,null,null,null,null,null,"Conséquences suite à la présence d'une pollution résiduelle: La perte de valeur du terrain est-elle sensible? Les terrains voisins sont-ils impactés? Des restrictions d'usage sont-elles d'application?",{"$f":"'Criterion #4'!C9","v":0},{"$f":"'Criterion #4'!D9","v":0},{"$f":"'Criterion #4'!E9","v":0},{"$f":"'Criterion #4'!F9","v":0},{"$f":"'Criterion #4'!G9","v":0},{"$f":"'Criterion #4'!H9","v":0},{"$f":"'Criterion #4'!I9","v":0}]
[null,"Coûts directs (cf tableau en annexe 3 du PA)"," €",{"$f":"'Input Variants'!E7","v":0},{"$f":"'Input Variants'!F7","v":0},{"$f":"'Input Variants'!G7","v":0},{"$f":"'Input Variants'!H7","v":0},{"$f":"'Input Variants'!I7","v":0},{"$f":"'Input Variants'!J7","v":0},{"$f":"'Input Variants'!K7","v":0}]
[null,"Coûts indirects"," €",{"$f":"'Input Variants'!E8","v":0},{"$f":"'Input Variants'!F8","v":0},{"$f":"'Input Variants'!G8","v":0},{"$f":"'Input Variants'!H8","v":0},{"$f":"'Input Variants'!I8","v":0},{"$f":"'Input Variants'!J8","v":0},{"$f":"'Input Variants'!K8","v":0}]
[null,"Coûts totaux"," €",{"$f":"'Input Variants'!E9","v":0},{"$f":"'Input Variants'!F9","v":0},{"$f":"'Input Variants'!G9","v":0},{"$f":"'Input Variants'!H9","v":0},{"$f":"'Input Variants'!I9","v":0},{"$f":"'Input Variants'!J9","v":0},{"$f":"'Input Variants'!K9","v":0},null,null,"Risques sécurité pendant travaux: Y a-t-il des risques spécifiques à considérer concernant l'aspect sécurité pendant les travaux?",{"$f":"'Criterion #4'!C10","v":0},{"$f":"'Criterion #4'!D10","v":0},{"$f":"'Criterion #4'!E10","v":0},{"$f":"'Criterion #4'!F10","v":0},{"$f":"'Criterion #4'!G10","v":0},{"$f":"'Criterion #4'!H10","v":0},{"$f":"'Criterion #4'!I10","v":0}]
[null,"Bilan environnemental"]
[null,"Elimination de charge polluante"]
[null,"Elimination prévue de charge polluante (hors phase libre, sauf exception §7.2)","kg",{"$f":"'Input Variants'!E12","v":0},{"$f":"'Input Variants'!F12","v":0},{"$f":"'Input Variants'!G12","v":0},{"$f":"'Input Variants'!H12","v":0},{"$f":"'Input Variants'!I12","v":0},{"$f":"'Input Variants'!J12","v":0},{"$f":"'Input Variants'!K12","v":0},null,null,"Emissions vers d'autres milieux (eau souterraine, atmosphère ) - hors CO2: Des émissions vers d'autres milieux sont-elles d'application pour la variante? Si oui, lesquelles?",{"$f":"'Criterion #4'!C11","v":0},{"$f":"'Criterion #4'!D11","v":0},{"$f":"'Criterion #4'!E11","v":0},{"$f":"'Criterion #4'!F11","v":0},{"$f":"'Criterion #4'!G11","v":0},{"$f":"'Criterion #4'!H11","v":0},{"$f":"'Criterion #4'!I11","v":0}]
[null,"Elimination de charge polluante en %",null,{"$f":"'Input Variants'!E13","v":""},{"$f":"'Input Variants'!F13","v":""},{"$f":"'Input Variants'!G13","v":""},{"$f":"'Input Variants'!H13","v":""},{"$f":"'Input Variants'!I13","v":""},{"$f":"'Input Variants'!J13","v":""},{"$f":"'Input Variants'!K13","v":""}]
[null,"Bonus environnemental"]
[null,"Critère n°1: Consommation énergétique et émissions de gaz à effet de serre","pts",{"$f":"'Input Variants'!E15","v":0},{"$f":"'Input Variants'!F15","v":0},{"$f":"'Input Variants'!G15","v":0},{"$f":"'Input Variants'!H15","v":0},{"$f":"'Input Variants'!I15","v":0},{"$f":"'Input Variants'!J15","v":0},{"$f":"'Input Variants'!K15","v":0},null,null,"Déchets non récupérables: Des déchets non récupérables vont-ils être produits par les travaux? Si oui, à énumérer.",{"$f":"'Criterion #4'!C12","v":0},{"$f":"'Criterion #4'!D12","v":0},{"$f":"'Criterion #4'!E12","v":0},{"$f":"'Criterion #4'!F12","v":0},{"$f":"'Criterion #4'!G12","v":0},{"$f":"'Criterion #4'!H12","v":0},{"$f":"'Criterion #4'!I12","v":0}]
[null,"Critère n°2: Gêne occasionnée par les travaux d'assainissement","pts",{"$f":"'Input Variants'!E16","v":0},{"$f":"'Input Variants'!F16","v":0},{"$f":"'Input Variants'!G16","v":0},{"$f":"'Input Variants'!H16","v":0},{"$f":"'Input Variants'!I16","v":0},{"$f":"'Input Variants'!J16","v":0},{"$f":"'Input Variants'!K16","v":0}]
[null,"Critère n°3: Incertitudes","pts",{"$f":"'Input Variants'!E17","v":0},{"$f":"'Input Variants'!F17","v":0},{"$f":"'Input Variants'!G17","v":0},{"$f":"'Input Variants'!H17","v":0},{"$f":"'Input Variants'!I17","v":0},{"$f":"'Input Variants'!J17","v":0},{"$f":"'Input Variants'!K17","v":0}]
[null,"Critère n°4: Aspects connexes","pts",{"$f":"'Input Variants'!E18","v":0},{"$f":"'Input Variants'!F18","v":0},{"$f":"'Input Variants'!G18","v":0},{"$f":"'Input Variants'!H18","v":0},{"$f":"'Input Variants'!I18","v":0},{"$f":"'Input Variants'!J18","v":0},{"$f":"'Input Variants'!K18","v":0},null,null,"Autres aspects éventuels: D'autres aspects environnementaux, économiques ou sociétaux sont-ils à considérer? Si oui, lesquels?",{"$f":"'Criterion #4'!C13","v":0},{"$f":"'Criterion #4'!D13","v":0},{"$f":"'Criterion #4'!E13","v":0},{"$f":"'Criterion #4'!F13","v":0},{"$f":"'Criterion #4'!G13","v":0},{"$f":"'Criterion #4'!H13","v":0},{"$f":"'Criterion #4'!I13","v":0}]
[null,"Bonus environnemental total","pts",{"$f":"'Input Variants'!E19","v":0},{"$f":"'Input Variants'!F19","v":0},{"$f":"'Input Variants'!G19","v":0},{"$f":"'Input Variants'!H19","v":0},{"$f":"'Input Variants'!I19","v":0},{"$f":"'Input Variants'!J19","v":0},{"$f":"'Input Variants'!K19","v":0}]
[null,"Bilan environnemental","pts",{"$f":"'Input Variants'!E20","v":""},{"$f":"'Input Variants'!F20","v":""},{"$f":"'Input Variants'!G20","v":""},{"$f":"'Input Variants'!H20","v":""},{"$f":"'Input Variants'!I20","v":""},{"$f":"'Input Variants'!J20","v":""},{"$f":"'Input Variants'!K20","v":""}]
[null,"Rendement environnemental",null,{"$f":"'Input Variants'!E21","v":""},{"$f":"'Input Variants'!F21","v":""},{"$f":"'Input Variants'!G21","v":""},{"$f":"'Input Variants'!H21","v":""},{"$f":"'Input Variants'!I21","v":""},{"$f":"'Input Variants'!J21","v":""},{"$f":"'Input Variants'!K21","v":""},null,null,"Score critère n°4 en points",{"$f":"'Criterion #4'!C14","v":0},{"$f":"'Criterion #4'!D14","v":0},{"$f":"'Criterion #4'!E14","v":0},{"$f":"'Criterion #4'!F14","v":0},{"$f":"'Criterion #4'!G14","v":0},{"$f":"'Criterion #4'!H14","v":0},{"$f":"'Criterion #4'!I14","v":0}]
[null,"Rendement environnemental +",null,{"$f":"'Input Variants'!E22","v":""},{"$f":"'Input Variants'!F22","v":""},{"$f":"'Input Variants'!G22","v":""},{"$f":"'Input Variants'!H22","v":""},{"$f":"'Input Variants'!I22","v":""},{"$f":"'Input Variants'!J22","v":""},{"$f":"'Input Variants'!K22","v":""},null,null,"Justification du score attribué pour le critère n°4",{"$f":"'Criterion #4'!C15","v":0},{"$f":"'Criterion #4'!D15","v":0},{"$f":"'Criterion #4'!E15","v":0},{"$f":"'Criterion #4'!F15","v":0},{"$f":"'Criterion #4'!G15","v":0},{"$f":"'Criterion #4'!H15","v":0},{"$f":"'Criterion #4'!I15","v":0}]

{"sheet":"Blad7","index":9,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Variante","Couts directs","Couts totaux","CP Eliminée","Bilan environnemental","Rendement","Rendement +","Label R+"]
[null,0,0,0,0,0,0,{"$f":" \"R+: \" &ROUND(G4,2)","v":"R+: 0"}]
[{"$f":"'Input Project'!C17","v":0},{"$f":"'Input Variants'!E7","v":0},{"$f":"'Input Variants'!E9","v":0},{"$f":"'Input Variants'!E13","v":""},{"$f":"'Input Variants'!E20","v":""},{"$f":"'Input Variants'!E21","v":""},{"$f":"'Input Variants'!E22","v":""},{"$f":"IF(ISERROR(\"R+: \" &ROUND(G5,2)),\"\",\"R+: \" &ROUND(G5,2))","v":""},{"$f":"G5","v":""},{"$f":"A5","v":0}]
[{"$f":"'Input Project'!C19","v":0},{"$f":"'Input Variants'!F7","v":0},{"$f":"'Input Variants'!F9","v":0},{"$f":"'Input Variants'!F13","v":""},{"$f":"'Input Variants'!F20","v":""},{"$f":"'Input Variants'!F21","v":""},{"$f":"'Input Variants'!F22","v":""},{"$f":"IF(ISERROR(\"R+: \" &ROUND(G6,2)),\"\",\"R+: \" &ROUND(G6,2))","v":""},{"$f":"G6","v":""},{"$f":"A6","v":0}]
[{"$f":"'Input Project'!C21","v":0},{"$f":"'Input Variants'!G7","v":0},{"$f":"'Input Variants'!G9","v":0},{"$f":"'Input Variants'!G13","v":""},{"$f":"'Input Variants'!G20","v":""},{"$f":"'Input Variants'!G21","v":""},{"$f":"'Input Variants'!G22","v":""},"","",0]
[{"$f":"IF('Input Project'!C23=0,\"\",'Input Project'!C23)","v":""},{"$f":"IF('Input Variants'!H7=0,\"\",'Input Variants'!H7)","v":""},{"$f":"IF('Input Variants'!H9=0,\"\",'Input Variants'!H9)","v":""},{"$f":"IF('Input Variants'!H13=0,\"\",'Input Variants'!H13)","v":""},{"$f":"IF('Input Variants'!H20=0,\"\",'Input Variants'!H20)","v":""},{"$f":"IF('Input Variants'!H21=0,\"\",'Input Variants'!H21)","v":""},{"$f":"IF('Input Variants'!H22=0,\"\",'Input Variants'!H22)","v":""},"","",""]
[{"$f":"IF('Input Project'!C25=0,\"\",'Input Project'!C25)","v":""},{"$f":"IF('Input Variants'!I7=0,\"\",'Input Variants'!I7)","v":""},{"$f":"IF('Input Variants'!I9=0,\"\",'Input Variants'!I9)","v":""},{"$f":"IF('Input Variants'!I13=0,\"\",'Input Variants'!I13)","v":""},{"$f":"IF('Input Variants'!I20=0,\"\",'Input Variants'!I20)","v":""},{"$f":"IF('Input Variants'!I21=0,\"\",'Input Variants'!I21)","v":""},{"$f":"IF('Input Variants'!I22=0,\"\",'Input Variants'!I22)","v":""},"","",""]
[{"$f":"IF('Input Project'!C27=0,\"\",'Input Project'!C27)","v":""},{"$f":"IF('Input Variants'!J7=0,\"\",'Input Variants'!J7)","v":""},{"$f":"IF('Input Variants'!J9=0,\"\",'Input Variants'!J9)","v":""},{"$f":"IF('Input Variants'!J13=0,\"\",'Input Variants'!J13)","v":""},{"$f":"IF('Input Variants'!J20=0,\"\",'Input Variants'!J20)","v":""},{"$f":"IF('Input Variants'!J21=0,\"\",'Input Variants'!J21)","v":""},{"$f":"IF('Input Variants'!J22=0,\"\",'Input Variants'!J22)","v":""},"","",""]
[{"$f":"IF('Input Project'!C29=0,\"\",'Input Project'!C29)","v":""},{"$f":"IF('Input Variants'!K7=0,\"\",'Input Variants'!K7)","v":""},{"$f":"IF('Input Variants'!K9=0,\"\",'Input Variants'!K9)","v":""},{"$f":"IF('Input Variants'!K13=0,\"\",'Input Variants'!K13)","v":""},{"$f":"IF('Input Variants'!K20=0,\"\",'Input Variants'!K20)","v":""},{"$f":"IF('Input Variants'!K21=0,\"\",'Input Variants'!K21)","v":""},{"$f":"IF('Input Variants'!K22=0,\"\",'Input Variants'!K22)","v":""},"","",""]
[null,null,null,null,null,"Max Rendement +",{"$f":"MAX(G4:G11)","v":0}]
[null,null,null,null,null,"Variant",{"$f":"VLOOKUP(G12,I5:J11,2,0)","v":{"$error":"#N/A"}}]