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

{"sheet":"零用金报销单","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"merged":[[1,2,1,3],[1,5,1,6],[3,2,3,3],[3,6,3,7],[3,10,3,11],[4,2,4,3],[4,6,4,7],[4,10,4,11],[20,2,20,4],[20,6,20,8],[21,2,21,4],[21,6,21,8]]}
[null,"零用金报销单",{"$nulls":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"}}]