{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Registro de cheques"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Registro de cheques","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[]
[]
[null,"LEYENDA",{"$nulls":5},"SALDO ACTUAL"]
[null,"TD = tarjeta de débito",null,"PA = pago automático ",{"$nulls":3},{"$f":"SALDO_ACTUAL","v":{"v":3311,"d":"$3,311.00"}}]
[null,"ATM = cajero automático",null,"PF = pago de factura en línea"]
[null,"DA = depósito automático ",null,"TR = transferencia en línea o por teléfono"]
[]
[null,"Cheque o código","Fecha","Transacción","Descripción","Retirada","Depósito","Saldo"]
[null,null,{"$f":"TODAY()-19","v":"2019-05-11"},"Woodgrove Bank","Saldo de apertura",null,{"v":2000,"d":"$2,000.00"},{"$f":"IFERROR(RegistroDeCheques[[#This Row],[Depósito]], \"\")","v":{"v":2000,"d":"$2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2019-05-19"},"School of Fine Art","Clase de arte de Julia - 6 semanas",{"v":100,"d":"$100.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[Retirada]]),H9+RegistroDeCheques[[#This Row],[Depósito]],H9-RegistroDeCheques[[#This Row],[Retirada]]), \"\")","v":{"v":1900,"d":"$1,900.00"}}]
[null,"DA",{"$f":"TODAY()-11","v":"2019-05-19"},"Nómina",null,null,{"v":1500,"d":"$1,500.00"},{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[Retirada]]),H10+RegistroDeCheques[[#This Row],[Depósito]],H10-RegistroDeCheques[[#This Row],[Retirada]]), \"\")","v":{"v":3400,"d":"$3,400.00"}}]
[null,"TD",{"$f":"TODAY()-8","v":"2019-05-22"},"Southridge Video","Alquiler de película + reembolso de 10 $",{"v":16,"d":"$16.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[Retirada]]),H11+RegistroDeCheques[[#This Row],[Depósito]],H11-RegistroDeCheques[[#This Row],[Retirada]]), \"\")","v":{"v":3384,"d":"$3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2019-05-25"},null,"Efectivo para cenar fuera",{"v":50,"d":"$50.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[Retirada]]),H12+RegistroDeCheques[[#This Row],[Depósito]],H12-RegistroDeCheques[[#This Row],[Retirada]]), \"\")","v":{"v":3334,"d":"$3,334.00"}}]
[null,"PF",{"$f":"TODAY()","v":"2019-05-30"},"The Phone Company",null,{"v":23,"d":"$23.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[Retirada]]),H13+RegistroDeCheques[[#This Row],[Depósito]],H13-RegistroDeCheques[[#This Row],[Retirada]]), \"\")","v":{"v":3311,"d":"$3,311.00"}}]
[null,"Totales",null,{"$f":"CONCATENATE(\"Número de transacciones: \",SUBTOTAL(103,RegistroDeCheques[Transacción]))","v":"Número de transacciones: 5"},null,{"$f":"SUBTOTAL(109,RegistroDeCheques[Retirada])","v":{"v":189,"d":"$189.00"}},{"$f":"SUBTOTAL(109,RegistroDeCheques[Depósito])","v":{"v":3500,"d":"$3,500.00"}},{"$f":"RegistroDeCheques[[#Totals],[Depósito]]-RegistroDeCheques[[#Totals],[Retirada]]","v":{"v":3311,"d":"$3,311.00"}}]