{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["零用金报销单"],"not_rendered":{"images":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"零用金报销单","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[0,1,0,8],[0,9,0,11],[2,2,2,3],[2,4,2,5],[2,6,2,7],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[17,1,17,10],[18,1,18,10],[19,1,19,10],[20,2,20,4],[20,6,20,9]]}
[null,"公司名称",{"$nulls":7},"仅用于办公用途"]
[null,"零用金报销单"]
[null,"事由：",null,null,"结算单号：",{"$nulls":4},"付款期：","开始日期",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MIN(费用[日期])), \"\")","v":""}]
[{"$nulls":10},"结束日期",{"$f":"IFERROR(IF(LEN(B10)=0,\"\",MAX(费用[日期])), \"\")","v":""}]
[null,"员工信息："]
[null,"姓名",{"$nulls":3},"职位",{"$nulls":3},"SSN/EIN"]
[null,"部门",{"$nulls":3},"经理",{"$nulls":3},"员工 ID"]
[]
[null,"日期","账目","说明","住宿费","交通费","油费","餐饮费","电话费","招待费","杂项费","总计"]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[{"$nulls":11},{"$f":"IFERROR(SUM(费用[[#This Row],[住宿费]:[杂项费]]), \"\")","v":0}]
[null,"总计",null,null,{"$f":"SUBTOTAL(109,费用[住宿费])","v":0},{"$f":"SUBTOTAL(109,费用[交通费])","v":0},{"$f":"SUBTOTAL(109,费用[油费])","v":0},{"$f":"SUBTOTAL(109,费用[餐饮费])","v":0},{"$f":"SUBTOTAL(109,费用[电话费])","v":0},{"$f":"SUBTOTAL(109,费用[招待费])","v":0},{"$f":"SUBTOTAL(109,费用[杂项费])","v":0},{"$f":"SUBTOTAL(109,费用[总计])","v":0}]
[null,"小计",{"$nulls":9},{"$f":"IFERROR(SUM(费用[[#Totals],[总计]]), \"\")","v":0}]
[null,"预付现金"]
[null,"总计",{"$nulls":9},{"$f":"IFERROR((L18-L19), \"\")","v":0}]
[null,"批准人：",{"$nulls":3},"备注： "]