{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["預金","引き出し"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"預金","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"毎月の\n銀行\n取引明細書",null,"月","前回の残高","預金合計"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"m月\"))","v":"5月"},{"v":2525.54,"d":"¥2,525.54"},{"$f":"Deposit_total","v":{"v":5400,"d":"¥5,400.00"}}]
[{"$nulls":3},"年","期末残高","引き出し合計"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(EndingBalance+Deposit_total-Withdrawls_total, \"\")","v":{"v":6550.54,"d":"¥6,550.54"}},{"$f":"Withdrawls_total","v":{"v":1375,"d":"¥1,375.00"}}]
[null,"預金"]
[null,"預金番号","日付","金額","明細","調整済み"]
[null,{"$f":"ROW()-ROW(預金[[#Headers],[預金番号]])","v":1},{"$f":"TODAY()-15","v":"2018-05-01"},{"v":1500,"d":"¥1,500.00"},"仕事 1、小切手 1","はい"]
[null,{"$f":"ROW()-ROW(預金[[#Headers],[預金番号]])","v":2},{"$f":"TODAY()-10","v":"2018-05-06"},{"v":1200,"d":"¥1,200.00"},"仕事 2、小切手 1","はい"]
[null,{"$f":"ROW()-ROW(預金[[#Headers],[預金番号]])","v":3},{"$f":"TODAY()-5","v":"2018-05-11"},{"v":1500,"d":"¥1,500.00"},"仕事 1、小切手 2","はい"]
[null,{"$f":"ROW()-ROW(預金[[#Headers],[預金番号]])","v":4},{"$f":"TODAY()","v":"2018-05-16"},{"v":1200,"d":"¥1,200.00"},"仕事 2、小切手 2","はい"]
[null,"合計",null,{"$f":"SUBTOTAL(109,預金[金額])","v":{"v":5400,"d":"¥5,400.00"}}]

{"sheet":"引き出し","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"引き出し"]
[null,"種目","日付","金額","用途","調整済み"]
[null,"小切手 1001",{"$f":"TODAY()-8","v":"2018-05-08"},{"v":150,"d":"¥150.00"},"電気代","はい"]
[null,"小切手 1002",{"$f":"TODAY()-6","v":"2018-05-10"},{"v":150,"d":"¥150.00"},"上下水道/ごみ","はい"]
[null,"小切手 1003",{"$f":"TODAY()-4","v":"2018-05-12"},{"v":850,"d":"¥850.00"},"住宅ローン","はい"]
[null,"引き落とし",{"$f":"TODAY()-2","v":"2018-05-14"},{"v":125,"d":"¥125.00"},"食料品","はい"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-16"},{"v":100,"d":"¥100.00"},"現金","はい"]
[null,"合計",null,{"$f":"SUBTOTAL(109,小切手[金額])","v":{"v":1375,"d":"¥1,375.00"}}]