{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Relevé de Compte"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":227,"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":"Relevé de Compte","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,1,0,9],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
[null,{"$f":"\"Relevé de Compte de depuis \"&PROPER(TEXT(DATE(YEAR(B2),MONTH(B2),DAY(B2)),\"mmmm aaaa\"))","v":"Relevé de Compte de depuis Septembre 2012"}]
[null,"2012-09-01"]
[null,null,null,{"$f":"SUM(sumcredit)","v":5253}]
[null,"Mois concerné²","Montant du loyer (Charges comprises) ","Reçu par",null,"Solde du mois","État","Restant","Solde du compte","Quittance ou facture EC* remise"]
[null,null,null,"Locataire","C.A.F."]
[null,{"$f":"PROPER(TEXT(EDATE(B2,0),\"mmmm aaaa\"))","v":"Septembre 2012"},650,650,0,{"$f":"IF(C6<>\"\",(E6+D6)-C6,\"\")","v":0},{"$f":"IF(C6=\"\",\"\",IF(SUM($C$6:C6)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C6=\"\",\"\",IF(G6=\"Soldé\",0,IF(AND(G5=\"Soldé\",G6=\"Non soldé\"),SUM($C$6:C6)-cdt,C6)))","v":0},{"$f":"IF(AND(C6<>\"\",C7=\"\"),SUM($F$6:$F$33),\"\")","v":""},"OUI"]
[null,{"$f":"IF(LEFT(B6,4)=\"Fact\",PROPER(TEXT(EDATE(B5,1),\"mmmm aaaa\")),IF(OR(MONTH(B6)=7,MONTH(B6)=1),\"Facture EC* \"&PROPER(TEXT(EDATE(B6,0),\"mmmm aaaa\")),PROPER(TEXT(EDATE(B6,1),\"mmmm aaaa\"))))","v":"Octobre 2012"},650,650,0,{"$f":"IF(C7<>\"\",(E7+D7)-C7,\"\")","v":0},{"$f":"IF(C7=\"\",\"\",IF(SUM($C$6:C7)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C7=\"\",\"\",IF(G7=\"Soldé\",0,IF(AND(G6=\"Soldé\",G7=\"Non soldé\"),SUM($C$6:C7)-cdt,C7)))","v":0},"","OUI"]
[null,{"$f":"IF(LEFT(B7,4)=\"Fact\",PROPER(TEXT(EDATE(B6,1),\"mmmm aaaa\")),IF(OR(MONTH(B7)=7,MONTH(B7)=1),\"Facture EC* \"&PROPER(TEXT(EDATE(B7,0),\"mmmm aaaa\")),PROPER(TEXT(EDATE(B7,1),\"mmmm aaaa\"))))","v":"Novembre 2012"},650,650,0,0,{"$f":"IF(C8=\"\",\"\",IF(SUM($C$6:C8)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C8=\"\",\"\",IF(G8=\"Soldé\",0,IF(AND(G7=\"Soldé\",G8=\"Non soldé\"),SUM($C$6:C8)-cdt,C8)))","v":0},"","OUI"]
[null,"Décembre 2012",650,650,0,0,{"$f":"IF(C9=\"\",\"\",IF(SUM($C$6:C9)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C9=\"\",\"\",IF(G9=\"Soldé\",0,IF(AND(G8=\"Soldé\",G9=\"Non soldé\"),SUM($C$6:C9)-cdt,C9)))","v":0},"","OUI"]
[null,"Janvier 2013",650,650,0,0,{"$f":"IF(C10=\"\",\"\",IF(SUM($C$6:C10)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C10=\"\",\"\",IF(G10=\"Soldé\",0,IF(AND(G9=\"Soldé\",G10=\"Non soldé\"),SUM($C$6:C10)-cdt,C10)))","v":0},"","OUI"]
[null,"Facture EC* Janvier 2013",53,53,0,0,{"$f":"IF(C11=\"\",\"\",IF(SUM($C$6:C11)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C11=\"\",\"\",IF(G11=\"Soldé\",0,IF(AND(G10=\"Soldé\",G11=\"Non soldé\"),SUM($C$6:C11)-cdt,C11)))","v":0},"","OUI"]
[null,"Février 2013",650,650,0,0,{"$f":"IF(C12=\"\",\"\",IF(SUM($C$6:C12)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C12=\"\",\"\",IF(G12=\"Soldé\",0,IF(AND(G11=\"Soldé\",G12=\"Non soldé\"),SUM($C$6:C12)-cdt,C12)))","v":0},"","OUI"]
[null,"Mars 2013",650,650,0,0,{"$f":"IF(C13=\"\",\"\",IF(SUM($C$6:C13)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C13=\"\",\"\",IF(G13=\"Soldé\",0,IF(AND(G12=\"Soldé\",G13=\"Non soldé\"),SUM($C$6:C13)-cdt,C13)))","v":0},"","OUI"]
[null,"Avril 2013",650,650,0,0,{"$f":"IF(C14=\"\",\"\",IF(SUM($C$6:C14)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":"Soldé"},{"$f":"IF(C14=\"\",\"\",IF(G14=\"Soldé\",0,IF(AND(G13=\"Soldé\",G14=\"Non soldé\"),SUM($C$6:C14)-cdt,C14)))","v":0},0,"OUI"]
[null,"Mai 2013",null,null,null,"",{"$f":"IF(C15=\"\",\"\",IF(SUM($C$6:C15)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(G15=\"Soldé\",0,IF(AND(G14=\"Soldé\",G15=\"Non soldé\"),SUM($C$6:C15)-cdt,C15)))","v":""},""]
[null,"Juin 2013",null,null,null,"",{"$f":"IF(C16=\"\",\"\",IF(SUM($C$6:C16)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C16=\"\",\"\",IF(G16=\"Soldé\",0,IF(AND(G15=\"Soldé\",G16=\"Non soldé\"),SUM($C$6:C16)-cdt,C16)))","v":""},""]
[null,"Juillet 2013",null,null,null,"",{"$f":"IF(C17=\"\",\"\",IF(SUM($C$6:C17)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C17=\"\",\"\",IF(G17=\"Soldé\",0,IF(AND(G16=\"Soldé\",G17=\"Non soldé\"),SUM($C$6:C17)-cdt,C17)))","v":""},""]
[null,"Facture EC* Juillet 2013",null,null,null,"",{"$f":"IF(C18=\"\",\"\",IF(SUM($C$6:C18)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C18=\"\",\"\",IF(G18=\"Soldé\",0,IF(AND(G17=\"Soldé\",G18=\"Non soldé\"),SUM($C$6:C18)-cdt,C18)))","v":""},""]
[null,"Août 2013",null,null,null,"",{"$f":"IF(C19=\"\",\"\",IF(SUM($C$6:C19)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C19=\"\",\"\",IF(G19=\"Soldé\",0,IF(AND(G18=\"Soldé\",G19=\"Non soldé\"),SUM($C$6:C19)-cdt,C19)))","v":""},""]
[null,"Septembre 2013",null,null,null,"",{"$f":"IF(C20=\"\",\"\",IF(SUM($C$6:C20)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C20=\"\",\"\",IF(G20=\"Soldé\",0,IF(AND(G19=\"Soldé\",G20=\"Non soldé\"),SUM($C$6:C20)-cdt,C20)))","v":""},""]
[null,"Octobre 2013",null,null,null,"",{"$f":"IF(C21=\"\",\"\",IF(SUM($C$6:C21)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C21=\"\",\"\",IF(G21=\"Soldé\",0,IF(AND(G20=\"Soldé\",G21=\"Non soldé\"),SUM($C$6:C21)-cdt,C21)))","v":""},""]
[null,"Novembre 2013",null,null,null,"",{"$f":"IF(C22=\"\",\"\",IF(SUM($C$6:C22)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C22=\"\",\"\",IF(G22=\"Soldé\",0,IF(AND(G21=\"Soldé\",G22=\"Non soldé\"),SUM($C$6:C22)-cdt,C22)))","v":""},""]
[null,"Décembre 2013",null,null,null,"",{"$f":"IF(C23=\"\",\"\",IF(SUM($C$6:C23)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C23=\"\",\"\",IF(G23=\"Soldé\",0,IF(AND(G22=\"Soldé\",G23=\"Non soldé\"),SUM($C$6:C23)-cdt,C23)))","v":""},""]
[null,"Janvier 2014",null,null,null,"",{"$f":"IF(C24=\"\",\"\",IF(SUM($C$6:C24)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C24=\"\",\"\",IF(G24=\"Soldé\",0,IF(AND(G23=\"Soldé\",G24=\"Non soldé\"),SUM($C$6:C24)-cdt,C24)))","v":""},""]
[null,{"$f":"IF(LEFT(B24,4)=\"Fact\",PROPER(TEXT(EDATE(B23,1),\"mmmm aaaa\")),IF(OR(MONTH(B24)=7,MONTH(B24)=1),\"Facture EC* \"&PROPER(TEXT(EDATE(B24,0),\"mmmm aaaa\")),PROPER(TEXT(EDATE(B24,1),\"mmmm aaaa\"))))","v":"Facture EC* Janvier 2014"},null,null,null,"",{"$f":"IF(C25=\"\",\"\",IF(SUM($C$6:C25)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C25=\"\",\"\",IF(G25=\"Soldé\",0,IF(AND(G24=\"Soldé\",G25=\"Non soldé\"),SUM($C$6:C25)-cdt,C25)))","v":""},""]
[null,"Février 2014",null,null,null,"",{"$f":"IF(C26=\"\",\"\",IF(SUM($C$6:C26)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C26=\"\",\"\",IF(G26=\"Soldé\",0,IF(AND(G25=\"Soldé\",G26=\"Non soldé\"),SUM($C$6:C26)-cdt,C26)))","v":""},{"$f":"IF(AND(C26<>\"\",C27=\"\"),SUM($F$6:$F$33),\"\")","v":""}]
[null,"Mars 2014",null,null,null,"",{"$f":"IF(C27=\"\",\"\",IF(SUM($C$6:C27)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C27=\"\",\"\",IF(G27=\"Soldé\",0,IF(AND(G26=\"Soldé\",G27=\"Non soldé\"),SUM($C$6:C27)-cdt,C27)))","v":""},{"$f":"IF(AND(C27<>\"\",C28=\"\"),SUM($F$6:$F$33),\"\")","v":""}]
[null,"Avril 2014",null,null,null,"",{"$f":"IF(C28=\"\",\"\",IF(SUM($C$6:C28)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C28=\"\",\"\",IF(G28=\"Soldé\",0,IF(AND(G27=\"Soldé\",G28=\"Non soldé\"),SUM($C$6:C28)-cdt,C28)))","v":""},""]
[null,"Mai 2014",null,null,null,"",{"$f":"IF(C29=\"\",\"\",IF(SUM($C$6:C29)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C29=\"\",\"\",IF(G29=\"Soldé\",0,IF(AND(G28=\"Soldé\",G29=\"Non soldé\"),SUM($C$6:C29)-cdt,C29)))","v":""},""]
[null,"Juin 2014",null,null,null,"",{"$f":"IF(C30=\"\",\"\",IF(SUM($C$6:C30)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C30=\"\",\"\",IF(G30=\"Soldé\",0,IF(AND(G29=\"Soldé\",G30=\"Non soldé\"),SUM($C$6:C30)-cdt,C30)))","v":""},""]
[null,"Juillet 2014",null,null,null,"",{"$f":"IF(C31=\"\",\"\",IF(SUM($C$6:C31)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C31=\"\",\"\",IF(G31=\"Soldé\",0,IF(AND(G30=\"Soldé\",G31=\"Non soldé\"),SUM($C$6:C31)-cdt,C31)))","v":""},""]
[null,"Facture EC* Juillet 2014",null,null,null,"",{"$f":"IF(C32=\"\",\"\",IF(SUM($C$6:C32)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C32=\"\",\"\",IF(G32=\"Soldé\",0,IF(AND(G31=\"Soldé\",G32=\"Non soldé\"),SUM($C$6:C32)-cdt,C32)))","v":""},{"$f":"IF(AND(C32<>\"\",C33=\"\"),SUM($F$6:$F$33),\"\")","v":""}]
[null,"Août 2014",null,null,null,"",{"$f":"IF(C33=\"\",\"\",IF(SUM($C$6:C33)<=SUM(INDIRECT(\"$D$5:\"&CELL(\"adresse\",OFFSET($D$6,COUNTA($D$6:$D$39),1)))),\"Soldé\",\"Non soldé\"))","v":""},{"$f":"IF(C33=\"\",\"\",IF(G33=\"Soldé\",0,IF(AND(G32=\"Soldé\",G33=\"Non soldé\"),SUM($C$6:C33)-cdt,C33)))","v":""},{"$f":"IF(AND(C33<>\"\",C34=\"\"),SUM($F$6:$F$33),\"\")","v":""}]
[]
[null,"* Facture d'eau chaude (tous les 6 mois)"]
[null,"² Chaque paiement concerne le mois en cours (ex : paiement le 05 septembre 2012 pour loyer de septembre 2012)"]