{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["小切手台帳"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"小切手台帳","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"小切手台帳"]
[null,"このセルには、銀行口座番号を入力します。"]
[null,{"$f":"CONCATENATE(\"現在の残高 : \"&TEXT(小切手台帳[[#Totals],[残高]],\"¥#,##0.00\"))","v":"現在の残高 : ¥2,730.84"}]
[]
[{"$nulls":4},"小切手 #","日付","説明","カテゴリ","出金","預金","残高"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-12"},"期首残高","預金",null,{"v":2916.73,"d":"¥2,916.73"},{"$f":"InitialBalance","v":{"v":2916.73,"d":"¥2,916.73"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-13"},"食料品店","食料品",{"v":205.61,"d":"¥205.61"},null,{"$f":"残高","v":{"v":2711.12,"d":"¥2,711.12"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-27"},"住宅ローン","住宅ローン",{"v":961.77,"d":"¥961.77"},null,{"$f":"残高","v":{"v":1749.35,"d":"¥1,749.35"}}]
[{"$nulls":4},"デビット",{"$f":"TODAY()-40","v":"2018-04-01"},"コーヒー ショップ","その他",{"v":3.65,"d":"¥3.65"},null,{"$f":"残高","v":{"v":1745.6999999999998,"d":"¥1,745.70"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-06"},"ガスと電気会社","水道光熱費",{"v":145.33,"d":"¥145.33"},null,{"$f":"残高","v":{"v":1600.37,"d":"¥1,600.37"}}]
[{"$nulls":4},"ATM",{"$f":"TODAY()-30","v":"2018-04-11"},"現金","その他",{"v":50,"d":"¥50.00"},null,{"$f":"残高","v":{"v":1550.37,"d":"¥1,550.37"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-16"},"クレジット カード","クレジット カード",{"v":936.48,"d":"¥936.48"},null,{"$f":"残高","v":{"v":613.8899999999999,"d":"¥613.89"}}]
[null,"サマリー​​",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-21"},"給与","預金",null,{"v":2365.82,"d":"¥2,365.82"},{"$f":"残高","v":{"v":2979.71,"d":"¥2,979.71"}}]
[null,"カテゴリ","合計",null,null,{"$f":"TODAY()-15","v":"2018-04-26"},"投信投資","投資",{"v":200,"d":"¥200.00"},null,{"$f":"残高","v":{"v":2779.71,"d":"¥2,779.71"}}]
[null,"預金",{"$f":"CategoryTotal","v":{"v":5282.55,"d":"¥5,282.55"}},null,2253,{"$f":"TODAY()","v":"2018-05-11"},"電話会社","水道光熱費",{"v":48.87,"d":"¥48.87"},null,{"$f":"残高","v":{"v":2730.84,"d":"¥2,730.84"}}]
[null,"クレジット カード",{"$f":"CategoryTotal","v":{"v":936.48,"d":"¥936.48"}},null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,小切手台帳[出金])","v":{"v":2551.71,"d":"¥2,551.71"}},{"$f":"SUBTOTAL(109,小切手台帳[預金])","v":{"v":5282.55,"d":"¥5,282.55"}},{"$f":"小切手台帳[[#Totals],[預金]]-小切手台帳[[#Totals],[出金]]","v":{"v":2730.84,"d":"¥2,730.84"}}]
[null,"投資",{"$f":"CategoryTotal","v":{"v":200,"d":"¥200.00"}}]
[null,"食料品",{"$f":"CategoryTotal","v":{"v":205.61,"d":"¥205.61"}}]
[null,"水道光熱費",{"$f":"CategoryTotal","v":{"v":194.20000000000002,"d":"¥194.20"}}]
[null,"保険料",{"$f":"CategoryTotal","v":{"v":0,"d":"¥0.00"}}]
[null,"住宅ローン",{"$f":"CategoryTotal","v":{"v":961.77,"d":"¥961.77"}}]
[null,"その他",{"$f":"CategoryTotal","v":{"v":53.65,"d":"¥53.65"}}]