{"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":13,"n_cols":8,"rows_kept":13,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[null,"Cheque Register"]
[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 = Cash machine withdrawal",null,"BP = Online bill payment"]
[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":"2018-05-27"},"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":"2018-06-04"},"School of Fine Art","Kelly’s art lessons – 6 weeks",{"v":100,"d":"£100.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[WITHDRAWAL]]),H7+ChequeRegister[[#This Row],[DEPOSIT]],H7-ChequeRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":1900,"d":"£1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2018-06-04"},"Pay slip",null,null,{"v":1500,"d":"£1,500.00"},{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[WITHDRAWAL]]),H8+ChequeRegister[[#This Row],[DEPOSIT]],H8-ChequeRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3400,"d":"£3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2018-06-07"},"Southridge Video","Film rental + £10 cashback",{"v":16,"d":"£16.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[WITHDRAWAL]]),H9+ChequeRegister[[#This Row],[DEPOSIT]],H9-ChequeRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3384,"d":"£3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2018-06-10"},null,"Cash for dining out",{"v":50,"d":"£50.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[WITHDRAWAL]]),H10+ChequeRegister[[#This Row],[DEPOSIT]],H10-ChequeRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3334,"d":"£3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2018-06-15"},"The Phone Company",null,{"v":23,"d":"£23.00"},null,{"$f":"IFERROR(IF(ISBLANK(ChequeRegister[[#This Row],[WITHDRAWAL]]),H11+ChequeRegister[[#This Row],[DEPOSIT]],H11-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"}}]