{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Feuil1","index":0,"n_rows":104,"n_cols":31,"rows_kept":104,"cut":false,"hidden":false,"merged":[[30,30,33,30],[89,28,92,28],[89,30,92,30],[90,2,92,2],[91,16,92,16],[35,14,38,14],[35,28,38,28],[35,30,38,30],[36,2,38,2],[37,16,38,16],[84,14,87,14],[32,29,33,29],[25,30,28,30],[85,2,87,2],[86,16,87,16],[7,2,7,30],[27,16,28,16],[32,16,33,16],[30,28,33,28],[20,28,23,28],[15,28,18,28],[10,28,13,28],[10,30,13,30],[15,30,18,30],[20,30,23,30],[35,29,36,29],[37,29,38,29],[84,30,87,30],[96,2,96,13],[42,2,42,13],[89,14,92,14],[76,2,76,30],[79,14,82,14],[79,28,82,28],[79,30,82,30],[80,2,82,2],[81,16,82,16],[84,28,87,28],[22,16,23,16],[31,2,33,2],[11,2,13,2],[16,2,18,2],[21,2,23,2],[26,2,28,2],[17,16,18,16],[12,16,13,16],[10,14,13,14],[15,14,18,14],[20,14,23,14],[25,14,28,14],[30,14,33,14],[25,28,28,28],[22,29,23,29],[25,29,26,29],[27,29,28,29],[30,29,31,29],[10,29,11,29],[12,29,13,29],[15,29,16,29],[17,29,18,29],[20,29,21,29]]}
["TRAITE"]
["REGLE"]
["HT"]
["%"]
["TVA"]
["TTC",null,"ENTREPRISES",null,"REMARQUES",null,"MARCHE ","AV.1","AV.2","AV.3","AV.4","AV.5","TOTAL ",null,null,"REMARQUES",null,"ACC","FA.1","FA.2","FA.3","FA.4","FA.5","FA.6","FA.7","FA.8","FA.9","FA.10","DÉJÀ REGLE TTC","RETENU DE GARANTI","RESTE A REGLE TTC"]
[]
[null,null,"ETUDES"]
[null,null,"ENTREPRISES",null,"REMARQUES",null,"MARCHE ","AV.1","AV.2","AV.3","AV.4","AV.5","TOTAL ",null,null,"REMARQUES",null,"ACC","FA.1","FA.2","FA.3","FA.4","FA.5","FA.6","FA.7","FA.8","FA.9","FA.10","DÉJÀ REGLE TTC","RETENU DE GARANTI","RESTE A REGLE TTC"]
[]
[null,null,"G",null,null,"HT",2780,null,null,null,null,null,{"$f":"SUM(G11:L11)","v":2780},"HT",{"$f":"C11","v":"G"},null,"Montant",null,{"$f":"M14","v":3336},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R11:AB11*(R13:AB13<>\"\"))","v":3336},"%",{"$f":"M14-AC11-AD13","v":0}]
[null,null,"Plan de topographie & bornage ",null,null,"%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G11*G12","v":556},null,null,null,null,null,{"$f":"SUM(G13:L13)","v":556},"TVA",null,null,"Règlement",null,"2015-08-10"]
[null,null,null,null,null,"TTC",{"$f":"G11+G13","v":3336},null,null,null,null,null,{"$f":"SUM(G14:L14)","v":3336},"TTC"]
[]
[null,null,"I",null,null,"HT",4800,null,null,null,null,null,{"$f":"SUM(G16:L16)","v":4800},"HT",{"$f":"C16","v":"I"},null,"Montant",null,{"$f":"(M19*30%)","v":1728},null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R16:AB16*(R18:AB18<>\"\"))","v":1728},"%",{"$f":"M19-AC16-AD18","v":4032}]
[null,null,"Bureau étude structure & charpente",null,null,"%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques",null,0.3]
[null,null,null,null,null,"TVA",{"$f":"G16*G17","v":960},null,null,null,null,null,{"$f":"SUM(G18:L18)","v":960},"TVA",null,null,"Règlement",null,"10.08.2015"]
[null,null,null,null,null,"TTC",{"$f":"G16+G18","v":5760},null,null,null,null,null,{"$f":"SUM(G19:L19)","v":5760},"TTC",null,null,null,null,"0000802"]
[]
[null,null,"E",null,null,"HT",2900,null,null,null,null,null,{"$f":"SUM(G21:L21)","v":2900},"HT",{"$f":"C21","v":"E"},null,"Montant",{"$f":"M24*R22","v":1044},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R21:AB21*(R23:AB23<>\"\"))","v":1044},"%",{"$f":"M24-AC21-AD23","v":2436}]
[null,null,"Etude de sol",null,null,"%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques",0.3]
[null,null,null,null,null,"TVA",{"$f":"G21*G22","v":580},null,null,null,null,null,{"$f":"SUM(G23:L23)","v":580},"TVA",null,null,"Règlement","25.08.2015"]
[null,null,null,null,null,"TTC",{"$f":"G21+G23","v":3480},null,null,null,null,null,{"$f":"SUM(G24:L24)","v":3480},"TTC",null,null,null,"SG.0000803"]
[]
[null,null,"M",null,null,"HT",700,null,null,null,null,null,{"$f":"SUM(G26:L26)","v":700},"HT",{"$f":"C26","v":"M"},null,"Montant",200,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R26:AB26*(R28:AB28<>\"\"))","v":200},"%",{"$f":"M29-AC26-AD28","v":640}]
[null,null,"Etude thermique",null,null,"%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G26*G27","v":140},null,null,null,null,null,{"$f":"SUM(G28:L28)","v":140},"TVA",null,null,"Règlement","18.11.2015"]
[null,null,null,null,null,"TTC",{"$f":"G26+G28","v":840},null,null,null,null,null,{"$f":"SUM(G29:L29)","v":840},"TTC",null,null,null,"0000803"]
[]
[null,null,"A",null,null,"HT",1370,null,null,null,null,null,{"$f":"SUM(G31:L31)","v":1370},"HT",{"$f":"C31","v":"A"},null,"Montant",0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R31:AB31*(R33:AB33<>\"\"))","v":0},"%",{"$f":"M34-AC31-AD33","v":1644}]
[null,null,"Diagnostique amiante",null,null,"%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G31*G32","v":274},null,null,null,null,null,{"$f":"SUM(G33:L33)","v":274},"TVA",null,null,"Règlement"]
[null,null,null,null,null,"TTC",{"$f":"G31+G33","v":1644},null,null,null,null,null,{"$f":"SUM(G34:L34)","v":1644},"TTC"]
[]
[null,null,"P",null,null,"HT",0,null,null,null,null,null,{"$f":"SUM(G36:L36)","v":0},"HT",{"$f":"C36","v":"P"},null,"Montant",0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(R36:AB36*(R38:AB38<>\"\"))","v":0},"%",{"$f":"M39-AC36-AD38","v":0}]
[null,null,"Economiste de la construction",null,"2% HT du Total Travaux HT","%",0.2,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G36*G37","v":0},null,null,null,null,null,{"$f":"SUM(G38:L38)","v":0},"TVA",null,null,"Règlement"]
[null,null,null,null,null,"TTC",{"$f":"G36+G38","v":0},null,null,null,null,null,{"$f":"SUM(G39:L39)","v":0},"TTC"]
[]
[]
[]
[null,null,"RECAPITULATIF ETUDE"]
[null,null,null,null,null,null,"HT","TVA","TTC"]
[]
[null,null,null,null,"MARCHES",null,{"$f":"SUM(G11,G16,G21,G26,G31,G36)","v":12550},{"$f":"SUM(G13,G18,G23,G28,G33,G38)","v":2510},{"$f":"G46+H46","v":15060}]
[null,null,null,null,"AVENANTS",null,{"$f":"SUM(H11:L11,H16:L16,H21:L21,H26:L26,H31:L31,H36:L36)","v":0},{"$f":"SUM(H13:L13,H18:L18,H23:L23,H28:L28,H33:L33,H38:L38)","v":0},{"$f":"G47+H47","v":0}]
[null,null,null,null,"MARCHES + AVENANTS",null,{"$f":"G46+G47","v":12550},{"$f":"H46+H47","v":2510},{"$f":"I46+I47","v":15060}]
[null,null,null,null,"DÉJÀ REGLE",null,null,null,{"$f":"SUM(AC11:AC41)","v":6308}]
[null,null,null,null,"RESTE A REGLER",null,null,null,{"$f":"SUM(AE11:AE41)","v":8752}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TRAVAUX"]
[null,null,"ENTREPRISES",null,"REMARQUES",null,"MT","AV.1","AV.2","AV.3","AV.4","AV.5","TOTAL  TRAVAUX",null,null,"REMARQUES",null,"ACC","FA.1","FA.2","FA.3","FA.4","FA.5","FA.6","FA.7","FA.8","FA.9","FA.10","DÉJÀ REGLE",null,"RESTE A REGLE"]
[]
[null,null,"LOT 1 - ",null,null,"HT",0,null,null,null,null,null,{"$f":"SUM(G80:L80)","v":0},"HT",{"$f":"C80","v":"LOT 1 - "},null,"Montant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SOMME_SI_COULEUR(R80:AB80,A2)","v":0},null,{"$f":"M83-AC80","v":0}]
[null,null,null,null,null,"%",0,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G80*G81","v":0},null,null,null,null,null,{"$f":"SUM(G82:L82)","v":0},"TVA",null,null,"Règlement"]
[null,null,null,null,null,"TTC",{"$f":"G80+G82","v":0},null,null,null,null,null,{"$f":"SUM(G83:L83)","v":0},"TTC"]
[]
[null,null,"LOT 2 - ",null,null,"HT",0,null,null,null,null,null,{"$f":"SUM(G85:L85)","v":0},"HT",{"$f":"C85","v":"LOT 2 - "},null,"Montant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SOMME_SI_COULEUR(R85:AB85,A6)","v":0},null,{"$f":"M88-AC85","v":0}]
[null,null,null,null,null,"%",0,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G85*G86","v":0},null,null,null,null,null,{"$f":"SUM(G87:L87)","v":0},"TVA",null,null,"Règlement"]
[null,null,null,null,null,"TTC",{"$f":"G85+G87","v":0},null,null,null,null,null,{"$f":"SUM(G88:L88)","v":0},"TTC"]
[]
[null,null,"LOT 3 - ",null,null,"HT",0,null,null,null,null,null,{"$f":"SUM(G90:L90)","v":0},"HT",{"$f":"C90","v":"LOT 3 - "},null,"Montant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SOMME_SI_COULEUR(R90:AB90,A20)","v":0},null,{"$f":"M93-AC90","v":0}]
[null,null,null,null,null,"%",0,null,null,null,null,null,null,"%",null,null,"Remarques"]
[null,null,null,null,null,"TVA",{"$f":"G90*G91","v":0},null,null,null,null,null,{"$f":"SUM(G92:L92)","v":0},"TVA",null,null,"Règlement"]
[null,null,null,null,null,"TTC",{"$f":"G90+G92","v":0},null,null,null,null,null,{"$f":"SUM(G93:L93)","v":0},"TTC"]
[]
[]
[]
[null,null,"RECAPITULATIF TRAVAUX"]
[null,null,null,null,null,null,"HT","TVA","TTC"]
[]
[null,null,null,null,"MARCHES",null,{"$f":"cumul_couleur(G79:G95,A3)","v":0},{"$f":"cumul_couleur(G79:G95,A5)","v":0},{"$f":"cumul_couleur(G79:G95,A6)","v":0}]
[null,null,null,null,"AVENANTS",null,{"$f":"cumul_couleur(H80:L95,A3)","v":0},{"$f":"cumul_couleur(H79:L95,A5)","v":0},{"$f":"cumul_couleur(H79:L95,A24)","v":0}]
[null,null,null,null,"MARCHES + AVENANTS",null,{"$f":"G100+G101","v":0},{"$f":"H100+H101","v":0},{"$f":"I100+I101","v":0}]
[null,null,null,null,"DÉJÀ REGLE",null,null,null,{"$f":"SUM(AC79:AC95)","v":0}]
[null,null,null,null,"RESTE A REGLER",null,null,null,{"$f":"SUM(AE79:AE95)","v":0}]

{"sheet":"Feuil2","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"LISTE DE CHOIX"]

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}