{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["銀行調節表"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"銀行調節表","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[1,1,4,2],[13,1,13,4]]}
[]
[null,"每月\n銀行\n對帳單",null,"月份","先前餘額","存款總額"]
[{"$nulls":3},"六月",{"v":2525.54,"d":"NT$2,526"},{"$f":"tblDeposits[[#Totals],[金額]]","v":{"v":162000,"d":"NT$162,000"}}]
[{"$nulls":3},"年度","結算餘額","提款總額"]
[{"$nulls":3},2013,{"$f":"EndingBalance+tblDeposits[[#Totals],[金額]]-tblChecks[[#Totals],[金額]]","v":{"v":123275.54000000001,"d":"NT$123,276"}},{"$f":"tblChecks[[#Totals],[金額]]","v":{"v":41250,"d":"NT$41,250"}}," "]
[]
[null,"存款",{"$nulls":4}," "]
[null,"存款編號","日期","金額","描述","調節情況"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[#Data],[存款編號]])","v":1},"2013-06-02",{"v":45000,"d":"NT$45,000"},"工作 1，支票 1","是"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[#Data],[存款編號]])","v":2},"2013-06-15",{"v":36000,"d":"NT$36,000"},"工作 2，支票 1","是"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[#Data],[存款編號]])","v":3},"2013-06-16",{"v":45000,"d":"NT$45,000"},"工作 1，支票 2","是"]
[null,{"$f":"ROW()-ROW(tblDeposits[[#Headers],[#Data],[存款編號]])","v":4},"2013-06-30",{"v":36000,"d":"NT$36,000"},"工作 2，支票 2","是"]
[null,"合計",null,{"$f":"SUBTOTAL(109,tblDeposits[[#Headers],[#Data],[金額]])","v":{"v":162000,"d":"NT$162,000"}}]
[]
[null,"提款"]
[null,"類型","日期","金額","用途","調節情況"]
[null,"支票 1001","2013-06-01",{"v":4500,"d":"NT$4,500"},"電費","是"]
[null,"支票 1002","2013-06-02",{"v":4500,"d":"NT$4,500"},"水費/汙水處理/垃圾","是"]
[null,"支票 1003","2013-06-04",{"v":25500,"d":"NT$25,500"},"房貸","是"]
[null,"轉帳","2013-06-08",{"v":3750,"d":"NT$3,750"},"日常雜貨","是"]
[null,"ATM","2013-06-09",{"v":3000,"d":"NT$3,000"},"現金","是"]
[null,"合計",null,{"$f":"SUBTOTAL(109,tblChecks[[#Headers],[#Data],[金額]])","v":{"v":41250,"d":"NT$41,250"}}]