{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Base de données","Dépenses","Revenus","Compte Crédit Agricole","Virements","Feuil2"],"not_rendered":{"macros":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Base de données","index":0,"n_rows":54,"n_cols":6,"rows_kept":54}
["Alimentation",null,null,"Salaire Sophie",null,"CB"]
["      Cantine enfants",null,null,"Salaire Christophe",null,"Chèque"]
["      Cantine tof",null,null,"Remboursement CPAM",null,"Prélèvement"]
["      Alimentation ",null,null,"Remboursement Mutuelle",null,"Espèces"]
["      Restaurant",null,null,"Remboursement Sanofi",null,"Retrait"]
["Communication",null,null,"Cadeaux","   "]
["      FREE"]
["Energie"]
["      EDF"]
["      SAUR"]
["      Gaz"]
["Enfants"]
["      Argent de poche Max"]
["      Argent de poche Clem"]
["      Garderie"]
["      TAP"]
["      Activité sportive "]
["      Activité culturel"]
["Famille"]
["     Produits hygiène"]
["     Produits d'entretien"]
["     Tabac"]
["     Alcool"]
["     Café…"]
["Habillement"]
["      Maxime"]
["      Clément"]
["      Sophie"]
["      Christophe"]
["Maison"]
["      Taxe foncière"]
["      Impôt locaux"]
["      Travaux"]
["      Equipement maison"]
["      Outillage"]
["      Jardinage"]
["      Assurance"]
["      Droguerie"]
["Retrait Espèces"]
["Santé"]
["      Maxime"]
["      Clément"]
["      Sophie"]
["     Ophtalmo"]
["      Christophe"]
["Voiture"]
["      Carburant clio"]
["      Carburant 306"]
["      Carburant"]
["      Assurance clio"]
["      Assurance 306"]
["      Entretien clio"]
["      Entretien 306"]
["Divers"]

{"sheet":"Dépenses","index":1,"n_rows":28,"n_cols":11,"rows_kept":28}
["Date","Libéllé","Montant","Commentaire","Mode de paiement","Montant espèces",{"$f":"SUMIF(E1:E35,\"Espèces\",C1:C35)","v":149.16},{"$f":"SUM(C:C)","v":986.13},{"$f":"SUMIF(E1:E31,\"Retrait\",F1:F31)","v":{"v":150,"d":"150.00"}},{"$f":"SUM(I1-G1)","v":{"v":0.8400000000000034,"d":"0.84"}},{"$f":"SUMIF(B1:B35,\"Alimentation\",$C$1:$C$35)","v":{"v":0,"d":"0.00"}}]
[]
["24/02/2015","Communication",6.04,"Free téléphone","Prélèvement"]
["18/02/2015","      Carburant 306",{"v":53.9,"d":"53.90"},null,"CB"]
["19/02/2015","     Café…",{"v":3,"d":"3.00"},"Café Fanta Patinoire","Espèces"]
["19/02/2015","      Alimentation ",{"v":1.5,"d":"1.50"},"Bouteille  d'eau patinoire","Espèces"]
["19/02/2015","      Activité sportive ",{"v":12,"d":"12.00"},"Patinoire Tof Max","Espèces"]
["21/02/2015","      Equipement maison",{"v":139.9,"d":"139.90"},"Acompte TV Sony","CB"]
["2015-02-21","Divers",{"v":60,"d":"60.00"},"Clémence","Espèces"]
["21/02/2015","      Jardinage",{"v":53.9,"d":"53.90"},"Pots/Arrosoire/Engrais/Terreau","CB"]
["19/02/2015","      Carburant clio",45.65,null,"CB"]
["19/02/2015","Retrait Espèces",null,null,"Retrait",{"v":40,"d":"40.00"}]
["19/02/2015","      Alimentation ",7.86,"épicerie","Espèces"]
["19/02/2015","      Activité culturel",{"v":14.5,"d":"14.50"},"Cnéma Sof clem","Espèces"]
["19/02/2015","      Restaurant",{"v":2.3,"d":"2.30"},"McDO","Espèces"]
["21/02/2015","Retrait Espèces",null,null,"Retrait",{"v":60,"d":"60.00"}]
["15/02/2015","Divers",{"v":48,"d":"48.00"},"30 sarments","Espèces"]
["15/02/2015","Retrait Espèces",null,"","Retrait",{"v":50,"d":"50.00"}]
["20/02/2015","      Carburant clio",45.65,null,"CB"]
["21/02/2016","      Entretien 306",{"v":50,"d":"50.00"},"Vitre arrière + Serrure","CB"]
["19/02/2015","      Maxime",{"v":38,"d":"38.00"},"chèque n°0023188 SPY","Chèque"]
["19/02/2015","      Sophie",{"v":7.8,"d":"7.80"},"chèque n°0023193 consult. main sof","Chèque"]
["19/02/2015","      TAP",{"v":16.5,"d":"16.50"},"chèque n°0023192 JANVIER","Chèque"]
["19/02/2015","      EDF",231.41,"facture n° 24224177561","Prélèvement"]
["19/02/2015","      Outillage",{"v":60.1,"d":"60.10"},"chèque n°0023190 scie sabre agraffes","Chèque"]
["21/02/2016","      Equipement maison",25.98,"chèque n°0023190 tablettes bois ","Chèque"]
["15/02/2015","      Clément",12.14,"Arnica","CB"]
["15/02/2015","      Carburant 306",{"v":50,"d":"50.00"},null,"CB"]

{"sheet":"Revenus","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
["Date","Libéllé","Montant","Commentaires",null,{"$f":"SUM(C:C)","v":1755.68}]
[]
[]
["20/02/2015","Salaire Sophie",1755.68]
{"$rows_empty":9}
[null,""]
{"$rows_empty":11}
[null,""]

{"sheet":"Compte Crédit Agricole","index":3,"n_rows":1,"n_cols":7,"rows_kept":1}
["Compte courant",{"$f":"SUM(F1-Dépenses!H1+Revenus!F1-Virements!F1+Virements!G1)","v":{"v":91.57999999999993,"d":"91.58"}},"LEP",{"$f":"SUM(G1-Virements!G1+Virements!F1)","v":1400},null,322.03,400]

{"sheet":"Virements","index":4,"n_rows":4,"n_cols":7,"rows_kept":4}
["Date","Virement Compte Courant /LEP","Virement LEP/Compte Courant",null,null,{"$f":"SUM(B:B)","v":1200},{"$f":"SUM(C:C)","v":200}]
[]
["2015-02-23",null,200]
["20/02/2015",1200]

{"sheet":"Feuil2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}