{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Métré"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":"Métré","index":0,"n_rows":251,"n_cols":8,"rows_kept":251,"cut":false,"hidden":false,"merged":[[92,3,92,7],[108,3,108,7],[151,3,151,7],[156,3,156,7],[173,3,173,7],[163,3,163,7],[169,3,169,7],[142,3,142,7],[146,3,146,7],[119,3,119,7],[124,3,124,7],[129,3,129,7],[132,3,132,7],[136,3,136,7],[186,3,186,7],[213,3,213,7],[172,3,172,7],[185,3,185,7],[179,3,179,7],[189,3,189,7],[195,3,195,7],[201,3,201,7],[207,3,207,7],[187,3,187,7],[250,2,250,7],[0,1,250,1],[0,8,250,8],[9,3,9,7],[19,3,19,7],[40,3,40,7],[168,3,168,7],[20,3,20,7],[26,3,26,7],[29,3,29,7],[33,3,33,7],[41,3,41,7],[50,3,50,7],[58,3,58,7],[62,3,62,7],[69,3,69,7],[3,2,3,7],[1,2,1,7],[0,2,0,7],[2,2,2,7],[4,2,4,7],[6,2,6,7],[5,2,5,3],[5,4,5,7],[8,2,8,7],[88,3,88,7],[18,2,18,7],[39,2,39,7],[21,3,21,7],[23,3,23,7],[91,3,91,7],[241,3,241,7],[70,3,70,7],[73,3,73,7],[76,3,76,7],[79,3,79,7],[82,3,82,7],[85,3,85,7],[93,3,93,7],[98,3,98,7],[103,3,103,7],[109,3,109,7],[114,3,114,7],[126,3,126,7],[150,3,150,7],[160,3,160,7],[248,2,248,6],[249,2,249,6],[214,3,214,7],[216,3,216,7],[222,3,222,7],[228,3,228,7],[247,2,247,7],[234,3,234,7]]}
[]
[null,null,"Annexe 5 - Métré d'estimation des coûts d'une variante d'assainissement"]
[]
[null,null,"La présente annexe du GRPA v5, basée sur le document T3220 « FOR_Estimation des couts d'assainissement_PA_v1.00 » de BOFAS, permet à l'expert de réaliser une estimation des coûts pour chaque variante pertinente proposée, et ce en remplissant les cellules grises pertinentes. Ces coûts sont utiles à l'encodage de l'outil GAMMA v2 (critère \"Coûts d'assainissement (€)\"). Le métré ci-dessous n'est pas exhaustif et n'a pas pour vocation d'estimer un coût précis pour une variante d'assainissement donnée, mais bien un coût approximatif et comparable d'une variante à une autre.\n\nLe métré ne reprenant pas toutes les techniques d'assainissement mais uniquement les plus courantes, l'expert peut rajouter des lignes, si nécessaire, dans le poste 5, et ce afin de compléter son estimation si les postes proposés ne couvriraient pas tous les coûts à prévoir. Certains prix unitaires sont également laissés à l'appréciation de l'expert.\n\nN.B. : Le bouton gris situé dans la cellule A9 permet, en sélectionnant uniquement \"1\", de n'afficher que les postes pour lesquels une quantité supérieure à 0 a été encodée. Les postes vides seront alors masqués, mais l'ensemble des lignes de titres resteront toujours visibles. En cochant \"0\" et \"1\", l'ensemble des lignes du fichier seront à nouveau affichées.\n\nLes lignes 243 à 247 (postes dans la catégorie \"5 Autres\") n'apparaissent que si elles sont entièrement complétées (colonnes C à G). Des lignes supplémentaires peuvent être ajoutée sous le poste \"5 Autres\" uniquement en étant insérées entre la ligne 243 et la ligne 247, et ce pour ne pas perturber le fonctionnement du fichier. Il faut ensuite étirer les formules respectives des colonnes A et H dans ces nouvelles lignes.\n\nCertains fonctionnalités du fichier étant liées aux couleurs des cellules, il est important de ne pas les modifier."]
[]
[null,null,"Nom de la variante :"]
[]
[null,null,"N°","Description","Unité","Prix unitaire (€)","Quantité","Prix total\n(€)"]
[]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C10)),AND(H10 <> 0,H10<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C10)),H10=\"-\",NOT(ISBLANK(G10))),1,\n  IF(AND(ISBLANK(C10),ISBLANK(H10)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C10)),H10<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1,"Prestations intellectuelles"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C11)),AND(H11 <> 0,H11<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C11)),H11=\"-\",NOT(ISBLANK(G11))),1,\n  IF(AND(ISBLANK(C11),ISBLANK(H11)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C11)),H11<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.1000000000000001,"Projet d'assainissement","forfait",7000,null,{"$f":"F11*G11","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C12)),AND(H12 <> 0,H12<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C12)),H12=\"-\",NOT(ISBLANK(G12))),1,\n  IF(AND(ISBLANK(C12),ISBLANK(H12)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C12)),H12<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.2,"Cahier des charges","forfait",2700,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C13)),AND(H13 <> 0,H13<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C13)),H13=\"-\",NOT(ISBLANK(G13))),1,\n  IF(AND(ISBLANK(C13),ISBLANK(H13)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C13)),H13<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.3,"Evaluation intermédiaire","forfait",5000,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C14)),AND(H14 <> 0,H14<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C14)),H14=\"-\",NOT(ISBLANK(G14))),1,\n  IF(AND(ISBLANK(C14),ISBLANK(H14)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C14)),H14<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.4,"Evaluation finale ","forfait",4000,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C15)),AND(H15 <> 0,H15<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C15)),H15=\"-\",NOT(ISBLANK(G15))),1,\n  IF(AND(ISBLANK(C15),ISBLANK(H15)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C15)),H15<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.5,"Etude de stabilité","forfait",1600,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C16)),AND(H16 <> 0,H16<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C16)),H16=\"-\",NOT(ISBLANK(G16))),1,\n  IF(AND(ISBLANK(C16),ISBLANK(H16)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C16)),H16<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.6,"Frais de dossier DAS - Projet d'assainissement","forfait",250,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C17)),AND(H17 <> 0,H17<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C17)),H17=\"-\",NOT(ISBLANK(G17))),1,\n  IF(AND(ISBLANK(C17),ISBLANK(H17)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C17)),H17<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.7,"Frais de dossier DAS - Evaluation finale","forfait",250,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C18)),AND(H18 <> 0,H18<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C18)),H18=\"-\",NOT(ISBLANK(G18))),1,\n  IF(AND(ISBLANK(C18),ISBLANK(H18)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C18)),H18<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,1.8,"Réalisation de la demande de permis (BXL)","forfait",1600,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C19)),AND(H19 <> 0,H19<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C19)),H19=\"-\",NOT(ISBLANK(G19))),1,\n  IF(AND(ISBLANK(C19),ISBLANK(H19)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C19)),H19<>0),1,0),0\n)))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C20)),AND(H20 <> 0,H20<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C20)),H20=\"-\",NOT(ISBLANK(G20))),1,\n  IF(AND(ISBLANK(C20),ISBLANK(H20)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C20)),H20<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,2,"Suivi des tavaux d'assainissement (expert environnemental)"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C21)),AND(H21 <> 0,H21<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C21)),H21=\"-\",NOT(ISBLANK(G21))),1,\n  IF(AND(ISBLANK(C21),ISBLANK(H21)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C21)),H21<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1","Coordination sécurité-santé"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C22)),AND(H22 <> 0,H22<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C22)),H22=\"-\",NOT(ISBLANK(G22))),1,\n  IF(AND(ISBLANK(C22),ISBLANK(H22)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C22)),H22<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1.1","Conception"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C23)),AND(H23 <> 0,H23<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C23)),H23=\"-\",NOT(ISBLANK(G23))),1,\n  IF(AND(ISBLANK(C23),ISBLANK(H23)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C23)),H23<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1.1.1","Réunion et documents de coordination","forfait",1500,null,{"$f":"F23*G23","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C24)),AND(H24 <> 0,H24<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C24)),H24=\"-\",NOT(ISBLANK(G24))),1,\n  IF(AND(ISBLANK(C24),ISBLANK(H24)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C24)),H24<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1.2","Réalisation"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C25)),AND(H25 <> 0,H25<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C25)),H25=\"-\",NOT(ISBLANK(G25))),1,\n  IF(AND(ISBLANK(C25),ISBLANK(H25)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C25)),H25<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1.2.1","Réunion incluant un rapport ","forfait",500,null,{"$f":"F25*G25","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C26)),AND(H26 <> 0,H26<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C26)),H26=\"-\",NOT(ISBLANK(G26))),1,\n  IF(AND(ISBLANK(C26),ISBLANK(H26)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C26)),H26<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.1.2.2","Visite de site incluant un rapport","forfait",1000,null,{"$f":"F26*G26","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C27)),AND(H27 <> 0,H27<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C27)),H27=\"-\",NOT(ISBLANK(G27))),1,\n  IF(AND(ISBLANK(C27),ISBLANK(H27)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C27)),H27<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.2","Suivi environnemental des travaux d'assainissement GC"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C28)),AND(H28 <> 0,H28<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C28)),H28=\"-\",NOT(ISBLANK(G28))),1,\n  IF(AND(ISBLANK(C28),ISBLANK(H28)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C28)),H28<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.2.1","Réunion de chantier ","forfait",400,null,{"$f":" F28*G28","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C29)),AND(H29 <> 0,H29<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C29)),H29=\"-\",NOT(ISBLANK(G29))),1,\n  IF(AND(ISBLANK(C29),ISBLANK(H29)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C29)),H29<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.2.2","Journée de suivi de travaux et commandes d'analyses","forfait",750,null,{"$f":" F29*G29","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C30)),AND(H30 <> 0,H30<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C30)),H30=\"-\",NOT(ISBLANK(G30))),1,\n  IF(AND(ISBLANK(C30),ISBLANK(H30)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C30)),H30<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.3","Suivi environnemental des travaux d'assainissement IS"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C31)),AND(H31 <> 0,H31<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C31)),H31=\"-\",NOT(ISBLANK(G31))),1,\n  IF(AND(ISBLANK(C31),ISBLANK(H31)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C31)),H31<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.3.1","Réunion de chantier ","forfait",400,null,{"$f":" F31*G31","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C32)),AND(H32 <> 0,H32<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C32)),H32=\"-\",NOT(ISBLANK(G32))),1,\n  IF(AND(ISBLANK(C32),ISBLANK(H32)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C32)),H32<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.3.2","Lancement installations et commandes d'analyses","jour",750,null,{"$f":" F32*G32","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C33)),AND(H33 <> 0,H33<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C33)),H33=\"-\",NOT(ISBLANK(G33))),1,\n  IF(AND(ISBLANK(C33),ISBLANK(H33)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C33)),H33<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.3.3","Suivi des installations et commandes d'analyses","jour",750,null,{"$f":" F33*G33","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C34)),AND(H34 <> 0,H34<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C34)),H34=\"-\",NOT(ISBLANK(G34))),1,\n  IF(AND(ISBLANK(C34),ISBLANK(H34)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C34)),H34<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4","Monitoring"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C35)),AND(H35 <> 0,H35<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C35)),H35=\"-\",NOT(ISBLANK(G35))),1,\n  IF(AND(ISBLANK(C35),ISBLANK(H35)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C35)),H35<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4.1","Placement de piézomètres/piézairs","forfait",2000,null,{"$f":" F35*G35","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C36)),AND(H36 <> 0,H36<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C36)),H36=\"-\",NOT(ISBLANK(G36))),1,\n  IF(AND(ISBLANK(C36),ISBLANK(H36)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C36)),H36<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4.2","Echantillonnage eau souterraine","forfait",1000,null,{"$f":" F36*G36","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C37)),AND(H37 <> 0,H37<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C37)),H37=\"-\",NOT(ISBLANK(G37))),1,\n  IF(AND(ISBLANK(C37),ISBLANK(H37)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C37)),H37<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4.3","Echantillonnage air ","forfait",1000,null,{"$f":" F37*G37","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C38)),AND(H38 <> 0,H38<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C38)),H38=\"-\",NOT(ISBLANK(G38))),1,\n  IF(AND(ISBLANK(C38),ISBLANK(H38)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C38)),H38<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4.5","Echantillonnage air du sol","forfait",1200,null,{"$f":" F38*G38","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C39)),AND(H39 <> 0,H39<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C39)),H39=\"-\",NOT(ISBLANK(G39))),1,\n  IF(AND(ISBLANK(C39),ISBLANK(H39)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C39)),H39<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"2.4.6","Rapport de monitoring","forfait",2700,null,{"$f":" F39*G39","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C40)),AND(H40 <> 0,H40<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C40)),H40=\"-\",NOT(ISBLANK(G40))),1,\n  IF(AND(ISBLANK(C40),ISBLANK(H40)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C40)),H40<>0),1,0),0\n)))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C41)),AND(H41 <> 0,H41<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C41)),H41=\"-\",NOT(ISBLANK(G41))),1,\n  IF(AND(ISBLANK(C41),ISBLANK(H41)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C41)),H41<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,3,"Travaux GC"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C42)),AND(H42 <> 0,H42<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C42)),H42=\"-\",NOT(ISBLANK(G42))),1,\n  IF(AND(ISBLANK(C42),ISBLANK(H42)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C42)),H42<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1","Aménagement du chantier"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C43)),AND(H43 <> 0,H43<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C43)),H43=\"-\",NOT(ISBLANK(G43))),1,\n  IF(AND(ISBLANK(C43),ISBLANK(H43)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C43)),H43<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.1","Etat des lieux du domaine public","forfait",550,null,{"$f":" F43*G43","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C44)),AND(H44 <> 0,H44<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C44)),H44=\"-\",NOT(ISBLANK(G44))),1,\n  IF(AND(ISBLANK(C44),ISBLANK(H44)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C44)),H44<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.2","Etat des lieux des bâtiments voisins","forfait",700,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C45)),AND(H45 <> 0,H45<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C45)),H45=\"-\",NOT(ISBLANK(G45))),1,\n  IF(AND(ISBLANK(C45),ISBLANK(H45)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C45)),H45<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.3","Clôture du chantier","m",12,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C46)),AND(H46 <> 0,H46<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C46)),H46=\"-\",NOT(ISBLANK(G46))),1,\n  IF(AND(ISBLANK(C46),ISBLANK(H46)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C46)),H46<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.4","Installation électrique de chantier","forfait",1800,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C47)),AND(H47 <> 0,H47<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C47)),H47=\"-\",NOT(ISBLANK(G47))),1,\n  IF(AND(ISBLANK(C47),ISBLANK(H47)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C47)),H47<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.5","Cabine de chantier, équipements sanitaires, …","forfait",3150,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C48)),AND(H48 <> 0,H48<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C48)),H48=\"-\",NOT(ISBLANK(G48))),1,\n  IF(AND(ISBLANK(C48),ISBLANK(H48)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C48)),H48<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.6","Demandes de conduites utilitaires, mesures pour raccordements privés","forfait",2600,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C49)),AND(H49 <> 0,H49<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C49)),H49=\"-\",NOT(ISBLANK(G49))),1,\n  IF(AND(ISBLANK(C49),ISBLANK(H49)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C49)),H49<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.7","Déviation impétrant domaine public","forfait",28000,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C50)),AND(H50 <> 0,H50<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C50)),H50=\"-\",NOT(ISBLANK(G50))),1,\n  IF(AND(ISBLANK(C50),ISBLANK(H50)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C50)),H50<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.1.8","Autres (signalisation, mesures tassement, etc.","forfait",null,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C51)),AND(H51 <> 0,H51<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C51)),H51=\"-\",NOT(ISBLANK(G51))),1,\n  IF(AND(ISBLANK(C51),ISBLANK(H51)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C51)),H51<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2","Travaux de démolition"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C52)),AND(H52 <> 0,H52<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C52)),H52=\"-\",NOT(ISBLANK(G52))),1,\n  IF(AND(ISBLANK(C52),ISBLANK(H52)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C52)),H52<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.1","Démantèlement du revètement (fondations et découpes inclus)","m²",12,null,{"$f":" F52*G52","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C53)),AND(H53 <> 0,H53<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C53)),H53=\"-\",NOT(ISBLANK(G53))),1,\n  IF(AND(ISBLANK(C53),ISBLANK(H53)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C53)),H53<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.2","Démolition de bâtiments, évacuation incluse (volume brut)","m³",18,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C54)),AND(H54 <> 0,H54<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C54)),H54=\"-\",NOT(ISBLANK(G54))),1,\n  IF(AND(ISBLANK(C54),ISBLANK(H54)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C54)),H54<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.3","Démolition de caves, évacuation incluse (volume brut)","m³",30,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C55)),AND(H55 <> 0,H55<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C55)),H55=\"-\",NOT(ISBLANK(G55))),1,\n  IF(AND(ISBLANK(C55),ISBLANK(H55)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C55)),H55<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.4","Démantèlement de fondations souterraines en maçonnerie","m³",95,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C56)),AND(H56 <> 0,H56<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C56)),H56=\"-\",NOT(ISBLANK(G56))),1,\n  IF(AND(ISBLANK(C56),ISBLANK(H56)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C56)),H56<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.5","Démantèlement de fondations souterraines en béton","m³",125,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C57)),AND(H57 <> 0,H57<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C57)),H57=\"-\",NOT(ISBLANK(G57))),1,\n  IF(AND(ISBLANK(C57),ISBLANK(H57)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C57)),H57<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.6","Démolition d'îlots de pompes, évacuation incluse","m³",55,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C58)),AND(H58 <> 0,H58<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C58)),H58=\"-\",NOT(ISBLANK(G58))),1,\n  IF(AND(ISBLANK(C58),ISBLANK(H58)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C58)),H58<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.2.7","Démantèlement auvent, évacuation incluse","m²",30,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C59)),AND(H59 <> 0,H59<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C59)),H59=\"-\",NOT(ISBLANK(G59))),1,\n  IF(AND(ISBLANK(C59),ISBLANK(H59)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C59)),H59<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.3","Démantèlement des installations de carburant souterraines\nvolume en m³"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C60)),AND(H60 <> 0,H60<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C60)),H60=\"-\",NOT(ISBLANK(G60))),1,\n  IF(AND(ISBLANK(C60),ISBLANK(H60)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C60)),H60<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.3.1","Coûts fixes (mob/démob camion vacuum, enlèvement conduites, etc)","forfait",1130,null,{"$f":" F60*G60","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C61)),AND(H61 <> 0,H61<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C61)),H61=\"-\",NOT(ISBLANK(G61))),1,\n  IF(AND(ISBLANK(C61),ISBLANK(H61)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C61)),H61<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.3.2","Neutralisation des citernes, dégagement et remblai inclus ","m³",120,null,{"$f":" F61*G61","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C62)),AND(H62 <> 0,H62<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C62)),H62=\"-\",NOT(ISBLANK(G62))),1,\n  IF(AND(ISBLANK(C62),ISBLANK(H62)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C62)),H62<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.3.3","Enlèvement citernes, dalle de lestage incluse","pièce",1010,null,{"$f":" F62*G62","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C63)),AND(H63 <> 0,H63<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C63)),H63=\"-\",NOT(ISBLANK(G63))),1,\n  IF(AND(ISBLANK(C63),ISBLANK(H63)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C63)),H63<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4","Travaux de terrassement"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C64)),AND(H64 <> 0,H64<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C64)),H64=\"-\",NOT(ISBLANK(G64))),1,\n  IF(AND(ISBLANK(C64),ISBLANK(H64)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C64)),H64<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.1","Excavation des terres propres et contaminées","m³",11,null,{"$f":" F64*G64","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C65)),AND(H65 <> 0,H65<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C65)),H65=\"-\",NOT(ISBLANK(G65))),1,\n  IF(AND(ISBLANK(C65),ISBLANK(H65)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C65)),H65<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.2","Livraison de sable de remblai","m³",11,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C66)),AND(H66 <> 0,H66<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C66)),H66=\"-\",NOT(ISBLANK(G66))),1,\n  IF(AND(ISBLANK(C66),ISBLANK(H66)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C66)),H66<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.3","Stockage temporaire des terres sur chantier","m³",8,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C67)),AND(H67 <> 0,H67<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C67)),H67=\"-\",NOT(ISBLANK(G67))),1,\n  IF(AND(ISBLANK(C67),ISBLANK(H67)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C67)),H67<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.4","Remblai et compactage","m³",9,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C68)),AND(H68 <> 0,H68<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C68)),H68=\"-\",NOT(ISBLANK(G68))),1,\n  IF(AND(ISBLANK(C68),ISBLANK(H68)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C68)),H68<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.5","Isolation des terres contaminées HDPE (0,4 mm)","m²",4,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C69)),AND(H69 <> 0,H69<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C69)),H69=\"-\",NOT(ISBLANK(G69))),1,\n  IF(AND(ISBLANK(C69),ISBLANK(H69)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C69)),H69<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.4.6","Essais à la plaque (4 pièces et 2 mob/démob)","forfait",1000,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C70)),AND(H70 <> 0,H70<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C70)),H70=\"-\",NOT(ISBLANK(G70))),1,\n  IF(AND(ISBLANK(C70),ISBLANK(H70)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C70)),H70<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5","Mesures de stabilité"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C71)),AND(H71 <> 0,H71<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C71)),H71=\"-\",NOT(ISBLANK(G71))),1,\n  IF(AND(ISBLANK(C71),ISBLANK(H71)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C71)),H71<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.1","Palplanches"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C72)),AND(H72 <> 0,H72<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C72)),H72=\"-\",NOT(ISBLANK(G72))),1,\n  IF(AND(ISBLANK(C72),ISBLANK(H72)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C72)),H72<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.1.1","Mob/démob","forfait",6500,null,{"$f":" F72*G72","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C73)),AND(H73 <> 0,H73<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C73)),H73=\"-\",NOT(ISBLANK(G73))),1,\n  IF(AND(ISBLANK(C73),ISBLANK(H73)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C73)),H73<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.1.2","Mètres courants de paroi à mettre en place","m",750,null,{"$f":" F73*G73","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C74)),AND(H74 <> 0,H74<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C74)),H74=\"-\",NOT(ISBLANK(G74))),1,\n  IF(AND(ISBLANK(C74),ISBLANK(H74)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C74)),H74<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.2","Parois berlinoises"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C75)),AND(H75 <> 0,H75<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C75)),H75=\"-\",NOT(ISBLANK(G75))),1,\n  IF(AND(ISBLANK(C75),ISBLANK(H75)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C75)),H75<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.2.1","Mob/démob","forfait",3500,null,{"$f":" F75*G75","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C76)),AND(H76 <> 0,H76<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C76)),H76=\"-\",NOT(ISBLANK(G76))),1,\n  IF(AND(ISBLANK(C76),ISBLANK(H76)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C76)),H76<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.2.2","Mètres courants de paroi à mettre en place","m",700,null,{"$f":" F76*G76","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C77)),AND(H77 <> 0,H77<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C77)),H77=\"-\",NOT(ISBLANK(G77))),1,\n  IF(AND(ISBLANK(C77),ISBLANK(H77)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C77)),H77<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.3","Système de blindage"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C78)),AND(H78 <> 0,H78<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C78)),H78=\"-\",NOT(ISBLANK(G78))),1,\n  IF(AND(ISBLANK(C78),ISBLANK(H78)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C78)),H78<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.3.1","Mob/démob","forfait",2000,null,{"$f":" F78*G78","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C79)),AND(H79 <> 0,H79<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C79)),H79=\"-\",NOT(ISBLANK(G79))),1,\n  IF(AND(ISBLANK(C79),ISBLANK(H79)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C79)),H79<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.3.2","Mètres courants de paroi à mettre en place","m",300,null,{"$f":" F79*G79","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C80)),AND(H80 <> 0,H80<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C80)),H80=\"-\",NOT(ISBLANK(G80))),1,\n  IF(AND(ISBLANK(C80),ISBLANK(H80)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C80)),H80<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.4","Parois pieux sécants"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C81)),AND(H81 <> 0,H81<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C81)),H81=\"-\",NOT(ISBLANK(G81))),1,\n  IF(AND(ISBLANK(C81),ISBLANK(H81)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C81)),H81<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.4.1","Mob/démob","forfait",7000,null,{"$f":" F81*G81","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C82)),AND(H82 <> 0,H82<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C82)),H82=\"-\",NOT(ISBLANK(G82))),1,\n  IF(AND(ISBLANK(C82),ISBLANK(H82)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C82)),H82<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.4.2","Mètres courants de paroi à mettre en place","m",2300,null,{"$f":" F82*G82","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C83)),AND(H83 <> 0,H83<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C83)),H83=\"-\",NOT(ISBLANK(G83))),1,\n  IF(AND(ISBLANK(C83),ISBLANK(H83)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C83)),H83<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.5","Excavations en passes alternées"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C84)),AND(H84 <> 0,H84<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C84)),H84=\"-\",NOT(ISBLANK(G84))),1,\n  IF(AND(ISBLANK(C84),ISBLANK(H84)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C84)),H84<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.5.1","Surcoût pour excavation en tranches","m",94,null,{"$f":" F84*G84","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C85)),AND(H85 <> 0,H85<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C85)),H85=\"-\",NOT(ISBLANK(G85))),1,\n  IF(AND(ISBLANK(C85),ISBLANK(H85)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C85)),H85<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.5.3","Surcoût pour livraison de sable stabilisé au lieu de terre","m³",50,null,{"$f":" F85*G85","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C86)),AND(H86 <> 0,H86<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C86)),H86=\"-\",NOT(ISBLANK(G86))),1,\n  IF(AND(ISBLANK(C86),ISBLANK(H86)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C86)),H86<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.6","Excavations tubées"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C87)),AND(H87 <> 0,H87<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C87)),H87=\"-\",NOT(ISBLANK(G87))),1,\n  IF(AND(ISBLANK(C87),ISBLANK(H87)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C87)),H87<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.6.1","Mob/démob","forfait",2900,null,{"$f":" F87*G87","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C88)),AND(H88 <> 0,H88<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C88)),H88=\"-\",NOT(ISBLANK(G88))),1,\n  IF(AND(ISBLANK(C88),ISBLANK(H88)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C88)),H88<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.5.6.2","Surcoût pour excavation tubée","m³",56,null,{"$f":" F88*G88","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C89)),AND(H89 <> 0,H89<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C89)),H89=\"-\",NOT(ISBLANK(G89))),1,\n  IF(AND(ISBLANK(C89),ISBLANK(H89)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C89)),H89<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.6","Rabattement"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C90)),AND(H90 <> 0,H90<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C90)),H90=\"-\",NOT(ISBLANK(G90))),1,\n  IF(AND(ISBLANK(C90),ISBLANK(H90)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C90)),H90<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.6.1","Rabattement par puits de pompage (bac de récupération exclus)","forfait",3500,null,{"$f":" F90*G90","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C91)),AND(H91 <> 0,H91<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C91)),H91=\"-\",NOT(ISBLANK(G91))),1,\n  IF(AND(ISBLANK(C91),ISBLANK(H91)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C91)),H91<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.6.2","Pompage en fond de fouille","forfait",900,null,{"$f":" F91*G91","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C92)),AND(H92 <> 0,H92<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C92)),H92=\"-\",NOT(ISBLANK(G92))),1,\n  IF(AND(ISBLANK(C92),ISBLANK(H92)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C92)),H92<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7","Epuration des eaux souterraines durant les travaux de terrassement"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C93)),AND(H93 <> 0,H93<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C93)),H93=\"-\",NOT(ISBLANK(G93))),1,\n  IF(AND(ISBLANK(C93),ISBLANK(H93)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C93)),H93<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1","Mob/démob",null,null,null,{"$f":"#REF!* G93","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C94)),AND(H94 <> 0,H94<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C94)),H94=\"-\",NOT(ISBLANK(G94))),1,\n  IF(AND(ISBLANK(C94),ISBLANK(H94)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C94)),H94<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.1","Installation jusqu'à 10 m³/h",null,null,null,{"$f":"#REF!* G94","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C95)),AND(H95 <> 0,H95<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C95)),H95=\"-\",NOT(ISBLANK(G95))),1,\n  IF(AND(ISBLANK(C95),ISBLANK(H95)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C95)),H95<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.1.1","Séparateur d'hydrocarbures","pièce",1100,null,{"$f":"F95*G95","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C96)),AND(H96 <> 0,H96<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C96)),H96=\"-\",NOT(ISBLANK(G96))),1,\n  IF(AND(ISBLANK(C96),ISBLANK(H96)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C96)),H96<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.1.2","Installation de stripping (incl. 1ère charge charbon actif)","pièce",4700,null,{"$f":"F96*G96","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C97)),AND(H97 <> 0,H97<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C97)),H97=\"-\",NOT(ISBLANK(G97))),1,\n  IF(AND(ISBLANK(C97),ISBLANK(H97)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C97)),H97<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.1.3","Installation de déferrisation (filtre à sable rinçage manuel)","pièce",3800,null,{"$f":"F97*G97","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C98)),AND(H98 <> 0,H98<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C98)),H98=\"-\",NOT(ISBLANK(G98))),1,\n  IF(AND(ISBLANK(C98),ISBLANK(H98)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C98)),H98<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.1.4","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",5800,null,{"$f":"F98*G98","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C99)),AND(H99 <> 0,H99<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C99)),H99=\"-\",NOT(ISBLANK(G99))),1,\n  IF(AND(ISBLANK(C99),ISBLANK(H99)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C99)),H99<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.2","Installation jusqu'à 20 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C100)),AND(H100 <> 0,H100<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C100)),H100=\"-\",NOT(ISBLANK(G100))),1,\n  IF(AND(ISBLANK(C100),ISBLANK(H100)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C100)),H100<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.2.1","Séparateur d'hydrocarbures","pièce",1250,null,{"$f":"F100*G100","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C101)),AND(H101 <> 0,H101<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C101)),H101=\"-\",NOT(ISBLANK(G101))),1,\n  IF(AND(ISBLANK(C101),ISBLANK(H101)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C101)),H101<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.2.2","Installation de stripping (incl. 1ère charge charbon actif)","pièce",7500,null,{"$f":"F101*G101","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C102)),AND(H102 <> 0,H102<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C102)),H102=\"-\",NOT(ISBLANK(G102))),1,\n  IF(AND(ISBLANK(C102),ISBLANK(H102)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C102)),H102<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.2.3","Installation de déferrisation (filtre à sable rinçage manuel)","pièce",5700,null,{"$f":"F102*G102","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C103)),AND(H103 <> 0,H103<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C103)),H103=\"-\",NOT(ISBLANK(G103))),1,\n  IF(AND(ISBLANK(C103),ISBLANK(H103)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C103)),H103<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.2.4","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",10650,null,{"$f":"F103*G103","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C104)),AND(H104 <> 0,H104<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C104)),H104=\"-\",NOT(ISBLANK(G104))),1,\n  IF(AND(ISBLANK(C104),ISBLANK(H104)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C104)),H104<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.3","Installation jusqu'à 40 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C105)),AND(H105 <> 0,H105<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C105)),H105=\"-\",NOT(ISBLANK(G105))),1,\n  IF(AND(ISBLANK(C105),ISBLANK(H105)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C105)),H105<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.3.1","Séparateur d'hydrocarbures","pièce",1450,null,{"$f":"F105*G105","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C106)),AND(H106 <> 0,H106<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C106)),H106=\"-\",NOT(ISBLANK(G106))),1,\n  IF(AND(ISBLANK(C106),ISBLANK(H106)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C106)),H106<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.3.2","Installation de stripping (incl. 1ère charge charbon actif)","pièce",13450,null,{"$f":"F106*G106","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C107)),AND(H107 <> 0,H107<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C107)),H107=\"-\",NOT(ISBLANK(G107))),1,\n  IF(AND(ISBLANK(C107),ISBLANK(H107)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C107)),H107<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.3.3","Installation de déferrisation (filtre à sable rinçage manuel)","pièce",7750,null,{"$f":"F107*G107","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C108)),AND(H108 <> 0,H108<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C108)),H108=\"-\",NOT(ISBLANK(G108))),1,\n  IF(AND(ISBLANK(C108),ISBLANK(H108)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C108)),H108<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.1.3.4","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",20150,null,{"$f":"F108*G108","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C109)),AND(H109 <> 0,H109<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C109)),H109=\"-\",NOT(ISBLANK(G109))),1,\n  IF(AND(ISBLANK(C109),ISBLANK(H109)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C109)),H109<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2","Location + utilisation",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C110)),AND(H110 <> 0,H110<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C110)),H110=\"-\",NOT(ISBLANK(G110))),1,\n  IF(AND(ISBLANK(C110),ISBLANK(H110)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C110)),H110<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.1","Installation jusqu'à 10 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C111)),AND(H111 <> 0,H111<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C111)),H111=\"-\",NOT(ISBLANK(G111))),1,\n  IF(AND(ISBLANK(C111),ISBLANK(H111)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C111)),H111<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.1.1","Séparateur d'hydrocarbures","semaine",75,null,{"$f":"F111*G111","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C112)),AND(H112 <> 0,H112<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C112)),H112=\"-\",NOT(ISBLANK(G112))),1,\n  IF(AND(ISBLANK(C112),ISBLANK(H112)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C112)),H112<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.1.2","Installation de stripping","semaine",350,null,{"$f":"F112*G112","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C113)),AND(H113 <> 0,H113<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C113)),H113=\"-\",NOT(ISBLANK(G113))),1,\n  IF(AND(ISBLANK(C113),ISBLANK(H113)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C113)),H113<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.1.3","Installation de déferrisation (filtre à sable rinçage manuel)","semaine",450,null,{"$f":"F113*G113","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C114)),AND(H114 <> 0,H114<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C114)),H114=\"-\",NOT(ISBLANK(G114))),1,\n  IF(AND(ISBLANK(C114),ISBLANK(H114)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C114)),H114<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.1.4","Filtre à charbon actif (eau)","semaine",125,null,{"$f":"F114*G114","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C115)),AND(H115 <> 0,H115<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C115)),H115=\"-\",NOT(ISBLANK(G115))),1,\n  IF(AND(ISBLANK(C115),ISBLANK(H115)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C115)),H115<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.2","Installation jusqu'à 20 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C116)),AND(H116 <> 0,H116<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C116)),H116=\"-\",NOT(ISBLANK(G116))),1,\n  IF(AND(ISBLANK(C116),ISBLANK(H116)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C116)),H116<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.2.1","Séparateur d'hydrocarbures","semaine",95,null,{"$f":"F116*G116","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C117)),AND(H117 <> 0,H117<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C117)),H117=\"-\",NOT(ISBLANK(G117))),1,\n  IF(AND(ISBLANK(C117),ISBLANK(H117)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C117)),H117<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.2.2","Installation de stripping","semaine",550,null,{"$f":"F117*G117","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C118)),AND(H118 <> 0,H118<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C118)),H118=\"-\",NOT(ISBLANK(G118))),1,\n  IF(AND(ISBLANK(C118),ISBLANK(H118)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C118)),H118<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.2.3","Installation de déferrisation (filtre à sable rinçage manuel)","semaine",650,null,{"$f":"F118*G118","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C119)),AND(H119 <> 0,H119<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C119)),H119=\"-\",NOT(ISBLANK(G119))),1,\n  IF(AND(ISBLANK(C119),ISBLANK(H119)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C119)),H119<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.2.4","Filtre à charbon actif (eau)","semaine",150,null,{"$f":"F119*G119","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C120)),AND(H120 <> 0,H120<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C120)),H120=\"-\",NOT(ISBLANK(G120))),1,\n  IF(AND(ISBLANK(C120),ISBLANK(H120)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C120)),H120<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3","Installation jusqu'à 40 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C121)),AND(H121 <> 0,H121<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C121)),H121=\"-\",NOT(ISBLANK(G121))),1,\n  IF(AND(ISBLANK(C121),ISBLANK(H121)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C121)),H121<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3.1","Séparateur d'hydrocarbures","semaine",150,null,{"$f":"F121*G121","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C122)),AND(H122 <> 0,H122<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C122)),H122=\"-\",NOT(ISBLANK(G122))),1,\n  IF(AND(ISBLANK(C122),ISBLANK(H122)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C122)),H122<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3.2","Installation de stripping","semaine",850,null,{"$f":"F122*G122","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C123)),AND(H123 <> 0,H123<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C123)),H123=\"-\",NOT(ISBLANK(G123))),1,\n  IF(AND(ISBLANK(C123),ISBLANK(H123)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C123)),H123<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3.3","Installation de déferrisation (filtre à sable rinçage manuel)","semaine",900,null,{"$f":"F123*G123","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C124)),AND(H124 <> 0,H124<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C124)),H124=\"-\",NOT(ISBLANK(G124))),1,\n  IF(AND(ISBLANK(C124),ISBLANK(H124)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C124)),H124<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3.4","Filtre à charbon actif (eau)","semaine",200,null,{"$f":"F124*G124","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C125)),AND(H125 <> 0,H125<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C125)),H125=\"-\",NOT(ISBLANK(G125))),1,\n  IF(AND(ISBLANK(C125),ISBLANK(H125)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C125)),H125<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3","Installation jusqu'à 40 m³/h",null,{"$f":" (#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C126)),AND(H126 <> 0,H126<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C126)),H126=\"-\",NOT(ISBLANK(G126))),1,\n  IF(AND(ISBLANK(C126),ISBLANK(H126)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C126)),H126<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.7.2.3.1","Remplacement charbon actif","kg",4,null,{"$f":"F126*G126","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C127)),AND(H127 <> 0,H127<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C127)),H127=\"-\",NOT(ISBLANK(G127))),1,\n  IF(AND(ISBLANK(C127),ISBLANK(H127)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C127)),H127<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8","Installations in situ souterraines"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C128)),AND(H128 <> 0,H128<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C128)),H128=\"-\",NOT(ISBLANK(G128))),1,\n  IF(AND(ISBLANK(C128),ISBLANK(H128)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C128)),H128<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.1","Isolation de la contamination résiduelle (film HDPE 0,4mm)","m²",4,null,{"$f":" F128*G128","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C129)),AND(H129 <> 0,H129<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C129)),H129=\"-\",NOT(ISBLANK(G129))),1,\n  IF(AND(ISBLANK(C129),ISBLANK(H129)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C129)),H129<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.2","Drain de pompage (HDPE, diam 110 mm) gravier drainant inclus","mètre courant",55,null,{"$f":" F129*G129","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C130)),AND(H130 <> 0,H130<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C130)),H130=\"-\",NOT(ISBLANK(G130))),1,\n  IF(AND(ISBLANK(C130),ISBLANK(H130)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C130)),H130<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.3","Puits de pompage et puits de purge",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C131)),AND(H131 <> 0,H131<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C131)),H131=\"-\",NOT(ISBLANK(G131))),1,\n  IF(AND(ISBLANK(C131),ISBLANK(H131)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C131)),H131<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.3.1","Puits de pompage (HDPE, diam. 400 mm)","mètre courant",235,null,{"$f":" F131*G131","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C132)),AND(H132 <> 0,H132<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C132)),H132=\"-\",NOT(ISBLANK(G132))),1,\n  IF(AND(ISBLANK(C132),ISBLANK(H132)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C132)),H132<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.3.2","Puits de purge (HDPE, diam. 110 mm)","mètre courant",35,null,{"$f":" F132*G132","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C133)),AND(H133 <> 0,H133<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C133)),H133=\"-\",NOT(ISBLANK(G133))),1,\n  IF(AND(ISBLANK(C133),ISBLANK(H133)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C133)),H133<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.4","Forages horizontaux (drains inclus)",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C134)),AND(H134 <> 0,H134<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C134)),H134=\"-\",NOT(ISBLANK(G134))),1,\n  IF(AND(ISBLANK(C134),ISBLANK(H134)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C134)),H134<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.4.1","Mob/démob machine de forage","forfait",1065,null,{"$f":" F134*G134","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C135)),AND(H135 <> 0,H135<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C135)),H135=\"-\",NOT(ISBLANK(G135))),1,\n  IF(AND(ISBLANK(C135),ISBLANK(H135)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C135)),H135<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.4.2","Coûts de mise en oeuvre par forage","pièce",325,null,{"$f":" F135*G135","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C136)),AND(H136 <> 0,H136<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C136)),H136=\"-\",NOT(ISBLANK(G136))),1,\n  IF(AND(ISBLANK(C136),ISBLANK(H136)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C136)),H136<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.4.3","Forage et placement drain 125/80","m",145,null,{"$f":" F136*G136","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C137)),AND(H137 <> 0,H137<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C137)),H137=\"-\",NOT(ISBLANK(G137))),1,\n  IF(AND(ISBLANK(C137),ISBLANK(H137)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C137)),H137<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5","Filtres (forages inclus)",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C138)),AND(H138 <> 0,H138<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C138)),H138=\"-\",NOT(ISBLANK(G138))),1,\n  IF(AND(ISBLANK(C138),ISBLANK(H138)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C138)),H138<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5.1","Mob/démob machine de forage, bac de récupération inclus","forfait",1230,null,{"$f":" F138*G138","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C139)),AND(H139 <> 0,H139<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C139)),H139=\"-\",NOT(ISBLANK(G139))),1,\n  IF(AND(ISBLANK(C139),ISBLANK(H139)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C139)),H139<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5.2","Coûts de mise en oeuvre par forage, connexions filtres incluses","pièce",160,null,{"$f":" F139*G139","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C140)),AND(H140 <> 0,H140<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C140)),H140=\"-\",NOT(ISBLANK(G140))),1,\n  IF(AND(ISBLANK(C140),ISBLANK(H140)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C140)),H140<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5.3","Filtre 2'' - gravier inclus, forage 210 mm","m",95,null,{"$f":" F140*G140","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C141)),AND(H141 <> 0,H141<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C141)),H141=\"-\",NOT(ISBLANK(G141))),1,\n  IF(AND(ISBLANK(C141),ISBLANK(H141)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C141)),H141<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5.4","Filtre 6'' - gravier inclus, forage 300 mm","m",225,null,{"$f":" F141*G141","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C142)),AND(H142 <> 0,H142<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C142)),H142=\"-\",NOT(ISBLANK(G142))),1,\n  IF(AND(ISBLANK(C142),ISBLANK(H142)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C142)),H142<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.5.5","Réalisation de forage béton","jour",300,null,{"$f":" F142*G142","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C143)),AND(H143 <> 0,H143<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C143)),H143=\"-\",NOT(ISBLANK(G143))),1,\n  IF(AND(ISBLANK(C143),ISBLANK(H143)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C143)),H143<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.6","Chambres de visites",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C144)),AND(H144 <> 0,H144<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C144)),H144=\"-\",NOT(ISBLANK(G144))),1,\n  IF(AND(ISBLANK(C144),ISBLANK(H144)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C144)),H144<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.6.1","Chambre de visite, couvercle inclus (diam. 400 mm)","pièce",580,null,{"$f":" F144*G144","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C145)),AND(H145 <> 0,H145<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C145)),H145=\"-\",NOT(ISBLANK(G145))),1,\n  IF(AND(ISBLANK(C145),ISBLANK(H145)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C145)),H145<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.6.2","Chambre de visite, couvercle inclus (diam. 600 mm)","pièce",1250,null,{"$f":" F145*G145","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C146)),AND(H146 <> 0,H146<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C146)),H146=\"-\",NOT(ISBLANK(G146))),1,\n  IF(AND(ISBLANK(C146),ISBLANK(H146)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C146)),H146<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.6.3","Chambre de collecte centrale, couvercle inclus","pièce",1600,null,{"$f":" F146*G146","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C147)),AND(H147 <> 0,H147<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C147)),H147=\"-\",NOT(ISBLANK(G147))),1,\n  IF(AND(ISBLANK(C147),ISBLANK(H147)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C147)),H147<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.7","Conduites",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C148)),AND(H148 <> 0,H148<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C148)),H148=\"-\",NOT(ISBLANK(G148))),1,\n  IF(AND(ISBLANK(C148),ISBLANK(H148)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C148)),H148<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.7.1","Conduite d'évacuation (HDPE, diam. 40)","mètre courant",18,null,{"$f":" F148*G148","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C149)),AND(H149 <> 0,H149<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C149)),H149=\"-\",NOT(ISBLANK(G149))),1,\n  IF(AND(ISBLANK(C149),ISBLANK(H149)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C149)),H149<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.7.2","Conduite d'évacuation (HDPE, diam. 110)","mètre courant",35,null,{"$f":" F149*G149","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C150)),AND(H150 <> 0,H150<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C150)),H150=\"-\",NOT(ISBLANK(G150))),1,\n  IF(AND(ISBLANK(C150),ISBLANK(H150)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C150)),H150<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.8.7.3","Gaine d'attente électricité (PVC, diam. 110), tire-fils inclus","mètre courant",20,null,{"$f":" F150*G150","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C151)),AND(H151 <> 0,H151<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C151)),H151=\"-\",NOT(ISBLANK(G151))),1,\n  IF(AND(ISBLANK(C151),ISBLANK(H151)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C151)),H151<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9","Autres travaux GC"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C152)),AND(H152 <> 0,H152<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C152)),H152=\"-\",NOT(ISBLANK(G152))),1,\n  IF(AND(ISBLANK(C152),ISBLANK(H152)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C152)),H152<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.1","Assainissement de couche surnageante",null,null,null,{"$f":"#REF!* G152","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C153)),AND(H153 <> 0,H153<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C153)),H153=\"-\",NOT(ISBLANK(G153))),1,\n  IF(AND(ISBLANK(C153),ISBLANK(H153)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C153)),H153<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.1.1","Mob/démob camion vacuum","pièce",785,null,{"$f":" F153*G153","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C154)),AND(H154 <> 0,H154<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C154)),H154=\"-\",NOT(ISBLANK(G154))),1,\n  IF(AND(ISBLANK(C154),ISBLANK(H154)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C154)),H154<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.1.2","Evacuation et traitement du produit extrait","kg",0.26,null,{"$f":" F154*G154","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C155)),AND(H155 <> 0,H155<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C155)),H155=\"-\",NOT(ISBLANK(G155))),1,\n  IF(AND(ISBLANK(C155),ISBLANK(H155)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C155)),H155<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.1.3","Tranchées de contrôle","m³",22,null,{"$f":" F155*G155","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C156)),AND(H156 <> 0,H156<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C156)),H156=\"-\",NOT(ISBLANK(G156))),1,\n  IF(AND(ISBLANK(C156),ISBLANK(H156)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C156)),H156<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.1.4","Placement et location bac tampon","forfait",450,null,{"$f":" F156*G156","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C157)),AND(H157 <> 0,H157<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C157)),H157=\"-\",NOT(ISBLANK(G157))),1,\n  IF(AND(ISBLANK(C157),ISBLANK(H157)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C157)),H157<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.2","Travaux de remise en état",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C158)),AND(H158 <> 0,H158<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C158)),H158=\"-\",NOT(ISBLANK(G158))),1,\n  IF(AND(ISBLANK(C158),ISBLANK(H158)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C158)),H158<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.2.1","Remise en état du revêtement","m²",65,null,{"$f":" F158*G158","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C159)),AND(H159 <> 0,H159<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C159)),H159=\"-\",NOT(ISBLANK(G159))),1,\n  IF(AND(ISBLANK(C159),ISBLANK(H159)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C159)),H159<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.2.2","Reconstruction piste étanche","m²",120,null,{"$f":" F159*G159","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C160)),AND(H160 <> 0,H160<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C160)),H160=\"-\",NOT(ISBLANK(G160))),1,\n  IF(AND(ISBLANK(C160),ISBLANK(H160)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C160)),H160<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.9.2.3","Reconstruction auvent","m²",60,null,{"$f":" F160*G160","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C161)),AND(H161 <> 0,H161<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C161)),H161=\"-\",NOT(ISBLANK(G161))),1,\n  IF(AND(ISBLANK(C161),ISBLANK(H161)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C161)),H161<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.10","Transport terres contaminées"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C162)),AND(H162 <> 0,H162<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C162)),H162=\"-\",NOT(ISBLANK(G162))),1,\n  IF(AND(ISBLANK(C162),ISBLANK(H162)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C162)),H162<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.10.1","Distance via route jusqu'au centre de traitement/jusqu'à la décharge","km","-",null,"-"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C163)),AND(H163 <> 0,H163<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C163)),H163=\"-\",NOT(ISBLANK(G163))),1,\n  IF(AND(ISBLANK(C163),ISBLANK(H163)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C163)),H163<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.10.2","Volume à transporter","tonne",{"$f":"G162*0.16","v":0},{"$f":"SUM(G165:G168)","v":0},{"$f":" F163*G163","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C164)),AND(H164 <> 0,H164<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C164)),H164=\"-\",NOT(ISBLANK(G164))),1,\n  IF(AND(ISBLANK(C164),ISBLANK(H164)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C164)),H164<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.11","Traitement de terre contaminée -  Ex Situ"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C165)),AND(H165 <> 0,H165<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C165)),H165=\"-\",NOT(ISBLANK(G165))),1,\n  IF(AND(ISBLANK(C165),ISBLANK(H165)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C165)),H165<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.11.1","Traitement biologique","tonne",30,null,{"$f":" F165*G165","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C166)),AND(H166 <> 0,H166<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C166)),H166=\"-\",NOT(ISBLANK(G166))),1,\n  IF(AND(ISBLANK(C166),ISBLANK(H166)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C166)),H166<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.11.2","Traitement physico-chimique","tonne",45,null,{"$f":" F166*G166","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C167)),AND(H167 <> 0,H167<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C167)),H167=\"-\",NOT(ISBLANK(G167))),1,\n  IF(AND(ISBLANK(C167),ISBLANK(H167)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C167)),H167<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.11.3","Traitement thermique","tonne",70,null,{"$f":" F167*G167","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C168)),AND(H168 <> 0,H168<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C168)),H168=\"-\",NOT(ISBLANK(G168))),1,\n  IF(AND(ISBLANK(C168),ISBLANK(H168)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C168)),H168<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"3.11.4","Autres traitements / décharge","tonne",100,null,{"$f":" F168*G168","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C169)),AND(H169 <> 0,H169<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C169)),H169=\"-\",NOT(ISBLANK(G169))),1,\n  IF(AND(ISBLANK(C169),ISBLANK(H169)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C169)),H169<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,4,"Travaux IS"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C170)),AND(H170 <> 0,H170<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C170)),H170=\"-\",NOT(ISBLANK(G170))),1,\n  IF(AND(ISBLANK(C170),ISBLANK(H170)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C170)),H170<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.1","Généralités (clôtures autour installations, alarmes, déplacements pour intervention)"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C171)),AND(H171 <> 0,H171<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C171)),H171=\"-\",NOT(ISBLANK(G171))),1,\n  IF(AND(ISBLANK(C171),ISBLANK(H171)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C171)),H171<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.1.1","En phase de démarrage (5 premières semaines)","forfait",2700,null,{"$f":" F171*G171","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C172)),AND(H172 <> 0,H172<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C172)),H172=\"-\",NOT(ISBLANK(G172))),1,\n  IF(AND(ISBLANK(C172),ISBLANK(H172)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C172)),H172<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.1.2","Après phase de démarrage","semaine",150,null,{"$f":" F172*G172","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C173)),AND(H173 <> 0,H173<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C173)),H173=\"-\",NOT(ISBLANK(G173))),1,\n  IF(AND(ISBLANK(C173),ISBLANK(H173)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C173)),H173<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2","Extraction de l'air du sol/injection/airsparging"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C174)),AND(H174 <> 0,H174<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C174)),H174=\"-\",NOT(ISBLANK(G174))),1,\n  IF(AND(ISBLANK(C174),ISBLANK(H174)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C174)),H174<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1","Mob/démob",null,null,null,{"$f":"#REF!* G174","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C175)),AND(H175 <> 0,H175<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C175)),H175=\"-\",NOT(ISBLANK(G175))),1,\n  IF(AND(ISBLANK(C175),ISBLANK(H175)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C175)),H175<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1.1","Test de pompage","pièce",1800,null,{"$f":" F175*G175","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C176)),AND(H176 <> 0,H176<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C176)),H176=\"-\",NOT(ISBLANK(G176))),1,\n  IF(AND(ISBLANK(C176),ISBLANK(H176)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C176)),H176<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1.2","Blower BLE (ca. 150 m³/h)","pièce",1550,null,{"$f":" F176*G176","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C177)),AND(H177 <> 0,H177<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C177)),H177=\"-\",NOT(ISBLANK(G177))),1,\n  IF(AND(ISBLANK(C177),ISBLANK(H177)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C177)),H177<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1.3","Filtre charbon actif 200 l (inclus 1e charge)","pièce",850,null,{"$f":" F177*G177","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C178)),AND(H178 <> 0,H178<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C178)),H178=\"-\",NOT(ISBLANK(G178))),1,\n  IF(AND(ISBLANK(C178),ISBLANK(H178)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C178)),H178<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1.4","Filtre charbon actif 1250 l (inclus 1e charge)","pièce",3100,null,{"$f":" F178*G178","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C179)),AND(H179 <> 0,H179<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C179)),H179=\"-\",NOT(ISBLANK(G179))),1,\n  IF(AND(ISBLANK(C179),ISBLANK(H179)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C179)),H179<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.1.5","Blower + CATOX (ca 500 Nm³/h)","forfait",9950,null,{"$f":" F179*G179","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C180)),AND(H180 <> 0,H180<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C180)),H180=\"-\",NOT(ISBLANK(G180))),1,\n  IF(AND(ISBLANK(C180),ISBLANK(H180)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C180)),H180<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2","Location + utilisation",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C181)),AND(H181 <> 0,H181<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C181)),H181=\"-\",NOT(ISBLANK(G181))),1,\n  IF(AND(ISBLANK(C181),ISBLANK(H181)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C181)),H181<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2.1","Blower BLE (ca 150 Nm³/h)","semaine",210,null,{"$f":" F181*G181","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C182)),AND(H182 <> 0,H182<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C182)),H182=\"-\",NOT(ISBLANK(G182))),1,\n  IF(AND(ISBLANK(C182),ISBLANK(H182)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C182)),H182<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2.2","Filtre charbon actif 200 l","semaine",40,null,{"$f":" F182*G182","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C183)),AND(H183 <> 0,H183<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C183)),H183=\"-\",NOT(ISBLANK(G183))),1,\n  IF(AND(ISBLANK(C183),ISBLANK(H183)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C183)),H183<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2.3","Filtre charbon actif 1250 l","semaine",50,null,{"$f":" F183*G183","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C184)),AND(H184 <> 0,H184<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C184)),H184=\"-\",NOT(ISBLANK(G184))),1,\n  IF(AND(ISBLANK(C184),ISBLANK(H184)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C184)),H184<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2.4","Blower + CATOX (ca 500 Nm³/h)","semaine",1675,null,{"$f":" F184*G184","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C185)),AND(H185 <> 0,H185<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C185)),H185=\"-\",NOT(ISBLANK(G185))),1,\n  IF(AND(ISBLANK(C185),ISBLANK(H185)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C185)),H185<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.2.2.5","Remplacement charbon actif","kg",4,null,{"$f":" F185*G185","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C186)),AND(H186 <> 0,H186<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C186)),H186=\"-\",NOT(ISBLANK(G186))),1,\n  IF(AND(ISBLANK(C186),ISBLANK(H186)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C186)),H186<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3","Pump & treat"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C187)),AND(H187 <> 0,H187<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C187)),H187=\"-\",NOT(ISBLANK(G187))),1,\n  IF(AND(ISBLANK(C187),ISBLANK(H187)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C187)),H187<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1","Mob/démob",null,null,null,{"$f":"#REF!* G187","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C188)),AND(H188 <> 0,H188<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C188)),H188=\"-\",NOT(ISBLANK(G188))),1,\n  IF(AND(ISBLANK(C188),ISBLANK(H188)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C188)),H188<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.1","Pompes immergées","pièce",800]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C189)),AND(H189 <> 0,H189<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C189)),H189=\"-\",NOT(ISBLANK(G189))),1,\n  IF(AND(ISBLANK(C189),ISBLANK(H189)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C189)),H189<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.1.1","Pompes immergées","pièce",800,null,{"$f":" F189*G189","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C190)),AND(H190 <> 0,H190<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C190)),H190=\"-\",NOT(ISBLANK(G190))),1,\n  IF(AND(ISBLANK(C190),ISBLANK(H190)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C190)),H190<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2","Installation jusqu'à 5 m³/h",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C191)),AND(H191 <> 0,H191<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C191)),H191=\"-\",NOT(ISBLANK(G191))),1,\n  IF(AND(ISBLANK(C191),ISBLANK(H191)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C191)),H191<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2.1","Pompe aérienne","pièce",860,null,{"$f":" F191*G191","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C192)),AND(H192 <> 0,H192<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C192)),H192=\"-\",NOT(ISBLANK(G192))),1,\n  IF(AND(ISBLANK(C192),ISBLANK(H192)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C192)),H192<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2.2","Séparateur d'hydrocarbures","pièce",910,null,{"$f":" F192*G192","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C193)),AND(H193 <> 0,H193<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C193)),H193=\"-\",NOT(ISBLANK(G193))),1,\n  IF(AND(ISBLANK(C193),ISBLANK(H193)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C193)),H193<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2.3","Installation de stripping (incl. 1ère charge charbon actif)","pièce",3575,null,{"$f":" F193*G193","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C194)),AND(H194 <> 0,H194<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C194)),H194=\"-\",NOT(ISBLANK(G194))),1,\n  IF(AND(ISBLANK(C194),ISBLANK(H194)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C194)),H194<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2.4","Installation de déferrisation (filtre à sable à rinçage automatique)","pièce",3150,null,{"$f":" F194*G194","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C195)),AND(H195 <> 0,H195<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C195)),H195=\"-\",NOT(ISBLANK(G195))),1,\n  IF(AND(ISBLANK(C195),ISBLANK(H195)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C195)),H195<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.2.5","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",3350,null,{"$f":" F195*G195","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C196)),AND(H196 <> 0,H196<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C196)),H196=\"-\",NOT(ISBLANK(G196))),1,\n  IF(AND(ISBLANK(C196),ISBLANK(H196)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C196)),H196<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3","Installation jusqu'à 10 m³/h",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C197)),AND(H197 <> 0,H197<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C197)),H197=\"-\",NOT(ISBLANK(G197))),1,\n  IF(AND(ISBLANK(C197),ISBLANK(H197)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C197)),H197<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3.1","Pompe aérienne","pièce",950,null,{"$f":" F197*G197","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C198)),AND(H198 <> 0,H198<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C198)),H198=\"-\",NOT(ISBLANK(G198))),1,\n  IF(AND(ISBLANK(C198),ISBLANK(H198)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C198)),H198<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3.2","Séparateur d'hydrocarbures","pièce",1100,null,{"$f":" F198*G198","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C199)),AND(H199 <> 0,H199<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C199)),H199=\"-\",NOT(ISBLANK(G199))),1,\n  IF(AND(ISBLANK(C199),ISBLANK(H199)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C199)),H199<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3.3","Installation de stripping (incl. 1ère charge charbon actif)","pièce",4700,null,{"$f":" F199*G199","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C200)),AND(H200 <> 0,H200<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C200)),H200=\"-\",NOT(ISBLANK(G200))),1,\n  IF(AND(ISBLANK(C200),ISBLANK(H200)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C200)),H200<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3.4","Installation de déferrisation (filtre à sable à rinçage automatique)","pièce",3800,null,{"$f":" F200*G200","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C201)),AND(H201 <> 0,H201<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C201)),H201=\"-\",NOT(ISBLANK(G201))),1,\n  IF(AND(ISBLANK(C201),ISBLANK(H201)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C201)),H201<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.3.5","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",5800,null,{"$f":" F201*G201","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C202)),AND(H202 <> 0,H202<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C202)),H202=\"-\",NOT(ISBLANK(G202))),1,\n  IF(AND(ISBLANK(C202),ISBLANK(H202)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C202)),H202<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4","Installation jusqu'à 20 m³/h",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C203)),AND(H203 <> 0,H203<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C203)),H203=\"-\",NOT(ISBLANK(G203))),1,\n  IF(AND(ISBLANK(C203),ISBLANK(H203)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C203)),H203<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4.1","Pompe aérienne","pièce",1050,null,{"$f":" F203*G203","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C204)),AND(H204 <> 0,H204<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C204)),H204=\"-\",NOT(ISBLANK(G204))),1,\n  IF(AND(ISBLANK(C204),ISBLANK(H204)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C204)),H204<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4.2","Séparateur d'hydrocarbures","pièce",1250,null,{"$f":" F204*G204","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C205)),AND(H205 <> 0,H205<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C205)),H205=\"-\",NOT(ISBLANK(G205))),1,\n  IF(AND(ISBLANK(C205),ISBLANK(H205)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C205)),H205<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4.3","Installation de stripping (incl. 1ère charge charbon actif)","pièce",7500,null,{"$f":" F205*G205","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C206)),AND(H206 <> 0,H206<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C206)),H206=\"-\",NOT(ISBLANK(G206))),1,\n  IF(AND(ISBLANK(C206),ISBLANK(H206)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C206)),H206<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4.4","Installation de déferrisation (filtre à sable à rinçage automatique)","pièce",5700,null,{"$f":" F206*G206","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C207)),AND(H207 <> 0,H207<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C207)),H207=\"-\",NOT(ISBLANK(G207))),1,\n  IF(AND(ISBLANK(C207),ISBLANK(H207)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C207)),H207<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.4.5","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",10650,null,{"$f":" F207*G207","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C208)),AND(H208 <> 0,H208<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C208)),H208=\"-\",NOT(ISBLANK(G208))),1,\n  IF(AND(ISBLANK(C208),ISBLANK(H208)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C208)),H208<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5","Installation jusqu'à 40 m³/h",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C209)),AND(H209 <> 0,H209<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C209)),H209=\"-\",NOT(ISBLANK(G209))),1,\n  IF(AND(ISBLANK(C209),ISBLANK(H209)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C209)),H209<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5.1","Pompe aérienne","pièce",1230,null,{"$f":" F209*G209","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C210)),AND(H210 <> 0,H210<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C210)),H210=\"-\",NOT(ISBLANK(G210))),1,\n  IF(AND(ISBLANK(C210),ISBLANK(H210)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C210)),H210<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5.2","Séparateur d'hydrocarbures","pièce",1450,null,{"$f":" F210*G210","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C211)),AND(H211 <> 0,H211<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C211)),H211=\"-\",NOT(ISBLANK(G211))),1,\n  IF(AND(ISBLANK(C211),ISBLANK(H211)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C211)),H211<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5.3","Installation de stripping (incl. 1ère charge charbon actif)","pièce",13450,null,{"$f":" F211*G211","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C212)),AND(H212 <> 0,H212<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C212)),H212=\"-\",NOT(ISBLANK(G212))),1,\n  IF(AND(ISBLANK(C212),ISBLANK(H212)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C212)),H212<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5.4","Installation de déferrisation (filtre à sable à rinçage automatique)","pièce",7750,null,{"$f":" F212*G212","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C213)),AND(H213 <> 0,H213<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C213)),H213=\"-\",NOT(ISBLANK(G213))),1,\n  IF(AND(ISBLANK(C213),ISBLANK(H213)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C213)),H213<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.1.5.5","Filtre à charbon actif (eau) (incl 1ère charge charbon actif)","pièce",20150,null,{"$f":" F213*G213","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C214)),AND(H214 <> 0,H214<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C214)),H214=\"-\",NOT(ISBLANK(G214))),1,\n  IF(AND(ISBLANK(C214),ISBLANK(H214)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C214)),H214<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2","Location + utilisation",null,{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C215)),AND(H215 <> 0,H215<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C215)),H215=\"-\",NOT(ISBLANK(G215))),1,\n  IF(AND(ISBLANK(C215),ISBLANK(H215)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C215)),H215<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.1","Pompes immergées","pièce",800]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C216)),AND(H216 <> 0,H216<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C216)),H216=\"-\",NOT(ISBLANK(G216))),1,\n  IF(AND(ISBLANK(C216),ISBLANK(H216)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C216)),H216<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.1.1","Pompes immergées","semaine",47,null,{"$f":" F216*G216","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C217)),AND(H217 <> 0,H217<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C217)),H217=\"-\",NOT(ISBLANK(G217))),1,\n  IF(AND(ISBLANK(C217),ISBLANK(H217)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C217)),H217<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2","Installation jusqu'à 5 m³/h","semaine",{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C218)),AND(H218 <> 0,H218<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C218)),H218=\"-\",NOT(ISBLANK(G218))),1,\n  IF(AND(ISBLANK(C218),ISBLANK(H218)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C218)),H218<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2.1","Pompe aérienne","semaine",80,null,{"$f":" F218*G218","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C219)),AND(H219 <> 0,H219<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C219)),H219=\"-\",NOT(ISBLANK(G219))),1,\n  IF(AND(ISBLANK(C219),ISBLANK(H219)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C219)),H219<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2.2","Séparateur d'hydrocarbures","semaine",65,null,{"$f":" F219*G219","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C220)),AND(H220 <> 0,H220<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C220)),H220=\"-\",NOT(ISBLANK(G220))),1,\n  IF(AND(ISBLANK(C220),ISBLANK(H220)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C220)),H220<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2.3","Installation de stripping (incl. filtre charbon actif air)","semaine",260,null,{"$f":" F220*G220","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C221)),AND(H221 <> 0,H221<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C221)),H221=\"-\",NOT(ISBLANK(G221))),1,\n  IF(AND(ISBLANK(C221),ISBLANK(H221)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C221)),H221<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2.4","Installation de déferrisation (filtre à sable à rinçage automatique)","semaine",340,null,{"$f":" F221*G221","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C222)),AND(H222 <> 0,H222<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C222)),H222=\"-\",NOT(ISBLANK(G222))),1,\n  IF(AND(ISBLANK(C222),ISBLANK(H222)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C222)),H222<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.2.5","Filtre à charbon actif (eau)","semaine",85,null,{"$f":" F222*G222","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C223)),AND(H223 <> 0,H223<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C223)),H223=\"-\",NOT(ISBLANK(G223))),1,\n  IF(AND(ISBLANK(C223),ISBLANK(H223)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C223)),H223<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3","Installation jusqu'à 10 m³/h","semaine",{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C224)),AND(H224 <> 0,H224<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C224)),H224=\"-\",NOT(ISBLANK(G224))),1,\n  IF(AND(ISBLANK(C224),ISBLANK(H224)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C224)),H224<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3.1","Pompe aérienne","semaine",95,null,{"$f":" F224*G224","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C225)),AND(H225 <> 0,H225<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C225)),H225=\"-\",NOT(ISBLANK(G225))),1,\n  IF(AND(ISBLANK(C225),ISBLANK(H225)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C225)),H225<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3.2","Séparateur d'hydrocarbures","semaine",75,null,{"$f":" F225*G225","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C226)),AND(H226 <> 0,H226<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C226)),H226=\"-\",NOT(ISBLANK(G226))),1,\n  IF(AND(ISBLANK(C226),ISBLANK(H226)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C226)),H226<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3.3","Installation de stripping (incl. filtre charbon actif air)","semaine",335,null,{"$f":" F226*G226","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C227)),AND(H227 <> 0,H227<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C227)),H227=\"-\",NOT(ISBLANK(G227))),1,\n  IF(AND(ISBLANK(C227),ISBLANK(H227)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C227)),H227<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3.4","Installation de déferrisation (filtre à sable à rinçage automatique)","semaine",435,null,{"$f":" F227*G227","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C228)),AND(H228 <> 0,H228<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C228)),H228=\"-\",NOT(ISBLANK(G228))),1,\n  IF(AND(ISBLANK(C228),ISBLANK(H228)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C228)),H228<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.3.5","Filtre à charbon actif (eau)","semaine",125,null,{"$f":" F228*G228","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C229)),AND(H229 <> 0,H229<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C229)),H229=\"-\",NOT(ISBLANK(G229))),1,\n  IF(AND(ISBLANK(C229),ISBLANK(H229)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C229)),H229<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4","Installation jusqu'à 20 m³/h","semaine",{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C230)),AND(H230 <> 0,H230<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C230)),H230=\"-\",NOT(ISBLANK(G230))),1,\n  IF(AND(ISBLANK(C230),ISBLANK(H230)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C230)),H230<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4.1","Pompe aérienne","semaine",135,null,{"$f":" F230*G230","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C231)),AND(H231 <> 0,H231<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C231)),H231=\"-\",NOT(ISBLANK(G231))),1,\n  IF(AND(ISBLANK(C231),ISBLANK(H231)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C231)),H231<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4.2","Séparateur d'hydrocarbures","semaine",95,null,{"$f":" F231*G231","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C232)),AND(H232 <> 0,H232<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C232)),H232=\"-\",NOT(ISBLANK(G232))),1,\n  IF(AND(ISBLANK(C232),ISBLANK(H232)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C232)),H232<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4.3","Installation de stripping (incl. filtre charbon actif air)","semaine",540,null,{"$f":" F232*G232","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C233)),AND(H233 <> 0,H233<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C233)),H233=\"-\",NOT(ISBLANK(G233))),1,\n  IF(AND(ISBLANK(C233),ISBLANK(H233)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C233)),H233<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4.4","Installation de déferrisation (filtre à sable à rinçage automatique)","semaine",630,null,{"$f":" F233*G233","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C234)),AND(H234 <> 0,H234<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C234)),H234=\"-\",NOT(ISBLANK(G234))),1,\n  IF(AND(ISBLANK(C234),ISBLANK(H234)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C234)),H234<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.4.5","Filtre à charbon actif (eau)","semaine",145,null,{"$f":" F234*G234","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C235)),AND(H235 <> 0,H235<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C235)),H235=\"-\",NOT(ISBLANK(G235))),1,\n  IF(AND(ISBLANK(C235),ISBLANK(H235)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C235)),H235<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5","Installation jusqu'à 40 m³/h","semaine",{"$f":"(#REF!*#REF!)+#REF!","v":{"$error":"#REF!"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C236)),AND(H236 <> 0,H236<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C236)),H236=\"-\",NOT(ISBLANK(G236))),1,\n  IF(AND(ISBLANK(C236),ISBLANK(H236)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C236)),H236<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.1","Pompe aérienne","semaine",200,null,{"$f":" F236*G236","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C237)),AND(H237 <> 0,H237<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C237)),H237=\"-\",NOT(ISBLANK(G237))),1,\n  IF(AND(ISBLANK(C237),ISBLANK(H237)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C237)),H237<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.2","Séparateur d'hydrocarbures","semaine",160,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C238)),AND(H238 <> 0,H238<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C238)),H238=\"-\",NOT(ISBLANK(G238))),1,\n  IF(AND(ISBLANK(C238),ISBLANK(H238)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C238)),H238<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.3","Installation de stripping (incl. filtre charbon actif air)","semaine",830,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C239)),AND(H239 <> 0,H239<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C239)),H239=\"-\",NOT(ISBLANK(G239))),1,\n  IF(AND(ISBLANK(C239),ISBLANK(H239)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C239)),H239<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.4","Installation de déferrisation (filtre à sable à rinçage automatique)","semaine",900,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C240)),AND(H240 <> 0,H240<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C240)),H240=\"-\",NOT(ISBLANK(G240))),1,\n  IF(AND(ISBLANK(C240),ISBLANK(H240)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C240)),H240<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.5","Filtre à charbon actif (eau)","semaine",200,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C241)),AND(H241 <> 0,H241<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C241)),H241=\"-\",NOT(ISBLANK(G241))),1,\n  IF(AND(ISBLANK(C241),ISBLANK(H241)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C241)),H241<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"4.3.2.5.6","Remplacement charbon actif","kg",4,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C242)),AND(H242 <> 0,H242<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C242)),H242=\"-\",NOT(ISBLANK(G242))),1,\n  IF(AND(ISBLANK(C242),ISBLANK(H242)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C242)),H242<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,5,"Autres"]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C243)),AND(H243 <> 0,H243<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C243)),H243=\"-\",NOT(ISBLANK(G243))),1,\n  IF(AND(ISBLANK(C243),ISBLANK(H243)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C243)),H243<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"F243*G243","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C244)),AND(H244 <> 0,H244<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C244)),H244=\"-\",NOT(ISBLANK(G244))),1,\n  IF(AND(ISBLANK(C244),ISBLANK(H244)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C244)),H244<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"F244*G244","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C245)),AND(H245 <> 0,H245<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C245)),H245=\"-\",NOT(ISBLANK(G245))),1,\n  IF(AND(ISBLANK(C245),ISBLANK(H245)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C245)),H245<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C246)),AND(H246 <> 0,H246<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C246)),H246=\"-\",NOT(ISBLANK(G246))),1,\n  IF(AND(ISBLANK(C246),ISBLANK(H246)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C246)),H246<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C247)),AND(H247 <> 0,H247<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C247)),H247=\"-\",NOT(ISBLANK(G247))),1,\n  IF(AND(ISBLANK(C247),ISBLANK(H247)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C247)),H247<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,null,null,null,null,null,0]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C248)),AND(H248 <> 0,H248<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C248)),H248=\"-\",NOT(ISBLANK(G248))),1,\n  IF(AND(ISBLANK(C248),ISBLANK(H248)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C248)),H248<>0),1,0),0\n)))","v":{"$error":"#NAME?"}}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C249)),AND(H249 <> 0,H249<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C249)),H249=\"-\",NOT(ISBLANK(G249))),1,\n  IF(AND(ISBLANK(C249),ISBLANK(H249)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C249)),H249<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"TOTAL (€ HTVA)",null,null,null,null,{"$f":"SUM(H11:H18)+SUM(H23)+SUM(H25:H26)+SUM(H28:H29)+SUM(H31:H33)+SUM(H35:H39)+SUM(H43:H50)+SUM(H52:H58)+SUM(H60:H62)+SUM(H64:H69)+SUM(H72:H73)+SUM(H75:H76)+SUM(H78:H79)+SUM(H81:H82)+SUM(H84:H85)+SUM(H87:H88)+SUM(H90:H91)+SUM(H95:H98)+SUM(H100:H103)+SUM(H105:H108)+SUM(H111:H114)+SUM(H116:H119)+SUM(H121:H124)+SUM(H126)+SUM(H128:H129)+SUM(H131:H132)+SUM(H134:H136)+SUM(H138:H142)+SUM(H144:H146)+SUM(H148:H150)+SUM(H153:H156)+SUM(H158:H160)+SUM(H162:H163)+SUM(H165:H168)+SUM(H171:H172)+SUM(H175:H179)+SUM(H181:H185)+SUM(H189)+SUM(H191:H195)+SUM(H197:H201)+SUM(H203:H207)+SUM(H209:H213)+SUM(H216)+SUM(H218:H222)+SUM(H224:H228)+SUM(H230:H234)+SUM(H236:H241)+SUM(H243:H247)","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C250)),AND(H250 <> 0,H250<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C250)),H250=\"-\",NOT(ISBLANK(G250))),1,\n  IF(AND(ISBLANK(C250),ISBLANK(H250)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C250)),H250<>0),1,0),0\n)))","v":{"$error":"#NAME?"}},null,"TOTAL avec 15 % de sécurité (€ HTVA)",null,null,null,null,{"$f":"H249*1.15","v":0}]
[{"$f":"IF(AND(BackgroundColor<>0,BackgroundColor<>15),1,\nIF(BackgroundColor=0,\n  IF(AND(NOT(ISBLANK(C251)),AND(H251 <> 0,H251<>\"-\")),1,\n  IF(AND(NOT(ISBLANK(C251)),H251=\"-\",NOT(ISBLANK(G251))),1,\n  IF(AND(ISBLANK(C251),ISBLANK(H251)),1,0))),\nIF(BackgroundColor=15,\nIF(AND(NOT(ISBLANK(C251)),H251<>0),1,0),0\n)))","v":{"$error":"#NAME?"}}]