{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Dépôts","Retraits"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Dépôts","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"relevé\nbancaire\nmensuel",null,"MOIS","SOLDE PRÉCÉDENT","TOTAL DES DÉPÔTS"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"JULY"},{"v":2525.54,"d":"2,525.54 $"},{"$f":"Dépôt_total","v":{"v":5400,"d":"5,400.00 $"}}]
[{"$nulls":3},"ANNÉE","SOLDE FINAL","TOTAL DES RETRAITS"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(SoldeFinal+Dépôt_total-Total_Retraits, \"\")","v":{"v":6550.54,"d":"6,550.54 $"}},{"$f":"Total_Retraits","v":{"v":1375,"d":"1,375.00 $"}}]
[null,"dépôts"]
[null,"N° de dépôt","date","montant","description","rapproché"]
[null,{"$f":"ROW()-ROW(Dépôts[[#Headers],[N° de dépôt]])","v":1},{"$f":"TODAY()-15","v":"2018-06-19"},{"v":1500,"d":"1,500.00 $"},"tâche 1, chèque 1","oui"]
[null,{"$f":"ROW()-ROW(Dépôts[[#Headers],[N° de dépôt]])","v":2},{"$f":"TODAY()-10","v":"2018-06-24"},{"v":1200,"d":"1,200.00 $"},"tâche 2, chèque 1","oui"]
[null,{"$f":"ROW()-ROW(Dépôts[[#Headers],[N° de dépôt]])","v":3},{"$f":"TODAY()-5","v":"2018-06-29"},{"v":1500,"d":"1,500.00 $"},"tâche 1, chèque 2","oui"]
[null,{"$f":"ROW()-ROW(Dépôts[[#Headers],[N° de dépôt]])","v":4},{"$f":"TODAY()","v":"2018-07-04"},{"v":1200,"d":"1,200.00 $"},"tâche 2, chèque 2","oui"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Dépôts[montant])","v":{"v":5400,"d":"5,400.00 $"}}]

{"sheet":"Retraits","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"retraits"]
[null,"type","date","montant","pour","rapproché"]
[null,"chèque 1001",{"$f":"TODAY()-8","v":"2018-06-26"},{"v":150,"d":"150.00 $"},"électricité","oui"]
[null,"chèque 1002",{"$f":"TODAY()-6","v":"2018-06-28"},{"v":150,"d":"150.00 $"},"eau/égoût/ordures","oui"]
[null,"chèque 1003",{"$f":"TODAY()-4","v":"2018-06-30"},{"v":850,"d":"850.00 $"},"prêt immobilier","oui"]
[null,"débit",{"$f":"TODAY()-2","v":"2018-07-02"},{"v":125,"d":"125.00 $"},"épicerie","oui"]
[null,"guichet automatique",{"$f":"TODAY()","v":"2018-07-04"},{"v":100,"d":"100.00 $"},"espèces","oui"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Vérifie[montant])","v":{"v":1375,"d":"1,375.00 $"}}]