{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["0. Contexte","1. Géométrie","2. Fouille principale","3. Services","4. Plan financier - Décompte","5. Synthèse","Listes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1677,"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":"0. Contexte","index":0,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[21,5,21,6],[27,5,27,6],[29,5,29,6],[31,12,39,12],[41,5,41,6],[41,12,47,12]]}
[]
[null,null,null,null,null,null,"FichierTypeFIA"]
[]
[]
[]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[]
[null,"Contexte"]
[]
[null,"A. ","INFORMATIONS GENERALES",null,null,null,null,null,"B. ","NATURE DES TRAVAUX"]
[]
[]
[null,null,"1. ","Commune(s)",null,null,null,null,null,"1.","Statut des équipements"]
[]
[null,null,null,null,"Pilote :"," -",null,null,null,null,null,"Réseau :"," -"]
[]
[null,null,null,null,"Partenaire 1 :"," -",null,null,null,"2.","Type de travaux"]
[]
[null,null,null,null,"Partenaire 2 :"," -",null,null,null,null,null,"Type 1 :"," -"]
[]
[null,null,"2. ","Nom usuel du chantier",null,null,null,null,null,null,null,"Type 2 :"," -"]
[]
[null,null,"3. ","Procédure",null,"PLAN FINANCIER",null,null,null,null,null,"Type 3 :"," -"]
[]
[null,null,"4. ","Dossier d'autorisation de construire",null,null,null,null,null,"3.","Contexte d'intervention"]
[]
[null,null,"5. ","Bureau d'ingénieurs",null,null,null,null,null,null,null,"Milieu :"," -"]
[]
[null,null,"6. ","Entreprise(s) adjudicatrice(s)",null,null,null,null,null,"4.","Remarque(s)"]
[]
[null,null,"7. ",{"$f":"IF(TypeDossier=\"PLAN FINANCIER\",\"Planning de réalisation\",\"Date de réalisation\")","v":"Planning de réalisation"},null,null,null,null,null,null,null,"Remarque 1 :","-"]
[]
[null,null,null,null,"Année de début :"]
[]
[null,null,null,null,"Année de fin :"]
[]
[null,null,"8. ","Outil de planification / Etude spécifique"]
[]
[null,null,null,null,"Type :"," -"]
[]
[null,null,null,null,"Description :",null,null,null,null,null,null,"Remarque 2 :","-"]

{"sheet":"1. Géométrie","index":1,"n_rows":336,"n_cols":21,"rows_kept":336,"cut":false,"hidden":false,"merged":[[197,10,197,11],[235,8,235,9],[235,6,235,7],[12,6,12,7],[12,4,12,5],[140,8,140,9],[197,6,197,7],[198,8,198,9]]}
["               "]
["                     "]
["                    "]
[]
[]
[]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[null,{"$f":"IF(TypeDossier=\"PLAN FINANCIER\",\"Géométrie du projet d'équipement - Projet d'ouvrage\",\"Géométrie du projet d'équipement - Plans conformes \")","v":"Géométrie du projet d'équipement - Projet d'ouvrage"}]
[1," EQUIPEMENTS PUBLICS D'ASSAINISSEMENT"]
[null,1.1000000000000001," NOUVEAUX SYSTÈMES DE COLLECTE"]
[null,null,"1.1.1","Caractéristiques des tronçons de canalisation"]
[null,null,null,"Tronçon","Chambre amont",null,"Chambre aval",null,"Tronçon",null,null,null,null,null,"Milieu"]
[null,null,null,"Identifiant","Identifiant","Profondeur ","Identifiant","Profondeur ","Linéaire","Configuration","Contenu","Diamètre","Matériaux","Profil ","Sous chaussée",null,"Champ / Forêt","Autre milieu"]
[null,null,null,null,null,null,null,null,null,"de la fouille",null,null,null,"SIA 190","Enrobés","Epaisseur ","Epaisseur terre végétale","Type","Epaisseur "]
[null,null,null,null,null,"[m]",null,"[m]","[m]","[-]","[-]","[mm]","[-]","[-]","[-]","[cm]","[cm]","[-]","[cm]"]
[null,null,1,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,2,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,3,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,4,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,5,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,6,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,7,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,8,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,9,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,10,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,11,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,12,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,13,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,14,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,15,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,16,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,17,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,18,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,19,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,20,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,21,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,22,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,23,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,24,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,25,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,26,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,27,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,28,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,29,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,30,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,31,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,32,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,33,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,34,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,35,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,36,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,37,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,38,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,39,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[null,null,40,null,null,0,null,0,0," -"," -"," -"," -"," -"," -",0,0," -",0]
[]
[null,null,"1.1.2","Excavation et blindage"]
[null,null,1,"Part d'excavation à la main",null,null,null,0,"%","PVCreuseMain"]
[null,null,2,"Part des déblais mis en dépôt et réutilisés sur place en %",null,null,null,0,"%","PartDeblaisReutilises"]
[null,null,3,"Part du blindage type Krings ou similaires",null,null,null,0,"%","PartBlindageApresExcav"]
[null,null,4,"Part du blindage foncé",null,null,null,0,"%","PartBlindageAvancement"]
[null,null,null,"Type de soutènement",null,null,null,null,null,"TypePalplanches"]
[]
[null,null,"1.1.3","Démolition des équipements préexistants, y compris les services"]
[null,null,null,"Collecteurs",null,"Regards",null,"Tuyaux / tubes"]
[null,null,null,"Diamètre","Linéaire","Diamètre","Quantité","Type","Linéaire"]
[null,null,null,null,"[m]",null,"[pc]",null,"[m]"]
[null,null,1," -",0," -",0," -",0,"Tbl_DemolEquipExistants"]
[null,null,2," -",0," -",0," -",0]
[null,null,3," -",0," -",0," -",0]
[null,null,4," -",0," -",0," -",0]
[null,null,5," -",0," -",0," -",0]
[null,null,6," -",0," -",0," -",0]
[null,null,7," -",0," -",0," -",0]
[null,null,8," -",0," -",0," -",0]
[null,null,9," -",0," -",0," -",0]
[null,null,10," -",0," -",0," -",0]
[null,null,11," -",0," -",0," -",0]
[null,null,12," -",0," -",0," -",0]
[null,null,13," -",0," -",0," -",0]
[null,null,14," -",0," -",0," -",0]
[null,null,15," -",0," -",0," -",0]
[null,null,16," -",0," -",0," -",0]
[null,null,17," -",0," -",0," -",0]
[null,null,18," -",0," -",0," -",0]
[null,null,19," -",0," -",0," -",0]
[null,null,20," -",0," -",0," -",0]
[]
[null,null,"1.1.4","Encombrement de réseaux préexistants, y compris services"]
[null,null,null,"Type","Linéaire"]
[null,null,null,null,"[m]"]
[null,null,1," -",0,"Tbl_EncombReseauExistants"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]
[null,null,6," -",0]
[null,null,7," -",0]
[null,null,8," -",0]
[null,null,9," -",0]
[null,null,10," -",0]
[]
[null,1.2,"REGARDS DE VISITE, DEVERSOIRS, TROP PLEINS"]
[null,null,"1.2.1"," Regards de visite"]
[null,null,null,"Nouveaux regards"]
[null,null,null,"Type","Profondeur","Quantité"]
[null,null,null,null,"[m]","[pc]"]
[null,null,1," -"," -",0,"Tbl_ChambresVisite"]
[null,null,2," -"," -",0]
[null,null,3," -"," -",0]
[null,null,4," -"," -",0]
[null,null,5," -"," -",0]
[null,null,6," -"," -",0]
[null,null,7," -"," -",0]
[null,null,8," -"," -",0]
[null,null,9," -"," -",0]
[null,null,10," -"," -",0]
[null,null,11," -"," -",0]
[null,null,12," -"," -",0]
[null,null,13," -"," -",0]
[null,null,14," -"," -",0]
[null,null,15," -"," -",0]
[null,null,16," -"," -",0]
[null,null,17," -"," -",0]
[null,null,18," -"," -",0]
[null,null,19," -"," -",0]
[null,null,20," -"," -",0]
[]
[null,null,"1.2.2","Déversoirs, trop pleins"]
[null,null,null,"Nouveaux déversoirs, trop pleins"]
[null,null,null,"Type d'ouvrage","Profondeur","Quantité"]
[null,null,null,null,"[m]","[pc]"]
[null,null,1," -"," -",0,"Tbl_Deversoirs"]
[null,null,2," -"," -",0]
[null,null,3," -"," -",0]
[null,null,4," -"," -",0]
[null,null,5," -"," -",0]
[]
[null,null,"1.2.3","Adaptation des regards, y compris les services"]
[null,null,null,"Diamètre","Rehaussement",null,"Abaissement",null,"Adaptation du fonds"]
[null,null,null,null,"Quantité","Hauteur","Quantité","Hauteur","Quantité","Type"]
[null,null,null,null,"[pc]","[m]","[pc]","[m]","[pc]","[-]"]
[null,null,1," -",0,0,0,0,0," -","Tbl_AdaptationRegards"]
[null,null,2," -",0,0,0,0,0," -"]
[null,null,3," -",0,0,0,0,0," -"]
[null,null,4," -",0,0,0,0,0," -"]
[null,null,5," -",0,0,0,0,0," -"]
[null,null,6," -",0,0,0,0,0," -"]
[null,null,7," -",0,0,0,0,0," -"]
[null,null,8," -",0,0,0,0,0," -"]
[null,null,9," -",0,0,0,0,0," -"]
[null,null,10," -",0,0,0,0,0," -"]
[]
[null,1.3,"MISE HORS SERVICE D'ÉQUIPEMENTS EXISTANTS"]
[null,null,"1.3.1","Remplissage de canalisations"]
[null,null,null,"Canalisations"]
[null,null,null,"Diamètre","Longueur"]
[null,null,null,null,"[m]"]
[null,null,1," -",0,"Tbl_RemplissageCanalisations"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]
[]
[null,null,"1.3.2","Remplissage de regards"]
[null,null,null,"Regards"]
[null,null,null,"Type","Hauteur"]
[null,null,null,null,"[m]"]
[null,null,1," -",0,"Tbl_RemplissageRegards"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]
[]
[2,"OUVRAGES SPECIFIQUES"]
[null,null,"2.1"," Bassin de rétention, noues, fossés, stations de pompage, ouvrages hydrauliques"]
[null,null,null,"Type","Longueur brute","Largeur brute","Hauteur brute","Descirption"]
[null,null,null,null,"[m]","[m]","[m]"]
[null,null,1,null,0,0,0,null,"Tbl_OuvragesSpecifiques"]
[null,null,2,null,0,0,0]
[null,null,3,null,0,0,0]
[null,null,4,null,0,0,0]
[null,null,5,null,0,0,0]
[null,null,6,null,0,0,0]
[null,null,7,null,0,0,0]
[null,null,8,null,0,0,0]
[null,null,9,null,0,0,0]
[null,null,10,null,0,0,0]
[null,null,11,null,0,0,0]
[null,null,12,null,0,0,0]
[null,null,13,null,0,0,0]
[null,null,14,null,0,0,0]
[null,null,15,null,0,0,0]
[]
[3,"RÉHABILITATION DES CANALISATIONS EXISTANTES"]
[null,"3.1","Réhabilitation par chemisage"]
[null,null,null,"Tronçon","Chambre amont","Chambre aval","Gaine polymérisée"]
[null,null,null,null,null,null,"Canalisation",null,"Raccords aux regards"]
[null,null,null,null,null,null,null,null,"Publics","Privés"]
[null,null,null,null,null,null,"Diamètre","Linéaire","Quantité","Quantité"]
[null,null,null,"[identifiant]","[identifiant]","[identifiant]",null,"[m]","[pc]","[pc]"]
[null,null,1,null,null,null," -",0,0,0,"Tbl_RehabilitationChemisage"]
[null,null,2,null,null,null," -",0,0,0]
[null,null,3,null,null,null," -",0,0,0]
[null,null,4,null,null,null," -",0,0,0]
[null,null,5,null,null,null," -",0,0,0]
[null,null,6,null,null,null," -",0,0,0]
[null,null,7,null,null,null," -",0,0,0]
[null,null,8,null,null,null," -",0,0,0]
[null,null,9,null,null,null," -",0,0,0]
[null,null,10,null,null,null," -",0,0,0]
[null,null,11,null,null,null," -",0,0,0]
[null,null,12,null,null,null," -",0,0,0]
[null,null,13,null,null,null," -",0,0,0]
[null,null,14,null,null,null," -",0,0,0]
[null,null,15,null,null,null," -",0,0,0]
[null,null,16,null,null,null," -",0,0,0]
[null,null,17,null,null,null," -",0,0,0]
[null,null,18,null,null,null," -",0,0,0]
[null,null,19,null,null,null," -",0,0,0]
[null,null,20,null,null,null," -",0,0,0]
[null,null,21,null,null,null," -",0,0,0]
[null,null,22,null,null,null," -",0,0,0]
[null,null,23,null,null,null," -",0,0,0]
[null,null,24,null,null,null," -",0,0,0]
[null,null,25,null,null,null," -",0,0,0]
[null,null,26,null,null,null," -",0,0,0]
[null,null,27,null,null,null," -",0,0,0]
[null,null,28,null,null,null," -",0,0,0]
[null,null,29,null,null,null," -",0,0,0]
[null,null,30,null,null,null," -",0,0,0]
[]
[null,"3.2","Réhabilitation par robotique"]
[null,null,null,"Tronçon","Chambre amont","Chambre aval","Réhabilitation par robotique"]
[null,null,null,null,null,null,"Canalisation principale",null,"Raccords privés"]
[null,null,null,null,null,null,"Type","Longueur","Type","Quantité"]
[null,null,null,"[identifiant]","[identifiant]","[identifiant]",null,"[m]",null,"[pc]"]
[null,null,1,null,null,null,null,0,null,0,"Tbl_RehabilitationRobotique"]
[null,null,2,null,null,null,null,0,null,0]
[null,null,3,null,null,null,null,0,null,0]
[null,null,4,null,null,null,null,0,null,0]
[null,null,5,null,null,null,null,0,null,0]
[null,null,6,null,null,null,null,0,null,0]
[null,null,7,null,null,null,null,0,null,0]
[null,null,8,null,null,null,null,0,null,0]
[null,null,9,null,null,null,null,0,null,0]
[null,null,10,null,null,null,null,0,null,0]
[null,null,11,null,null,null,null,0,null,0]
[null,null,12,null,null,null,null,0,null,0]
[null,null,13,null,null,null,null,0,null,0]
[null,null,14,null,null,null,null,0,null,0]
[null,null,15,null,null,null,null,0,null,0]
[null,null,16,null,null,null,null,0,null,0]
[null,null,17,null,null,null,null,0,null,0]
[null,null,18,null,null,null,null,0,null,0]
[null,null,19,null,null,null,null,0,null,0]
[null,null,20,null,null,null,null,0,null,0]
[null,null,21,null,null,null,null,0,null,0]
[null,null,22,null,null,null,null,0,null,0]
[null,null,23,null,null,null,null,0,null,0]
[null,null,24,null,null,null,null,0,null,0]
[null,null,25,null,null,null,null,0,null,0]
[null,null,26,null,null,null,null,0,null,0]
[null,null,27,null,null,null,null,0,null,0]
[null,null,28,null,null,null,null,0,null,0]
[null,null,29,null,null,null,null,0,null,0]
[null,null,30,null,null,null,null,0,null,0]
[]
[4,"TRAVAUX SPÉCIAUX"]
[null,"4.1","Travaux spéciaux"]
[null,null,null,"Tronçon","Chambre amont",null,"Chambre aval",null,"Linéaire","Configuration ","Technique","Contenu","Diamètre","Matériaux","Cellule amont",null,null,"Cellule aval"]
[null,null,null,null,"Descritption","Profondeur","Descritption","Profondeur",null,null,null,null,null,null,"Longueur","Largeur","Profondeur ","Longueur","Largeur","Profondeur"]
[null,null,null,"[identifiant]","[identifiant]","[m]","[identifiant]","[m]","[m]",null,null,null,null,null,"[m]","[m]","[m]","[m]","[m]","[m]"]
[null,null,1,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0,"Tbl_TravauxSpeciaux"]
[null,null,2,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,3,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,4,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,5,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,6,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,7,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,8,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,9,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[null,null,10,null,null,0,null,0,0," -"," -"," -"," -"," -",0,0,0,0,0,0]
[]
[5,"SERVICES MIS EN PÉRIL PAR LE CHANTIER D'ASSAINISSEMENT "]
[null,"5.1","Services situés hors emprise de la fouille"]
[null,null,"5.1.1","Nouveaux services"]
[null,null,null,"Tronçon","Profondeur","Linéaire","Milieu","Largeur fouille","Enrobés bitumineux",null,"Enrobage",null,"Champ / forêt","Autre couverture",null,"Services"]
[null,null,null,null,null,null,null,null,"Enrobés Type","Epaisseur","Type","Hauteur encombrement","Epaisseur terre végétale","Type","Epaisseur","Type(s) / Diam (mm)"]
[null,null,null,"[identifiant]","[m]","[m]","[-]","[m]",null,"[cm]",null,"[m]","[cm]","[-]","[cm]"]
[null,null,1,null,0,0," -",0,"-",0," -",0,0," -",0,null,"Tbl_ServicesHorsEmprise"]
[null,null,2,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,3,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,4,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,5,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,6,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,7,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,8,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,9,null,0,0," -",0,"-",0," -",0,0," -",0]
[null,null,10,null,0,0," -",0,"-",0," -",0,0," -",0]
[]
[null,"5.2","Chambres, socles et butées"]
[null,null,"5.2.1","Nouvelles chambres dédiées aux services"]
[null,null,null,"Diamètre","Quantité"]
[null,null,null,"[mm]","[pc]"]
[null,null,1," -",0,"Tbl_ChambresServices"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]
[]
[null,null,"5.2.2","Socles et butées"]
[null,null,null,"Type","Quantité"]
[null,null,null,null,"[pc]"]
[null,null,1,"Socles",0,"Tbl_SoclesButees"]
[null,null,2,"Butées",0]
[]
[null,"5.3","Mise hors service d'équipements existants"]
[null,null,"5.3.1","Canalisations"]
[null,null,null,"Diamètre","Longueur"]
[null,null,null,"[mm]","[m]"]
[null,null,1," -",0,"Tbl_MiseHorsServicesEquipCanalo"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]
[]
[null,null,"5.3.2","Regards"]
[null,null,null,"Type","Hauteur"]
[null,null,null,null,"[m]"]
[null,null,1," -",0,"Tbl_MiseHorsServicesEquipRegards"]
[null,null,2," -",0]
[null,null,3," -",0]
[null,null,4," -",0]
[null,null,5," -",0]

{"sheet":"2. Fouille principale","index":2,"n_rows":473,"n_cols":15,"rows_kept":473,"cut":false,"hidden":false,"merged":[[9,7,9,8],[9,11,9,12]]}
[null,"               "]
[null,"                     "]
[null,"                    "]
[]
[]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[null,"Fouille principale"]
[]
[null,null,"Libellé","Caractéristiques",null,"Unité",null,"Quantité",null,"Prix unitaire\nfr HT",null,"Montant\nfr HT",null,null,"Remarque / Commentaire"]
[]
[null,"1.1","INSTALLATIONS DE CHANTIER (CAN 113)"]
[]
[null,"1.1.1","INSTALLATIONS DE CHANTIER COMPLÈTES"]
[null,"1","Installations (bloc)"]
[null,"a","Pour la durée des travaux","Part liée aux collecteurs",null,"%",null,0,null,0,null,{"$f":"0.01*H16*J16","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F17=\"%\",0.01*H17*J17,H17*J17)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F18=\"%\",0.01*H18*J18,H18*J18)","v":0}]
[]
[null,"1.1.2","AUTRES POSTES SPÉCIFIQUES"]
[null,"1","Signalisations de chantier"]
[null,"a","Mesures de police selon autorité compétente",null,null,"gl",null,0,null,0,null,{"$f":"H22*J22","v":0}]
[null,"b","Feux de signalisation",null,null,"gl",null,0,null,0,null,{"$f":"H23*J23","v":0}]
[null,"c","Régulation manuelle du trafic (palette)",null,null,"h",null,0,null,0,null,{"$f":"H24*J24","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F25=\"%\",0.01*H25*J25,H25*J25)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F26=\"%\",0.01*H26*J26,H26*J26)","v":0}]
[]
[null,"2","Clôtures de chantier"]
[null,"a","Pour la durée des travaux","Type: (…)",null,"m",null,0,null,0,null,{"$f":"H29*J29","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F30=\"%\",0.01*H30*J30,H30*J30)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F31=\"%\",0.01*H31*J31,H31*J31)","v":0}]
[]
[null,"3","Sondage, analyses, essais"]
[null,"a","Sondages à la pelle",null,null,"m3",null,0,null,0,null,{"$f":"H34*J34","v":0}]
[null,"b","Analyses de laboratoire",null,null,"gl",null,0,null,0,null,{"$f":"H35*J35","v":0}]
[null,"c","Essais de portance ME",null,null,"pc",null,0,null,0,null,{"$f":"H36*J36","v":0}]
[null,"d","Détermination HAP laboratoire",null,null,"pc",null,0,null,0,null,{"$f":"H37*J37","v":0}]
[null,"e","Essais Panda, yc installation",null,null,"pc",null,0,null,0,null,{"$f":"H38*J38","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F39=\"%\",0.01*H39*J39,H39*J39)","v":0}]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F40=\"%\",0.01*H40*J40,H40*J40)","v":0}]
[]
[null,"4","Piste de chantier"]
[null,"a","Pour l'exécution du chantier",null,null,"m2",null,0,null,0,null,{"$f":"H43*J43","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F44=\"%\",0.01*H44*J44,H44*J44)","v":0}]
[]
[null,"5","Passages provisoires sur fouille"]
[null,"a","Passerelles piétons",null,null,"pc",null,0,null,0,null,{"$f":"H47*J47","v":0}]
[null,"b","Ponts légers",null,null,"pc",null,0,null,0,null,{"$f":"H48*J48","v":0}]
[null,"c","Ponts lourds",null,null,"pc",null,0,null,0,null,{"$f":"H49*J49","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F50=\"%\",0.01*H50*J50,H50*J50)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F51=\"%\",0.01*H51*J51,H51*J51)","v":0}]
[]
[null,"6","Déplacements lignes et arrêts des transports en commun"]
[null,"a","Prestations de génie-civil",null,null,"gl",null,0,null,0,null,{"$f":"H54*J54","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F55=\"%\",0.01*H55*J55,H55*J55)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F56=\"%\",0.01*H56*J56,H56*J56)","v":0}]
[]
[null,"7","Revêtements provisoires"]
[null,"a","Tapis froid",null,null,"t",null,0,null,0,null,{"$f":"H59*J59","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F60=\"%\",0.01*H60*J60,H60*J60)","v":0}]
[]
[null,"8","Divers"]
[null,"a","Travaux préliminaire (nettoyage canalisation)",null,null,"gl",null,0,null,0,null,{"$f":"H63*J63","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F64=\"%\",0.01*H64*J64,H64*J64)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F65=\"%\",0.01*H65*J65,H65*J65)","v":0}]
[]
[null,null,"Installations de chantier (CAN 113)",null,null,null,null,null,null,null,null,{"$f":"SUM(L16:L65)","v":0},"fr HT"]
[]
[null,"1.2","DÉMOLITIONS, CANALISATIONS, ÉVACUATION DES EAUX, CHAUSSÉES ET REVÊTEMENTS (CAN 117, 162, 223 ET 237)"]
[]
[null,"1.2.1","TRAVAUX PRÉLIMINAIRES"]
[null,"1","Défrichement et abattage"]
[null,"a","Défrichement,  yc évacuation des résidus","Type: (…)",null,"m",null,0,null,0,null,{"$f":"H73*J73","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F74=\"%\",0.01*H74*J74,H74*J74)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"H75*J75","v":0}]
[]
[null,"2","Dérivation provisoire des eaux et pompages"]
[null,"a","Pour la durée des travaux",null,null,"gl",null,0,null,0,null,{"$f":"H78*J78","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F79=\"%\",0.01*H79*J79,H79*J79)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F80=\"%\",0.01*H80*J80,H80*J80)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F81=\"%\",0.01*H81*J81,H81*J81)","v":0}]
[]
[null,"3","Démolition et démontage des équipements préexistants"]
[null,"a","Regards de visite - Simultanément au terrassement",null,null,"pc",null,0,null,0,null,{"$f":"H84*J84","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F85=\"%\",0.01*H85*J85,H85*J85)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.2.2","DEMOLITION ET DEMONTAGE"]
[null,"1","Enrobés bitumineux (HAP < 5'000 mg/kg)"]
[null,"a","Coupe  en cm","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H93*J93","v":0}]
[null,"b","Démolition et chargement: épaisseur < 15 cm","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,0]
[null,"c","Démolition et chargement: épaisseur < 30 cm","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,0]
[null,"d","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F97=\"%\",0.01*H97*J97,H97*J97)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F98=\"%\",0.01*H98*J98,H98*J98)","v":0}]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"2","PV pour enrobés pollués "]
[null,"a","5'001 < HAP < 20'000 mg/kg",null,null,"m3",null,0,null,0,null,{"$f":"H102*J102","v":0}]
[null,"b","HAP > 20'001 mg/kg",null,null,"m3",null,0,null,0,null,{"$f":"H103*J103","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F104=\"%\",0.01*H104*J104,H104*J104)","v":0}]
[]
[null,"3","Chaussée en béton, armé ou non"]
[null,"a","Coupe","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H107*J107","v":0}]
[null,"b","Démolition et chargement","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,{"$f":"H108*J108","v":0}]
[null,"c","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H109*J109","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F110=\"%\",0.01*H110*J110,H110*J110)","v":0}]
[]
[null,"4","Dallage (trottoirs)"]
[null,"a","Coupe","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H113*J113","v":0}]
[null,"b","Démolition et chargement","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,{"$f":"H114*J114","v":0}]
[null,"c","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H115*J115","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F116=\"%\",0.01*H116*J116,H116*J116)","v":0}]
[]
[null,"5","Démolition / démontage des aménagements de surface et éléments divers (yc évacuation, mise en décharge, nettoyage et stockage)"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F119=\"%\",0.01*H119*J119,H119*J119)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.2.3","TERRASSEMENTS"]
[null,"1","Terre végétale"]
[null,"a","Décapage, yc transport et mise en dépôt","Epaisseur  : (…) cm",null,"m3",null,0,null,0,null,{"$f":"H127*J127","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F128=\"%\",0.01*H128*J128,H128*J128)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F129=\"%\",0.01*H129*J129,H129*J129)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F130=\"%\",0.01*H130*J130,H130*J130)","v":0}]
[]
[null,"2","Excavation de tranchées, yc chargement"]
[null,"a","Excavation à la machine",null,null,"m3",null,0,null,0,null,{"$f":"H133*J133","v":0}]
[null,"b","Excavation à la main",null,null,"m3",null,0,null,0,null,{"$f":"H134*J134","v":0}]
[null,"c","Excavation à l'aspiratrice yc transport à l'intérieur du chantier",null,null,"m3",null,0,null,0,null,{"$f":"H135*J135","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F136=\"%\",0.01*H136*J136,H136*J136)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"3","Matériaux d'excavation"]
[null,"a","Transport en décharge y compris taxes",null,null,"m3",null,0,null,0,null,{"$f":"H142*J142","v":0}]
[null,"b","Mise en dépôt, yc transport",null,null,"m3",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F144=\"%\",0.01*H144*J144,H144*J144)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"4","Blindage (boisage)"]
[null,"a","Boisage","Type: (…)",null,"m2",null,0,null,0,null,{"$f":"H150*J150","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"H151*J151","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F152=\"%\",0.01*H152*J152,H152*J152)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F153=\"%\",0.01*H153*J153,H153*J153)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"5","Blindage (type Krings)"]
[null,"a","Caisson type Krings ou palplanches légères","Type: (…)",null,"m2",null,0,null,0,null,{"$f":"H157*J157","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F158=\"%\",0.01*H158*J158,H158*J158)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F159=\"%\",0.01*H159*J159,H159*J159)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"6","Blindage foncé (yc installations spécifiques, mise en place et extraction)"]
[null,"a","Palplanches foncées","Type: (…)",null,"m2",null,0,null,0,null,{"$f":"H163*J163","v":0}]
[null,"b","PV pour palplanches demeurant dans le sol","Type: (…)",null,"m2",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F165=\"%\",0.01*H165*J165,H165*J165)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F166=\"%\",0.01*H166*J166,H166*J166)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"7","Encombrement et étaiement de réseaux"]
[null,"a","Longitudinal",null,null,"m",null,0,null,0,null,{"$f":"H170*J170","v":0}]
[null,"b","Transversal",null,null,"m",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F172=\"%\",0.01*H172*J172,H172*J172)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F173=\"%\",0.01*H173*J173,H173*J173)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.2.4","SYSTEMES DE CANALISATIONS (fourniture et pose, yc déviations provisoires)"]
[null,"1","Tuyaux (yc manchons et chemise drainante pour les drains)","Matériau"]
[null,"a"," -"," -",null,"m",null,0,null,0,null,{"$f":"H178*J178","v":0}]
[null,"b"," -"," -",null,"m",null,0,null,0,null,0]
[null,"c"," -"," -",null,"m",null,0,null,0,null,0]
[null,"d"," -"," -",null,"m",null,0,null,0,null,0]
[null,"e"," -"," -",null,"m",null,0,null,0,null,0]
[null,"f"," -"," -",null,"m",null,0,null,0,null,0]
[null,"g"," -"," -",null,"m",null,0,null,0,null,0]
[null,"h"," -"," -",null,"m",null,0,null,0,null,0]
[null,"i"," -"," -",null,"m",null,0,null,0,null,0]
[null,"j"," -"," -",null,"m",null,0,null,0,null,0]
[null,"k"," -"," -",null,"m",null,0,null,0,null,0]
[null,"l"," -"," -",null,"m",null,0,null,0,null,0]
[null,"m"," -"," -",null,"m",null,0,null,0,null,0]
[null,"n"," -"," -",null,"m",null,0,null,0,null,0]
[null,"o"," -"," -",null,"m",null,0,null,0,null,0]
[null,"p"," -"," -",null,"m",null,0,null,0,null,0]
[null,"q"," -"," -",null,"m",null,0,null,0,null,0]
[null,"r"," -"," -",null,"m",null,0,null,0,null,0]
[null,"s"," -"," -",null,"m",null,0,null,0,null,0]
[null,"t"," -"," -",null,"m",null,0,null,0,null,0]
[null,"u","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F198=\"%\",0.01*H198*J198,H198*J198)","v":0}]
[null,"v","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F199=\"%\",0.01*H199*J199,H199*J199)","v":0}]
[null,"w","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F200=\"%\",0.01*H200*J200,H200*J200)","v":0}]
[]
[null,"1.2.5","REGARDS DE VISITE (fourniture et pose)"]
[null,"1","Regards (fond, fût et couronnement)","Profondeur"]
[null,"a"," -"," -",null,"pc",null,0,null,0,null,{"$f":"H204*J204","v":0}]
[null,"b"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"c"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"d"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"e"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"f"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"g"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"h"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"i"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"j"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"k"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"l"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"m"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"n"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"o"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"p"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"q"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"r"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"s"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"t"," -"," -",null,"pc",null,0,null,0,null,0]
[null,"u","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F224=\"%\",0.01*H224*J224,H224*J224)","v":0}]
[null,"v","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F225=\"%\",0.01*H225*J225,H225*J225)","v":0}]
[null,"w","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"x","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"y","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"z","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"2","Fonds de regards"]
[null,"a","Traditionnels maçonnés",null,null,"pc",null,0,null,0,null,{"$f":"H232*J232","v":0}]
[null,"b","Préfabriqués PVC",null,null,"pc",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F234=\"%\",0.01*H234*J234,H234*J234)","v":0}]
[null,"d","Préfabriqués PRV",null,null,"pc",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F236=\"%\",0.01*H236*J236,H236*J236)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"3","Couronnement (cadre et tampon)"]
[null,"a","Carrosable D 400",null,null,"pc",null,0,null,0,null,{"$f":"H240*J240","v":0}]
[null,"b","Carrosable C 250",null,null,"pc",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F242=\"%\",0.01*H242*J242,H242*J242)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"4","Adaptation de regards de visite existants"]
[null,"a","Modification fond regard existant",null,null,"pc",null,0,null,0,null,{"$f":"H247*J247","v":0}]
[null,"b","Mise à niveau de regard - Rehaussement",null,null,"pc",null,0,null,0,null,{"$f":"H248*J248","v":0}]
[null,"c","Mise à niveau de regard - Abaissement",null,null,"pc",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F250=\"%\",0.01*H250*J250,H250*J250)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F251=\"%\",0.01*H251*J251,H251*J251)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F252=\"%\",0.01*H252*J252,H252*J252)","v":0}]
[]
[null,"1.2.6","REMBLAYAGE"]
[null,"1","Avec matériaux d'apport (yc fourniture) ou déblais d'excavation (yc reprise du dépôt et mise en œuvre)"]
[null,"a","Grave non traitée","GNT 0/16-0/22-0/45",null,"m3",null,0,null,0,null,{"$f":"H256*J256","v":0}]
[null,"b","Grave recyclée","GNT 0/16-0/22-0/45",null,"m3",null,0,null,0,null,{"$f":"H257*J257","v":0}]
[null,"c","Avec déblai d'excavation (reprise et mise en oeuvre)",null,null,"m3",null,0,null,0,null,{"$f":"H258*J258","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F259=\"%\",0.01*H259*J259,H259*J259)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F260=\"%\",0.01*H260*J260,H260*J260)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.2.7","ENROBAGES"]
[null,"1","Mise en œuvre de matériaux d'enrobage, yc fourniture"]
[null,"a","Gaviers, gravillons",null,null,"m3",null,0,null,0,null,{"$f":"H265*J265","v":0}]
[null,"b","Béton",null,null,"m3",null,0,null,0,null,{"$f":"H266*J266","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F267=\"%\",0.01*H267*J267,H267*J267)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F268=\"%\",0.01*H268*J268,H268*J268)","v":0}]
[]
[null,"1.2.8","REMISE EN ETAT"]
[null,"1","Terre végétale"]
[null,"a","Fourniture de terre végétale, yc amenée à pied d'œuvre",null,null,"m3",null,0,null,0,null,{"$f":"H272*J272","v":0}]
[null,"b","Mise en œuvre de terre végétale, yc ensemencement",null,null,"m2",null,0,null,0,null,{"$f":"H273*J273","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F274=\"%\",0.01*H274*J274,H274*J274)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F275=\"%\",0.01*H275*J275,H275*J275)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F276=\"%\",0.01*H276*J276,H276*J276)","v":0}]
[]
[null,"2","Enrobés bitumineux, fourniture et pose"]
[null,"a","Enrobés bitumineux - Couche de base","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H279*J279","v":0}]
[null,"b","Enrobés bitumineux - Couche de roulement","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H280*J280","v":0}]
[null,"c","Enrobés bitumineux - Phonoabsorbant","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H281*J281","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F282=\"%\",0.01*H282*J282,H282*J282)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F283=\"%\",0.01*H283*J283,H283*J283)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F284=\"%\",0.01*H284*J284,H284*J284)","v":0}]
[]
[null,"3","Chaussée béton, armé ou non, fourniture et pose"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F287=\"%\",0.01*H287*J287,H287*J287)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"4","Dallage (trottoirs)"]
[null,"a","Dalle béton","Epaisseur : (…)",null,"m2",null,0,null,0,null,{"$f":"H293*J293","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F294=\"%\",0.01*H294*J294,H294*J294)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F295=\"%\",0.01*H295*J295,H295*J295)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F296=\"%\",0.01*H296*J296,H296*J296)","v":0}]
[]
[null,"5","Remise en état des aménagements de surface et éléments divers"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F299=\"%\",0.01*H299*J299,H299*J299)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F300=\"%\",0.01*H300*J300,H300*J300)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F301=\"%\",0.01*H301*J301,H301*J301)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F302=\"%\",0.01*H302*J302,H302*J302)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F303=\"%\",0.01*H303*J303,H303*J303)","v":0}]
[]
[null,"1.2.9","RECEPTION"]
[null,"1","Nettoyage et inspection vidéo, yc rapport"]
[null,"a","Curage, inspection vidéo et rapport",null,null,"m",null,0,null,0,null,{"$f":"H307*J307","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"H308*J308","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F309=\"%\",0.01*H309*J309,H309*J309)","v":0}]
[]
[null,"2","Remplissage de canalisations et regards"]
[null,"a","Fourniture et remplissage de béton liquide, canalisations",null,null,"m3",null,0,null,0,null,{"$f":"H312*J312","v":0}]
[null,"b","Fourniture et remplissage de sable / tout-venant, regards",null,null,"pc",null,0,null,0,null,{"$f":"H313*J313","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F314=\"%\",0.01*H314*J314,H314*J314)","v":0}]
[]
[null,null,"Démolitions, canalisations, évacuation des eaux, chaussées et revêtements (CAN 117, 162, 223 et 237)",null,null,null,null,null,null,null,null,{"$f":"SUM(L73:L314)","v":0},"fr HT"]
[]
[null,"1.3","OUVRAGES SPECIFIQUES (Bassin de rétention, noues, fossés, stations de pompage, ouvrages hydrauliques)"]
[]
[null,"1.3.1","INSTALLATIONS DE CHANTIER SPECIFIQUES "]
[null,"1","Installations complètes"]
[null,"a","Pour la durée des travaux",null,null,"%",null,0,null,0,null,{"$f":"H322*0.01*J322","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F323=\"%\",0.01*H323*J323,H323*J323)","v":0}]
[]
[null,"1.3.2","MISE EN OEUVRE"]
[null,"1","Mise en oeuvre"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F327=\"%\",0.01*H327*J327,H327*J327)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F328=\"%\",0.01*H328*J328,H328*J328)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F329=\"%\",0.01*H329*J329,H329*J329)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F330=\"%\",0.01*H330*J330,H330*J330)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"h","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"i","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"j","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"k","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"l","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"m","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"n","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"o","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"p","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"q","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"r","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"s","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"t","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F346=\"%\",0.01*H346*J346,H346*J346)","v":0}]
[]
[null,null,"Bassin de rétention, ouvrages de gestion des eaux, stations de pompage, ouvrages hydrauliques",null,null,null,null,null,null,null,null,{"$f":"SUM(L322:L346)","v":0},"fr HT"]
[]
[null,"1.4","REHABILITATION DE CANALISATION ET GAINAGE (CAN 135)"]
[]
[null,"1.4.1","INSTALLATIONS DE CHANTIER SPECIFIQUES "]
[null,"1","Installations complètes"]
[null,"a","Pour la durée des travaux",null,null,"%",null,0,null,0,null,{"$f":"H354*0.01*J354","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F355=\"%\",0.01*H355*J355,H355*J355)","v":0}]
[]
[null,"2","Epuisement des eaux"]
[null,"a","Dérivation des eaux usées, yc pompage",null,null,"gl",null,0,null,0,null,{"$f":"H358*J358","v":0}]
[null,"b","Dérivation des eaux usées, yc pompage",null,null,"h",null,0,null,0,null,{"$f":"H359*J359","v":0}]
[null,"c","Dérivation des eaux claires, yc pompage",null,null,"gl",null,0,null,0,null,{"$f":"H360*J360","v":0}]
[null,"d","Dérivation des eaux claires, yc pompage",null,null,"h",null,0,null,0,null,{"$f":"H361*J361","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F362=\"%\",0.01*H362*J362,H362*J362)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F363=\"%\",0.01*H363*J363,H363*J363)","v":0}]
[]
[null,"1.4.2","RELEVE DE L'ETAT STRUCTUREL ET ESSAIS"]
[null,"1","Nettoyage et inspection vidéo"]
[null,"a","Curage avant travaux",null,null,"m",null,0,null,0,null,{"$f":"H367*J367","v":0}]
[null,"b","Curage après travaux",null,null,"m",null,0,null,0,null,{"$f":"H368*J368","v":0}]
[null,"c","Caméra",null,null,"m",null,0,null,0,null,{"$f":"H369*J369","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F370=\"%\",0.01*H370*J370,H370*J370)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F371=\"%\",0.01*H371*J371,H371*J371)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F372=\"%\",0.01*H372*J372,H372*J372)","v":0}]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F373=\"%\",0.01*H373*J373,H373*J373)","v":0}]
[]
[null,"2","Calibrage des canalisations"]
[null,"a","Collecteurs",null,null,"m",null,0,null,0,null,{"$f":"IF(F376=\"%\",0.01*H376*J376,H376*J376)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F377=\"%\",0.01*H377*J377,H377*J377)","v":0}]
[]
[null,"1.4.3","TRAVAUX PRELIMINAIRES"]
[null,"1","Fraisage et/ou robotique"]
[null,"a","Sur l'entier de l'équipement",null,null,"h",null,0,null,0,null,{"$f":"H381*J381","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F382=\"%\",0.01*H382*J382,H382*J382)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F383=\"%\",0.01*H383*J383,H383*J383)","v":0}]
[]
[null,"2","Autres interventions préliminaires"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F386=\"%\",0.01*H386*J386,H386*J386)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F387=\"%\",0.01*H387*J387,H387*J387)","v":0}]
[]
[null,"1.4.4","TRAVAUX DE REHABILITATION"]
[null,"1","Par chemisage"]
[null,"a","Gaines polymérisées - Section circulaire","jusqu'à DN 250",null,"m",null,0,null,0,null,{"$f":"H391*J391","v":0}]
[null,"b","Gaines polymérisées - Section circulaire","jusqu'à DN 300",null,"m",null,0,null,0,null,{"$f":"H392*J392","v":0}]
[null,"c","Gaines polymérisées - Section circulaire","jusqu'à DN 400",null,"m",null,0,null,0,null,{"$f":"H393*J393","v":0}]
[null,"d","Gaines polymérisées - Section circulaire","jusqu'à DN 500",null,"m",null,0,null,0,null,0]
[null,"e","Gaines polymérisées - Section circulaire","jusqu'à DN 600",null,"m",null,0,null,0,null,0]
[null,"f","Gaines polymérisées - Section circulaire","jusqu'à DN 700",null,"m",null,0,null,0,null,0]
[null,"g","Gaines polymérisées - Section circulaire","jusqu'à DN 800",null,"m",null,0,null,0,null,0]
[null,"h","Gaines polymérisées - Section circulaire","jusqu'à DN 1000",null,"m",null,0,null,0,null,0]
[null,"i","Gaines polymérisées - Section circulaire","jusqu'à DN 1100",null,"m",null,0,null,0,null,0]
[null,"j","Gaines polymérisées - Section circulaire","jusqu'à DN 1250",null,"m",null,0,null,0,null,0]
[null,"k","Gaines polymérisées - Section ovoïde","jusqu'à 400/600",null,"m",null,0,null,0,null,0]
[null,"l","Gaines polymérisées - Section ovoïde","jusqu'à 800/1200",null,"m",null,0,null,0,null,0]
[null,"m","Gaines polymérisées","Autre",null,"m",null,0,null,0,null,0]
[null,"n","Chemisage partiel de la canalisation principale",null,null," -",null,0,null,0,null,{"$f":"IF(F404=\"%\",0.01*H404*J404,H404*J404)","v":0}]
[null,"o","Adaptation de la gaine au fond du regard",null,null,"pc",null,0,null,0,null,{"$f":"H405*J405","v":0}]
[null,"p","Ouverture de raccordements privés",null,null,"pc",null,0,null,0,null,{"$f":"H406*J406","v":0}]
[null,"q","Pose de manchette pour étanchéité (raccords privés)",null,null,"pc",null,0,null,0,null,0]
[null,"r","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F408=\"%\",0.01*H408*J408,H408*J408)","v":0}]
[null,"s","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"t","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"2","Par robotique"]
[null,"a","Canalisation principale",null,null," -",null,0,null,0,null,{"$f":"IF(F413=\"%\",0.01*H413*J413,H413*J413)","v":0}]
[null,"b","Raccords privés",null,null,"pc",null,0,null,0,null,{"$f":"H414*J414","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F415=\"%\",0.01*H415*J415,H415*J415)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F416=\"%\",0.01*H416*J416,H416*J416)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F417=\"%\",0.01*H417*J417,H417*J417)","v":0}]
[]
[null,"1.4.5","REPARATION DE REGARDS"]
[null,"1","Dégradations localisées"]
[null,"a","Paroi, Fond",null,null,"pc",null,0,null,0,null,{"$f":"H421*J421","v":0}]
[null,"b","Fond, hors chemisage",null,null,"pc",null,0,null,0,null,{"$f":"H422*J422","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F423=\"%\",0.01*H423*J423,H423*J423)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F424=\"%\",0.01*H424*J424,H424*J424)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.4.6","RECEPTION"]
[null,"1","Nettoyage, inspection vidéo et rapport"]
[null,"a","Curage, inspection vidéo et rapport",null,null,"m",null,0,null,0,null,{"$f":"H429*J429","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F430=\"%\",0.01*H430*J430,H430*J430)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F431=\"%\",0.01*H431*J431,H431*J431)","v":0}]
[]
[null,null,"Réhabilitation de canalisation et gainage (CAN 135)",null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(L354:L431),0)","v":0},"fr HT"]
[]
[null,"1.5","TRAVAUX SPÉCIAUX"]
[]
[null,"1.5.1","INSTALLATIONS DE CHANTIER SPECIFIQUES "]
[null,"1","Installations complètes"]
[null,"a","Pour la durée des travaux",null,null,"%",null,0,null,0,null,{"$f":"H439*0.01*J439","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F440=\"%\",0.01*H440*J440,H440*J440)","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F441=\"%\",0.01*H441*J441,H441*J441)","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.5.2","CREATION DE CELLULES"]
[null,"1","Réalisation de cellules"]
[null,"a","Création de cellules (prix global)",null,null,"gl",null,0,null,0,null,{"$f":"H448*J448","v":0}]
[null,"b","Création de cellules (au mètre)",null,null,"m",null,0,null,0,null,{"$f":"H449*J449","v":0}]
[null,"c","Création de cellule (à la pièce)",null,null,"pc",null,0,null,0,null,{"$f":"H450*J450","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F451=\"%\",0.01*H451*J451,H451*J451)","v":0}]
[null,"e","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F452=\"%\",0.01*H452*J452,H452*J452)","v":0}]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F453=\"%\",0.01*H453*J453,H453*J453)","v":0}]
[null,"g","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F454=\"%\",0.01*H454*J454,H454*J454)","v":0}]
[null,"h","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F455=\"%\",0.01*H455*J455,H455*J455)","v":0}]
[]
[null,"1.5.3","MISE EN OEUVRE DE CANALISATIONS"]
[null,"1","Dimensions","Mode de réalisation"]
[null,"a"," -"," -",null,"m",null,0,null,0,null,{"$f":"H459*J459","v":0}]
[null,"b"," -"," -",null,"m",null,0,null,0,null,0]
[null,"c"," -"," -",null,"m",null,0,null,0,null,0]
[null,"d"," -"," -",null,"m",null,0,null,0,null,0]
[null,"e"," -"," -",null,"m",null,0,null,0,null,0]
[null,"f"," -"," -",null,"m",null,0,null,0,null,0]
[null,"g"," -"," -",null,"m",null,0,null,0,null,0]
[null,"h"," -"," -",null,"m",null,0,null,0,null,0]
[null,"i"," -"," -",null,"m",null,0,null,0,null,0]
[null,"j"," -"," -",null,"m",null,0,null,0,null,0]
[null,"k","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F469=\"%\",0.01*H469*J469,H469*J469)","v":0}]
[null,"l","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F470=\"%\",0.01*H470*J470,H470*J470)","v":0}]
[null,"m","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,null,"Travaux spéciaux",null,null,null,null,null,null,null,null,{"$f":"SUM(L439:L471)","v":0},"fr HT"]

{"sheet":"3. Services","index":3,"n_rows":134,"n_cols":15,"rows_kept":134,"cut":false,"hidden":false,"merged":[[9,11,9,12]]}
[null,"               "]
[null,"                     "]
[null,"                    "]
[]
[]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[null,"Services mis en péril par le chantier d'assainissement"]
[]
[null,null,"Libellé","Caractéristiques",null,"Unité",null,"Quantité",null,"Prix unitaire\nfr HT",null,"Montant\nfr HT",null,null,"Commentaire / Remarque"]
[]
[null,"1.6.1","DÉMOLITION ET DÉMONTAGE"]
[null,"1","Enrobés bitumineux (HAP < 5'000 mg/kg)"]
[null,"a","Coupe","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H14*J14","v":0}]
[null,"b","Démolition et chargement","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,{"$f":"H15*J15","v":0}]
[null,"c","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H16*J16","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F17=\"%\",0.01*H17*J17,H17*J17)","v":0}]
[]
[null,"2","PV pour enrobés pollués "]
[null,"a","5'001 < HAP < 20'000 mg/kg",null,null,"m3",null,0,null,0,null,{"$f":"H20*J20","v":0}]
[null,"b","HAP > 20'001 mg/kg",null,null,"m3",null,0,null,0,null,{"$f":"H21*J21","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F22=\"%\",0.01*H22*J22,H22*J22)","v":0}]
[]
[null,"3","Chaussée en béton, armé ou non"]
[null,"a","Coupe","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H25*J25","v":0}]
[null,"b","Démolition et chargement","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,{"$f":"H26*J26","v":0}]
[null,"c","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H27*J27","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F28=\"%\",0.01*H28*J28,H28*J28)","v":0}]
[]
[null,"4","Dallage (trottoirs)"]
[null,"a","Coupe","Epaisseur  : (…) cm",null,"m",null,0,null,0,null,{"$f":"H31*J31","v":0}]
[null,"b","Démolition et chargement","Epaisseur  : (…) cm",null,"m2",null,0,null,0,null,{"$f":"H32*J32","v":0}]
[null,"c","Evacuation et mise en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H33*J33","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F34=\"%\",0.01*H34*J34,H34*J34)","v":0}]
[]
[null,"5","Démolition / démontage des aménagements de surface et éléments divers (yc évacuation, mise en décharge, nettoyage et stockage)"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F37=\"%\",0.01*H37*J37,H37*J37)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"1.6.2","TERRASSEMENTS"]
[null,"1","Excavation de tranchées"]
[null,"a","Machine et main ",null,null,"m3",null,0,null,0,null,{"$f":"H44*J44","v":0}]
[null,"b","PV pour excavation à la main",null,null,"m3",null,0,null,0,null,{"$f":"H45*J45","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F46=\"%\",0.01*H46*J46,H46*J46)","v":0}]
[]
[null,"2","Matériaux d'excavation"]
[null,"a","Transport en décharge, yc taxes",null,null,"m3",null,0,null,0,null,{"$f":"H49*J49","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F50=\"%\",0.01*H50*J50,H50*J50)","v":0}]
[]
[null,"3","Etayage de tranchée après excavation"]
[null,"a","Etayage","Type : (…)",null,"m2",null,0,null,0,null,{"$f":"H53*J53","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F54=\"%\",0.01*H54*J54,H54*J54)","v":0}]
[]
[null,"1.6.3","TUYAUX DE PROTECTION ET CÂBLES, POSE SANS FOURNITURE"]
[null,"1","Tuyaux, yc manchons"]
[null,"a","DN 1","DN mm et matériau",null,"m",null,0,null,0,null,{"$f":"H58*J58","v":0}]
[null,"b","DN 2","DN mm et matériau",null,"m",null,0,null,0,null,0]
[null,"c","DN 3","DN mm et matériau",null,"m",null,0,null,0,null,0]
[null,"d","DN 4","DN mm et matériau",null,"m",null,0,null,0,null,0]
[null,"e","DN 5","DN mm et matériau",null,"m",null,0,null,0,null,0]
[null,"f","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F63=\"%\",0.01*H63*J63,H63*J63)","v":0}]
[]
[null,"2","Tirage de ficelle et calibrage de tubes"]
[null,"a","Sur l'entier de l'équipement",null,null,"m",null,0,null,0,null,{"$f":"H66*J66","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F67=\"%\",0.01*H67*J67,H67*J67)","v":0}]
[]
[null,"1.6.4","CHAMBRES, SOCLES ET BUTÉE, FOURNITURE ET POSE"]
[null,"1","Chambres"]
[null,"a","Hauteur < 1.20 m","DN mm",null,"pc",null,0,null,0,null,{"$f":"H71*J71","v":0}]
[null,"b","Hauteur m : 1.21 à 1.40","DN mm",null,"pc",null,0,null,0,null,{"$f":"H72*J72","v":0}]
[null,"c","Hauteur m : 1.41 à 1.60","DN mm",null,"pc",null,0,null,0,null,{"$f":"H73*J73","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F74=\"%\",0.01*H74*J74,H74*J74)","v":0}]
[]
[null,"2","Socles"]
[null,"a","SIG T10",null,null,"pc",null,0,null,0,null,{"$f":"H77*J77","v":0}]
[null,"b","SIG T20",null,null,"pc",null,0,null,0,null,{"$f":"H78*J78","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F79=\"%\",0.01*H79*J79,H79*J79)","v":0}]
[]
[null,"3","Butées"]
[null,"a","Sur l'entier de l'équipement",null,null,"pc",null,0,null,0,null,{"$f":"H82*J82","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F83=\"%\",0.01*H83*J83,H83*J83)","v":0}]
[]
[null,"1.6.5","TRAVAUX DES SERVICES INDUSTRIELS"]
[null,"1","Travaux SIG"]
[null,"a","Tranchée pour conduite provisoire",null,null,"m3",null,0,null,0,null,{"$f":"H87*J87","v":0}]
[null,"b","Capes de vannes SIG - Pose et mise à niveau, hors fourniture",null,null,"pc",null,0,null,0,null,{"$f":"H88*J88","v":0}]
[null,"c","Capes de vannes SIG - Fourniture, pose et mise à niveau",null,null,"pc",null,0,null,0,null,{"$f":"H89*J89","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F90=\"%\",0.01*H90*J90,H90*J90)","v":0}]
[]
[null,"1.6.6","REMBLAYAGE"]
[null,"1","Avec matériaux d'apport, yc fourniture"]
[null,"a","Grave non traitée","GNT 0/16-0/22-0/45",null,"m3",null,0,null,0,null,{"$f":"H94*J94","v":0}]
[null,"b","Grave recyclée","GNT 0/16-0/22-0/45",null,"m3",null,0,null,0,null,{"$f":"H95*J95","v":0}]
[null,"c","Avec déblai d'excavation (reprise et mise en oeuvre)",null,null,"m3",null,0,null,0,null,{"$f":"H96*J96","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F97=\"%\",0.01*H97*J97,H97*J97)","v":0}]
[]
[null,"1.6.7","ENROBAGE"]
[null,"1","Mise en œuvre de matériaux d'enrobage, yc fourniture"]
[null,"a","Graviers, sable, gravillons",null,null,"m3",null,0,null,0,null,{"$f":"H101*J101","v":0}]
[null,"b","Béton",null,null,"m3",null,0,null,0,null,{"$f":"H102*J102","v":0}]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F103=\"%\",0.01*H103*J103,H103*J103)","v":0}]
[]
[null,"2","Compléments pour enrobage"]
[null,"a","Coffrage du béton d'enrobage",null,null,"m2",null,0,null,0,null,{"$f":"H106*J106","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F107=\"%\",0.01*H107*J107,H107*J107)","v":0}]
[]
[null,"1.6.8","REMISE EN ÉTAT"]
[null,"1","Enrobés bitumineux, fourniture et pose"]
[null,"a","Enrobés bitumineux - Couche de base","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H111*J111","v":0}]
[null,"b","Enrobés bitumineux - Couche de roulement","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H112*J112","v":0}]
[null,"c","Enrobés bitumineux - Phonoabsorbant","Type et épaisseur",null,"t",null,0,null,0,null,{"$f":"H113*J113","v":0}]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F114=\"%\",0.01*H114*J114,H114*J114)","v":0}]
[]
[null,"2","Chaussée béton, armé ou non, fourniture et pose"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F117=\"%\",0.01*H117*J117,H117*J117)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"3","Dallage"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F123=\"%\",0.01*H123*J123,H123*J123)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,"4","Remise en état des aménagements de surface et éléments divers"]
[null,"a","Descriptif",null,null," -",null,0,null,0,null,{"$f":"IF(F129=\"%\",0.01*H129*J129,H129*J129)","v":0}]
[null,"b","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"c","Descriptif",null,null," -",null,0,null,0,null,0]
[null,"d","Descriptif",null,null," -",null,0,null,0,null,0]
[]
[null,null,"Services mis en péril par le chantier d'assainissement",null,null,null,null,null,null,null,null,{"$f":"SUM(L14:L132)","v":0},"fr HT"]

{"sheet":"4. Plan financier - Décompte","index":4,"n_rows":124,"n_cols":17,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
[null,"               "]
[null,"                     "]
[null,"                    "]
[]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[null,{"$f":"TypeDossier","v":"PLAN FINANCIER"}]
[]
[]
[null,"0.0","RECAPITULATIF DU MONTANT DES TRAVAUX",null,null,"Montant HT",null,null,null,null,null,null,null,"Remarque(s)"]
[null,"0.1","Hors travaux publics d'assainissement (soumission ou décompte final, yc rabais)",null,null,0,"fr"]
[null,"0.2","Travaux publics assainissement (soumission ou décompte final, yc rabais)",null,null,0,"fr"]
[]
[null,null,"Montant total des travaux (tous lots confondus y compris avenants, régies, rabais,..,…)",null,null,{"$f":"SUM(F11:F12)","v":0},"fr HT"]
[]
[]
[null,"1.0"," TRAVAUX PUBLICS D'ASSAINISSEMENT",null,null,"Montant HT",null,null,null,null,null,null,null,"Remarque(s)"]
[null,1.1000000000000001,"Installations de chantier",null,null,{"$f":"SsTt_S_1_1","v":0},"fr"]
[null,1.2,"Démolitions, canalisations, évacuation des eaux, chaussées et revêtements",null,null,{"$f":"SsTt_S_1_2","v":0},"fr"]
[null,1.3,"Ouvrages spécifiques (Bassin de rétention, noues, fossés, stations de pompage,...)",null,null,{"$f":"SsTt_S_1_3","v":0},"fr"]
[null,1.4,"Réhabilitation des canalisations existantes",null,null,{"$f":"SsTt_S_1_4","v":0},"fr"]
[null,"1.5","Travaux spéciaux",null,null,{"$f":"SsTt_S_1_5","v":0},"fr"]
[null,"1.6","Services mis en péril",null,null,{"$f":"SsTt_S_1_6","v":0},"fr"]
[null,"1.7","Raccords privés, grilles, collecteurs de sac",null,null,0,"fr"]
[null,"1.8","Offres complémentaires",null,null,0,"fr"]
[null,"1.9","Régies",null,null,0,"fr"]
[null,"1.10","Postes non renseignés",null,null,{"$f":"(F12/(1-D29*0.01))-SUM(F18:F26)","v":0},"fr",null,{"$f":"IF(OR(F27<0,F12=0,ISBLANK(F12)),\"Renseigner/Adapter le montant au point 0.2\",\"\")","v":"Renseigner/Adapter le montant au point 0.2"}]
[null,null,"Montant total des travaux publics assainissement (avant rabais)",null,null,{"$f":"SUM(F18:F27)","v":0},"fr"]
[null,null,"Rabais",0,"%",{"$f":"-F28*D29*0.01","v":0},"fr"]
[null,null,null,null,null,null,null,null,"TVA",null,"Montant"]
[null,null,"Montant total des travaux publics assainissement",null,null,{"$f":"F28+F29","v":0},"fr HT",null,8.1,"%",{"$f":"I31*0.01*F31","v":0},"fr"]
[null,null,"Montant total des travaux publics assainissement (hors raccords privés, sacs grilles, collecteurs de sac)",null,null,{"$f":"F28+F29-(100-Rabais_Soumission)*0.01*F_S_1_07","v":0},"fr HT",null,{"$f":"I31","v":8.1},"%",{"$f":"I32*0.01*F32","v":0},"fr"]
[]
[null,"2.0","PRESTATIONS DE MANDATAIRES (pour les travaux publics d'assainissement)"]
[null,2.1,"Ingénieur civil (Phases SIA 103)",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Phase 31 - Avant-projet",null,null,0,"fr",null,8.1,"%",{"$f":"I36*0.01*F36","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Phase 32 - Projet de l'ouvrage",null,null,0,"fr",null,8.1,"%",{"$f":"I37*0.01*F37","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Phase 33 - Procédure de demande d'autorisation",null,null,0,"fr",null,8.1,"%",{"$f":"I38*0.01*F38","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Phase 41 - Appels d'offres, comparaison des offres, proposition d'adjudication",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Phase 51 - Projet d'exécution",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Phase 52 - Exécution de l'ouvrage",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Phase 53 - Mise en service, achèvement",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[]
[null,"2.2","Géomètre",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",{"$f":"I46*0.01*F46","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[]
[null,"2.3","Huissier judiciaire",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",{"$f":"I55*0.01*F55","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Description prestation",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[]
[null,"2.4","Autres prestations",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",{"$f":"I64*0.01*F64","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[null,null,"Autres prestations",null,null,0,"fr",null,8.1,"%",0,"fr",null,null,null,0,"fr"]
[]
[null,null,"Montant total des prestations de mandataires",null,null,{"$f":"SUM(F36:F78)","v":0},"fr HT",null,null,null,{"$f":"SUM(K36:K78)","v":0},"fr"]
[]
[]
[null,"3.0","FRAIS DIVERS"]
[null,"3.1","Autorisation de construire",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I85*0.01*F85","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I86*0.01*F86","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I87*0.01*F87","v":0},"fr",null,null,null,0,"fr"]
[]
[null,"3.2","Emoluments",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I90*0.01*F90","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I91*0.01*F91","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,0,"%",{"$f":"I92*0.01*F92","v":0},"fr",null,null,null,0,"fr"]
[]
[null,"3.2","Cadastration des réseaux",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I95*0.01*F95","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I96*0.01*F96","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I97*0.01*F97","v":0},"fr",null,null,null,0,"fr"]
[]
[null,"3.3","Publications",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I100*0.01*F100","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I101*0.01*F101","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I102*0.01*F102","v":0},"fr",null,null,null,0,"fr"]
[]
[null,"3.4","Débours",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I105*0.01*F105","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I106*0.01*F106","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I107*0.01*F107","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I108*0.01*F108","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I109*0.01*F109","v":0},"fr",null,null,null,0,"fr"]
[]
[null,"3.4","Autres",null,null,"Montant HT (Assainissement)",null,null,"TVA",null,"Montant",null,null,"N° / Référence de la (des) facture(s) - Remarque(s)",null,"Montant HT (tous travaux)"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I112*0.01*F112","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I113*0.01*F113","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I114*0.01*F114","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I115*0.01*F115","v":0},"fr",null,null,null,0,"fr"]
[null,null,"Description",null,null,0,"fr",null,8.1,"%",{"$f":"I116*0.01*F116","v":0},"fr",null,null,null,0,"fr"]
[]
[null,null,"Montant total des frais divers",null,null,{"$f":"SUM(F85:F116)","v":0},"fr HT",null,null,null,{"$f":"SUM(K85:K116)","v":0},"fr"]
[]
[]
[null,"4.0","COUT TOTAL",null,null,"Montant HT (Assainissement)",null,null,null,null,null,null,null,"Remarque(s)"]
[null,null,"Total",null,null,{"$f":"F32+F80+F118","v":0},"fr HT"]
[null,null,"TVA",{"$f":"IF(F122=0,0,(F123/F122)*100)","v":0},"%",{"$f":"K32+K80+K118","v":0},"fr"]
[null,null,"Total (TTC)",null,null,{"$f":"F122+F123","v":0},"fr TTC"]

{"sheet":"5. Synthèse","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"               "]
[null,"                     "]
[null,"                    "]
[]
[null,"Chantiers publics d'assainissement des eaux"]
[null,{"$f":"TypeDossier","v":"PLAN FINANCIER"}]
[]
[null,"0","Montant total des travaux",null,null,{"$f":"'4. Plan financier - Décompte'!$F$14","v":0},"francs HT"]
[]
[null,"1","Montant total des travaux publics assainissement",null,null,{"$f":"'4. Plan financier - Décompte'!$F$32","v":0},"francs HT"]
[null,"2","Montant total des prestations de mandataires",null,null,{"$f":"'4. Plan financier - Décompte'!$F$80","v":0},"francs HT"]
[null,"3","Montant total des frais divers",null,null,{"$f":"'4. Plan financier - Décompte'!$F$118","v":0},"francs HT"]
[null,"4","Cout total",null,null,{"$f":"'4. Plan financier - Décompte'!$F$122","v":0},"francs HT"]
[null,"5","TVA",{"$f":"'4. Plan financier - Décompte'!$D$123","v":0},"%",{"$f":"'4. Plan financier - Décompte'!$F$123","v":0},"francs HT"]
[null,"6","Cout total (TTC)",null,null,{"$f":"'4. Plan financier - Décompte'!$F$124","v":0},"francs TTC"]

{"sheet":"Listes","index":6,"n_rows":52,"n_cols":44,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Configuration \nde la fouille",null,"Contenu",null,"Diamètre",null,"Matériau",null,"Profil SIA 190",null,"Enrobés",null,"Revêtement",null,"Chambres visite",null,"Profondeur des chambres",null,"Service",null,"Reseau",null,"Déversoirs, trop pleins,…",null,"Gainage",null,"Travaux spéciaux",null,"Enrobage services",null,"Unités",null,"Procédure",null,"Commune",null,"Outil de planification",null,"Satut équipement",null,"Type de travaux",null,"Milieu travaux"]
[null,"ConfigFouille",null,"Contenu",null,"DiametreCanalisation",null,"MateriauCanalisation",null,"ProfilSIA190",null,"Enrobes",null,"RevetementSurface",null,"DiametreChambre",null,"ProfChambre",null,"ServiceType",null,"ReseauType",null,"TypeOHSpeciaux",null,"GainesPolymerisees",null,"TechTravauxSpeciaux",null,"EnrobServices",null,"Unites",null,"Procedure",null,"LCommune",null,"OutilPlanif",null,"LSatut",null,"LTypeTravaux",null,"LMilieuContexte"]
[null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null," -",null,"PLAN FINANCIER",null," -",null," -",null," -",null," -",null," -"]
[null,"1 collecteur",null,"EU",null,"DN 160 mm",null,"PVC",null,"U2",null,"Couche de base",null,"Sous-trottoir",null,"DN  800 mm",null,"jusqu'à 1.50 m",null,"Services",null,"Services",null,"Déversoir",null,"jusqu'à DN 250 mm",null,"Forage dirigé",null,"Béton",null,"m",null,"DECOMPTE",null,"Aire-la-ville",null,"PREE",null,"Secondaire",null,"Nouveau réseau séparatif",null,"Urbain ou rural sous voirie (yc trottoirs)"]
[null,"2 collecteurs",null,"EP",null,"DN 200 mm",null,"PRFV",null,"U4",null,"Couche de base et de roulement",null,"Mobilier urbain",null,"DN 1000 mm",null,"1.51 à 2.00 m",null,"Eau potable / Gaz",null,"Eau potable / Gaz",null,"Trop plein",null,"jusqu'à DN 300 mm",null,"Cracking",null,"Sable",null,"m2",null,null,null,"Anières",null,"PGEE",null,"Collectif privé",null,"Nouveau réseau unitaire",null,"Urbain ou rural hors voirie sous espaces verts"]
[null,null,null,"EM",null,"DN 250 mm",null,"PE",null,"U1",null,"Couche de base et de phonoabsorbant",null,"Autre",null,"DN 1200 mm",null,"2.01 à 2.50 m",null,null,null,"Collecteurs privés",null,"Autre ouvrage",null,"jusqu'à DN 400 mm",null,"Microtunnelier",null,"Mixte",null,"m3",null,null,null,"Avully",null,"Schéma directeur",null,"Secondaire et collectif privé",null,"Reconstruction de réseau séparatif",null,"Urbain ou rural hors voirie avec mobilier urbain"]
[null,null,null,"ED",null,"DN 315 mm",null,"Béton",null,"U2A",null,"Autre",null,null,null,"OV 1'100/900 mm",null,"2.51 à 3.00 m",null,null,null,"Collecteurs publics",null,null,null,"jusqu'à DN 500 mm",null,"Pousse tube",null,"Autre",null,"kg",null,null,null,"Avusy",null,"Etude spécifique",null,"Autre",null,"Reconstruction de réseau unitaire",null,"Plein champ"]
[null,null,null,null,null,"DN 355 mm",null,"Autre",null,"U3",null,null,null,null,null,null,null,"3.01 à 3.50 m",null,null,null,null,null,null,null,"jusqu'à DN 600 mm",null,"Autre",null,null,null,"t",null,null,null,"Bardonnex",null,"Autre",null,null,null,"Réhabilitation de réseau séparatif",null,"Forêt"]
[null,null,null,null,null,"DN 400 mm",null,null,null,"V1",null,null,null,null,null,null,null,"3.51 à 4.00 m",null,null,null,null,null,null,null,"jusqu'à DN 700 mm",null,null,null,null,null,"pc",null,null,null,"Bellevue",null,null,null,null,null,"Réhabilitation de réseau unitaire",null,"Autre"]
[null,null,null,null,null,"DN 450 mm",null,null,null,"V2",null,null,null,null,null,null,null,"4.01 à 4.50 m",null,null,null,null,null,null,null,"jusqu'à DN 800 mm",null,null,null,null,null,"h",null,null,null,"Bernex",null,null,null,null,null,"Ouvrage(s) de gestion des eaux"]
[null,null,null,null,null,"DN 500 mm",null,null,null,"V2A",null,null,null,null,null,null,null,"4.51 à 5.00 m",null,null,null,null,null,null,null,"jusqu'à DN 1000 mm",null,null,null,null,null,"j",null,null,null,"Carouge",null,null,null,null,null,"Autre"]
[null,null,null,null,null,"DN 630 mm",null,null,null,"V3",null,null,null,null,null,null,null,"5.01 à 5.50 m",null,null,null,null,null,null,null,"jusqu'à DN 1100 mm",null,null,null,null,null,"gl",null,null,null,"Cartigny"]
[null,null,null,null,null,"DN 710 mm",null,null,null,"V4",null,null,null,null,null,null,null,"5.51 à 6.00 m",null,null,null,null,null,null,null,"jusqu'à DN 1250 mm",null,null,null,null,null,"%",null,null,null,"Céligny"]
[null,null,null,null,null,"DN 800 mm",null,null,null,null,null,null,null,null,null,null,null,"6.01 à 6.50 m",null,null,null,null,null,null,null,"jusqu'à Ov 400/600 mm",null,null,null,null,null,"Autre",null,null,null,"Chancy"]
[null,null,null,null,null,"DN 900 mm",null,null,null,null,null,null,null,null,null,null,null,"6.51 à 7.00 m",null,null,null,null,null,null,null,"jusqu'à Ov 800/1200 mm",null,null,null,null,null,null,null,null,null,"Chêne-Bougeries"]
[null,null,null,null,null,"DN 1000 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autre",null,null,null,null,null,null,null,null,null,"Chêne-Bourg"]
[null,null,null,null,null,"DN 1100 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choulex"]
[null,null,null,null,null,"DN 1200 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collex-Bossy"]
[null,null,null,null,null,"DN 1400 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Collonge-Bellerive"]
[null,null,null,null,null,"DN 1500 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cologny"]
[null,null,null,null,null,"DN 1600 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Confignon"]
[null,null,null,null,null,"DN 1800 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corsier"]
[null,null,null,null,null,"DN 2000 mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dardagny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genève"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Genthod"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand-Saconnex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hermance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jussy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laconnex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lancy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meinier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meyrin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perly-Certoux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan-les-Ouates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pregny-Chambésy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presinge "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puplinge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Russin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satigny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soral"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thônex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Troinex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vandoeuvres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vernier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versoix"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veyrier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FTI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autre"]