{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["工單追蹤表"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"工單追蹤表","index":0,"n_rows":6,"n_cols":10,"rows_kept":6}
[null,"工單追蹤報告",{"$nulls":7}," "]
[]
[null,"工單號碼","描述","申請人","指定對象","開始日期","到期日","完成百分比","狀態"]
[null,"TR45878","裝置庫存","黃安東","廖建宏",{"$f":"TODAY()-120","v":"2012-05-21"},{"$f":"TODAY()-1","v":"2012-09-17"},{"v":0.75,"d":"75%"},{"$f":"IF(工作順序[[#This Row],[完成百分比]]=1,2,IF(ISBLANK(工作順序[[#This Row],[到期日]]),\"\",IF(AND(TODAY()>工作順序[[#This Row],[到期日]],工作順序[[#This Row],[完成百分比]]<>1),0,1)))","v":0}]
[null,"YT9876","建立新客戶資料庫","劉丹尼","謝史分",{"$f":"TODAY()-30","v":"2012-08-19"},{"$f":"TODAY()+15","v":"2012-10-03"},{"v":1,"d":"100%"},{"$f":"IF(工作順序[[#This Row],[完成百分比]]=1,2,IF(ISBLANK(工作順序[[#This Row],[到期日]]),\"\",IF(AND(TODAY()>工作順序[[#This Row],[到期日]],工作順序[[#This Row],[完成百分比]]<>1),0,1)))","v":2}]
[null,"TR7865","升級桌上型電腦","劉丹尼","廖建宏",{"$f":"TODAY()","v":"2012-09-18"},{"$f":"工作順序[[#This Row],[開始日期]]+30","v":"2012-10-18"},{"v":0,"d":"0%"},{"$f":"IF(工作順序[[#This Row],[完成百分比]]=1,2,IF(ISBLANK(工作順序[[#This Row],[到期日]]),\"\",IF(AND(TODAY()>工作順序[[#This Row],[到期日]],工作順序[[#This Row],[完成百分比]]<>1),0,1)))","v":1}]