{"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-07"},"既存の残高",{"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-08"},"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-09"},"図枠",{"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-10"},"ワイン",{"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-11"},"マウイ行きのチケット",{"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-12"},"出金",{"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},"*(利息は含まれません)"]