{"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月結單",null,"月份","前期餘額","總計存款金額"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"m\"&\"月\"))","v":"5月"},{"v":2525.54,"d":"NT$2,525.54"},{"$f":"存款_總計","v":{"v":5400,"d":"NT$5,400.00"}}]
[{"$nulls":3},"年份","期末餘額","總計提款金額"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(期末餘額+存款_總計-提款_總計, \"\")","v":{"v":6550.54,"d":"NT$6,550.54"}},{"$f":"提款_總計","v":{"v":1375,"d":"NT$1,375.00"}}]
[null,"存款"]
[null,"存款編號","日期","金額","描述","對帳"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款編號]])","v":1},{"$f":"TODAY()-15","v":"2018-04-30"},{"v":1500,"d":"NT$1,500.00"},"工作 1，支票 1","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款編號]])","v":2},{"$f":"TODAY()-10","v":"2018-05-05"},{"v":1200,"d":"NT$1,200.00"},"工作 2，支票 1","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款編號]])","v":3},{"$f":"TODAY()-5","v":"2018-05-10"},{"v":1500,"d":"NT$1,500.00"},"工作 1，支票 2","是"]
[null,{"$f":"ROW()-ROW(存款[[#Headers],[存款編號]])","v":4},{"$f":"TODAY()","v":"2018-05-15"},{"v":1200,"d":"NT$1,200.00"},"工作 2，支票 2","是"]
[null,"總計",null,{"$f":"SUBTOTAL(109,存款[金額])","v":{"v":5400,"d":"NT$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-07"},{"v":150,"d":"NT$150.00"},"電費","是"]
[null,"支票 1002",{"$f":"TODAY()-6","v":"2018-05-09"},{"v":150,"d":"NT$150.00"},"水費/污水下水道使用費/垃圾處理費","是"]
[null,"支票 1003",{"$f":"TODAY()-4","v":"2018-05-11"},{"v":850,"d":"NT$850.00"},"貸款","是"]
[null,"簽帳",{"$f":"TODAY()-2","v":"2018-05-13"},{"v":125,"d":"NT$125.00"},"雜貨","是"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-15"},{"v":100,"d":"NT$100.00"},"現金","是"]
[null,"總計",null,{"$f":"SUBTOTAL(109,支票[金額])","v":{"v":1375,"d":"NT$1,375.00"}}]