{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SYNTHESE","Sommaire"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"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":"SYNTHESE","index":0,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,10,16,11],[0,1,0,2],[11,9,11,10],[5,6,5,8],[4,3,4,20],[5,9,5,12],[5,14,5,16],[5,17,5,20],[5,3,5,5],[19,1,19,6],[17,2,18,2],[17,6,18,6],[17,1,18,1],[18,9,18,10]]}
["TABLEAU SYNTHESE","TABLEAU SYNTHESE"]
[]
[]
[]
[null,"Synthèse suivi au ","DateSitu","NOM CHANTIER"]
[null,null,"Marché",null,null,null,null,null,null,null,null,null,null,null,"Reste à facturer/dépenser",null,null,"ATTERISSAGE"]
[null,null,"Marché Ht","Debs Ht","Marge Ht","coeff","Debs Ht","Marge Ht","coeff","Facturé HT","Dépensé HT","Marge Ht","coeff",null,"Reste à facturer","Reste à dépenser","Estim dépenses restantes","DGD","TOTAL DEPENSE","MARGE","Coeff"]
[{"$f":"IF(B8=\"\",\"\",IF(OFFSET(Sommaire!$M$4,ROWS($1:2),0)=\"\",OFFSET(Sommaire!O$3,ROWS($1:2)-COUNTA(Sommaire!$M$6:$M$23),0),OFFSET(Sommaire!L$4,ROWS($1:2),0)))","v":11},"Démolition",null,null,{"$f":"IF(OR(D8=\"\",C8=\"\")=FALSE,D8-D8,\"\")","v":""},{"$f":"IF(OR(D8=\"\",C8=\"\",D8=0)=FALSE,C8/D8,\"\")","v":""},null,{"$f":"IF(OR(G8=\"\",C8=\"\")=FALSE,C8-G8,\"\")","v":""},{"$f":"IF(OR(G8=\"\",C8=\"\",G8=0)=FALSE,C8/G8,\"\")","v":""},null,{"$f":"VLOOKUP(A8,#REF!,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(OR(K8=\"\",J8=\"\")=FALSE,J8-K8,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR(K8=\"\",J8=\"\",K8=0)=FALSE,J8/K8,\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF(AND(J8=\"\",K8=\"\")=TRUE,\"\",C8-J8)","v":{"$error":"#REF!"}},{"$f":"IF(G8=\"\",\"\",IF(G8-K8<0,\"0 €\",G8-K8))","v":""},null,{"$f":"IF(O8=\"\",\"\",O8+J8)","v":{"$error":"#REF!"}},{"$f":"IF(AND(Q8=\"\",K8=\"\")=TRUE,\"\",+K8+Q8)","v":{"$error":"#REF!"}},{"$f":"IF(S8=\"\",\"\",+R8-S8)","v":{"$error":"#REF!"}},{"$f":"IF(Q8=\"\",\"\",R8/S8)","v":""}]
[{"$f":"IF(B9=\"\",\"\",IF(OFFSET(Sommaire!$M$4,ROWS($1:3),0)=\"\",OFFSET(Sommaire!O$3,ROWS($1:3)-COUNTA(Sommaire!$M$6:$M$23),0),OFFSET(Sommaire!L$4,ROWS($1:3),0)))","v":101},"TS1 : …",null,null,{"$f":"IF(OR(D9=\"\",C9=\"\")=FALSE,D9-D9,\"\")","v":""},{"$f":"IF(OR(D9=\"\",C9=\"\",D9=0)=FALSE,C9/D9,\"\")","v":""},null,{"$f":"IF(OR(G9=\"\",C9=\"\")=FALSE,C9-G9,\"\")","v":""},{"$f":"IF(OR(G9=\"\",C9=\"\",G9=0)=FALSE,C9/G9,\"\")","v":""},null,{"$f":"VLOOKUP(A9,#REF!,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(OR(K9=\"\",J9=\"\")=FALSE,J9-K9,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR(K9=\"\",J9=\"\",K9=0)=FALSE,J9/K9,\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF(AND(J9=\"\",K9=\"\")=TRUE,\"\",C9-J9)","v":{"$error":"#REF!"}},{"$f":"IF(G9=\"\",\"\",IF(G9-K9<0,\"0 €\",G9-K9))","v":""},null,{"$f":"IF(O9=\"\",\"\",O9+J9)","v":{"$error":"#REF!"}},{"$f":"IF(AND(Q9=\"\",K9=\"\")=TRUE,\"\",+K9+Q9)","v":{"$error":"#REF!"}},{"$f":"IF(S9=\"\",\"\",+R9-S9)","v":{"$error":"#REF!"}},{"$f":"IF(Q9=\"\",\"\",R9/S9)","v":""}]
[{"$f":"IF(B10=\"\",\"\",IF(OFFSET(Sommaire!$M$4,ROWS($1:4),0)=\"\",OFFSET(Sommaire!O$3,ROWS($1:4)-COUNTA(Sommaire!$M$6:$M$23),0),OFFSET(Sommaire!L$4,ROWS($1:4),0)))","v":102},"essai",null,null,{"$f":"IF(OR(D10=\"\",C10=\"\")=FALSE,D10-D10,\"\")","v":""},{"$f":"IF(OR(D10=\"\",C10=\"\",D10=0)=FALSE,C10/D10,\"\")","v":""},null,{"$f":"IF(OR(G10=\"\",C10=\"\")=FALSE,C10-G10,\"\")","v":""},{"$f":"IF(OR(G10=\"\",C10=\"\",G10=0)=FALSE,C10/G10,\"\")","v":""},null,{"$f":"VLOOKUP(A10,#REF!,6,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(OR(K10=\"\",J10=\"\")=FALSE,J10-K10,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(OR(K10=\"\",J10=\"\",K10=0)=FALSE,J10/K10,\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF(AND(J10=\"\",K10=\"\")=TRUE,\"\",C10-J10)","v":{"$error":"#REF!"}},{"$f":"IF(G10=\"\",\"\",IF(G10-K10<0,\"0 €\",G10-K10))","v":""},null,{"$f":"IF(O10=\"\",\"\",O10+J10)","v":{"$error":"#REF!"}},{"$f":"IF(AND(Q10=\"\",K10=\"\")=TRUE,\"\",+K10+Q10)","v":{"$error":"#REF!"}},{"$f":"IF(S10=\"\",\"\",+R10-S10)","v":{"$error":"#REF!"}},{"$f":"IF(Q10=\"\",\"\",R10/S10)","v":""}]
[null,"TOTAL HT",{"$f":"SUM(C$8:C$10)","v":0},0,0,0,0,0,0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0,{"$error":"#REF!"},0,0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0,0]
[null,null,null,null,null,null,null,null,null,"PRORATA"]
[null,null,null,null,null,null,null,null,null,"Facturé HT","Dépensé HT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Sommaire!M5=\"\",0,VLOOKUP(0,#REF!,6,FALSE))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J14,J11)","v":0},{"$f":"SUM(K14,K11)","v":{"$error":"#REF!"}},{"$f":"J16-K16","v":{"$error":"#REF!"}},{"$f":"IF(K29=0,0,J29/K29)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Marge prorata compris"]
[null,{"$f":"D5","v":"NOM CHANTIER"}," MARGE",null,null,null,{"$f":"M29","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"EN COURS"]
[null,"(prorata et \"en cours\" compris)",null,null,null,null,null,null,null,"Facturé HT","Dépensé HT"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(K14=\"\",\"\",K14*(1-#REF!)-J14+(K14-J14)*#REF!)","v":{"$error":"#REF!"}},null,"Prorata Non Facturé"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,"Fait & Non Facturé"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},"Dépense à recevoir"]
[null,null,null,null,null,null,null,null,null,{"$f":"-SUM(#REF!)","v":{"$error":"#REF!"}},null,"Facturé & Non fait"]
[null,null,null,null,null,null,null,null,null,null,null,"Litiges/Stock"]
[null,null,null,null,null,null,null,null,null,null,null,"Autres"]
[null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J21:J26)","v":{"$error":"#REF!"}},{"$f":"SUM(K21:K26)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J16=0,J11,SUM(J27,J16))","v":0},{"$f":"IF(K16=0,K11,SUM(K27,K16))","v":{"$error":"#REF!"}},{"$f":"J29-K29","v":{"$error":"#REF!"}},{"$f":"IF(K29=0,0,J29/K29)","v":{"$error":"#REF!"}}]

{"sheet":"Sommaire","index":1,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[36,24,36,25],[41,24,42,24],[1,11,1,12],[3,11,3,12],[3,14,3,15],[1,13,1,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL MONTANT",null,{"$f":"SUM(F2:F10)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CODE TÂCHE MARCHE",null,null,"CODE TÂCHE T.S."]
[null,null,null,null,null,null,null,null,null,null,null,0,"Prorata",null,101,"TS1 : …"]
[null,null,null,null,null,null,null,null,null,null,null,11,"Démolition",null,102,"essai"]
[null,null,null,null,null,null,null,null,null,null,null,12,null,null,103]
[null,null,null,null,null,null,null,null,null,null,null,21,null,null,104]
[null,null,null,null,null,null,null,null,null,null,null,4,null,null,105]
[null,null,null,null,null,null,null,null,null,null,null,5,null,null,106]
[null,null,null,null,null,null,null,null,null,null,null,6,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,7,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,8,null,null,109]
[null,null,null,null,null,null,null,null,null,null,null,9,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,10,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,11,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,12,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,13,null,null,114]
[null,null,null,null,null,null,null,null,null,null,null,14,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,15,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,16,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,17,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,18,null,null,119]