{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","專案參數","專案詳細資料","專案總計"],"not_rendered":{"charts":2,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"關於此範本"]
[null,"這個活動規劃追蹤工具活頁簿可用來追蹤專案參數、專案詳細資料及專案總計。"]
[null,"在 [專案參數] 以及 [專案詳細資料] 工作表中輸入資訊，即可更新欄圖表。[專案總計] 工作表中的樞紐分析表會自動更新。"]
[null,"在 [參數] 工作表中填入公司名稱後，其他工作表也會自動更新這個名稱。"]
[null,"附註：  "]
[null,"我們已在活動規劃追蹤工具活頁簿中的每個工作表的欄 A 提供額外指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取欄 A，然後變更字型色彩。"]
[null,"若要深入了解此工作表中的表格，請在表格內按 SHIFT 並按 F10、選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"專案參數","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[23,1,42,3]]}
[null,"公司名稱"]
[null,"活動管理專案追蹤工具"]
[null,{"$f":"B1&\"機密\"","v":"公司名稱機密"}]
[null,"工作表會為您計算有陰影的儲存格。您不需要在其中輸入任何內容。"]
[null,"專案類型","客戶經理","專案經理","策略經理","設計專家","活動工作人員","行政人員","總計"]
[null,"活動策略發展",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"活動規劃",{"v":0.2,"d":"20%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":0.9999999999999999,"d":"100%"}}]
[null,"活動設計",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"活動邏輯",{"v":0.2,"d":"20%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"活動工作人員規劃",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.1,"d":"10%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"活動評估",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"$f":"SUM(參數[[#This Row],[客戶經理]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"混合費率",{"v":180,"d":"NT$180"},{"v":120,"d":"NT$120"},{"v":150,"d":"NT$150"},{"v":100,"d":"NT$100"},{"v":80,"d":"NT$80"},{"v":60,"d":"NT$60"}]
[]
[{"$nulls":5},"這個儲存格是顯示計劃時數與實際時數的比較直條圖。"]
[null,null,"客戶經理","專案經理","策略經理","設計專家","活動工作人員","行政人員"]
[null,"計劃費用",{"$f":"SUBTOTAL(109,專案詳細資料[客戶經理])","v":{"v":54000,"d":"NT$54,000.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[專案經理])","v":{"v":52200,"d":"NT$52,200.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[策略經理])","v":{"v":24000,"d":"NT$24,000.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[設計專家])","v":{"v":29000,"d":"NT$29,000.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[活動工作人員])","v":{"v":13200,"d":"NT$13,200.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[行政人員])","v":{"v":9000,"d":"NT$9,000.00"}}]
[null,"實際費用",{"$f":"SUBTOTAL(109,專案詳細資料[[客戶經理 ]])","v":{"v":54360,"d":"NT$54,360.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[[專案經理 ]])","v":{"v":51540,"d":"NT$51,540.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[[策略經理 ]])","v":{"v":25650,"d":"NT$25,650.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[[設計專家 ]])","v":{"v":28900,"d":"NT$28,900.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[[活動工作人員 ]])","v":{"v":13400,"d":"NT$13,400.00"}},{"$f":"SUBTOTAL(109,專案詳細資料[[行政人員 ]])","v":{"v":9060,"d":"NT$9,060.00"}}]
[null,"計劃時數",{"$f":"C16/$C$12","v":{"v":300,"d":"300.00"}},{"$f":"D16/$C$12","v":{"v":290,"d":"290.00"}},{"v":133.33333333333334,"d":"133.33"},{"v":161.11111111111111,"d":"161.11"},{"v":73.33333333333333,"d":"73.33"},{"v":50,"d":"50.00"}]
[null,"實際時數",{"$f":"C17/$C$12","v":{"v":302,"d":"302.00"}},{"$f":"D17/$C$12","v":{"v":286.3333333333333,"d":"286.33"}},{"$f":"E17/$C$12","v":{"v":142.5,"d":"142.50"}},{"$f":"F17/$C$12","v":{"v":160.55555555555554,"d":"160.56"}},{"$f":"G17/$C$12","v":{"v":74.44444444444444,"d":"74.44"}},{"$f":"H17/$C$12","v":{"v":50.333333333333336,"d":"50.33"}}]

{"sheet":"專案詳細資料","index":2,"n_rows":10,"n_cols":23,"rows_kept":10}
[null,{"$f":"專案參數!B1","v":"公司名稱"}]
[null,"活動管理專案追蹤工具"]
[null,{"$f":"專案參數!B3","v":"公司名稱機密"}]
["在從右側儲存格開始的 [專案詳細資料] 表格中輸入資訊。\n資訊\n若要在右側表格中新增一列，請選取表格內最右下方的儲存格 (不是總計列)、在您要插入列的位置按下 Tab 鍵或 SHIFT+F10，然後選取 [插入] | [上方表格列]/[下方表格列]。\n請務必刪除所有未使用的列，因為「專案總計樞紐分析表」會使用所有表格儲存格，如果未刪除將會產生錯誤結果。","專案名稱","專案類型","預估開始時間","預估結束時間","實際開始時間","實際結束時間","預估工時","實際工時","預估工期","實際工期","客戶經理","專案經理","策略經理","設計專家","活動工作人員","行政人員","客戶經理 ","專案經理 ","策略經理 ","設計專家 ","活動工作人員 ","行政人員 "]
[null,"專案 1","活動策略發展",{"$f":"DATE(YEAR(TODAY()),6,9)","v":"2022-06-09"},{"$f":" DATE(YEAR(TODAY()),8,7)","v":"2022-08-07"},{"$f":"DATE(YEAR(TODAY()),6,29)","v":"2022-06-29"},{"$f":"DATE(YEAR(TODAY()),9,3)","v":"2022-09-03"},200,220,{"$f":"DAYS360(專案詳細資料[[#This Row],[預估開始時間]],專案詳細資料[[#This Row],[預估結束時間]],FALSE)","v":58},{"$f":"DAYS360(專案詳細資料[[#This Row],[實際開始時間]],專案詳細資料[[#This Row],[實際結束時間]],FALSE)","v":64},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":7200,"d":"NT$7,200"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":2400,"d":"NT$2,400"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":18000,"d":"NT$18,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":1200,"d":"NT$1,200"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":7920,"d":"NT$7,920"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":2640,"d":"NT$2,640"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":19800,"d":"NT$19,800"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":1320,"d":"NT$1,320"}}]
[null,"專案 2","活動規劃",{"$f":"DATE(YEAR(TODAY())+1,6,25)","v":"2023-06-25"},{"$f":"DATE(YEAR(TODAY())+1,7,27)","v":"2023-07-27"},{"$f":"DATE(YEAR(TODAY()),7,15)","v":"2022-07-15"},{"$f":"DATE(YEAR(TODAY())+1,8,25)","v":"2023-08-25"},400,390,{"$f":"DAYS360(專案詳細資料[[#This Row],[預估開始時間]],專案詳細資料[[#This Row],[預估結束時間]],FALSE)","v":32},{"$f":"DAYS360(專案詳細資料[[#This Row],[實際開始時間]],專案詳細資料[[#This Row],[實際結束時間]],FALSE)","v":400},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":14400,"d":"NT$14,400"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":24000,"d":"NT$24,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":6000,"d":"NT$6,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":4000,"d":"NT$4,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":2400,"d":"NT$2,400"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":14040,"d":"NT$14,040"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":23400,"d":"NT$23,400"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":5850,"d":"NT$5,850"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":3900,"d":"NT$3,900"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":2340,"d":"NT$2,340"}}]
[null,"專案 3","活動設計",{"$f":"DATE(YEAR(TODAY())+2,7,12)","v":"2024-07-12"},{"$f":"DATE(YEAR(TODAY())+2,9,19)","v":"2024-09-19"},"2025-08-07","2025-10-10",500,500,{"$f":"DAYS360(專案詳細資料[[#This Row],[預估開始時間]],專案詳細資料[[#This Row],[預估結束時間]],FALSE)","v":67},{"$f":"DAYS360(專案詳細資料[[#This Row],[實際開始時間]],專案詳細資料[[#This Row],[實際結束時間]],FALSE)","v":63},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":18000,"d":"NT$18,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":12000,"d":"NT$12,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":25000,"d":"NT$25,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":3000,"d":"NT$3,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":18000,"d":"NT$18,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":12000,"d":"NT$12,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":25000,"d":"NT$25,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":3000,"d":"NT$3,000"}}]
[null,"專案 4","活動邏輯",{"$f":"DATE(YEAR(TODAY())+3,7,30)","v":"2025-07-30"},{"$f":"DATE(YEAR(TODAY())+3,9,28)","v":"2025-09-28"},{"$f":"DATE(YEAR(TODAY())+3,9,14)","v":"2025-09-14"},{"$f":"DATE(YEAR(TODAY())+3,11,13)","v":"2025-11-13"},150,145,{"$f":"DAYS360(專案詳細資料[[#This Row],[預估開始時間]],專案詳細資料[[#This Row],[預估結束時間]],FALSE)","v":58},{"$f":"DAYS360(專案詳細資料[[#This Row],[實際開始時間]],專案詳細資料[[#This Row],[實際結束時間]],FALSE)","v":59},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":5400,"d":"NT$5,400"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":10800,"d":"NT$10,800"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":1200,"d":"NT$1,200"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":900,"d":"NT$900"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":5220,"d":"NT$5,220"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":10440,"d":"NT$10,440"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":1160,"d":"NT$1,160"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":870,"d":"NT$870"}}]
[null,"專案 5","活動工作人員規劃",{"$f":"DATE(YEAR(TODAY())+4,8,11)","v":"2026-08-11"},{"$f":"DATE(YEAR(TODAY())+4,8,21)","v":"2026-08-21"},{"$f":"DATE(YEAR(TODAY())+4,9,14)","v":"2026-09-14"},{"$f":"DATE(YEAR(TODAY())+4,9,25)","v":"2026-09-25"},250,255,{"$f":"DAYS360(專案詳細資料[[#This Row],[預估開始時間]],專案詳細資料[[#This Row],[預估結束時間]],FALSE)","v":10},{"$f":"DAYS360(專案詳細資料[[#This Row],[實際開始時間]],專案詳細資料[[#This Row],[實際結束時間]],FALSE)","v":11},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":9000,"d":"NT$9,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":3000,"d":"NT$3,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":12000,"d":"NT$12,000"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[預估工時]]","v":{"v":1500,"d":"NT$1,500"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[客戶經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":9180,"d":"NT$9,180"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[專案經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":3060,"d":"NT$3,060"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[策略經理]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[設計專家]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[活動工作人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":12240,"d":"NT$12,240"}},{"$f":"INDEX(參數[],MATCH(專案詳細資料[[#This Row],[專案類型]],參數[專案類型],0),MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(專案詳細資料[[#Headers],[行政人員]],參數[#Headers],0))*專案詳細資料[[#This Row],[實際工時]]","v":{"v":1530,"d":"NT$1,530"}}]
[null,"合計",{"$nulls":5},{"$f":"SUBTOTAL(109,專案詳細資料[預估工時])","v":1500},{"$f":"SUBTOTAL(109,專案詳細資料[實際工時])","v":1510},{"$f":"SUBTOTAL(109,專案詳細資料[預估工期])","v":225},{"$f":"SUBTOTAL(109,專案詳細資料[實際工期])","v":597}]

{"sheet":"專案總計","index":3,"n_rows":10,"n_cols":14,"rows_kept":10}
[null,{"$f":"專案參數!B1","v":"公司名稱"}]
[null,"活動管理專案追蹤工具"]
[null,{"$f":"專案參數!B3","v":"公司名稱機密"}]
["從右側儲存格開始的樞紐分析表會自動更新。\n資訊\n若要重新整理右側的樞紐分析表，請選取樞紐分析表中的任何儲存格，並在 [樞紐分析表工具] | [分析] 功能區索引標籤上選取 [重新整理]。或者在樞紐分析表中的任何儲存格上按 SHIFT + F10 鍵，再選取 [重新整理]。","專案名稱","客戶經理預估值","專案經理預估值","策略經理預估值","設計專家預估值","事件工作人員預測值","行政人員預測值","客戶經理實際值","專案經理實際值","策略經理實際值","設計專家實際值","活動工作人員實際值","行政人員實際值"]
[null,"專案 1",{"v":7200,"d":"NT$7,200.00"},{"v":2400,"d":"NT$2,400.00"},{"v":18000,"d":"NT$18,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":1200,"d":"NT$1,200.00"},{"v":7920,"d":"NT$7,920.00"},{"v":2640,"d":"NT$2,640.00"},{"v":19800,"d":"NT$19,800.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":1320,"d":"NT$1,320.00"}]
[null,"專案 2",{"v":14400,"d":"NT$14,400.00"},{"v":24000,"d":"NT$24,000.00"},{"v":6000,"d":"NT$6,000.00"},{"v":4000,"d":"NT$4,000.00"},{"v":0,"d":"NT$0.00"},{"v":2400,"d":"NT$2,400.00"},{"v":14040,"d":"NT$14,040.00"},{"v":23400,"d":"NT$23,400.00"},{"v":5850,"d":"NT$5,850.00"},{"v":3900,"d":"NT$3,900.00"},{"v":0,"d":"NT$0.00"},{"v":2340,"d":"NT$2,340.00"}]
[null,"專案 3",{"v":18000,"d":"NT$18,000.00"},{"v":12000,"d":"NT$12,000.00"},{"v":0,"d":"NT$0.00"},{"v":25000,"d":"NT$25,000.00"},{"v":0,"d":"NT$0.00"},{"v":3000,"d":"NT$3,000.00"},{"v":18000,"d":"NT$18,000.00"},{"v":12000,"d":"NT$12,000.00"},{"v":0,"d":"NT$0.00"},{"v":25000,"d":"NT$25,000.00"},{"v":0,"d":"NT$0.00"},{"v":3000,"d":"NT$3,000.00"}]
[null,"專案 4",{"v":5400,"d":"NT$5,400.00"},{"v":10800,"d":"NT$10,800.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":1200,"d":"NT$1,200.00"},{"v":900,"d":"NT$900.00"},{"v":5220,"d":"NT$5,220.00"},{"v":10440,"d":"NT$10,440.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":1160,"d":"NT$1,160.00"},{"v":870,"d":"NT$870.00"}]
[null,"專案 5",{"v":9000,"d":"NT$9,000.00"},{"v":3000,"d":"NT$3,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":12000,"d":"NT$12,000.00"},{"v":1500,"d":"NT$1,500.00"},{"v":9180,"d":"NT$9,180.00"},{"v":3060,"d":"NT$3,060.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":12240,"d":"NT$12,240.00"},{"v":1530,"d":"NT$1,530.00"}]
[null,"Grand Total",{"v":54000,"d":"NT$54,000.00"},{"v":52200,"d":"NT$52,200.00"},{"v":24000,"d":"NT$24,000.00"},{"v":29000,"d":"NT$29,000.00"},{"v":13200,"d":"NT$13,200.00"},{"v":9000,"d":"NT$9,000.00"},{"v":54360,"d":"NT$54,360.00"},{"v":51540,"d":"NT$51,540.00"},{"v":25650,"d":"NT$25,650.00"},{"v":28900,"d":"NT$28,900.00"},{"v":13400,"d":"NT$13,400.00"},{"v":9060,"d":"NT$9,060.00"}]