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

{"sheet":" 費用報表","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
[" 公司名稱"]
["費用報表"]
[]
[null,"員工:","黃安東",{"$nulls":3},"授權人："]
[null,"部門:","銷售"]
[null,"一週結束日:","2013-03-07",{"$nulls":3},"日期："]
[null,"里程數補貼費率:",{"v":20.1,"d":"NT$20.10"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"aaa\"))","v":"週五"},{"$f":"UPPER(TEXT(D10,\"aaa\"))","v":"週六"},"週日","週一","週二","週三","週四"]
[null,"交通",{"$f":"WeekEnding-6","v":"2013-03-01"},{"$f":"WeekEnding-5","v":"2013-03-02"},{"$f":"WeekEnding-4","v":"2013-03-03"},{"$f":"WeekEnding-3","v":"2013-03-04"},{"$f":"WeekEnding-2","v":"2013-03-05"},{"$f":"WeekEnding-1","v":"2013-03-06"},{"$f":"WeekEnding","v":"2013-03-07"},"合計"]
[null,"行駛里程數",{"v":4350,"d":"4,350 "},{"$nulls":6},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":4350,"d":"4,350 "}}]
[null,"里程數補助",{"$f":"C11*MileageRate","v":{"v":87435,"d":"NT$87,435.00"}},{"$f":"D11*MileageRate","v":{"v":0,"d":"NT$0.00"}},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":87435,"d":"NT$87,435.00"}}]
[null,"停車與通行費",{"$nulls":3},{"v":510,"d":"NT$510.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":510,"d":"NT$510.00"}}]
[null,"租車",{"v":2370,"d":"NT$2,370.00"},null,null,{"v":2370,"d":"NT$2,370.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":4740,"d":"NT$4,740.00"}}]
[null,"計程車 / 大型轎車",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他 (火車或巴士)",{"$nulls":7},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"機票",{"$nulls":3},{"v":235,"d":"NT$235.00"},{"$nulls":3},{"$f":"SUM(Transportation[[#This Row],[Day 1]:[Day 7]])","v":{"v":235,"d":"NT$235.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":89805,"d":"NT$89,805.00"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"NT$0.00"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":3115,"d":"NT$3,115.00"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(J12:J17)","v":{"v":92920,"d":"NT$92,920.00"}}]
[]
[null,"食宿"]
[null,"住宿",{"v":4350,"d":"NT$4,350.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":4350,"d":"NT$4,350.00"}}]
[null,"早餐",{"v":344.7,"d":"NT$344.70"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":344.7,"d":"NT$344.70"}}]
[null,"午餐",{"v":360,"d":"NT$360.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":360,"d":"NT$360.00"}}]
[null,"晚餐",{"v":510,"d":"NT$510.00"},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":510,"d":"NT$510.00"}}]
[null,"點心",{"$f":"C24*MileageRate","v":{"v":10251,"d":"NT$10,251.00"}},{"$nulls":6},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":10251,"d":"NT$10,251.00"}}]
[null,"餐費小計",{"$f":"SUM(C22:C24)","v":{"v":1214.7,"d":"NT$1,214.70"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"NT$0.00"}},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"SUM(LodgingMeals[[#This Row],[Day 1]:[Day 7]])","v":{"v":1214.7,"d":"NT$1,214.70"}}]
[null,"合計",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":5564.7,"d":"NT$5,564.70"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"NT$0.00"}},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":5564.7,"d":"NT$5,564.70"}}]
[]
[null,"雜項"]
[null,"日常用品",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"設備",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"電話、傳真、網際網路",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"其他*",{"$nulls":7},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":0,"d":"NT$0.00"}}]
[null,"娛樂*",{"$nulls":3},{"v":5970,"d":"NT$5,970.00"},{"$nulls":3},{"$f":"SUM(Misc[[#This Row],[Day 1]:[Day 7]])","v":{"v":5970,"d":"NT$5,970.00"}}]
[null,"合計",{"$f":"SUBTOTAL(109,Misc[Day 1])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 2])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 3])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 4])","v":{"v":5970,"d":"NT$5,970.00"}},{"$f":"SUBTOTAL(109,Misc[Day 5])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 6])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Day 7])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,Misc[Total])","v":{"v":5970,"d":"NT$5,970.00"}}]
[]
[null,"總計",{"$f":"SUM(Misc[[#Totals],[Day 1]],LodgingMeals[[#Totals],[Day 1]],Transportation[[#Totals],[Day 1]])","v":{"v":95369.7,"d":"NT$95,369.70"}},{"$f":"SUM(Misc[[#Totals],[Day 2]],LodgingMeals[[#Totals],[Day 2]],Transportation[[#Totals],[Day 2]])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 3]],LodgingMeals[[#Totals],[Day 3]],Transportation[[#Totals],[Day 3]])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 4]],LodgingMeals[[#Totals],[Day 4]],Transportation[[#Totals],[Day 4]])","v":{"v":9085,"d":"NT$9,085.00"}},{"$f":"SUM(Misc[[#Totals],[Day 5]],LodgingMeals[[#Totals],[Day 5]],Transportation[[#Totals],[Day 5]])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 6]],LodgingMeals[[#Totals],[Day 6]],Transportation[[#Totals],[Day 6]])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(Misc[[#Totals],[Day 7]],LodgingMeals[[#Totals],[Day 7]],Transportation[[#Totals],[Day 7]])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUM(Misc[[#Totals],[Total]],LodgingMeals[[#Totals],[Total]],Transportation[[#Totals],[Total]])","v":{"v":104454.7,"d":"NT$104,454.70"}}]
[]
[{"$nulls":9},"總費用"]
[null," *「娛樂」與「其他」項目的公務用途：",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":104454.7,"d":"NT$104,454.70"}}]
[{"$nulls":9},"進階"]
[]
[{"$nulls":9},"總補助金額"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":104454.7,"d":"NT$104,454.70"}}]
[{"$nulls":9},"請附上所有收據。"]