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

{"sheet":"零用金报销单","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"merged":[[2,2,2,3],[2,5,2,6],[4,2,4,3],[4,6,4,7],[4,10,4,11],[5,2,5,3],[5,6,5,7],[5,10,5,11],[21,2,21,4],[21,6,21,8],[22,2,22,4],[22,6,22,8]]}
[]
[]
[null,"用途：",null,null,"结算单号：",null,null,"付款期","开始时间：",{"$f":"IF(COUNTA(ExpenseData[日期])=0,\"\",MIN(ExpenseData[日期]))","v":""},"结束时间：",{"$f":"IF(COUNTA(ExpenseData[日期])=0,\"\",MAX(ExpenseData[日期]))","v":""}]
[null,"员工信息："]
[null,"姓名",{"$nulls":3},"职位",{"$nulls":3},"SSN"]
[null,"部门",{"$nulls":3},"经理",{"$nulls":3},"员工 ID"]
[]
[null,"日期","账目","说明","住宿","交通费","燃油","餐饮","电话","娱乐","杂项费","汇总"]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":11},{"$f":"SUM(ExpenseData[[#This Row],[住宿]:[杂项费]])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",null,null,{"$f":"SUBTOTAL(109,ExpenseData[住宿])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[交通费])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[燃油])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[餐饮])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[电话])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[娱乐])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[杂项费])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExpenseData[汇总])","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":10},"小计",{"$f":"ExpenseData[[#Totals],[汇总]]","v":{"v":0,"d":"¥0.00"}}]
[null,"批准人：",{"$nulls":3},"备注： ",{"$nulls":4},"预付款",{"v":0,"d":"¥0.00"}]
[{"$nulls":10},"汇总",{"$f":"小计-预付款","v":{"v":0,"d":"¥0.00"}}]