{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["零用金收支表"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"零用金收支表","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"merged":[[3,1,3,3],[3,6,3,7]]}
[null,"公司名稱"]
[null,"零用金收支表"]
[]
[null,{"$f":"\"從 \"&TEXT(MIN(B7:B11),\"[$-x-sysdate]dddd, mmmm dd, yyyy\")&\" 到 \"&TEXT(MAX(B7:B11),\"[$-x-sysdate]dddd, mmmm dd, yyyy\")","v":"從 2018年7月1日 到 2018年7月3日"},null,null,"餘額",{"$f":"IFERROR(E12-F12, \"\")","v":{"v":944.1,"d":"NT$944.10"}}]
[]
[null,"日期","收據編號","說明","存入金額","支出金額","付款方式","簽收","核准者"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-07-01"},1011,"存入零用金",{"v":1500,"d":"NT$1,500.00"},null,"零用金",null,"張舒慧"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),3)","v":"2018-07-03"},243,"給加班人員的披薩",null,{"v":555.9,"d":"NT$555.90"},"員工福利金","羅書成","張舒慧"]
[]
[]
[]
[null,"總計",{"$f":"SUBTOTAL(103,收支記錄[收據編號])","v":2},null,{"$f":"SUBTOTAL(109,收支記錄[存入金額])","v":{"v":1500,"d":"NT$1,500.00"}},{"$f":"SUBTOTAL(109,收支記錄[支出金額])","v":{"v":555.9,"d":"NT$555.90"}}]