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

{"sheet":"信用卡记录","index":0,"n_rows":11,"n_cols":7,"rows_kept":11}
[null,"信用卡名称"]
[null,"在下表中以负数形式输入支付金额。"]
[null,"日期","说明","金额","商户名称","交易费","余额*"]
[null,{"$f":"TODAY()-5","v":"2022-12-01"},"现有余额",{"v":45,"d":"¥45.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":45,"d":"¥45.00"}}]
[null,{"$f":"TODAY()-4","v":"2022-12-02"},"6 月付款",{"v":-34,"d":"¥-34.00"},"Woodgrove Bank",{"v":2,"d":"¥2.00"},{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":13,"d":"¥13.00"}}]
[null,{"$f":"TODAY()-3","v":"2022-12-03"},"图片框",{"v":45,"d":"¥45.00"},"Northwind Traders",null,{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":58,"d":"¥58.00"}}]
[null,{"$f":"TODAY()-2","v":"2022-12-04"},"葡萄酒",{"v":600,"d":"¥600.00"},"Wide World Importers",{"v":20,"d":"¥20.00"},{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":678,"d":"¥678.00"}}]
[null,{"$f":"TODAY()-1","v":"2022-12-05"},"毛伊岛票务",{"v":469,"d":"¥469.00"},"Margie's Travel",null,{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":1147,"d":"¥1,147.00"}}]
[null,{"$f":"TODAY()","v":"2022-12-06"},"现金取款",{"v":654,"d":"¥654.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(数据[[#Headers],[余额*]])=1,数据[[#This Row],[交易费]]+数据[[#This Row],[金额]],SUM(INDEX(数据[金额],1,1):数据[[#This Row],[金额]],INDEX(数据[交易费],1,1):数据[[#This Row],[交易费]])), \"\")","v":{"v":1801,"d":"¥1,801.00"}}]
[null,"汇总",null,{"$f":"SUBTOTAL(109,数据[金额])","v":{"v":1779,"d":"¥1,779.00"}},null,{"$f":"SUBTOTAL(109,数据[交易费])","v":{"v":22,"d":"¥22.00"}}]
[{"$nulls":6},"*（不包括利息）"]