{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget","BDD"],"not_rendered":{"images":1,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":12,"n_cols":3,"rows_kept":12}
[]
[]
[]
[]
[]
["N° PRIX","Désignation Ouvrage","Colonne1"]
["A 8.30",{"$f":"VLOOKUP(A7,BDD!$E$4:$F$997,2,FALSE)","v":" BALISAGE DES RETABLISSEMENTS"}]
["A 8.20",{"$f":"VLOOKUP(A8,BDD!$E$4:$F$997,2,FALSE)","v":" DEVIATION ITINERAIRE AUTOROUTE"}]
["A 8.45",{"$f":"VLOOKUP(A9,BDD!$E$4:$F$997,2,FALSE)","v":" ASTREINTE CRITIQUE"}]
["H5 633.00",{"$f":"VLOOKUP(A10,BDD!$E$4:$F$997,2,FALSE)","v":" DESOCCULTATION SUR ACCOTEMENT"}]
["A 5.30",{"$f":"VLOOKUP(A11,BDD!$E$4:$F$997,2,FALSE)","v":" DOSSIER DE RECOLEMENT"}]
["A 8.20",{"$f":"VLOOKUP(A12,BDD!$E$4:$F$997,2,FALSE)","v":" DEVIATION ITINERAIRE AUTOROUTE"}]

