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

{"sheet":"費用報表","index":0,"n_rows":14,"n_cols":14,"rows_kept":14,"merged":[[0,1,0,5],[2,3,2,5],[2,6,2,7],[2,8,2,10],[4,3,4,5],[4,6,4,7],[4,8,4,10]]}
[null,"差旅費用報表"]
[]
[null,"姓名","翁祖君","授權者",null,null,"吳又倫",null,"每里程數補助",null,null,{"v":0.32,"d":"NT$0.32"}]
[]
[null,"部門","銷售","提交日期",null,null,{"$f":"TODAY()","v":"2018-05-16"},null,"補助總額",null,null,{"$f":"補助總額","v":{"v":15513.367619047618,"d":"NT$15,513.37"}}]
[]
[null,"期間",{"$f":"IF(MIN(B10:B13)=MAX(B10:B13),TEXT(MIN(B10:B13),\"yyyy年m月d日\"),\"從 \"&TEXT(MIN(B10:B13),\"yyyy年m月d日\")&\" 到 \"&TEXT(MAX(B10:B13),\"yyyy年m月d日\"))","v":"從 2018年4月16日 到 2018年4月21日"}]
[]
[null,"日期","費用描述","機票","住宿","地面交通方式\n(油費、租車費、計程車費)","餐費和小費","會議和研討會","里程數","里程數補助","雜項","貨幣匯率","費用貨幣","合計"]
[null,{"$f":"TODAY()-30","v":"2018-04-16"},"到客戶辦公室出差",{"v":350,"d":"350.00"},{"v":150,"d":"150.00"},{"v":45,"d":"45.00"},{"v":12,"d":"12.00"},{"v":50,"d":"50.00"},{"v":35,"d":"35.00"},{"$f":"IF(費用報表!I10<>\"\",費用報表!I10*里程數比率,\"\")","v":{"v":11.200000000000001,"d":"11.20"}},null,{"v":0.042,"d":"0.04"},"CAD",{"$f":"IFERROR(IF(OR(費用報表!$L10=\"\",費用報表!$L10=1),SUM(費用報表!$J10:$K10,費用報表!$D10:$H10)*1,SUM(費用報表!$J10:$K10,費用報表!$D10:$H10)/費用報表!$L10),\"\")","v":{"v":14719.047619047618,"d":"NT$14,719.05"}}]
[null,{"$f":"TODAY()-30","v":"2018-04-16"},"和客戶午餐",{"$nulls":3},{"v":24.3,"d":"24.30"},null,{"v":12,"d":"12.00"},{"$f":"IF(費用報表!I11<>\"\",費用報表!I11*里程數比率,\"\")","v":3.84},null,{"v":0.042,"d":"0.04"},"CAD",{"$f":"IFERROR(IF(OR(費用報表!$L11=\"\",費用報表!$L11=1),SUM(費用報表!$J11:$K11,費用報表!$D11:$H11)*1,SUM(費用報表!$J11:$K11,費用報表!$D11:$H11)/費用報表!$L11),\"\")","v":{"v":670,"d":"NT$670.00"}}]
[null,"2018-04-16","下午研討會",{"$nulls":4},{"v":100,"d":"100.00"},{"v":6,"d":"6.00"},{"$f":"IF(費用報表!I12<>\"\",費用報表!I12*里程數比率,\"\")","v":1.92},null,{"v":1,"d":"1.00"},"TWD",{"$f":"IFERROR(IF(OR(費用報表!$L12=\"\",費用報表!$L12=1),SUM(費用報表!$J12:$K12,費用報表!$D12:$H12)*1,SUM(費用報表!$J12:$K12,費用報表!$D12:$H12)/費用報表!$L12),\"\")","v":{"v":101.92,"d":"NT$101.92"}}]
[null,{"$f":"TODAY()-25","v":"2018-04-21"},"前往機場",{"$nulls":5},{"v":70,"d":"70.00"},{"$f":"IF(費用報表!I13<>\"\",費用報表!I13*里程數比率,\"\")","v":{"v":22.400000000000002,"d":"22.40"}},null,{"v":1,"d":"1.00"},"TWD",{"$f":"IFERROR(IF(OR(費用報表!$L13=\"\",費用報表!$L13=1),SUM(費用報表!$J13:$K13,費用報表!$D13:$H13)*1,SUM(費用報表!$J13:$K13,費用報表!$D13:$H13)/費用報表!$L13),\"\")","v":{"v":22.400000000000002,"d":"NT$22.40"}}]
[null,"合計",null,{"$f":"SUBTOTAL(109,費用[機票])","v":{"v":350,"d":"350.00"}},{"$f":"SUBTOTAL(109,費用[住宿])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,費用[地面交通方式\n(油費、租車費、計程車費)])","v":{"v":45,"d":"45.00"}},{"$f":"SUBTOTAL(109,費用[餐費和小費])","v":{"v":36.3,"d":"36.30"}},{"$f":"SUBTOTAL(109,費用[會議和研討會])","v":{"v":150,"d":"150.00"}},{"$f":"SUBTOTAL(109,費用[里程數])","v":{"v":123,"d":"123.00"}},{"$f":"SUBTOTAL(109,費用[里程數補助])","v":39.36},{"$f":"SUBTOTAL(109,費用[雜項])","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUBTOTAL(109,費用[合計])","v":{"v":15513.367619047618,"d":"NT$15,513.37"}}]