{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Liste paiements","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Liste paiements","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Nom","N° Fact","Montant","Date Fact","Échéance","Date Pai","Acompte","Paiem","Payé","Alerte","Retard","Relance","Cpte"]
[null,null,4840,"2019-07-04",{"$f":"Tableau2[[#This Row],[Date Fact]]+14","v":"2019-07-18"},"2019-07-08",null,4840,{"$f":"IF(Tableau2[[#This Row],[Montant]]=Tableau2[[#This Row],[Paiem]]+Tableau2[[#This Row],[Acompte]],\"Payé\",\"\")","v":"Payé"},{"$f":"IF(AND(Tableau2[[#This Row],[Échéance]]+ Tableau2[[#This Row],[Acompte]]<TODAY(), Réglé + Tableau2[[#This Row],[Acompte]]<> Tableau2[Montant] ), \"ALERTE\", \"\")","v":""},{"$f":"IF(AND(E2<TODAY(),F2=\"\"),\"Retard\",\"\")","v":""}]
[null,null,8354.6,"2019-07-01",{"$f":"Tableau2[[#This Row],[Date Fact]]+14","v":"2019-07-15"},null,null,null,{"$f":"IF(Tableau2[[#This Row],[Montant]]=Tableau2[[#This Row],[Paiem]]+Tableau2[[#This Row],[Acompte]],\"Payé\",\"\")","v":""},{"$f":"IF(AND(Tableau2[[#This Row],[Échéance]]+ Tableau2[[#This Row],[Acompte]]<TODAY(), Réglé + Tableau2[[#This Row],[Acompte]]<> Tableau2[Montant] ), \"ALERTE\", \"\")","v":"ALERTE"},{"$f":"IF(AND(E3<TODAY(),F3=\"\"),\"Retard\",\"\")","v":"Retard"}]
[null,null,300,"2019-06-27",{"$f":"Tableau2[[#This Row],[Date Fact]]+14","v":"2019-07-11"},"2019-07-11",null,220,{"$f":"IF(Tableau2[[#This Row],[Montant]]=Tableau2[[#This Row],[Paiem]]+Tableau2[[#This Row],[Acompte]],\"Payé\",\"\")","v":""},{"$f":"IF(AND(Tableau2[[#This Row],[Échéance]]+ Tableau2[[#This Row],[Acompte]]<TODAY(), Réglé + Tableau2[[#This Row],[Acompte]]<> Tableau2[Montant] ), \"ALERTE\", \"\")","v":"ALERTE"},""]
[null,null,2400,"2019-06-26",{"$f":"Tableau2[[#This Row],[Date Fact]]+14","v":"2019-07-10"},null,1400,null,{"$f":"IF(Tableau2[[#This Row],[Montant]]=Tableau2[[#This Row],[Paiem]]+Tableau2[[#This Row],[Acompte]],\"Payé\",\"\")","v":""},{"$f":"IF(AND(Tableau2[[#This Row],[Échéance]]+ Tableau2[[#This Row],[Acompte]]<TODAY(), Réglé + Tableau2[[#This Row],[Acompte]]<> Tableau2[Montant] ), \"ALERTE\", \"\")","v":""},"Retard"]
[null,null,13297,"2019-06-26",{"$f":"Tableau2[[#This Row],[Date Fact]]+14","v":"2019-07-10"},"2019-07-03",null,13297,{"$f":"IF(Tableau2[[#This Row],[Montant]]=Tableau2[[#This Row],[Paiem]]+Tableau2[[#This Row],[Acompte]],\"Payé\",\"\")","v":"Payé"},{"$f":"IF(AND(Tableau2[[#This Row],[Échéance]]+ Tableau2[[#This Row],[Acompte]]<TODAY(), Réglé + Tableau2[[#This Row],[Acompte]]<> Tableau2[Montant] ), \"ALERTE\", \"\")","v":""},""]

{"sheet":"Feuil2","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Client",null,"Caisse",null,"NC"]
["Abo",null,"Banque",null,"Rappel"]
[null,null,null,null,"Rappel 2"]
[null,null,null,null,"Recom"]
[null,null,null,null,"Relance"]