{"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,"AP = 自動支払 ",{"$nulls":3},{"$f":"現在の残高","v":{"v":3311,"d":"¥3,311.00"}}]
[null,"ATM = 現金自動預払機による出金",null,"BP = オンライン決済"]
[null,"AD = 自動預金機 ",null,"TR = オンラインまたは電話による振替"]
[null,"小切手/コード","日付","取引","説明","出金","預金","残高"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-18"},"Woodgrove Bank","期首残高",null,{"v":2000,"d":"¥2,000.00"},{"$f":"IFERROR(小切手台帳[[#This Row],[預金]], \"\")","v":{"v":2000,"d":"¥2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-26"},"ファイン アート スクール","Kelly の授業料 - 6 週間分",{"v":100,"d":"¥100.00"},null,{"$f":"IFERROR(IF(ISBLANK(小切手台帳[[#This Row],[出金]]),H7+小切手台帳[[#This Row],[預金]],H7-小切手台帳[[#This Row],[出金]]), \"\")","v":{"v":1900,"d":"¥1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2022-03-26"},"給与",null,null,{"v":1500,"d":"¥1,500.00"},{"$f":"IFERROR(IF(ISBLANK(小切手台帳[[#This Row],[出金]]),H8+小切手台帳[[#This Row],[預金]],H8-小切手台帳[[#This Row],[出金]]), \"\")","v":{"v":3400,"d":"¥3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2022-03-29"},"Southridge Video","映画レンタル + $10 キャッシュ バック",{"v":16,"d":"¥16.00"},null,{"$f":"IFERROR(IF(ISBLANK(小切手台帳[[#This Row],[出金]]),H9+小切手台帳[[#This Row],[預金]],H9-小切手台帳[[#This Row],[出金]]), \"\")","v":{"v":3384,"d":"¥3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-01"},null,"外食で現金支払",{"v":50,"d":"¥50.00"},null,{"$f":"IFERROR(IF(ISBLANK(小切手台帳[[#This Row],[出金]]),H10+小切手台帳[[#This Row],[預金]],H10-小切手台帳[[#This Row],[出金]]), \"\")","v":{"v":3334,"d":"¥3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2022-04-06"},"The Phone Company",null,{"v":23,"d":"¥23.00"},null,{"$f":"IFERROR(IF(ISBLANK(小切手台帳[[#This Row],[出金]]),H11+小切手台帳[[#This Row],[預金]],H11-小切手台帳[[#This Row],[出金]]), \"\")","v":{"v":3311,"d":"¥3,311.00"}}]
[null,"合計",null,{"$f":"CONCATENATE(\"取引数: \",SUBTOTAL(103,小切手台帳[取引]))","v":"取引数: 5"},null,{"$f":"SUBTOTAL(109,小切手台帳[出金])","v":{"v":189,"d":"¥189.00"}},{"$f":"SUBTOTAL(109,小切手台帳[預金])","v":{"v":3500,"d":"¥3,500.00"}},{"$f":"小切手台帳[[#Totals],[預金]]-小切手台帳[[#Totals],[出金]]","v":{"v":3311,"d":"¥3,311.00"}}]