{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["支票登記表"],"read":"whole","date_system":"1900"}

{"sheet":"支票登記表","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[3,6,4,7]]}
["支票登記表",{"$nulls":7}," "]
[null,"代碼說明",{"$nulls":4},"目前餘額",null," "]
[]
[null,"DC = 簽帳卡",null,"AP = 自動付款 ",null,null,{"$f":"CheckRegister[[#Totals],[餘額]]","v":{"v":99330,"d":"NT$99,330.00"}}]
[null,"ATM = 自動櫃員機提款",null,"BP = 線上帳單繳費"]
[null,"AD = 自動存款 ",null,"TR = 線上或電話轉帳"]
[]
[null,"支票/代碼","日期","交易","描述","提款","存款","餘額"]
[null,null,"2012-01-04","第二銀行","期初餘額",null,{"v":60000,"d":"NT$60,000.00"},{"$f":"CheckRegister[[#This Row],[存款]]","v":{"v":60000,"d":"NT$60,000.00"}}]
[null,1001,"2012-01-15","美術學校","卡洛的美術課 - 6 週",{"v":3000,"d":"NT$3,000.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[提款]]),H9+CheckRegister[[#This Row],[存款]],H9-CheckRegister[[#This Row],[提款]])","v":{"v":57000,"d":"NT$57,000.00"}}]
[null,"AD","2012-01-15","薪水",null,null,{"v":45000,"d":"NT$45,000.00"},{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[提款]]),H10+CheckRegister[[#This Row],[存款]],H10-CheckRegister[[#This Row],[提款]])","v":{"v":102000,"d":"NT$102,000.00"}}]
[null,"DC","2012-01-18","萬海影音","影片租借 + $10 元現金回饋",{"v":480,"d":"NT$480.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[提款]]),H11+CheckRegister[[#This Row],[存款]],H11-CheckRegister[[#This Row],[提款]])","v":{"v":101520,"d":"NT$101,520.00"}}]
[null,"ATM","2012-01-23",null,"外食所需的現金",{"v":1500,"d":"NT$1,500.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[提款]]),H12+CheckRegister[[#This Row],[存款]],H12-CheckRegister[[#This Row],[提款]])","v":{"v":100020,"d":"NT$100,020.00"}}]
[null,"BP","2012-01-24","中國通",null,{"v":690,"d":"NT$690.00"},null,{"$f":"IF(ISBLANK(CheckRegister[[#This Row],[提款]]),H13+CheckRegister[[#This Row],[存款]],H13-CheckRegister[[#This Row],[提款]])","v":{"v":99330,"d":"NT$99,330.00"}}]
[null,"合計",null,{"$f":"CONCATENATE(\"交易計數: \",SUBTOTAL(103,CheckRegister[交易]))","v":"交易計數: 5"},null,{"$f":"SUBTOTAL(109,CheckRegister[提款])","v":{"v":5670,"d":"NT$5,670.00"}},{"$f":"SUBTOTAL(109,CheckRegister[存款])","v":{"v":105000,"d":"NT$105,000.00"}},{"$f":"CheckRegister[[#Totals],[存款]]-CheckRegister[[#Totals],[提款]]","v":{"v":99330,"d":"NT$99,330.00"}}]