{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["里程數記錄和費用報表"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"里程數記錄和費用報表","index":0,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,"里程數記錄和費用報表"]
[]
[null,"員工姓名",null,"每英里費用",{"v":0.27,"d":"NT$0.27"}]
[null,"員工識別碼",null,"期間",{"$f":"\"起訖 \"&TEXT(MIN(B9:B19),\"yy年m月d日\")&\" 時間 \"&TEXT(MAX(B9:B19),\"yy年m月d日\")","v":"起訖 17年7月31日 時間 17年8月1日"}]
[null,"車輛描述",null,"總里程數",{"$f":"費用[[#Totals],[里程數]]","v":10}]
[null,"授權者",null,"補助總額",{"$f":"費用[[#Totals],[補助]]","v":{"v":2.7,"d":"NT$2.70"}}]
[]
[null,"日期","出發地點","目的地","描述/備註","里程表開始","里程表結束","里程數","補助"]
[null,{"$f":"TODAY()","v":"2017-07-31"},"住家公司","Northwind Traders","客戶會議",36098,36103,{"$f":"IFERROR(IF(OR(ISBLANK(F9),ISBLANK(G9)),0,G9-F9), \"\")","v":5},{"$f":"IFERROR(H9*$E$3, \"\")","v":{"v":1.35,"d":"NT$1.35"}}]
[null,{"$f":"TODAY()+1","v":"2017-08-01"},"Northwind Traders","住家公司","客戶會議",36103,36108,{"$f":"IFERROR(IF(OR(ISBLANK(F10),ISBLANK(G10)),0,G10-F10), \"\")","v":5},{"$f":"IFERROR(H10*$E$3, \"\")","v":{"v":1.35,"d":"NT$1.35"}}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":7},0,{"v":0,"d":"NT$0.00"}]
[{"$nulls":6},"總計",{"$f":"SUBTOTAL(109,費用[里程數])","v":10},{"$f":"SUBTOTAL(109,費用[補助])","v":{"v":2.7,"d":"NT$2.70"}}]