{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["信用卡記錄"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"信用卡記錄","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[null,"信用卡號碼"]
[null,"將支付的款項以負數金額輸入於下表中。"]
[null,"日期","描述","金額","商店名稱","交易手續費","餘額\n(不含利息)"]
[null,{"$f":"TODAY()-5","v":"2018-06-24"},"現存結餘",{"v":45,"d":"NT$45.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":45,"d":"NT$45.00"}}]
[null,{"$f":"TODAY()-4","v":"2018-06-25"},"6 月款項",{"v":-34,"d":"-NT$34.00"},"Woodgrove Bank",{"v":2,"d":"NT$2.00"},{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":13,"d":"NT$13.00"}}]
[null,{"$f":"TODAY()-3","v":"2018-06-26"},"相框",{"v":45,"d":"NT$45.00"},"Northwind Traders",null,{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":58,"d":"NT$58.00"}}]
[null,{"$f":"TODAY()-2","v":"2018-06-27"},"紅酒",{"v":600,"d":"NT$600.00"},"Coho Winery",{"v":20,"d":"NT$20.00"},{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":678,"d":"NT$678.00"}}]
[null,{"$f":"TODAY()-1","v":"2018-06-28"},"往茂宜島的票",{"v":469,"d":"NT$469.00"},"Blue Yonder Airlines",null,{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":1147,"d":"NT$1,147.00"}}]
[null,{"$f":"TODAY()","v":"2018-06-29"},"提款",{"v":654,"d":"NT$654.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(資料[[#Headers],[餘額\n(不含利息)]])=1,資料[[#This Row],[交易手續費]]+資料[[#This Row],[金額]],SUM(INDEX(資料[金額],1,1):資料[[#This Row],[金額]],INDEX(資料[交易手續費],1,1):資料[[#This Row],[交易手續費]])), \"\")","v":{"v":1801,"d":"NT$1,801.00"}}]
[null,"合計",null,{"$f":"SUBTOTAL(109,資料[金額])","v":{"v":1779,"d":"NT$1,779.00"}},null,{"$f":"SUBTOTAL(109,資料[交易手續費])","v":{"v":22,"d":"NT$22.00"}}]