{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Libellés","MENU","BANQUE 1","BANQUE 2","BANQUE 3","BANQUE 4"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":8,"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":"Libellés","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["BANQUE 1","BANQUE 2","BANQUE 3","BANQUE 4"]
["ABONNEMENT","VIR EUROPEEN SEPA RECU","Téléphone","CARTE VISA /"]
["CHEQUE N° ","VIR EUROPEEN SEPA EMIS","Impôts","PENSION"]
["DIRECTION GALE FINANCES","CHEQUE N°","virement","PRLV /"]
["1° appel de fonds","PRELEVEMENT BANQUE 1","CPAM","PRLV IMPÔTS"]
["2° appel de fonds","PRELEVEMENT FRANCE TELECOM","Chèque","VIR EMIS /"]
["3° appel de fonds","VIR CPTE A CPTE RECU ",null,"VIR RECU /"]
["4° appel de fonds","VIR EMIS /"]
["Régul charges","VIR RECU /"]
["appel travaux"]
["LOYER"]
["LOYER 2"]
["PRLV 1"]
["PRLV 2"]
["PRLV TRESOR PUBLIC"]
["VIR EMIS /"]
["VIR RECU /"]

{"sheet":"MENU","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,8,6,9],[25,8,26,9],[27,8,27,9],[18,8,19,9],[7,8,7,9],[11,8,12,9],[13,8,13,9],[20,8,20,9]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SOLDE"]
[]
[null,null,null,null,null,null,null,null,{"$f":"'BANQUE 1'!A2","v":1000}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SOLDE"]
[]
[null,null,null,null,null,null,null,null,{"$f":"'BANQUE 2'!A2","v":4840.59}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SOLDE"]
[]
[null,null,null,null,null,null,null,null,{"$f":"'BANQUE 3'!A2","v":1410.3500000000001}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"SOLDE"]
[]
[null,null,null,null,null,null,null,null,{"$f":"'BANQUE 4'!A2","v":7973.27}]

{"sheet":"BANQUE 1","index":2,"n_rows":92,"n_cols":7,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"BANQUE 1"]
[{"$f":"OFFSET(G4,1,)","v":1000},null,"Dates","Libellés","Débit","Crédit","Solde"]
[null,"Compt_1"]
[{"$f":"COUNTA($C4:$C$5)","v":0},null,null,null,null,null,{"$f":"IF(C4<>\"\",$G$5-SUM(E4:$E$5)+SUM(F4:$F$5),\"\")","v":""}]
[null,null,null,"SOLDE INITIAL",null,null,1000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(C30=\"\",\"\",IF(E30>0,G31-E30,G31+F30))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(C31=\"\",\"\",IF(E31>0,G32-E31,G32+F31))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(C32=\"\",\"\",IF(E32>0,G33-E32,G33+F33))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(C57=\"\",\"\",IF(E57>0,G58-E57,G58+#REF!))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(C58=\"\",\"\",IF(E58>0,G59-E58,G59+F58))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(C74=\"\",\"\",IF(E74>0,G75-E74,G75+F74))","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"BANQUE 2","index":3,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"BANQUE 2"]
[{"$f":"OFFSET(G4,1,)","v":4840.59},null,"Dates","Libellés","Débit","Crédit","Solde"]
[null,"Compt_2"]
[{"$f":"COUNTA($C4:$C$5)","v":0},null,null,null,null,null,{"$f":"IF(C4<>\"\",$G$5-SUM(E4:$E$5)+SUM(F4:$F$5),\"\")","v":""}]
[null,null,null,"SOLDE AU 28/02/2014",null,null,4840.59]

{"sheet":"BANQUE 3","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"BANQUE 3"]
[{"$f":"OFFSET(G4,1,)","v":1410.3500000000001},null,"Dates","Libellés","Débit","Crédit","Solde"]
[null,"Compt_3"]
[{"$f":"COUNTA($C4:$C$15)","v":10},null,null,null,null,null,{"$f":"IF(C4<>\"\",$G$15-SUM(E4:$E$15)+SUM(F4:$F$15),\"\")","v":""}]
[{"$f":"COUNTA($C5:$C$15)","v":10},null,"2014-02-03","Chèque",null,550,{"$f":"IF(C5<>\"\",$G$15-SUM(E5:$E$15)+SUM(F5:$F$15),\"\")","v":1410.3500000000001}]
[{"$f":"COUNTA($C6:$C$15)","v":9},null,"2014-01-27","CHEQUE N° 500000",82.61,null,{"$f":"IF(C6<>\"\",$G$15-SUM(E6:$E$15)+SUM(F6:$F$15),\"\")","v":860.35000000000014}]
[{"$f":"COUNTA($C7:$C$15)","v":8},null,"2014-01-27","CHEQUE N° 500000",32.950000000000003,null,{"$f":"IF(C7<>\"\",$G$15-SUM(E7:$E$15)+SUM(F7:$F$15),\"\")","v":942.96}]
[{"$f":"COUNTA($C8:$C$15)","v":7},null,"2014-01-23","CHEQUE N° 500000",44.99,null,{"$f":"IF(C8<>\"\",$G$15-SUM(E8:$E$15)+SUM(F8:$F$15),\"\")","v":975.91000000000008}]
[{"$f":"COUNTA($C9:$C$15)","v":6},null,"2014-01-21","CHEQUE N° 500000",null,16.5,{"$f":"IF(C9<>\"\",$G$15-SUM(E9:$E$15)+SUM(F9:$F$15),\"\")","v":1020.9000000000001}]
[{"$f":"COUNTA($C10:$C$15)","v":5},null,"2014-01-15","CHEQUE N° 500000",36.799999999999997,null,{"$f":"IF(C10<>\"\",$G$15-SUM(E10:$E$15)+SUM(F10:$F$15),\"\")","v":1004.4000000000001}]
[{"$f":"COUNTA($C11:$C$15)","v":4},null,"2014-01-15","ASSURANCE",null,824.45,{"$f":"IF(C11<>\"\",$G$15-SUM(E11:$E$15)+SUM(F11:$F$15),\"\")","v":1041.2}]
[{"$f":"COUNTA($C12:$C$15)","v":3},null,"2014-01-08","VIREMENT EMIS",980,null,{"$f":"IF(C12<>\"\",$G$15-SUM(E12:$E$15)+SUM(F12:$F$15),\"\")","v":216.75}]
[{"$f":"COUNTA($C13:$C$15)","v":2},null,"2014-01-07","Frais de tenue de compte",3.25,null,{"$f":"IF(C13<>\"\",$G$15-SUM(E13:$E$15)+SUM(F13:$F$15),\"\")","v":1196.75}]
[{"$f":"COUNTA($C14:$C$15)","v":1},null,"2013-12-02","VIREMENT RECU",null,200,{"$f":"IF(C14<>\"\",$G$15-SUM(E14:$E$15)+SUM(F14:$F$15),\"\")","v":1200}]
[null,null,null,"SOLDE DE DÉPART",null,null,1000]

{"sheet":"BANQUE 4","index":5,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"BANQUE 4"]
[{"$f":"OFFSET(G4,1,)","v":7973.27},null,"Dates","Libellés","Débit","Crédit","Solde"]
[null,"Compt_4"]
[{"$f":"COUNTA($C4:$C$6)","v":1},null,null,null,null,null,{"$f":"IF(C4<>\"\",$G$6-SUM(E4:$E$6)+SUM($F4:$F$6),\"\")","v":""}]
[{"$f":"COUNTA($C5:$C$6)","v":1},null,"2014-03-03","VIR RECU /",null,6000,{"$f":"IF(C5<>\"\",$G$6-SUM(E5:$E$6)+SUM($F5:$F$6),\"\")","v":7973.27}]
[null,null,null,"SOLDE AU 28/02/2014",null,null,1973.27]