{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["甘特圖","大約"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"甘特圖","index":0,"n_rows":34,"n_cols":64,"rows_kept":34,"merged":[[1,8,1,11],[1,13,1,16],[1,18,1,21],[1,23,1,26],[1,28,1,31],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,1,4,7]]}
["在此工作表中建立甘特圖。\n在儲存格 B1 中輸入此專案的標題。\n圖例標題位於儲存格 I1。\n如何使用本工作表的相關資訊，其中包括位於 [關於] 工作表中的螢幕助讀程式的指示和此活頁簿的作者。\n繼續往下瀏覽欄 A，以聆聽進一步的指示。","專案標題",{"$nulls":6},"圖例："]
["在儲存格 B2 中輸入公司名稱。\n儲存格 I2 到 AC2 為圖例。","公司名稱",{"$nulls":6},"進度正常",{"$nulls":4},"低風險",{"$nulls":4},"中風險",{"$nulls":4},"高風險",{"$nulls":4},"未指派"]
["在儲存格 B3 中輸入專案負責人姓名。在儲存格 F3 中輸入專案開始日期，或讓範例公式從甘特運算列表尋找最小的日期值。\n專案開始日期：標籤位於儲存格 D3。","專案負責人",null,"專案開始日期：",null,{"$f":"IFERROR(IF(MIN(里程碑[開始])=0,TODAY(),MIN(里程碑[開始])),TODAY())","v":"2018-07-07"}]
["捲動的增量位於儲存格 F4。\n從儲存格 I4 開始至儲存格 BL4 顯示列 5 中日期的月份。\n請勿修改此儲存格。它們會根據儲存格 F3 中的專案開始日期自動更新。",null,null,"捲動的增量：",null,0,null,null,{"$f":"TEXT(I5,\"m月\")","v":"7月"},{"$nulls":6},{"$f":"IF(TEXT(P5,\"m月\")=I4,\"\",TEXT(P5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(W5,\"m月\")=P4,TEXT(W5,\"m月\")=I4),\"\",TEXT(W5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AD5,\"m月\")=W4,TEXT(AD5,\"m月\")=P4,TEXT(AD5,\"m月\")=I4),\"\",TEXT(AD5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AK5,\"m月\")=AD4,TEXT(AK5,\"m月\")=W4,TEXT(AK5,\"m月\")=P4,TEXT(AK5,\"m月\")=I4),\"\",TEXT(AK5,\"m月\"))","v":"8月"},{"$nulls":6},{"$f":"IF(OR(TEXT(AR5,\"m月\")=AK4,TEXT(AR5,\"m月\")=AD4,TEXT(AR5,\"m月\")=W4,TEXT(AR5,\"m月\")=P4),\"\",TEXT(AR5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(AY5,\"m月\")=AR4,TEXT(AY5,\"m月\")=AK4,TEXT(AY5,\"m月\")=AD4,TEXT(AY5,\"m月\")=W4),\"\",TEXT(AY5,\"m月\"))","v":""},{"$nulls":6},{"$f":"IF(OR(TEXT(BF5,\"m月\")=AY4,TEXT(BF5,\"m月\")=AR4,TEXT(BF5,\"m月\")=AK4,TEXT(BF5,\"m月\")=AD4),\"\",TEXT(BF5,\"m月\"))","v":""}]
["儲存格 I5 到 BL5 含有呈現在每個會自動計算的日期儲存格上方的儲存格區塊中的月份的天數。\n請勿修改此儲存格。\n從整個日期欄到專案排程結尾中列 5 的今天日期已標示為紅色 (十六進位 #AD3815)。",{"$nulls":7},{"$f":"IFERROR(Project_Start+Scrolling_Increment,TODAY())","v":"2018-07-07"},{"$f":"I5+1","v":"2018-07-08"},{"$f":"J5+1","v":"2018-07-09"},"2018-07-10","2018-07-11","2018-07-12","2018-07-13",{"$f":"O5+1","v":"2018-07-14"},{"$f":"P5+1","v":"2018-07-15"},"2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20",{"$f":"V5+1","v":"2018-07-21"},{"$f":"W5+1","v":"2018-07-22"},"2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27",{"$f":"AC5+1","v":"2018-07-28"},{"$f":"AD5+1","v":"2018-07-29"},"2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03",{"$f":"AJ5+1","v":"2018-08-04"},{"$f":"AK5+1","v":"2018-08-05"},"2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10",{"$f":"AQ5+1","v":"2018-08-11"},{"$f":"AR5+1","v":"2018-08-12"},"2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17",{"$f":"AX5+1","v":"2018-08-18"},{"$f":"AY5+1","v":"2018-08-19"},{"$f":"AZ5+1","v":"2018-08-20"},"2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BE5+1","v":"2018-08-25"},{"$f":"BF5+1","v":"2018-08-26"},{"$f":"BG5+1","v":"2018-08-27"},"2018-08-28","2018-08-29","2018-08-30","2018-08-31"]
["捲軸位於儲存格 I6 到 BL6。分頁瀏覽資料的增量定義為一次 2 頁，且可在設定中設定控制列。\n若要在時間表中往前或往後，請在儲存格 F4 中輸入 0 或更高的值。\n輸入 0 會前往圖表的開頭。"]
["此列包含接在專案排程下方的標頭。\n從 B7 瀏覽到 BL7 來聆聽內容。從儲存格 I7 開始持續到儲存格 BL7 的標題上方所述的日期為每周每一天的第一個字母。\n所有專案時間表的圖表會根據 [里程碑] 表格中輸入的類別、開始日期和天數自動產生。","里程碑描述","類別","指派對象","進度","開始","天數",null,{"$f":"RIGHT(TEXT(I5,\"aaa\"),1)","v":"六"},{"$f":"RIGHT(TEXT(J5,\"aaa\"),1)","v":"日"},"一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五","六","日","一","二","三","四","五"]
["請勿刪除此列。已隱藏此列來保留在專案排程內用來反白顯示目前日期的公式。 "]
["從儲存格 B9 開始到儲存格 G9 中輸入專案資訊。\n範例資料位於儲存格 B9 到 G33。\n輸入里程碑描述，從下拉式清單選取類別、指派某人項目、輸入進度、工作的開始日期和天數以開始繪製圖表。\n下一個指示位於儲存格 A34。","標題 1",{"$nulls":6},{"$f":"IF(AND($C9=\"目標\",I$5>=$F9,I$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",I$5>=$F9,I$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",Y$5>=$F9,Y$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",Y$5>=$F9,Y$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",AO$5>=$F9,AO$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",AO$5>=$F9,AO$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C9=\"目標\",BE$5>=$F9,BE$5<=$F9+$G9-1),2,IF(AND($C9=\"里程碑\",BE$5>=$F9,BE$5<=$F9+$G9-1),1,\"\"))","v":""},"","","","","","",""]
[null,"工作 1","目標","姓名",{"v":0.25,"d":"25%"},{"$f":"TODAY()","v":"2019-07-30"},3,null,{"$f":"IF(AND($C10=\"目標\",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10=\"里程碑\",I$5>=$F10,I$5<=$F10+$G10-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 2","里程碑",null,null,{"$f":"TODAY()+5","v":"2019-08-04"},1,null,{"$f":"IF(AND($C11=\"目標\",I$5>=$F11,I$5<=$F11+$G11-1),2,IF(AND($C11=\"里程碑\",I$5>=$F11,I$5<=$F11+$G11-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 3","低風險",null,{"v":0.5,"d":"50%"},{"$f":"F10-3","v":"2019-07-27"},10,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 4","里程碑",null,null,{"$f":"F10+20","v":"2019-08-19"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 5","中風險",null,{"v":0.1,"d":"10%"},{"$f":"F10+6","v":"2019-08-05"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"標題 2",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 1","高風險",null,{"v":0.6,"d":"60%"},{"$f":"F10+6","v":"2019-08-05"},13,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 2","進度正常",null,{"v":0.5,"d":"50%"},{"$f":"F16+2","v":"2019-08-07"},9,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 3","低風險",null,{"v":0.33,"d":"33%"},{"$f":"F17+5","v":"2019-08-12"},11,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 4","里程碑",null,null,{"$f":"F18+2","v":"2019-08-14"},1,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 5",{"$nulls":3},{"$f":"F19+1","v":"2019-08-15"},24,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"標題 3",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 1","進度正常",null,null,{"$f":"F10+15","v":"2019-08-14"},4,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 2","中風險",null,null,{"$f":"F22+3","v":"2019-08-17"},14,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 3","進度正常",null,null,{"$f":"F23+15","v":"2019-09-01"},6,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"目標\",AN$5>=$F24,AN$5<=$F24+$G24-1),2,IF(AND($C24=\"里程碑\",AN$5>=$F24,AN$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(AND($C24=\"目標\",BD$5>=$F24,BD$5<=$F24+$G24-1),2,IF(AND($C24=\"里程碑\",BD$5>=$F24,BD$5<=$F24+$G24-1),1,\"\"))","v":""},"","","","","","","",""]
[null,"工作 4","目標",null,null,{"$f":"F19+22","v":"2019-09-05"},3,null,"","","","","","","","","","","","","","","","",{"$f":"IF(AND($C25=\"目標\",Y$5>=$F25,Y$5<=$F25+$G25-1),2,IF(AND($C25=\"里程碑\",Y$5>=$F25,Y$5<=$F25+$G25-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 5","低風險",null,null,{"$f":"F14","v":"2019-08-05"},19,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"標題 4",{"$nulls":6},{"$f":"IF(AND($C27=\"目標\",I$5>=$F27,I$5<=$F27+$G27-1),2,IF(AND($C27=\"里程碑\",I$5>=$F27,I$5<=$F27+$G27-1),1,\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 1",{"$nulls":3},{"$f":"F25+3","v":"2019-09-08"},15,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 2",{"$nulls":3},"2018-07-07",5,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 3","里程碑",null,null,"2018-07-25",1,null,"","","","","","","","","","","","","","","","","","",1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 4",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"工作 5",{"$nulls":6},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["此為空白列",{"$nulls":7},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["此列標示甘特圖里程碑資料的結尾。請勿在此列中輸入任何內容。\n若要新增更多項目，請在此上方插入新列。","若要新增更多資料，請在此上方插入新列"]

{"sheet":"大約","index":1,"n_rows":5,"n_cols":1,"rows_kept":5}
["關於此範本"]
["此範本提供簡單的方式來建立甘特圖，以協助您視覺化並追蹤專案。簡單輸入工作描述、選取目標類別、里程碑、進度正常、低風險、中風險、高風險、工作完成情況的進度百分比、開始日期和完成工作的天數。甘特圖會以色彩編碼填滿來協助區分不同的類別。捲軸可讓您捲動整個時間表。插入新列來插入新的工作。\n"]
["螢幕助讀程式的指南"]
["此活頁簿有 2 個工作表。\n\n甘特圖\n關於\n\n每個工作表的儲存格 A1 開始的 A 欄中為每個工作表的指示。指示是以隱藏文字撰寫。每個步驟都會引導您完成下一列中的資訊。除非另有明確的指示，否則每個後續步驟會繼續在儲存格 A2、A3 中，依此類推。例如，指示文字會顯示「繼續前往儲存格 A6」以進行下一個步驟。\n\n這些隱藏文字不會列印出來。\n\n若要移除工作表中的這些指示，只要刪除欄 A 即可。"]
["這是此工作表中的最後指示。"]