{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Registre de chèques"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Registre de chèques","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"Registre de chèques"]
[null,"Entrez votre numéro de compte bancaire dans cette cellule"]
[null,{"$f":"CONCATENATE(\"Solde actuel : \"&TEXT(RegistreChèques[[#Totals],[Solde]],\"# ##0,00 €\"))","v":"Solde actuel : 2 730,84 €"}]
[]
[{"$nulls":4},"N° chèque","Date","Description","Catégorie","Retrait","Dépôt","Solde"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-11"},"Solde de départ","Dépôt",null,{"v":2916.73,"d":"2,916.73 €"},{"$f":"SoldeInitial","v":{"v":2916.73,"d":"2,916.73 €"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-12"},"Supermarché","Courses",{"v":205.61,"d":"205.61 €"},null,{"$f":"Solde","v":{"v":2711.12,"d":"2,711.12 €"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-26"},"Prêt immobilier","Prêt immobilier",{"v":961.77,"d":"961.77 €"},null,{"$f":"Solde","v":{"v":1749.35,"d":"1,749.35 €"}}]
[{"$nulls":4},"Débit",{"$f":"TODAY()-40","v":"2018-03-31"},"Café","Autres",{"v":3.65,"d":"3.65 €"},null,{"$f":"Solde","v":{"v":1745.6999999999998,"d":"1,745.70 €"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-05"},"Gaz et électricité","Charges",{"v":145.33,"d":"145.33 €"},null,{"$f":"Solde","v":{"v":1600.37,"d":"1,600.37 €"}}]
[{"$nulls":4},"Distributeur automatique de billets",{"$f":"TODAY()-30","v":"2018-04-10"},"Espèces","Autres",{"v":50,"d":"50.00 €"},null,{"$f":"Solde","v":{"v":1550.37,"d":"1,550.37 €"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-15"},"Carte de crédit","Carte de crédit",{"v":936.48,"d":"936.48 €"},null,{"$f":"Solde","v":{"v":613.8899999999999,"d":"613.89 €"}}]
[null,"Récapitulatif",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-20"},"Salaire","Dépôt",null,{"v":2365.82,"d":"2,365.82 €"},{"$f":"Solde","v":{"v":2979.71,"d":"2,979.71 €"}}]
[null,"Catégorie","Total",null,null,{"$f":"TODAY()-15","v":"2018-04-25"},"Fond commun de placement","Investissement",{"v":200,"d":"200.00 €"},null,{"$f":"Solde","v":{"v":2779.71,"d":"2,779.71 €"}}]
[null,"Dépôt",{"$f":"TotalCatégorie","v":{"v":5282.55,"d":"5,282.55 €"}},null,2253,{"$f":"TODAY()","v":"2018-05-10"},"Opérateur téléphonique","Charges",{"v":48.87,"d":"48.87 €"},null,{"$f":"Solde","v":{"v":2730.84,"d":"2,730.84 €"}}]
[null,"Carte de crédit",{"$f":"TotalCatégorie","v":{"v":936.48,"d":"936.48 €"}},null,"Totaux",{"$nulls":3},{"$f":"SUBTOTAL(109,RegistreChèques[Retrait])","v":{"v":2551.71,"d":"2,551.71 €"}},{"$f":"SUBTOTAL(109,RegistreChèques[Dépôt])","v":{"v":5282.55,"d":"5,282.55 €"}},{"$f":"RegistreChèques[[#Totals],[Dépôt]]-RegistreChèques[[#Totals],[Retrait]]","v":{"v":2730.84,"d":"2,730.84 €"}}]
[null,"Investissement",{"$f":"TotalCatégorie","v":{"v":200,"d":"200.00 €"}}]
[null,"Courses",{"$f":"TotalCatégorie","v":{"v":205.61,"d":"205.61 €"}}]
[null,"Charges",{"$f":"TotalCatégorie","v":{"v":194.20000000000002,"d":"194.20 €"}}]
[null,"Assurance",{"$f":"TotalCatégorie","v":{"v":0,"d":"0.00 €"}}]
[null,"Prêt immobilier",{"$f":"TotalCatégorie","v":{"v":961.77,"d":"961.77 €"}}]
[null,"Autres",{"$f":"TotalCatégorie","v":{"v":53.65,"d":"53.65 €"}}]