{"sheet":"BDD","index":1,"n_rows":216,"n_cols":6,"rows_kept":216}
["Fourniture","Unité","prix/U"]
["Panneau béton bois EA976 DURISOL","m²",{"$f":"121","v":{"v":121,"d":"121.00"}}]
["Panneau bois MoulinVest","m²",{"v":48,"d":"48.00"},null,"Numéro de prix","Désignation"]
["Peinture EA 976","m²",{"v":8,"d":"8.00"},null,"A 1.01"," INSTALLATIONS DE CHANTIER"]
["Antigraff","m²",{"v":8,"d":"8.00"},null,"A 5.10"," ETUDES D'EXECUTION"]
["Grillage antigraff","m²",{"v":10,"d":"10.00"},null,"A 5.30"," DOSSIER DE RECOLEMENT"]
["joint et boulonnerie","m²",{"v":1.5,"d":"1.50"},null,"A 8.20"," DEVIATION ITINERAIRE AUTOROUTE"]
["Ancrage","U",{"v":50,"d":"50.00"},null,"A 8.30"," BALISAGE DES RETABLISSEMENTS"]
["Poteaux","Kg",2.07,null,"A 8.40"," ASTREINTE"]
["Couvertine","Ml",{"v":45,"d":"45.00"},null,"A 8.45"," ASTREINTE CRITIQUE"]
["C30/37 XF4 340 Kg MINIER","m3",{"$f":"116.5+1.9","v":{"v":118.4,"d":"118.40"}},null,"C3 4.01"," DEPOSE GLISSIERES SIMPLE FILE"]
["C35/45 XF2 330 Kg MINIER","m3",{"$f":"119.5+1.9","v":{"v":121.4,"d":"121.40"}},null,"C3 4.02"," DEPOSE GLISSIERES DOUBLE"]
["C20/25 ","m3",{"v":119.5,"d":"119.50"},null,"E1 1001.04"," INSTAL. CHANTIER 10EA976-1"]
["Fibre métal DRAMIX 5D","Kg",{"v":1.7,"d":"1.70"},null,"E1 1001.05"," INSTAL. CHANTIER 71EA982-1"]
["Filan HA12","Kg",{"v":1,"d":"1.00"},null,"E1 1001.06"," INSTAL. CHANTIER 71EA994-1"]
["Péage","U",{"v":9.7,"d":"9.70"},null,"E1 1001.07"," INSTAL. CHANTIER 71EA996-1"]
["Drain","ml",{"v":2,"d":"2.00"},null,"E1 1006.04"," DOC. CONFORMES 10EA976-1"]
["Caillebotti 125 KN","Pu",{"v":1,"d":"1.00"},null,"E1 1006.05"," DOC. CONFORMES 71EA982-1"]
["Grille 400 KN","Pu",{"v":85,"d":"85.00"},null,"E1 1006.06"," DOC. CONFORMES 71EA994-1"]
["Gaine CAF300","ml",3.5,null,"E1 1006.07"," DOC. CONFORMES 71EA996-1"]
["Gaine CAF400","ml",4.5,null,"E1 1012.00"," SERVICE QUALITE OA"]
["Primaire d'accrochage joint","kg",null,null,"E9 9001.01"," ECRAN ACOUSTIQUE 10EA976-1"]
["SIKA Flex garnissage joint","U",8.6,null,"E9 9001.02"," ECRAN ACOUSTIQUE 71EA982-1"]
["Passage d'eau","U",{"v":13,"d":"13.0"},null,"E9 9001.03"," ECRAN ACOUSTIQUE 71EA994-1"]
["Produit de cure","l",{"v":1.58,"d":"1.6"},null,"E9 9001.04"," ECRAN ACOUSTIQUE 71EA996-1"]
["Container à matériel ","u",{"v":2000,"d":"2000.0"},null,"F3 60.31"," CUN BETON 2,00M x 0,50M"]
["Armature renforcement ","kg",1.65,null,"F3 70.10"," FOSSE BETON"]
["Capot hydraulique","U",{"v":100,"d":"100.00"},null,"F3 90.03"," CAF Ø300"]
["Capot Distriroute","U",{"v":1650,"d":"1650.0"},null,"F3 90.04"," CAF Ø400"]
["Raccord GBA/DBA sur N2W5","U",{"v":1442.63,"d":"1442.6"},null,"F3 90.05"," PV POUR OBTURATION FENTE CAF"]
["Raccord GBA sur BN5 existante","U",{"v":2000,"d":"2000.0"},null,"F3 91.01"," CANIVEAUX EN U 30x30 GRILLE"]
["Raccord GBA sur H3 W4","U",{"v":2750,"d":"2750.0"},null,"F3 91.02"," CANIVEAUX EN U 40x40 GRILLE"]
[{"$nulls":4},"H1 101.00"," SEPARATEUR BETON GBA"]
[{"$nulls":4},"H1 110.00"," EXTREMITE FILE DBA L=1.65M"]
[{"$nulls":4},"H1 111.00"," EXTREMITE FILE GBA L=1.65M"]
[{"$nulls":4},"H1 131.10"," PASSAGE D'EAU POUR DBA"]
[{"$nulls":4},"H1 131.20"," PASSAGE D'EAU POUR GBA"]
[{"$nulls":4},"H1 132.20"," SEMELLE BETON GBA"]
[{"$nulls":4},"H1 135.10"," CAPOT REGARD HYDRAULIQUE"]
[{"$nulls":4},"H1 151.00"," JOINT GBA SUR OA"]
[{"$nulls":4},"H1 301.00"," RACC. DBA / PILE OA"]
[{"$nulls":4},"H1 302.00"," RACC. DBA / PIED DE PORTIQUE"]
[{"$nulls":4},"H1 303.00"," RACC.GBA/GBA OU DBA/DBA EXIST."]
[{"$nulls":4},"H1 304.00"," RACC. DBA / DOUBLE FILE GBA"]
[{"$nulls":4},"H1 311.00"," RACC. GBA OU DBA / N2 W5"]
[{"$nulls":4},"H1 312.00"," RACC. GBA / BARR. H2 PSI986"]
[{"$nulls":4},"H1 313.00"," RACC. GBA / BARR. H2 PSI986/49"]
[{"$nulls":4},"H1 315.00"," RACC. GBA / BN5 EXIST"]
[{"$nulls":4},"H1 316.00"," RACC. GBA / H3 W4"]
[{"$nulls":4},"H2 200.00"," GS SIMPLE N2 W5"]
[{"$nulls":4},"H2 205.00"," GS SIMPLE N2 W5 + ECRAN MOTO"]
[{"$nulls":4},"H2 206.00"," GS SIMPLE N2 W1 SUR LONGRINE"]
[{"$nulls":4},"H2 207.00"," GS SIMPLE N2 W3"]
[{"$nulls":4},"H2 208.00"," GS SIMPLE H3 W4"]
[{"$nulls":4},"H2 210.00"," EXTREM. ABAISSEE GS N2 W5"]
[{"$nulls":4},"H2 220.00"," GS DOUBLE H1 W5"]
[{"$nulls":4},"H2 230.00"," GS DOUBLE N2 W5"]
[{"$nulls":4},"H2 250.00"," PASSAGE SERVICE N2 W5"]
[{"$nulls":4},"H2 301.00"," SUPPRESSION ITPC"]
[{"$nulls":4},"H2 302.00"," ITPC PIVOTANT H2"]
[{"$nulls":4},"H2 311.00"," ATTENUAT. CHOC 80"]
[{"$nulls":4},"H2 312.00"," ATTENUAT. CHOC 80/1"]
[{"$nulls":4},"H2 313.00"," ATTENUAT. CHOC 100"]
[{"$nulls":4},"H2 401.00"," REFLECTEUR SIMPLE FACE N2"]
[{"$nulls":4},"H2 402.00"," REFLECTEUR SIMPLE FACE GBA/DBA"]
[{"$nulls":4},"H2 404.00"," REFLECTEUR JUMELE DBA"]
[{"$nulls":4},"H2 611.00"," RACC. GS / BN5 EXIST"]
[{"$nulls":4},"H2  614.00"," RACC. N2 W3 / N2 W5 DOUBLE"]
[{"$nulls":4},"H2  615.00"," RACC. N2 W5 / H1 W5 DOUBLE"]
[{"$nulls":4},"H2  616.00"," RACC. H3 W4 / H3 SUR PI989"]
[{"$nulls":4},"H4 3001.20"," 1ère campagne P3 200M  L=0,150"]
[{"$nulls":4},"H4 3002.20"," 1ère campagne P3 200M  L=0,225"]
[{"$nulls":4},"H4 3003.20"," 1ère campagne P3 200M  L=0,375"]
[{"$nulls":4},"H4 3005.20"," 1ère campagne P3 200M ZEBRAS"]
[{"$nulls":4},"H4 3006.20"," 1ère campagne P3 200M FLECHES"]
[{"$nulls":4},"H4 3010.50"," 2nd campagne P4 500M L=0,150"]
[{"$nulls":4},"H4 3011.50"," 2nd campagne P4 500M L=0,225"]
[{"$nulls":4},"H4 3012.50"," 2nd campagne P4 500M L=0,375"]
[{"$nulls":4},"H4 3014.50"," 2nd campagne P4 500M ZEBRAS"]
[{"$nulls":4},"H4 3015.50"," 2nd campagne P4 500M FLECHES"]
[{"$nulls":4},"H4 3250.00"," EFFACAGE MARQUAGE"]
[{"$nulls":4},"H4 3255.00"," BARRETTES SONORES P4 500M"]
[{"$nulls":4},"H5 100.01"," ASSISTANCE CONTROLEUR TECHNIQU"]
[{"$nulls":4},"H5 101.02"," PANNEAU SD3 sur PPHM"]
[{"$nulls":4},"H5 190.02"," CACHE AVEC / SANS INSCRIPTIONS"]
[{"$nulls":4},"H5 201.02"," PAN SD2 DOS OUVERT"]
[{"$nulls":4},"H5 301.02"," PANNEAU SD1/SD3 SUR ACCOTEMENT"]
[{"$nulls":4},"H5 302.02"," CACHE AVEC/SANS INSCRIPTIONS"]
[{"$nulls":4},"H5 401.02"," TRIANGLE TG"]
[{"$nulls":4},"H5 402.02"," TRIANGLE GG"]
[{"$nulls":4},"H5 403.02"," TRIANGLE N"]
[{"$nulls":4},"H5 405.02"," DISQUE TG"]
[{"$nulls":4},"H5 406.02"," DISQUE GG"]
[{"$nulls":4},"H5 407.02"," DISQUE N"]
[{"$nulls":4},"H5 409.02"," CARRE TG"]
[{"$nulls":4},"H5 410.02"," CARRE GG"]
[{"$nulls":4},"H5 411.02"," CARRE N"]
[{"$nulls":4},"H5 420.02"," PANONCEAU"]
[{"$nulls":4},"H5 580.02"," PLAQUETTE OUVRAGE (PI PS)"]
[{"$nulls":4},"H5 581.02"," PLAQUETTE OH"]
[{"$nulls":4},"H5 582.02"," PLAQUETTE GROS MATER SIGNAL"]
[{"$nulls":4},"H5 583.02"," PLAQUETTE FAUNE"]
[{"$nulls":4},"H5 584.02"," PLAQUETTE LIGNES ELECTRIQUES"]
[{"$nulls":4},"H5 585.02"," PLAQUETTES ISSUES DE SECOURS"]
[{"$nulls":4},"H5 586.02"," BORNE KILOMETRIQUE"]
[{"$nulls":4},"H5 588.02"," Dp1a ou Dp1b"]
[{"$nulls":4},"H5 601.00"," DEPOSE PANNEAU >5 M²"]
[{"$nulls":4},"H5 602.00"," REPOSE PANNEAU >5 M²"]
[{"$nulls":4},25," DEPOSE PANNEAU <5 M²"]
[{"$nulls":4},"H5 604.00"," REPOSE PANNEAU <5 M²"]
[{"$nulls":4},"H5 605.00"," DEPOSE PANNEAU >3 M²"]
[{"$nulls":4},"H5 606.00"," REPOSE PANNEAU >3 M²"]
[{"$nulls":4},"H5 607.00"," DEPOSE PANNEAU <3 M²"]
[{"$nulls":4},"H5 608.00"," REPOSE PANNEAU <3 M²"]
[{"$nulls":4},"H5 609.00"," DEPOSE PANNEAU SUR MAT"]
[{"$nulls":4},"H5 610.00"," REPOSE PANNEAU SUR MAT"]
[{"$nulls":4},"H5 611.00"," DEPOSE MAT (SERIE 1200)"]
[{"$nulls":4},"H5 612.00"," REPOSE MAT (SERIE 1200)"]
[{"$nulls":4},"H5 613.00"," DEPOSE SUPPORT (SERIE 1300)"]
[{"$nulls":4},"H5 614.00"," REPOSE SUPPORT (SERIE 1300)"]
[{"$nulls":4},"H5 615.00"," DEPOSE PANNEAU POLICE"]
[{"$nulls":4},"H5 616.00"," REPOSE PANNEAU POLICE"]
[{"$nulls":4},"H5 617.00"," DEPOSE DE PORTIQUE"]
[{"$nulls":4},"H5 618.00"," DEPOSE DE HAUT MAT"]
[{"$nulls":4},"H5 619.00"," DEPOSE DE POTENCE"]
[{"$nulls":4},"H5 620.00"," DEPOSE CAISSON DYNAMIQUE"]
[{"$nulls":4},"H5 630.00"," OCCULTATION SUR SUP. SPECIAL"]
[{"$nulls":4},"H5 631.00"," DESOCCULTATION SUR SUP.SPECIAL"]
[{"$nulls":4},"H5 632.00"," OCCULTATION SUR ACCOTEMENT"]
[{"$nulls":4},"H5 633.00"," DESOCCULTATION SUR ACCOTEMENT"]
[{"$nulls":4},"H5 634.00"," OCCULTATION SUR MAT"]
[{"$nulls":4},"H5 635.00"," DESOCCULTATION SUR MAT"]
[{"$nulls":4},"H5 650.00"," DEMOLITION MASSIF PPHM TPC/DR"]
[{"$nulls":4},"H5 651.00"," DEMOLITION MASSIF PPHM TPC/DBA"]
[{"$nulls":4},"H5 1100.00"," PORTIQUE 1-A71-02"]
[{"$nulls":4},"H5 1101.00"," PORTIQUE 1-A71-04"]
[{"$nulls":4},"H5 1102.00"," PORTIQUE 1-A71-05"]
[{"$nulls":4},"H5 1103.00"," PORTIQUE 2-A71-04"]
[{"$nulls":4},"H5 1104.00"," PORTIQUE 2-A71-05"]
[{"$nulls":4},"H5 1105.00"," PORTIQUE 2-A71-06"]
[{"$nulls":4},"H5 1106.00"," PORTIQUE 2-A71-07"]
[{"$nulls":4},"H5 1107.00"," POTENCE 2-A71-08"]
[{"$nulls":4},"H5 1108.00"," PORTIQUE 2-A10-03"]
[{"$nulls":4},"H5 1109.00"," PORTIQUE 2-A10-04"]
[{"$nulls":4},"H5 1110.00"," HAUT MAT 1-A71-01"]
[{"$nulls":4},"H5 1111.00"," HAUT MAT 2-A71-03"]
[{"$nulls":4},"H5 1112.00"," HAUT MAT 2-A10-02"]
[{"$nulls":4},"H5 1160.00"," PLUS VALUE LONGUEUR BRAS"]
[{"$nulls":4},"H5 1161.00"," PLUS VALUE LONGUEUR PIED"]
[{"$nulls":4},"H5 1210.00"," MAT ME NON TRAVERSANT"]
[{"$nulls":4},"H5 1212.00"," MAT MF NON TRAVERSANT"]
[{"$nulls":4},"H5 1300.00"," SUPPORT DE POLICE"]
[{"$nulls":4},"H5 1302.00"," SUPPORT DE TYPE MB"]
[{"$nulls":4},"H5 1303.00"," SUPPORT DE TYPE MC"]
[{"$nulls":4},"H5 1304.00"," SUPPORT DE TYPE MD"]
[{"$nulls":4},"H5 1305.00"," SUPPORT DE TYPE ME"]
[{"$nulls":4},"H5 1306.00"," SUPPORT DE TYPE MF"]
[{"$nulls":4},"H5 1307.00"," SUPPORT DE TYPE MG"]
[{"$nulls":4},"H5 1308.00"," SUPPORT DE TYPE MH"]
[{"$nulls":4},"H5 1320.00"," FIXATION SEPARATEURS"]
[{"$nulls":4},"H5 2101.00"," MASSIFS SUPP SPECIAUX DE JOUR"]
[{"$nulls":4},"H5 2102.00"," PLUS VALUE NUIT MASS SUPP SPEC"]
[{"$nulls":4},"H5 2170.00"," MURET DE SOUTENEMENT"]
[{"$nulls":4},"H5 2210.00"," MASSIF POUR MAT ME"]
[{"$nulls":4},"H5 2212.00"," MASSIF POUR MAT MF"]
[{"$nulls":4},"H5 2301.00"," MASSIF BETON NON ARME"]
[{"$nulls":4},"H5 2302.00"," PLUS VALUE FOUILLE TER ROCHEU"]
[{"$nulls":4},"H5 2303.00"," CHAPE DE PROPRETE"]
[{"$nulls":4},"H5 2502.00"," BALISE J4"]
[{"$nulls":4},"H5 2503.00"," BALISE J11"]
[{"$nulls":4},"H5 2510.00"," BALISE J14a DIAMETRE 2000"]
[{"$nulls":4},"H5 2512.00"," BALISE J14b HAUTEUR 2200"]
[{"$nulls":4},"W1 3000.05"," PEINT 50M PAS.ROUES L=0,150"]
[{"$nulls":4},"W1 3000.06"," PEINT 50M PAS.ROUES L=0,225"]
[{"$nulls":4},"W1 3000.08"," PEINT 50 M PAS.ROUES L=0,375"]
[{"$nulls":4},"W1 3000.09"," PEINT 50 M PAS.ROUES L=0,500"]
[{"$nulls":4},"W1 3000.10"," PEINT 50 M PAS.ROUES ZEBRAS"]
[{"$nulls":4},"W1 3000.11"," PEINT 50 M PAS.ROUES FLECHES"]
[{"$nulls":4},"W2 3100.01"," PANNEAU PROV TRES GRANDE GAMME"]
[{"$nulls":4},"W2 3100.02"," PANNEAU PROV GRANDE GAMME"]
[{"$nulls":4},"W2 3100.03"," PANNEAU PROV GAMME NORMALE"]
[{"$nulls":4},"W2 3102.02"," BALISE K5a"]
[{"$nulls":4},"W2 3103.02"," BALISE K5C"]
[{"$nulls":4},"W2 3104.02"," BALISE K5D"]
[{"$nulls":4},"W2 3108.00"," PANNEAU PROV KC OU KD"]
[{"$nulls":4},"W2 3120.00"," PANNEAU INFORMATION CHANTIER"]
[{"$nulls":4},"W2 3130.00"," PROTECTION ACOUSTIQUE"]
[{"$nulls":4},"W2 3160.00"," 3 FEUX A ECLATS"]
[{"$nulls":4},"W2 3162.00"," FEUX A DEFILEMENT"]
[{"$nulls":4},"W2 3175.01"," DEPLACEMENT POLICE  A, AK,B,C"]
[{"$nulls":4},"W2 3175.02"," DEPLACEMENT BALISE K5a"]
[{"$nulls":4},"W2 3175.03"," DEPLACEMENT BALISE K5c"]
[{"$nulls":4},"W2 3175.04"," DEPLACEMENT BALISE K5d"]
[{"$nulls":4},"W2 3175.07"," DEPLACEMENT PANNEAU KC KD"]
[{"$nulls":4},"W2 3175.08"," DEPLACEMENT FEUX"]
[{"$nulls":4},"W2 3180.01"," REPLIEMENT POLICE  A, AK, B,C"]
[{"$nulls":4},"W2 3180.02"," REPLIEMENT BALISE K5a"]
[{"$nulls":4},"W2 3180.03"," REPLIEMENT BALISE K5c"]
[{"$nulls":4},"W2 3180.04"," REPLIEMENT BALISE K5d"]
[{"$nulls":4},"W2 3180.07"," REPLIEMENT PANNEAU KC KD"]
[{"$nulls":4},"W2 3180.08"," REPLIEMENT  FEUX"]
[{"$nulls":4},"W2 3201.00"," MISE EN PLACE SMV"]
[{"$nulls":4},"W2 3205.00"," LOCATION SMV"]
[{"$nulls":4},"W2 3207.00"," RIPAGE SMV"]
[{"$nulls":4},"W2 3209.00"," TRANSFERT SMV"]
[{"$nulls":4},"W2 3210.00"," FOURNITURE PROTECTION SUR SMV"]
[{"$nulls":4},"W2 3220.00"," PV PROTECTION SUR SMV"]
[{"$nulls":4},"W2 3500.00"," MISE EN PLACE SEPARATEUR K16"]
[{"$nulls":4},"W2 3501.00"," LOCATION K16"]
[{"$nulls":4},"W2 3502.00"," RIPAGE K16"]
[{"$nulls":4},"W2 3504.00"," TRANSFERT K16"]
[{"$nulls":4},"W2 3600.00"," MISE EN PLACE ATTÉNUATEUR"]
[{"$nulls":4},"W2 3601.00"," LOCATION ATTÉNUATEUR"]
[{"$nulls":4},"W2 3609.00"," TRANSFERT ATTÉNUATEUR"]
[{"$nulls":4},"W2 4000.00"," LAVE-ROUE DANS BALISAGE"]
[{"$nulls":4},"W2 5000.00"," OUVERTURE / FERMETURE ITPC"]