{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["費用報表"],"not_rendered":{"images":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"費用報表","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"費用報表"]
[null,"CONTOSO, LTD"]
[null,"12345 紐約州北水牛城城南大街 123 號"]
[null,"電話",4255550121,null,"姓名","翁祖君",null,null,"事由","銷售研討年會",null,"里程補貼費率",{"v":15,"d":"NT$15.00/英哩"}]
[null,"傳真",4255550122,null,"部門","銷售",null,null,"開始日期",{"$f":"IFERROR(MIN(費用[日期]),\"\")","v":"2018-06-28"},null,"餐費補貼費率",{"v":900,"d":"NT$900.00/天"}]
[null,"電子郵件","info@contoso.com",null,"職位","總經理",null,null,"結束日期",{"$f":"IFERROR(MAX(費用[日期]),\"\")","v":"2018-07-28"},null,"住宿費補貼費率",{"v":6000,"d":"NT$6,000.00/晚"}]
[null,"網站","www.contoso.com",null,"主管","康邁可",null,null,"申報人","翁祖君",null,"電話費補貼費率",{"v":300,"d":"NT$300.00/天"}]
[{"$nulls":8},"核准人","康邁可",null,"雜項費用補貼費率",{"v":1500,"d":"NT$1,500.00/天"}]
[]
[null,"日期","會計科目","描述","住宿費","交通費","餐費","電話費","雜項費用","里程數開始","里程數結束","里程數總計","總計 "]
[null,{"$f":"TODAY()","v":"2018-06-28"},"銷售","里程數補貼",{"$nulls":4},{"v":1500,"d":"NT$1,500.00"},{"v":11378.5,"d":"11,378.5 英哩"},{"v":11456.2,"d":"11,456.2 英哩"},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":{"v":1165.500000000011,"d":"NT$1,165.50"}},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":{"v":2665.500000000011,"d":"NT$2,665.50"}}]
[null,{"$f":"TODAY()+30","v":"2018-07-28"},"銷售","開會",{"v":13350,"d":"NT$13,350.00"},{"v":6750,"d":"NT$6,750.00"},{"v":600,"d":"NT$600.00"},null,{"v":150,"d":"NT$150.00"},{"v":11500,"d":"11,500.0 英哩"},{"v":11560,"d":"11,560.0 英哩"},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":{"v":900,"d":"NT$900.00"}},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":{"v":21750,"d":"NT$21,750.00"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(費用[[#This Row],[里程數開始]:[里程數結束]])=2,(費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*里程補貼費率,\"\")","v":""},{"$f":"IF(COUNTA(費用[[#This Row],[日期]:[里程數結束]])=0,\"\",SUM(費用[[#This Row],[住宿費]:[交通費]],費用[[#This Row],[餐費]:[雜項費用]],((費用[[#This Row],[里程數結束]]-費用[[#This Row],[里程數開始]])*(里程補貼費率))))","v":""}]
[null,"總計",null,null,{"$f":"SUBTOTAL(109,費用[住宿費])","v":{"v":13350,"d":"NT$13,350.00"}},{"$f":"SUBTOTAL(109,費用[交通費])","v":{"v":6750,"d":"NT$6,750.00"}},{"$f":"SUBTOTAL(109,費用[餐費])","v":{"v":600,"d":"NT$600.00"}},{"$f":"SUBTOTAL(109,費用[電話費])","v":0},{"$f":"SUBTOTAL(109,費用[雜項費用])","v":{"v":1650,"d":"NT$1,650.00"}},{"$nulls":3},{"$f":"SUBTOTAL(109,費用[[總計 ]])","v":{"v":24415.50000000001,"d":"NT$24,415.50"}}]
[{"$nulls":11},"預支費用",{"v":0,"d":"NT$0.00"}]
[{"$nulls":11},"總計",{"$f":"費用[[#Totals],[總計 ]]-預支費用","v":{"v":24415.50000000001,"d":"NT$24,415.50"}}]