{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["BPU","Modèle","Modèle2","Ressources"],"not_rendered":{"images":1,"macros":1,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"BPU","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[1,4,1,5],[5,0,5,5],[6,0,6,5],[8,7,8,8],[8,9,8,13],[9,0,9,5],[9,7,9,8],[9,9,9,13],[21,3,21,4],[22,3,22,4],[23,3,23,4]]}
[]
[]
[]
[]
[]
["Bordereau des prix Unitaires",{"$nulls":6},"Frais généraux","Frais\nchantier","Marge","Sous-traitant"]
[{"$f":"J9","v":"Test chantier numéro uno dos tres quatro cinquo seis"},{"$nulls":6},{"v":0.15,"d":"15%"},{"v":0.05,"d":"5%"}]
[]
[{"$nulls":7},"Nom chantier /AO :",null,"Test chantier numéro uno dos tres quatro cinquo seis"]
["Les prix sont indiqués en Euros Hors Taxes",{"$nulls":6},"Nom client :",null,"RATP Ingénierie"]
["Prix","Désignation des travaux","Unité","Qté","Prix Unitaire","Montant"]
{"$rows_empty":10}
[{"$nulls":3},"TOTAL H.T.     .",null,{"$f":"SUM(F12:F21)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"T.V.A 20%     .",null,{"$f":"F22*0.2","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":3},"TOTAL T.T.C.     .",null,{"$f":"F22+F23","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Modèle","index":1,"n_rows":51,"n_cols":5,"rows_kept":51,"merged":[[0,1,0,4],[2,1,2,4]]}
["Chantier :"]
["n° prix :"]
["Intitulé prix :"]
["Quantité :"]
["Désignation/type","Unité","Quantité","Prix Unitaire","Prix total"]
["Main-d'œuvre"]
[{"$nulls":3},{"$f":"IF(ISNA(INDEX(Prixpersonnel,MATCH(B7,Periode,0),MATCH(A7,MO,0))),\"\",INDEX(Prixpersonnel,MATCH(B7,Periode,0),MATCH(A7,MO,0)))","v":""},{"$f":"IFERROR(ROUND(C7*D7,2),\"\")","v":""}]
[{"$nulls":3},"",{"$f":"IFERROR(ROUND(C8*D8,2),\"\")","v":""}]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"",""]
[{"$nulls":3},"Total M.O.",{"$f":"SUM(E7:E16)","v":0}]
["Matériel"]
[null,{"$f":"IF(ISNA(INDEX(Unitemateriel,MATCH(A19,MAT,0),0)),\"\",INDEX(Unitemateriel,MATCH(A19,MAT,0)))","v":""},null,{"$f":"IF(ISNA(INDEX(Prixmateriel,MATCH(A19,MAT,0),0)),\"\",INDEX(Prixmateriel,MATCH(A19,MAT,0),))","v":""},{"$f":"IFERROR(ROUND(C19*D19,2),\"\")","v":""}]
[null,{"$f":"IF(ISNA(INDEX(Unitemateriel,MATCH(A20,MAT,0),0)),\"\",INDEX(Unitemateriel,MATCH(A20,MAT,0)))","v":""},null,{"$f":"IF(ISNA(INDEX(Prixmateriel,MATCH(A20,MAT,0),0)),\"\",INDEX(Prixmateriel,MATCH(A20,MAT,0),))","v":""},""]
[null,"",null,"",""]
[null,{"$f":"IF(ISNA(INDEX(Unitemateriel,MATCH(A19,MAT,0),0)),\"\",INDEX(Unitemateriel,MATCH(A19,MAT,0)))","v":""},null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[{"$nulls":3},"Total Matériel",{"$f":"SUM(E19:E28)","v":0}]
["Fournitures"]
[null,{"$f":"IF(ISNA(INDEX(Unitefourniture,MATCH(A31,FOUR,0),0)),\"\",INDEX(Unitefourniture,MATCH(A31,FOUR,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(Prixfourniture,MATCH(A31,FOUR,0),0)),\"\",INDEX(Prixfourniture,MATCH(A31,FOUR,0),0))","v":""},{"$f":"IFERROR(ROUND(C31*D31,2),\"\")","v":""}]
[null,{"$f":"IF(ISNA(INDEX(Unitefourniture,MATCH(A32,FOUR,0),0)),\"\",INDEX(Unitefourniture,MATCH(A32,FOUR,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(Prixfourniture,MATCH(A32,FOUR,0),0)),\"\",INDEX(Prixfourniture,MATCH(A32,FOUR,0),0))","v":""},""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[null,"",null,"",""]
[{"$nulls":3},"Total Fournitures",{"$f":"SUM(E31:E40)","v":0}]
["Sous-traitance"]
[null,{"$f":"IF(ISNA(INDEX(UniteSST,MATCH(A43,SST,0),0)),\"\",INDEX(UniteSST,MATCH(A43,SST,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(PrixSST,MATCH(A43,SST,0),0)),\"\",INDEX(PrixSST,MATCH(A43,SST,0),0))","v":""},{"$f":"IFERROR(ROUND(C43*D43,2),\"\")","v":""}]
[null,{"$f":"IF(ISNA(INDEX(UniteSST,MATCH(A44,SST,0),0)),\"\",INDEX(UniteSST,MATCH(A44,SST,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(PrixSST,MATCH(A44,SST,0),0)),\"\",INDEX(PrixSST,MATCH(A44,SST,0),0))","v":""},""]
[null,{"$f":"IF(ISNA(INDEX(UniteSST,MATCH(A45,SST,0),0)),\"\",INDEX(UniteSST,MATCH(A45,SST,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(PrixSST,MATCH(A45,SST,0),0)),\"\",INDEX(PrixSST,MATCH(A45,SST,0),0))","v":""},""]
[null,{"$f":"IF(ISNA(INDEX(UniteSST,MATCH(A46,SST,0),0)),\"\",INDEX(UniteSST,MATCH(A46,SST,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(PrixSST,MATCH(A46,SST,0),0)),\"\",INDEX(PrixSST,MATCH(A46,SST,0),0))","v":""},""]
[null,{"$f":"IF(ISNA(INDEX(UniteSST,MATCH(A47,SST,0),0)),\"\",INDEX(UniteSST,MATCH(A47,SST,0),0))","v":""},null,{"$f":"IF(ISNA(INDEX(PrixSST,MATCH(A47,SST,0),0)),\"\",INDEX(PrixSST,MATCH(A47,SST,0),0))","v":""},""]
[{"$nulls":3},"Total SST",{"$f":"SUM(E43:E47)","v":0}]
[{"$nulls":3},"Déboursé Prix",{"$f":"E17+E29+E41+E48","v":0}]
[{"$nulls":3},"Prix Total",{"$f":"E49*(1+BPU!I7)*(1+BPU!H7)","v":0}]
[{"$nulls":3},"Prix unitaire",{"$f":"IFERROR(ROUNDUP(E50/B4,0),\"\")","v":""}]

{"sheet":"Modèle2","index":2,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[1,0,1,14],[3,2,3,6],[4,2,4,6],[6,0,6,4],[6,5,6,14],[7,0,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[8,0,9,0],[8,1,9,2],[8,3,9,3],[8,11,8,12],[9,11,9,12],[10,1,10,2],[10,11,10,12],[11,1,11,2],[11,11,11,12],[12,1,12,2],[12,11,12,12],[13,1,13,2],[13,11,13,12],[14,1,14,2],[14,11,14,12],[15,1,15,2],[15,11,15,12],[16,1,16,2],[16,11,16,12],[17,1,17,2],[17,11,17,12],[18,1,18,2],[18,11,18,12],[19,1,19,2],[19,11,19,12],[20,1,20,2],[20,11,20,12],[21,1,21,2],[21,11,21,12],[22,1,22,2],[22,11,22,12],[23,1,23,2],[23,11,23,12],[24,1,24,2],[24,11,24,12],[25,1,25,2],[25,11,25,12],[26,1,26,2],[26,11,26,12],[27,1,27,2],[27,11,27,12],[28,1,28,2],[28,11,28,12],[29,1,29,2],[29,11,29,12],[30,1,30,2],[30,11,30,12],[31,1,31,2],[31,11,31,12],[32,1,32,2],[32,11,32,12],[33,1,33,2],[33,11,33,12],[34,1,34,2],[34,11,34,12],[35,1,35,2],[35,11,35,12],[36,1,36,2],[36,11,36,12],[37,1,37,2],[37,11,37,12],[38,1,38,2],[38,11,38,12],[39,1,39,2],[39,11,39,12],[40,1,40,2],[40,11,40,12],[41,1,41,2],[41,11,41,12],[42,1,42,2],[42,11,42,12],[43,0,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[45,0,45,3],[46,0,46,3],[47,0,48,3],[49,0,50,3],[49,10,49,11],[51,0,51,3],[52,10,52,11],[54,10,54,11],[54,13,54,14],[55,10,55,11],[55,13,55,14]]}
[]
[]
[]
[null,"Désignation du chantier :",{"$f":"BPU!A7","v":"Test chantier numéro uno dos tres quatro cinquo seis"},{"$nulls":5},"Date :",{"$f":"TODAY()","v":"2020-11-02"}]
[null,"Désignation du prix :",{"$nulls":6},"N° de prix :",null,null,"Quantité prix :",50,"Unité prix :"]
[]
["Eléments de base du prix",{"$nulls":4},"Décomposition de prix"]
["Ressources",{"$nulls":4},"Matériels et matières fongibles",null,"Main-d'œuvre",null,"Fournitures",null,"TOTAL 1",null,"Sous-traitance (2) et (5)"]
["Type","Désignation du prix",null,"Unité","Quantité ou durées d'utilisation élémentaires","Prix\n\nUnitaires","Total\n\n(1 x 2)","Prix\n\nUnitaires","Total\n\n(1 x 4)","Prix\n\nUnitaires","Total\n\n(1 x 6)","\n(3  + 5 + 7)",null,"Prix\n\nUnitaires","TOTAL 4\n\n(1 x 9)"]
[{"$nulls":4},1,2,3,4,5,6,7,8,null,9,10]
[{"$nulls":6},{"$f":"IF(F11=0,\"\",$E11*F11)","v":""},null,{"$f":"IF(H11=0,\"\",$E11*H11)","v":""},null,{"$f":"IF(J11=0,\"\",$E11*J11)","v":""},{"$f":"IF(OR(E11=0,N11<>\"\"),\"\",SUMIFS(F11:K11,$F$9:$K$9,\"*Total*\",F11:K11,\"<>\"\"\"))","v":""},null,null,{"$f":"IF(N11=0,\"\",$E11*N11)","v":""}]
[{"$nulls":6},{"$f":"IF(F12=0,\"\",$E12*F12)","v":""},null,"",null,"",{"$f":"IF(OR(E12=0,N12<>\"\"),\"\",SUMIFS(F12:K12,$F$9:$K$9,\"*Total*\",F12:K12,\"<>\"\"\"))","v":""},null,null,""]
[{"$nulls":8},"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
["MAT","Véhicule équipe",null,"J",null,{"v":80,"d":"80.00 €"},0,null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
["FOUR","Ballast 31,5/50 C4 Paris",null,"To",null,null,"",null,"",{"v":35,"d":"35.00 €"},0,"",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
[{"$nulls":6},"",null,"",null,"","",null,null,""]
["Déboursés TOTAL",{"$nulls":4},{"$f":"SUM(G11:G43)","v":0},null,{"$f":"SUM(I11:I43)","v":0},null,{"$f":"SUM(K11:K43)","v":0},null,"TOTAL 1 (T1) :",{"$f":"SUM(L11:M43)","v":0},"TOTAL 4 (T4) :",{"$f":"SUM(O11:O43)","v":0}]
[]
["(1) Tous les prix sont hors TVA."]
["(2) A compléter pour les prix de bordereau uniquement.",{"$nulls":4},"     K1 frais généraux de siège (3) :",null,{"v":0.15,"d":"15%"},"   du Total 1",null,"     TOTAL 1 (T1) :",null,{"$f":"M44","v":0}]
["(3) Si les taux appliqués aux fournitures, aux travaux sous-traités ou aux travaux exécutés par l'entrepreneur sont différents, les faire apparaître distinctement.",{"$nulls":4},"     K2 frais généraux de chantier (4) :",null,{"v":0,"d":"0%"},"   du Total 1",null,"     TOTAL 2 (T2) = T1*(1 + K1/100 + K2/100) :",null,{"$f":"M47*(1+H47+H48)","v":0}]
[{"$nulls":5},"     K3 aléas et bénéfices :",null,{"v":0.05,"d":"5%"},"   du Total 2",null,"     TOTAL 3 (T3) = T2*(1 + K3/100) :",null,{"$f":"M48*(1+H49)","v":0}]
["(4) Si les frais généraux de chantier comprennent une part importante de matériel ou de frais d'installation de chantier, en donner la décomposition par nature de dépenses.",{"$nulls":4},"     K4 frais de sous-traitance :",null,{"v":0,"d":"0%"},"   du Total 4",null,"     TOTAL 5 (T5) = T4*(1 + K4/100) :",null,{"$f":"O44*(1+H50)","v":0}]
[]
["(5) L'entrepreneur fournit le sous-détail de prix du sous-traitant."]
[]
[]
[{"$nulls":10},"TOTAL GENERAL",null,null,"PRIX UNITAIRE GENERAL"]
[{"$nulls":10},"(T3 + T5)",null,null,"(T3 + T5)/Quantité prix"]
[{"$nulls":10},"TOTAL :",{"$f":"M49+M50","v":0},null,"P.U. :",{"$f":"IFERROR(L57/M5,\"\")","v":0}]

{"sheet":"Ressources","index":3,"n_rows":107,"n_cols":9,"rows_kept":107}
[]
["Période/Qualification","Chef de chantier","Chef d'équipe","Poseur","Contrôleur","Conducteur d'engin","Test","Bureau d'étude","Géomètre"]
["Jour",{"v":1,"d":"1.00 €"},{"v":7,"d":"7.00 €"},{"v":13,"d":"13.00 €"},{"v":19,"d":"19.00 €"},{"v":25,"d":"25.00 €"},{"v":31,"d":"31.00 €"},{"v":37,"d":"37.00 €"},{"v":38,"d":"38.00 €"}]
["Nuit",{"v":2,"d":"2.00 €"},{"v":8,"d":"8.00 €"},{"v":14,"d":"14.00 €"},{"v":20,"d":"20.00 €"},{"v":26,"d":"26.00 €"},{"v":32,"d":"32.00 €"},null,{"v":39,"d":"39.00 €"}]
["Week-end",{"v":3,"d":"3.00 €"},{"v":9,"d":"9.00 €"},{"v":15,"d":"15.00 €"},{"v":21,"d":"21.00 €"},{"v":27,"d":"27.00 €"},{"v":33,"d":"33.00 €"},null,{"v":40,"d":"40.00 €"}]
["Jour GD",{"v":4,"d":"4.00 €"},{"v":10,"d":"10.00 €"},{"v":16,"d":"16.00 €"},{"v":22,"d":"22.00 €"},{"v":28,"d":"28.00 €"},{"v":34,"d":"34.00 €"},null,{"v":41,"d":"41.00 €"}]
["Nuit GD",{"v":5,"d":"5.00 €"},{"v":11,"d":"11.00 €"},{"v":17,"d":"17.00 €"},{"v":23,"d":"23.00 €"},{"v":29,"d":"29.00 €"},{"v":35,"d":"35.00 €"},null,{"v":42,"d":"42.00 €"}]
["Week-end GD",{"v":6,"d":"6.00 €"},{"v":12,"d":"12.00 €"},{"v":18,"d":"18.00 €"},{"v":24,"d":"24.00 €"},{"v":30,"d":"30.00 €"},{"v":36,"d":"36.00 €"},null,{"v":43,"d":"43.00 €"}]
[]
[]
["Matériel","Prix","Unité"]
["Bungalow chantier",{"v":1,"d":"1.00 €"},"J"]
["Camion 6x4 J",{"v":2,"d":"2.00 €"},"J"]
["Camion 6x4 N",{"v":3,"d":"3.00 €"},"N"]
["Compresseur",{"v":4,"d":"4.00 €"},"J"]
["Containeur outils",{"v":5,"d":"5.00 €"},"J"]
["Forfait vidange WC",{"v":6,"d":"6.00 €"},"U"]
["Groupe de bourrage MB8",{"v":7,"d":"7.00 €"},"J"]
["Hydrocal",{"v":8,"d":"8.00 €"},"J"]
["Immobilisation bourreuse",{"v":9,"d":"9.00 €"},"Fft"]
["Location Héras",{"v":10,"d":"10.00 €"},"ml"]
["Matériel de sablage",{"v":11,"d":"11.00 €"},"J"]
["Matériel libé",{"v":12,"d":"12.00 €"},"J"]
["Matériel voie",{"v":13,"d":"13.00 €"},"J"]
["Mini-pelle 5 To",{"v":14,"d":"14.00 €"},"J"]
["Mini-pelle RR 8To",{"v":15,"d":"15.00 €"},"J"]
["Pelle à pneus 15 To",{"v":16,"d":"16.00 €"},"J"]
["Pelle RR",{"v":17,"d":"17.00 €"},"J"]
["Porte char",{"v":18,"d":"18.00 €"},"h"]
["Releveuse voie",{"v":19,"d":"19.00 €"},"J"]
["Rouleau 3,5 To",{"v":20,"d":"20.00 €"},"J"]
["Semi benne",{"v":21,"d":"21.00 €"},"h"]
["Semi plateau",{"v":22,"d":"22.00 €"},"h"]
["Transfert pelle",{"v":23,"d":"23.00 €"},"U"]
["Véhicule chef",{"v":24,"d":"24.00 €"},"J"]
["Véhicule conducteur d'engin",{"v":25,"d":"25.00 €"},"J"]
["Véhicule équipe",{"v":26,"d":"26.00 €"},"J"]
["WC chimique",{"v":27,"d":"27.00 €"},"J"]
{"$rows_empty":9}
["Fournitures","Prix","Unité"]
["Barrières Héras",{"v":1,"d":"1.00 €"},"ml"]
["Boulons",{"v":2,"d":"2.00 €"},"U"]
["Cales altimétriques",{"v":3,"d":"3.00 €"},"U"]
["Cornières 100x80x9 mm",{"v":4,"d":"4.00 €"},"ml"]
["Divers",{"v":5,"d":"5.00 €"},"U"]
["Entretoise 1600 mm",{"v":6,"d":"6.00 €"},"U"]
["Fiches métalliques",{"v":7,"d":"7.00 €"},"U"]
["Gabarit de pose",{"v":8,"d":"8.00 €"},"U"]
["GNT 0/31,5",{"v":9,"d":"9.00 €"},"To"]
["Grillage avertisseur orange",{"v":10,"d":"10.00 €"},"ml"]
["Parpaings",{"v":11,"d":"11.00 €"},"U"]
["Tire-pousses",{"v":12,"d":"12.00 €"},"U"]
{"$rows_empty":30}
["Sous-traitance","Prix","Unité"]
["Evacuation",{"v":2,"d":"2.00 €"},"To"]
["Evacuation pollué",{"v":1,"d":"1.00 €"},"To"]
{"$rows_empty":10}
["MO"]
["MAT"]
["FOUR"]
["SST"]