{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["差旅行程預算"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"差旅行程預算","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,2,5],[2,1,2,2],[2,3,2,4],[3,1,3,2],[3,3,3,4]]}
[null,"差旅行程預算"]
[null,"目標行程預算",null,{"v":2500,"d":"NT$2,500.00"},null,null,{"$f":"D3","v":{"v":2369.3599999999997,"d":"NT$2,369.36"}}]
[null,"行程總費用",null,{"$f":"SUBTOTAL(9,資料[金額])","v":{"v":2369.3599999999997,"d":"NT$2,369.36"}},null,null,{"$f":"D2","v":{"v":2500,"d":"NT$2,500.00"}}]
[null,{"$f":"IF(D2>D3,\"您低於預算\",\"您超出預算\")","v":"您低於預算"},null,{"$f":"(D2-D3)","v":{"v":130.64000000000033,"d":"NT$130.64"}}]
[null,"項目","描述","費用","數量","金額","附註"]
[null,"機票","票券",{"v":300,"d":"NT$300.00"},1,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":300,"d":"NT$300.00"}}]
[null,"機票","票券",{"v":350,"d":"NT$350.00"},1,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":350,"d":"NT$350.00"}}]
[null,"住宿費","住宿房間",{"v":125,"d":"NT$125.00"},3,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":375,"d":"NT$375.00"}}]
[null,"住宿費","住宿房間",{"v":150,"d":"NT$150.00"},3,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":450,"d":"NT$450.00"}}]
[null,"租車","每日費用",{"v":52,"d":"NT$52.00"},6,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":312,"d":"NT$312.00"}}]
[null,"汽油","每加侖價格",{"v":1.74,"d":"NT$1.74"},14,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":24.36,"d":"NT$24.36"}}]
[null,"娛樂費","金額",{"v":130,"d":"NT$130.00"},1,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":130,"d":"NT$130.00"}}]
[null,"禮物","金額",{"v":85,"d":"NT$85.00"},1,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":85,"d":"NT$85.00"}}]
[null,"其他","金額",{"v":55,"d":"NT$55.00"},1,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":55,"d":"NT$55.00"}}]
[null,"伙食","每日費用",{"v":48,"d":"NT$48.00"},6,{"$f":"資料[[#This Row],[數量]]*資料[[#This Row],[費用]]","v":{"v":288,"d":"NT$288.00"}}]
[null,"合計",{"$nulls":3},{"$f":"SUBTOTAL(109,資料[金額])","v":{"v":2369.3599999999997,"d":"NT$2,369.36"}}]