{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["專案概覽","工作詳細資料"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"專案概覽","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"專案概覽"]
[]
[null,"專案","  ","進度"," 開始"," 結束","附註"]
[null,"計劃假期",{"$f":"IFERROR((SUMIFS(Tasks[完成],Tasks[專案],Projects[[#This Row],[專案]])/COUNTIFS(Tasks[專案],Projects[[#This Row],[專案]]))+0.0001,0.0001)","v":0.50009999999999999},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[開始]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[[開始]:[結束]]))","v":"2011-12-31"},"出發前往貝里斯！"]
[null,"計劃 Sara 的驚喜派對",{"$f":"IFERROR((SUMIFS(Tasks[完成],Tasks[專案],Projects[[#This Row],[專案]])/COUNTIFS(Tasks[專案],Projects[[#This Row],[專案]]))+0.0001,0.0001)","v":1.0001},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[開始]))","v":"2011-09-10"},{"$f":"MAX(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[[開始]:[結束]]))","v":"2011-10-03"}]
[null,"進行馬拉松訓練",{"$f":"IFERROR((SUMIFS(Tasks[完成],Tasks[專案],Projects[[#This Row],[專案]])/COUNTIFS(Tasks[專案],Projects[[#This Row],[專案]]))+0.0001,0.0001)","v":0.28581428571428569},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":"||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"MIN(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[開始]))","v":"2011-09-01"},{"$f":"MAX(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[[開始]:[結束]]))","v":"2012-04-18"},"在 4 月 18 日打破我的記錄"]
[null,"幫 Sara 報名游泳課",{"$f":"IFERROR((SUMIFS(Tasks[完成],Tasks[專案],Projects[[#This Row],[專案]])/COUNTIFS(Tasks[專案],Projects[[#This Row],[專案]]))+0.0001,0.0001)","v":1E-4},{"$f":"REPT(\"|\",Projects[[  ]]*175)","v":""},{"$f":"MIN(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[開始]))","v":"2011-10-01"},{"$f":"MAX(IF((Tasks[專案]=Projects[[#This Row],[專案]])*(Tasks[開始]>0),Tasks[[開始]:[結束]]))","v":"2011-10-15"}]

{"sheet":"工作詳細資料","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"工作詳細資料"]
[]
[null,"開始","結束","專案","工作","完成","附註"]
[null,"2011-10-01","2011-10-15","計劃假期","選擇熱帶或溫帶區域",1,"選擇熱帶區域。貝里斯我們來了！"]
[null,"2011-10-15","2011-12-31","計劃假期","線上追蹤春季票價"]
[null,"2011-10-15",null,"計劃假期","研究貝里斯的歷史與文化"]
[null,"2011-10-15","2011-10-20","計劃假期","研究度假村評論",1]
[null,"2011-10-20",null,"計劃假期","預訂度假村",1,"4 月 19 日至 4 月 30 日"]
[null,"2011-10-20","2011-11-15","計劃假期","取得全家人的護照",null,"考慮臨時成行方案…"]
[null,"2011-09-01","2011-09-30","進行馬拉松訓練","一天 10 英哩",1,"比賽於 4 月 18 日舉行"]
[null,"2011-10-01","2011-10-31","進行馬拉松訓練","一天 12 英哩",1]
[null,"2011-11-01","2011-11-30","進行馬拉松訓練","一天 14 英哩"]
[null,"2011-12-01","2012-04-15","進行馬拉松訓練","一天 15 英哩"]
[null,"2012-04-16",null,"進行馬拉松訓練","前往參加馬拉松"]
[null,"2012-04-16","2012-04-17","進行馬拉松訓練","檢查課程",null,"每天 10 英哩慢跑"]
[null,"2012-04-18",null,"進行馬拉松訓練","在 3 小時內抵達終點線！",null,"立即前往貝里斯！"]
[null,"2011-09-10",null,"計劃 Sara 的驚喜派對","發出派對邀請",1,"於 10 月 3 日舉辦驚喜生日派對"]
[null,"2011-09-20",null,"計劃 Sara 的驚喜派對","訂外燴",1]
[null,"2011-09-22",null,"計劃 Sara 的驚喜派對","排定娛樂節目",1]
[null,"2011-10-03",null,"計劃 Sara 的驚喜派對","派對時間！",1,"太棒了。她完全沒料到！"]
[null,"2011-10-01","2011-10-15","幫 Sara 報名游泳課","比較當地社區中心的價格"]