{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["métré détaillé base","métré détaillé présentation","Feuil1"],"not_rendered":{"macros":1,"external_links":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"métré détaillé base","index":0,"n_rows":14,"n_cols":25,"rows_kept":14,"merged":[[0,1,0,13],[1,1,1,10],[2,3,2,4],[2,5,2,6],[2,10,3,11],[2,12,3,13],[3,1,5,1],[3,2,5,2],[3,3,3,4],[3,5,3,7],[4,3,5,5],[4,6,5,7],[4,10,5,11],[4,12,5,13],[6,1,6,13],[7,2,7,13],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,8,7],[8,8,8,9],[8,10,9,10],[8,11,8,12],[8,13,9,13],[8,16,8,17],[8,18,9,18]]}
[]
[{"$nulls":23},"Mct","QP"]
[null,null,"Désignation du poste métré","Date",null,{"$f":"TODAY()","v":"2018-09-25"},{"$nulls":4},"Unité",null,"M2",{"$nulls":10},"M2","Fft"]
[{"$nulls":3},"Métreur",{"$nulls":19},"M3"]
[{"$nulls":3},"Quantité prévue",{"$nulls":6},"Type de marché",null,"QP",{"$nulls":10},"Pces"]
[{"$nulls":23},"Kg"]
[{"$nulls":23},"Fft"]
[null,{"v":1,"d":"Lot 1 :"},"Terrassement",{"$nulls":20},"Hrs"]
[null,"N°","Désignation des ouvrages","Elément","Nombre","Dimensions",null,null,"Quantités",null,"Unité","Quantités",null,"Unité",null,null,"Prix unitaire",null,"Prix total en € "]
[{"$nulls":5},"Long","Larg","Haut","+","-",null,"Partielles","Totales",{"$nulls":3},"Prix ","Unité"]
[null,{"$f":"B8+0.01","v":1.01},{"$nulls":10},{"$f":"SUM(I11:I14)-SUM(J11:J14)","v":0.06},"M2",null,null,5,{"$f":"N11","v":"M2"},{"$f":"M11*Q11","v":{"v":0.3,"d":"0.30 €"}},null,{"$f":"M11","v":0.06},{"$f":"N11","v":"M2"}]
[null,{"$f":"B11","v":1.01},null,null,1,{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},null,{"$f":"IF(E12>0,PRODUCT(E12:H12),\"\")","v":{"v":0.06,"d":"0.060"}},{"$f":"IF(E12<0,PRODUCT(E12:H12),\"\")","v":""},{"$f":"IF(E12=\"\",\"\",N11)","v":"M2"},{"$f":"IF(E12=\"\",\"\",SUM(I12:J12))","v":0.06},null,{"$f":"N11","v":"M2"}]
[null,{"$f":"B12","v":1.01},{"$nulls":6},{"$f":"IF(E13>0,PRODUCT(E13:H13),\"\")","v":""},{"$f":"IF(E13<0,PRODUCT(E13:H13),\"\")","v":""},{"$f":"IF(E13=\"\",\"\",N12)","v":""},{"$f":"IF(E13=\"\",\"\",SUM(I13:J13))","v":""},null,{"$f":"N12","v":"M2"}]
[null,{"$f":"B13","v":1.01}]

