{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["差旅费用计算表"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"差旅费用计算表","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"merged":[[0,1,0,9],[1,1,1,2],[1,3,1,4],[1,6,1,9],[2,1,2,2],[2,3,2,4],[2,6,2,7],[2,8,2,9],[3,1,4,1],[3,3,3,4],[3,6,3,7],[3,8,3,9],[4,3,4,4],[4,6,4,7],[4,8,4,9],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,8,5,9],[6,2,6,4],[6,6,6,7],[6,8,6,9],[8,2,8,4],[8,6,8,9]]}
[null,"差旅费用计算表"]
[null,"员工姓名",{"$nulls":4},"费用一览表"]
[null,"员工 ID",{"$nulls":4},"总出行天数"]
[null,"出行日期","开始日期",{"$nulls":3},"交通费",null,{"$f":"IFERROR(E17, \"\")","v":{"v":0,"d":"¥0.00"}}]
[null,null,"结束日期",{"$nulls":3},"住宿费",null,{"$f":"IFERROR(F17, \"\")","v":{"v":0,"d":"¥0.00"}}]
[null,"事由",{"$nulls":4},"餐饮费",null,{"$f":"IFERROR(SUM(G17:J17), \"\")","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":6},"总出行费用",null,{"$f":"IFERROR(SUM(I4:I6),\"\")","v":{"v":0,"d":"¥0.00"}}]
[]
[null,null,"交通",null,null,"住宿","餐饮"]
[null,"日期","出发地（起点站）","目的地（终点站）","¥","¥ ","早餐","午餐","晚餐","零食"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"SUBTOTAL(109,计算表[¥])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,计算表[[¥ ]])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,计算表[早餐])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,计算表[午餐])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,计算表[晚餐])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,计算表[零食])","v":{"v":0,"d":"¥0.00"}}]