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

{"sheet":"Cheque register","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,"LEGEND",{"$nulls":5},"CURRENT BALANCE"]
[null,"DC = Debit Card",null,"AP = Automatic Payment ",{"$nulls":3},{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"£3,311.00"}}]
[null,"ATM = Automated Teller Withdrawal",null,"BP = Online Bill Pay"]
[null,"AD = Automatic Deposit ",null,"TR = Online or Phone Transfer"]
[]
[null,"Cheque/Code","Date","Transaction","Description","Withdrawal","Deposit","Balance"]
[null,null,{"$f":"TODAY()-19","v":"2019-05-12"},"Woodgrove Bank","Opening balance",null,{"v":2000,"d":"£2,000.00"},{"$f":"IFERROR(ChequeRegister[[#This Row],[Deposit]], \"\")","v":{"v":2000,"d":"£2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2019-05-20"},"School of Fine Art","Kelly’s art lessons – 6 weeks",{"v":100,"d":"£100.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[Withdrawal]]),H9+ChequeRegister[[#This Row],[Deposit]],H9-ChequeRegister[[#This Row],[Withdrawal]]), \"\")","v":{"v":1900,"d":"£1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2019-05-20"},"Pay slip",null,null,{"v":1500,"d":"£1,500.00"},{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[Withdrawal]]),H10+ChequeRegister[[#This Row],[Deposit]],H10-ChequeRegister[[#This Row],[Withdrawal]]), \"\")","v":{"v":3400,"d":"£3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2019-05-23"},"Southridge Video","Film rental + £10 cashback",{"v":16,"d":"£16.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[Withdrawal]]),H11+ChequeRegister[[#This Row],[Deposit]],H11-ChequeRegister[[#This Row],[Withdrawal]]), \"\")","v":{"v":3384,"d":"£3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2019-05-26"},null,"Cash for dining out",{"v":50,"d":"£50.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[Withdrawal]]),H12+ChequeRegister[[#This Row],[Deposit]],H12-ChequeRegister[[#This Row],[Withdrawal]]), \"\")","v":{"v":3334,"d":"£3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2019-05-31"},"The Phone Company",null,{"v":23,"d":"£23.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[Withdrawal]]),H13+ChequeRegister[[#This Row],[Deposit]],H13-ChequeRegister[[#This Row],[Withdrawal]]), \"\")","v":{"v":3311,"d":"£3,311.00"}}]
[null,"Totals",null,{"$f":"CONCATENATE(\"Transaction count: \",SUBTOTAL(103,ChequeRegister[Transaction]))","v":"Transaction count: 5"},null,{"$f":"SUBTOTAL(109,ChequeRegister[Withdrawal])","v":{"v":189,"d":"£189.00"}},{"$f":"SUBTOTAL(109,ChequeRegister[Deposit])","v":{"v":3500,"d":"£3,500.00"}},{"$f":"ChequeRegister[[#Totals],[Deposit]]-ChequeRegister[[#Totals],[Withdrawal]]","v":{"v":3311,"d":"£3,311.00"}}]