{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["存款","取款"],"not_rendered":{"defined_names":14},"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":"存款_总额","v":{"v":5400,"d":"¥5,400.00"}}]
[{"$nulls":3},"年份","期末余额","取款总额"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(期末余额+存款_总额-取款_总额, \"\")","v":{"v":6550.54,"d":"¥6,550.54"}},{"$f":"取款_总额","v":{"v":1375,"d":"¥1,375.00"}}]
[null,"存款"]
[null,"存款编号","日期","金额","说明","已对帐"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款编号]])","v":1},{"$f":"TODAY()-15","v":"2018-05-02"},{"v":1500,"d":"¥1,500.00"},"工作 1，支票 1","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款编号]])","v":2},{"$f":"TODAY()-10","v":"2018-05-07"},{"v":1200,"d":"¥1,200.00"},"工作 2，支票 1","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款编号]])","v":3},{"$f":"TODAY()-5","v":"2018-05-12"},{"v":1500,"d":"¥1,500.00"},"工作 1，支票 2","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款编号]])","v":4},{"$f":"TODAY()","v":"2018-05-17"},{"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-09"},{"v":150,"d":"¥150.00"},"电费","是"]
[null,"支票 1002",{"$f":"TODAY()-6","v":"2018-05-11"},{"v":150,"d":"¥150.00"},"水费/下水道修理费/垃圾清理费","是"]
[null,"支票 1003",{"$f":"TODAY()-4","v":"2018-05-13"},{"v":850,"d":"¥850.00"},"抵押贷款","是"]
[null,"借记卡",{"$f":"TODAY()-2","v":"2018-05-15"},{"v":125,"d":"¥125.00"},"日用杂货","是"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-17"},{"v":100,"d":"¥100.00"},"现金","是"]
[null,"汇总",null,{"$f":"SUBTOTAL(109,支票[金额])","v":{"v":1375,"d":"¥1,375.00"}}]