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

{"sheet":"支票登記簿","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"支票登記簿"]
[null,"代碼說明",{"$nulls":5},"目前餘額"]
[null,"DC = 轉帳卡",null,"AD = 自動付款 ",{"$nulls":3},{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"NT$3,311.00"}}]
[null,"ATM = 自動櫃員機提款",null,"BP = 線上帳單繳費"]
[null,"AD = 自動存款 ",null,"TR = 線上或電話轉帳"]
[null,"支票/代碼","日期","交易","描述","提款","存款","餘額"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-18"},"木林銀行","期初餘額",null,{"v":2000,"d":"NT$2,000.00"},{"$f":"IFERROR(支票登記簿[[#This Row],[存款]], \"\")","v":{"v":2000,"d":"NT$2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-26"},"美術學校","梨莎的美術課 - 6 週",{"v":100,"d":"NT$100.00"},null,{"$f":"IFERROR(IF(ISBLANK(支票登記簿[[#This Row],[提款]]),H7+支票登記簿[[#This Row],[存款]],H7-支票登記簿[[#This Row],[提款]]), \"\")","v":{"v":1900,"d":"NT$1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2022-03-26"},"薪水",null,null,{"v":1500,"d":"NT$1,500.00"},{"$f":"IFERROR(IF(ISBLANK(支票登記簿[[#This Row],[提款]]),H8+支票登記簿[[#This Row],[存款]],H8-支票登記簿[[#This Row],[提款]]), \"\")","v":{"v":3400,"d":"NT$3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2022-03-29"},"南橋影音","影片租借 + NT$10 元現金回饋",{"v":16,"d":"NT$16.00"},null,{"$f":"IFERROR(IF(ISBLANK(支票登記簿[[#This Row],[提款]]),H9+支票登記簿[[#This Row],[存款]],H9-支票登記簿[[#This Row],[提款]]), \"\")","v":{"v":3384,"d":"NT$3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-01"},null,"外食所需的現金",{"v":50,"d":"NT$50.00"},null,{"$f":"IFERROR(IF(ISBLANK(支票登記簿[[#This Row],[提款]]),H10+支票登記簿[[#This Row],[存款]],H10-支票登記簿[[#This Row],[提款]]), \"\")","v":{"v":3334,"d":"NT$3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2022-04-06"},"電信公司",null,{"v":23,"d":"NT$23.00"},null,{"$f":"IFERROR(IF(ISBLANK(支票登記簿[[#This Row],[提款]]),H11+支票登記簿[[#This Row],[存款]],H11-支票登記簿[[#This Row],[提款]]), \"\")","v":{"v":3311,"d":"NT$3,311.00"}}]
[null,"合計",null,{"$f":"CONCATENATE(\"交易計數: \",SUBTOTAL(103,支票登記簿[交易]))","v":"交易計數: 5"},null,{"$f":"SUBTOTAL(109,支票登記簿[提款])","v":{"v":189,"d":"NT$189.00"}},{"$f":"SUBTOTAL(109,支票登記簿[存款])","v":{"v":3500,"d":"NT$3,500.00"}},{"$f":"支票登記簿[[#Totals],[存款]]-支票登記簿[[#Totals],[提款]]","v":{"v":3311,"d":"NT$3,311.00"}}]