{"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},"身份證字號/統一編號"]
[null,"部門",{"$nulls":3},"主管",{"$nulls":3},"員工識別碼"]
[]
[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},"備註： "]