{"sheet":"métré détaillé présentation","index":1,"n_rows":40,"n_cols":25,"rows_kept":40,"merged":[[0,1,0,13],[1,1,1,10],[2,3,2,4],[2,5,2,6],[2,10,3,11],[2,12,3,13],[3,1,5,1],[3,2,5,2],[3,3,3,4],[3,5,3,7],[4,3,5,5],[4,6,5,7],[4,10,5,11],[4,12,5,13],[6,1,6,13],[7,2,7,13],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,8,7],[8,8,8,9],[8,10,9,10],[8,11,8,12],[8,13,9,13],[8,16,8,17],[8,18,9,18]]}
[]
[{"$nulls":23},"Mct","QP"]
[null,null,"Désignation du poste métré","Date",null,{"$f":"TODAY()","v":"2018-09-25"},{"$nulls":4},"Unité",null,"M2",{"$nulls":10},"M2","Fft"]
[{"$nulls":3},"Métreur",{"$nulls":19},"M3"]
[{"$nulls":3},"Quantité prévue",{"$nulls":6},"Type de marché",null,"QP",{"$nulls":10},"Pces"]
[{"$nulls":23},"Kg"]
[{"$nulls":23},"Fft"]
[null,{"v":1,"d":"Lot 1 :"},"Terrassement",{"$nulls":20},"Hrs"]
[null,"N°","Désignation des ouvrages","Elément","Nombre","Dimensions",null,null,"Quantités",null,"Unité","Quantités",null,"Unité",null,null,"Prix unitaire",null,"Prix total en € "]
[{"$nulls":5},"Long","Larg","Haut","+","-",null,"Partielles","Totales",{"$nulls":3},"Prix ","Unité"]
[null,{"$f":"B8+0.01","v":1.01},{"$nulls":10},{"$f":"SUM(I11:I23)-SUM(J11:J23)","v":1.44},"M2",null,null,5,{"$f":"N11","v":"M2"},{"$f":"M11*Q11","v":{"v":7.199999999999999,"d":"7.20 €"}},null,{"$f":"M11","v":1.44},{"$f":"N11","v":"M2"}]
[null,{"$f":"B11","v":1.01},null,null,1,{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},null,{"$f":"IF(E12>0,PRODUCT(E12:H12),\"\")","v":{"v":0.06,"d":"0.060"}},{"$f":"IF(E12<0,PRODUCT(E12:H12),\"\")","v":""},{"$f":"IF(E12=\"\",\"\",N11)","v":"M2"},{"$f":"IF(E12=\"\",\"\",SUM(I12:J12))","v":0.06},null,{"$f":"N11","v":"M2"}]
[null,1.01,null,null,2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.12,"d":"0.120"},"","M2",0.12,null,"M2"]
[null,1.01,null,null,1,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.06,"d":"0.060"},"","M2",0.06,null,"M2"]
[null,1.01,null,null,1,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.06,"d":"0.060"},"","M2",0.06,null,"M2"]
[null,1.01,null,null,3,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.18,"d":"0.180"},"","M2",0.18,null,"M2"]
[null,1.01,null,null,-2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,"",{"v":-0.12,"d":"-0.120"},"M2",-0.12,null,"M2"]
[null,1.01,null,null,6,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.36,"d":"0.360"},"","M2",0.36,null,"M2"]
[null,1.01,null,null,3,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.18,"d":"0.180"},"","M2",0.18,null,"M2"]
[null,1.01,null,null,2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.12,"d":"0.120"},"","M2",0.12,null,"M2"]
[null,1.01,null,null,3,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,{"v":0.18,"d":"0.180"},"","M2",0.18,null,"M2"]
[null,1.01,{"$nulls":6},"","","","",null,"M2"]
[null,1.01]
[null,{"$f":"B21+0.01","v":1.02},{"$nulls":10},{"$f":"SUM(I24:I33)-SUM(J24:J33)","v":{"v":2.922,"d":"2.92"}},"M3",null,null,5,{"$f":"N24","v":"M3"},{"$f":"M24*Q24","v":{"v":14.610000000000001,"d":"14.61 €"}},null,{"$f":"M24","v":{"v":2.922,"d":"2.92"}},{"$f":"N24","v":"M3"}]
[null,{"$f":"B24","v":1.02},null,null,2,{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},{"v":1.2,"d":"1.20"},{"$f":"IF(E25>0,PRODUCT(E25:H25),\"\")","v":0.144},{"$f":"IF(E25<0,PRODUCT(E25:H25),\"\")","v":""},{"$f":"IF(E25=\"\",\"\",N24)","v":"M3"},{"$f":"IF(E25=\"\",\"\",SUM(I25:J25))","v":{"v":0.144,"d":"0.14"}},null,{"$f":"N24","v":"M3"}]
[null,{"$f":"B25","v":1.02},null,null,2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},{"v":1.6,"d":"1.60"},0.192,"",{"$f":"IF(E26=\"\",\"\",N25)","v":"M3"},{"v":0.192,"d":"0.19"},null,{"$f":"N25","v":"M3"}]
[null,1.02,null,null,6,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},{"v":1.8,"d":"1.80"},0.648,"",{"$f":"IF(E27=\"\",\"\",N26)","v":"M3"},{"v":0.648,"d":"0.65"},null,{"$f":"N26","v":"M3"}]
[null,1.02,null,null,-4,{"v":0.3,"d":"0.30"},{"v":0.5,"d":"0.50"},{"v":1.8,"d":"1.80"},"",{"v":-1.08,"d":"-1.080"},{"$f":"IF(E28=\"\",\"\",N27)","v":"M3"},-1.08,null,{"$f":"N27","v":"M3"}]
[null,1.02,null,null,-2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},{"v":6,"d":"6.00"},"",{"v":-0.72,"d":"-0.720"},"M3",-0.72,null,"M3"]
[null,1.02,null,null,2,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},{"v":0.7,"d":"0.70"},{"v":0.08399999999999999,"d":"0.084"},"",{"$f":"IF(E30=\"\",\"\",N29)","v":"M3"},{"v":0.08399999999999999,"d":"0.08"},null,"M3"]
[null,1.02,null,null,3,{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},{"v":0.3,"d":"0.30"},0.054,"",{"$f":"IF(E31=\"\",\"\",N30)","v":"M3"},{"v":0.054,"d":"0.05"},null,"M3"]
[null,1.02,{"$nulls":6},"","",{"$f":"IF(E32=\"\",\"\",N31)","v":""},"",null,"M3"]
[null,1.02]
[null,{"$f":"B31+0.01","v":1.03},{"$nulls":10},{"$f":"SUM(I34:I40)-SUM(J34:J40)","v":{"v":2.5999999999999996,"d":"2.60"}},"Mct",null,null,5,{"$f":"N34","v":"Mct"},{"$f":"M34*Q34","v":{"v":12.999999999999998,"d":"13.00 €"}},null,{"$f":"M34","v":{"v":2.5999999999999996,"d":"2.60"}},{"$f":"N34","v":"Mct"}]
[null,{"$f":"B34","v":1.03},null,null,1,{"v":0.2,"d":"0.20"},null,null,{"$f":"IF(E35>0,PRODUCT(E35:H35),\"\")","v":{"v":0.2,"d":"0.200"}},{"$f":"IF(E35<0,PRODUCT(E35:H35),\"\")","v":""},{"$f":"IF(E35=\"\",\"\",N34)","v":"Mct"},{"$f":"IF(E35=\"\",\"\",SUM(I35:J35))","v":{"v":0.2,"d":"0.20"}},null,{"$f":"N34","v":"Mct"}]
[null,{"$f":"B35","v":1.03},null,null,3,{"v":0.3,"d":"0.30"},null,null,{"$f":"IF(E36>0,PRODUCT(E36:H36),\"\")","v":{"v":0.8999999999999999,"d":"0.900"}},{"$f":"IF(E36<0,PRODUCT(E36:H36),\"\")","v":""},{"$f":"IF(E36=\"\",\"\",N35)","v":"Mct"},{"$f":"IF(E36=\"\",\"\",SUM(I36:J36))","v":{"v":0.8999999999999999,"d":"0.90"}},null,{"$f":"N35","v":"Mct"}]
[null,1.03,null,null,2,{"v":0.3,"d":"0.30"},null,null,{"$f":"IF(E37>0,PRODUCT(E37:H37),\"\")","v":{"v":0.6,"d":"0.600"}},{"$f":"IF(E37<0,PRODUCT(E37:H37),\"\")","v":""},"Mct",{"$f":"IF(E37=\"\",\"\",SUM(I37:J37))","v":{"v":0.6,"d":"0.60"}},null,"Mct"]
[null,1.03,null,null,3,{"v":0.3,"d":"0.30"},null,null,{"$f":"IF(E38>0,PRODUCT(E38:H38),\"\")","v":{"v":0.8999999999999999,"d":"0.900"}},{"$f":"IF(E38<0,PRODUCT(E38:H38),\"\")","v":""},"Mct",{"$f":"IF(E38=\"\",\"\",SUM(I38:J38))","v":{"v":0.8999999999999999,"d":"0.90"}},null,"Mct"]
[null,1.03,{"$nulls":6},{"$f":"IF(E39>0,PRODUCT(E39:H39),\"\")","v":""},{"$f":"IF(E39<0,PRODUCT(E39:H39),\"\")","v":""},{"$f":"IF(E39=\"\",\"\",N38)","v":""},{"$f":"IF(E39=\"\",\"\",SUM(I39:J39))","v":""},null,"Mct"]
[null,1.03]

{"sheet":"Feuil1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}