{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Check Register"],"read":"whole","date_system":"1900"}

{"sheet":"Check Register","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[3,6,4,7]]}
["Check Register",{"$nulls":7}," "]
[null,"LEGEND",{"$nulls":4},"CURRENT BALANCE",null," "]
[]
[null,"DC = Debit Card",null,"AP = Automatic Payment ",null,null,{"$f":"CheckRegister[[#Totals],[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,"CHECK/CODE","DATE","TRANSACTION","DESCRIPTION","WITHDRAWAL","DEPOSIT","BALANCE"]
[null,null,"2012-01-04","Woodgrove Bank","Opening Balance",null,{"v":2000,"d":"$2,000.00"},{"$f":"CheckRegister[[#This Row],[DEPOSIT]]","v":{"v":2000,"d":"$2,000.00"}}]
[null,1001,"2012-01-15","School of Fine Art","Kelly's art class - 6 weeks",{"v":100,"d":"$100.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H9+CheckRegister[[#This Row],[DEPOSIT]],H9-CheckRegister[[#This Row],[WITHDRAWAL]])","v":{"v":1900,"d":"$1,900.00"}}]
[null,"AD","2012-01-15","Paycheck",null,null,{"v":1500,"d":"$1,500.00"},{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H10+CheckRegister[[#This Row],[DEPOSIT]],H10-CheckRegister[[#This Row],[WITHDRAWAL]])","v":{"v":3400,"d":"$3,400.00"}}]
[null,"DC","2012-01-18","Southridge Video","Movie rental + $10 cash back",{"v":16,"d":"$16.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H11+CheckRegister[[#This Row],[DEPOSIT]],H11-CheckRegister[[#This Row],[WITHDRAWAL]])","v":{"v":3384,"d":"$3,384.00"}}]
[null,"ATM","2012-01-23",null,"Cash for dining out",{"v":50,"d":"$50.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H12+CheckRegister[[#This Row],[DEPOSIT]],H12-CheckRegister[[#This Row],[WITHDRAWAL]])","v":{"v":3334,"d":"$3,334.00"}}]
[null,"BP","2012-01-24","The Phone Company",null,{"v":23,"d":"$23.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H13+CheckRegister[[#This Row],[DEPOSIT]],H13-CheckRegister[[#This Row],[WITHDRAWAL]])","v":{"v":3311,"d":"$3,311.00"}}]
[null,"Totals",null,{"$f":"CONCATENATE(\"Transaction count: \",SUBTOTAL(103,CheckRegister[TRANSACTION]))","v":"Transaction count: 5"},null,{"$f":"SUBTOTAL(109,CheckRegister[WITHDRAWAL])","v":{"v":189,"d":"$189.00"}},{"$f":"SUBTOTAL(109,CheckRegister[DEPOSIT])","v":{"v":3500,"d":"$3,500.00"}},{"$f":"CheckRegister[[#Totals],[DEPOSIT]]-CheckRegister[[#Totals],[WITHDRAWAL]]","v":{"v":3311,"d":"$3,311.00"}}]