{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Depósitos","Retiradas"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Depósitos","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"extracto\nbancario\nmensual",null,"MES","SALDO ANTERIOR","TOTALES DE DEPÓSITOS"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"MAYO"},{"v":2525.54,"d":"2,525.54 €"},{"$f":"Total_depósitos","v":{"v":5400,"d":"5,400.00 €"}}]
[{"$nulls":3},"AÑO","SALDO FINAL","TOTAL DE RETIRADAS"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(SaldoFinal+Total_depósitos-Total_retiradas, \"\")","v":{"v":6550.54,"d":"6,550.54 €"}},{"$f":"Total_retiradas","v":{"v":1375,"d":"1,375.00 €"}}]
[null,"depósitos"]
[null,"N.º de depósito","fecha","importe","descripción","conciliación"]
[null,{"$f":"ROW()-ROW(Depósitos[[#Headers],[N.º de depósito]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"1,500.00 €"},"trabajo 1, cheque 1","sí"]
[null,{"$f":"ROW()-ROW(Depósitos[[#Headers],[N.º de depósito]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"1,200.00 €"},"trabajo 2, cheque 1","sí"]
[null,{"$f":"ROW()-ROW(Depósitos[[#Headers],[N.º de depósito]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"1,500.00 €"},"trabajo 1, cheque 2","sí"]
[null,{"$f":"ROW()-ROW(Depósitos[[#Headers],[N.º de depósito]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"1,200.00 €"},"trabajo 2, cheque 2","sí"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Depósitos[importe])","v":{"v":5400,"d":"5,400.00 €"}}]

{"sheet":"Retiradas","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"retiradas"]
[null,"tipo","fecha","importe","uso","conciliación"]
[null,"cheque 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"150.00 €"},"electricidad","sí"]
[null,"cheque 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"150.00 €"},"agua/alcantarillado/basura","sí"]
[null,"cheque 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"850.00 €"},"hipoteca","sí"]
[null,"débito",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"125.00 €"},"comida","sí"]
[null,"cajero automático",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"100.00 €"},"efectivo","sí"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Cheques[importe])","v":{"v":1375,"d":"1,375.00 €"}}]