{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["NE PAS TOUCHER","Juin","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":15,"n_cols":1,"rows_kept":15,"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 + 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"]

{"sheet":"Juin","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"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,"03"]
[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,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,"05","2019-07-01",null,"X","X","X"]
[null,"15","2019-06-19",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,"11","2019-06-03",null,"X","X",null,"X","Attente situation rectifiée"]
[null,"10","2019-06-28","X","X","X","X"]
[null,"09 / 10","2019-06-21","X","X","X",null,"X","Attente situation rectifiée"]
[null,"07","2019-06-27","X","X","X","X"]
[null,"11","2019-06-27",null,"X","X",null,"X","Attente situation rectifiée"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"05","2019-07-08",null,"X","X","X"]
[null,null,null,null,null,null,null,null,"Pas de situation sur le mois"]
[null,"05","2019-07-02",null,"X","X",null,"X","Avancement surévalué"]
["Bordereau de paiement obligatoire"]
["Enveloppe fournie"]
["@ : situation reçue par mail"]
["S : Situation saisie"]

{"sheet":"BORDEREAU D'ENVOI","index":2,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,9,6,12],[7,9,7,12],[9,9,9,12],[38,2,38,5],[38,6,38,8],[32,2,32,5],[32,6,32,8],[33,2,33,5],[33,6,33,8],[34,2,34,5],[34,6,34,8],[29,2,29,5],[29,6,29,8],[30,2,30,5],[30,6,30,8],[31,2,31,5],[39,2,39,5],[39,6,39,8],[40,2,40,5],[40,6,40,8],[35,2,35,5],[35,6,35,8],[36,2,36,5],[36,6,36,8],[37,2,37,5],[37,6,37,8],[31,6,31,8],[26,2,26,5],[26,6,26,8],[27,2,27,5],[27,6,27,8],[28,2,28,5],[28,6,28,8],[23,2,23,5],[23,6,23,8],[24,2,24,5],[24,6,24,8],[25,2,25,5],[25,6,25,8],[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]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BORDEREAU D’ENVOI"]
[]
[null,"Objet :",null,null,null,null,null,null,null,"MERIGNAC, le",{"$f":"TODAY()","v":"2019-07-11"}]
[]
[null,"Situation au : ",{"$f":"offsetfeuil(-1,$B$6)","v":"30/06/2019"}]
[]
[null,"Madame, Monsieur,"]
[]
[null,{"$f":"\"Nous vous prions de bien vouloir trouver, ci-jont, en 2 exemplaires, les situations de travaux à fin \"&Juin!$B$7&\" de :\"","v":"Nous vous prions de bien vouloir trouver, ci-jont, en 2 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'!D2","v":"301"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E2","v":"FONDATIONS  - GROS ŒUVRE"},null,null,null,{"$f":"Juin!A11","v":0},null,null,{"$f":"offsetfeuil(-1,C11)","v":"1904-01-01"},{"$f":"offsetfeuil(-1,B11)","v":0},{"$f":"offsetfeuil(-1,I11)","v":"Pas de situation sur le mois"}]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D3","v":"309"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E3","v":"ISOLATION FLOCAGE"},null,null,null,{"$f":"Juin!A12","v":0},null,null,{"$f":"offsetfeuil(-1,C12)","v":"1904-01-01"},{"$f":"offsetfeuil(-1,B12)","v":0},{"$f":"offsetfeuil(-1,I12)","v":"Pas de situation sur le mois"}]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D4","v":"402"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E4","v":"ETANCHEITE"},null,null,null,{"$f":"Juin!A13","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D5","v":"403/406"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E5","v":"CHARPENTE - COUVERTURE"},null,null,null,{"$f":"Juin!A14","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D6","v":"409"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E6","v":"RAVALEMENT"},null,null,null,{"$f":"Juin!A15","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D7","v":"415/417"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E7","v":"MENUISERIES ALUMINUIM ET PVC"},null,null,null,{"$f":"Juin!A16","v":0},null,null,"2019-07-01","05",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D8","v":"502/503/504"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E8","v":"PLOMBERIE - VMC - CHAUFFAGE"},null,null,null,{"$f":"Juin!A17","v":0},null,null,{"$f":"offsetfeuil(-1,C17)","v":"2019-06-19"},"15",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D9","v":"510"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E9","v":"ELECTRICITE - COURANTS FORTS"},null,null,null,{"$f":"Juin!A18","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D10","v":"522"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E10","v":"ASCENSEUR"},null,null,null,{"$f":"Juin!A19","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D11","v":"602"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E11","v":"PLATRERIE"},null,null,null,{"$f":"Juin!A20","v":0},null,null,"2019-06-03","11","Attente situation rectifiée"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D12","v":"603"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E12","v":"MENUISERIES INTERIEURES + PLACARDS"},null,null,null,{"$f":"Juin!A21","v":0},null,null,"2019-06-28","10",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D13","v":"609/611"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E13","v":"CARRELAGE - FAÏENCE - SOLS SOUPLES"},null,null,null,{"$f":"Juin!A22","v":0},null,null,"2019-06-21","09 / 10","Attente situation rectifiée"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D14","v":"616"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E14","v":"PEINTURES"},null,null,null,{"$f":"Juin!A23","v":0},null,null,"2019-06-27","07",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D15","v":"620"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E15","v":"SERRURERIE"},null,null,null,{"$f":"Juin!A24","v":0},null,null,"2019-06-27","11","Attente situation rectifiée"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D16","v":"621"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E16","v":"PORTES DE GARAGE"},null,null,null,{"$f":"Juin!A25","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D17","v":"801"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E17","v":"VRD"},null,null,null,{"$f":"Juin!A26","v":0},null,null,"2019-07-08","05",0]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D18","v":"806"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E18","v":"TERRASSES BOIS"},null,null,null,{"$f":"Juin!A27","v":0},null,null,"1904-01-01",0,"Pas de situation sur le mois"]
[null,{"$f":"'[1]ACTE D''ENGAGEMENT'!D19","v":"807"},{"$f":"'[1]ACTE D''ENGAGEMENT'!E19","v":"ESPACES VERTS"},null,null,null,{"$f":"Juin!A28","v":0},null,null,"2019-07-02","05","Avancement surévalué"]
[]
[null,null,null,null,null,null,null,null,null,null,"SIGNATURE MOE"]