{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NE PAS TOUCHER","Juin","Juillet","BORDEREAU D'ENVOI"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"1904"}

{"sheet":"NE PAS TOUCHER","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Pas de situation sur le mois"]
["Situation présentée hors délai"]
["Pénalités appliquées"]
["Avancement surévalué"]
["En attente validation MOE"]
["Caution bancaire jointe"]
["Visa Hors Marché"]
["Voir pénalités + CIE"]
["Montant BP # de la facture"]
["Manque CIE"]
["Manque CP sur facture"]
["Manque CP + retenue \"bonne fin de chantier\" sur facture"]
["Attente situation rectifiée"]
["Manque retenue \"bonne fin de chantier\" sur facture"]
["CIE sur mauvaise ligne"]
["Attente format papier"]
["Déjà envoyée"]
["Compte Prorata"]

{"sheet":"Juin","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,9],[8,0,9,0],[8,1,9,1],[8,9,9,9],[8,2,9,2],[8,3,9,3],[8,5,9,5],[8,6,8,7],[8,4,9,4],[8,8,9,8]]}
[]
["RECEPTION DES SITUATIONS DE TRAVAUX"]
[]
["RESIDENCE : ",null,null,"Resp. affaire :"]
[]
["SITUATION AU :","30/06/2019",null,"Nb exemplaires facture :",null,null,null,"04"]
[null,{"$f":"TEXT(B6,\"Mmmm aaaa\")","v":"juin 2019"}]
[]
["ENTREPRISES","SITUATION\nN°","RECUE\nLE ","@","C","S","CONFORME",null,"OBSERVATIONS","TRAITEE LE"]
[null,null,null,null,null,null,"OUI","NON"]
[null,"06","2019-06-26",null,"X","X","X",null,"Caution bancaire jointe"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"02","2019-06-27",null,"X","X","X"]
[null,"01","2019-06-24","X","X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"02","2019-06-24",null,"X","X","X"]
[null,"01","2019-06-17","X","X","X","X"]
[null,"02","2019-06-17",null,"X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"02","2019-06-24","X","X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"04","2019-06-18","X","X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[]
[]
["Bordereau de paiement obligatoire"]
["Enveloppe fournie"]
["@ : situation reçue par mail"]
["S : Situation saisie"]

{"sheet":"Juillet","index":2,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,9],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,8,7],[8,8,9,8],[8,9,9,9]]}
[]
["RECEPTION DES SITUATIONS DE TRAVAUX"]
[]
["RESIDENCE : ",{"$f":"'[1]ACTE D''ENGAGEMENT'!$A$2","v":"PARC DES VERDIERS"},null,"Resp. affaire :",null,null,"Sylvain EGGERT"]
[]
["SITUATION AU :","31/07/2019",null,"Nb exemplaires facture :",null,null,null,"04"]
[null,{"$f":"TEXT(B6,\"Mmmm aaaa\")","v":"juillet 2019"}]
[]
["ENTREPRISES","SITUATION\nN°","RECUE\nLE ","@","C","S","CONFORME",null,"OBSERVATIONS","TRAITEE LE"]
[null,null,null,null,null,null,"OUI","NON"]
[null,"07","2019-07-19",null,"X","X","X"]
[null,"01","2019-07-23",null,"X","X","X",null,"Compte Prorata"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"03","2019-07-25",null,"X","X","X"]
[null,"02","2019-07-23",null,"X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"03","2019-07-24","X","X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"02","2019-07-05",null,"X","X","X"]
[null,"01","2019-07-25",null,"X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
["Bordereau de paiement obligatoire"]
["Enveloppe fournie"]
["@ : situation reçue par mail"]
["S : Situation saisie"]

{"sheet":"BORDEREAU D'ENVOI","index":3,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,1,11,11],[15,11,15,12],[21,1,22,5],[21,6,22,8],[21,9,21,11],[15,2,15,3],[13,10,13,11],[23,2,23,5],[23,6,23,8],[25,2,25,5],[25,6,25,8],[26,2,26,5],[26,6,26,8],[24,2,24,5],[24,6,24,8],[27,2,27,5],[27,6,27,8],[28,2,28,5],[28,6,28,8],[29,2,29,5],[29,6,29,8],[30,2,30,5],[30,6,30,8],[31,2,31,5],[31,6,31,8],[32,2,32,5],[32,6,32,8],[38,6,38,8],[33,2,33,5],[33,6,33,8],[34,2,34,5],[34,6,34,8],[35,2,35,5],[35,6,35,8],[9,9,9,12],[41,2,41,5],[43,2,43,5],[41,6,41,8],[43,6,43,8],[42,2,42,5],[42,6,42,8],[39,2,39,5],[39,6,39,8],[40,2,40,5],[40,6,40,8],[36,2,36,5],[36,6,36,8],[37,2,37,5],[37,6,37,8],[38,2,38,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BORDEREAU D’ENVOI"]
[]
[null,"Objet :",{"$f":"Juin!B4","v":0},null,null,null,null,null,null,"MERIGNAC, le",{"$f":"TODAY()","v":"2019-08-01"}]
[]
[null,"Situation au : ",{"$f":"offsetfeuil(-1,$B$6)","v":"31/07/2019"}]
[]
[null,"Madame, Monsieur,"]
[]
[null,{"$f":"\"Nous vous prions de bien vouloir trouver, ci-jont, en 3 exemplaires, les situations de travaux à fin \"&Juin!$B$7&\" de :\"","v":"Nous vous prions de bien vouloir trouver, ci-jont, en 3 exemplaires, les situations de travaux à fin juin 2019 de :"}]
[]
[null,"Lot",null,null,null,null,"Entreprise",null,null,"MOE (ALM REALISATION)"]
[null,null,null,null,null,null,null,null,null,"Date de réception \"situation entreprise\"","N°","Observations"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C2","v":"01"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D2","v":"FONDATIONS  - GO"},null,null,null,null,null,null,{"$f":"offsetfeuil(-1,C11)","v":"2019-07-19"},{"$f":"offsetfeuil(-1,B11)","v":"07"},{"$f":"offsetfeuil(-1,I11)","v":0}]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C2","v":"01"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D2","v":"FONDATIONS  - GO"},null,null,null,null,null,null,{"$f":"offsetfeuil(-1,C12)","v":"2019-07-23"},"01",{"$f":"offsetfeuil(-1,I12)","v":"Compte Prorata"}]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C3","v":"02"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D3","v":"ETANCHEITE "},null,null,null,null,null,null,{"$f":"offsetfeuil(-1,C13)","v":"1904-01-01"},0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C4","v":"03"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D4","v":"CHARPENTE "},null,null,null,null,null,null,{"$f":"offsetfeuil(-1,C14)","v":"2019-07-25"},{"$f":"offsetfeuil(-1,B14)","v":"03"},0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C5","v":"04"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D5","v":"COUVERTURE – ZINGUERIE"},null,null,null,null,null,null,"2019-07-23","02",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C6","v":"05"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D6","v":"ENDUIT EXTERIEUR – PLACAGE PIERRE"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C7","v":"06"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D7","v":"MENUISERIE PVC"},null,null,null,null,null,null,"2019-07-24","03",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C8","v":"07"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D8","v":"PLOMBERIE – SANITAIRE - VMC – GAZ  "},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C9","v":"08"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D9","v":"COURANT FORT - COURANT FAIBLE "},null,null,null,null,null,null,"2019-07-05","02",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C10","v":"09"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D10","v":"PLATRERIE - CLOISONS - DOUBLAGES - PLAFONDS"},null,null,null,null,null,null,"2019-07-25","01",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C11","v":"10"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D11","v":"ISOLATION COMBLE – FLOCAGE"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C12","v":"11"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D12","v":"MENUISERIE INTERIEURE "},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C13","v":"12"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D13","v":"CARRELAGE – FAIENCE "},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C14","v":"13"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D14","v":"SOLS SOUPLES"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C15","v":"14"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D15","v":"PEINTURE - REVETEMENTS MURAUX "},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C16","v":"15"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D16","v":"METALLERIE"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C17","v":"16"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D17","v":"PORTAIL BASCULANT"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C18","v":"17"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D18","v":"ESCALIER BOIS / GARDE CORPS"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C19","v":"18"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D19","v":"VOIRIES  - RESEAUX – DIVERS  - EU/EP – RESEAU FT ET EP "},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C20","v":"19"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D20","v":"ESPACES VERTS"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!C21","v":"20"},{"$f":"'[1]ACTE D''ENGAGEMENT'!D21","v":"CUISINE"},null,null,null,null,null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[]
[null,null,null,null,null,null,null,null,null,null,"SIGNATURE MOE"]