{"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":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"Registro de cheques"]
[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,"CÓDIGO DE CHEQUE","FECHA","TRANSACCIÓN","DESCRIPCIÓN","RETIRADA","DEPÓSITO","SALDO"]
[null,null,{"$f":"TODAY()-19","v":"2018-05-26"},"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":"2018-06-03"},"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]]),H7+RegistroDeCheques[[#This Row],[DEPÓSITO]],H7-RegistroDeCheques[[#This Row],[RETIRADA]]), \"\")","v":{"v":1900,"d":"$1,900.00"}}]
[null,"DA",{"$f":"TODAY()-11","v":"2018-06-03"},"Nómina",null,null,{"v":1500,"d":"$1,500.00"},{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[RETIRADA]]),H8+RegistroDeCheques[[#This Row],[DEPÓSITO]],H8-RegistroDeCheques[[#This Row],[RETIRADA]]), \"\")","v":{"v":3400,"d":"$3,400.00"}}]
[null,"TD",{"$f":"TODAY()-8","v":"2018-06-06"},"Southridge Video","Alquiler de película + reembolso de $10",{"v":16,"d":"$16.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[RETIRADA]]),H9+RegistroDeCheques[[#This Row],[DEPÓSITO]],H9-RegistroDeCheques[[#This Row],[RETIRADA]]), \"\")","v":{"v":3384,"d":"$3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2018-06-09"},null,"Efectivo para cenar fuera",{"v":50,"d":"$50.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[RETIRADA]]),H10+RegistroDeCheques[[#This Row],[DEPÓSITO]],H10-RegistroDeCheques[[#This Row],[RETIRADA]]), \"\")","v":{"v":3334,"d":"$3,334.00"}}]
[null,"PF",{"$f":"TODAY()","v":"2018-06-14"},"The Phone Company",null,{"v":23,"d":"$23.00"},null,{"$f":"IFERROR(IF(ISBLANK(RegistroDeCheques[[#This Row],[RETIRADA]]),H11+RegistroDeCheques[[#This Row],[DEPÓSITO]],H11-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"}}]