{"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":314.7,"d":"¥314.70"}}]
[]
[null,"日期","收据编号","说明","存入金额","提取金额","付款人","收款人","审批人"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-07-01"},1011,"存入零用现金",{"v":500,"d":"¥500.00"},null,"零用现金",null,"林媚卉"]
[null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),3)","v":"2018-07-03"},243,"为加班员工购买披萨",null,{"v":185.3,"d":"¥185.30"},"士气鼓舞帐户","廖磊","林媚卉"]
[]
[]
[]
[null,"总计",{"$f":"SUBTOTAL(103,现金记录[收据编号])","v":2},null,{"$f":"SUBTOTAL(109,现金记录[存入金额])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,现金记录[提取金额])","v":{"v":185.3,"d":"¥185.30"}}]