{"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":"¥180"},{"v":120,"d":"¥120"},{"v":150,"d":"¥150"},{"v":100,"d":"¥100"},{"v":80,"d":"¥80"},{"v":60,"d":"¥60"}]
[]
[{"$nulls":5},"显示计划工时与实际工时的柱形图位于此单元格中。"]
[null,null,"客户经理","项目经理","战略经理","设计专员","参与活动的员工","管理人员"]
[null,"计划成本",{"$f":"SUBTOTAL(109,项目详细信息[客户经理])","v":{"v":54000,"d":"¥54,000.00"}},{"$f":"SUBTOTAL(109,项目详细信息[项目经理])","v":{"v":52200,"d":"¥52,200.00"}},{"$f":"SUBTOTAL(109,项目详细信息[战略经理])","v":{"v":24000,"d":"¥24,000.00"}},{"$f":"SUBTOTAL(109,项目详细信息[设计专员])","v":{"v":29000,"d":"¥29,000.00"}},{"$f":"SUBTOTAL(109,项目详细信息[参与活动的员工])","v":{"v":13200,"d":"¥13,200.00"}},{"$f":"SUBTOTAL(109,项目详细信息[管理人员])","v":{"v":9000,"d":"¥9,000.00"}}]
[null,"实际成本",{"$f":"SUBTOTAL(109,项目详细信息[[客户经理 ]])","v":{"v":54360,"d":"¥54,360.00"}},{"$f":"SUBTOTAL(109,项目详细信息[[项目经理 ]])","v":{"v":51540,"d":"¥51,540.00"}},{"$f":"SUBTOTAL(109,项目详细信息[[战略经理 ]])","v":{"v":25650,"d":"¥25,650.00"}},{"$f":"SUBTOTAL(109,项目详细信息[[设计专员 ]])","v":{"v":28900,"d":"¥28,900.00"}},{"$f":"SUBTOTAL(109,项目详细信息[[参与活动的员工 ]])","v":{"v":13400,"d":"¥13,400.00"}},{"$f":"SUBTOTAL(109,项目详细信息[[管理人员 ]])","v":{"v":9060,"d":"¥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若要在右侧表格中添加一行，请选择该表主体（不是汇总行）最右下方的单元格，在想要插入行的位置按 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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥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":"¥7,200.00"},{"v":2400,"d":"¥2,400.00"},{"v":18000,"d":"¥18,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1200,"d":"¥1,200.00"},{"v":7920,"d":"¥7,920.00"},{"v":2640,"d":"¥2,640.00"},{"v":19800,"d":"¥19,800.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1320,"d":"¥1,320.00"}]
[null,"项目 2",{"v":14400,"d":"¥14,400.00"},{"v":24000,"d":"¥24,000.00"},{"v":6000,"d":"¥6,000.00"},{"v":4000,"d":"¥4,000.00"},{"v":0,"d":"¥0.00"},{"v":2400,"d":"¥2,400.00"},{"v":14040,"d":"¥14,040.00"},{"v":23400,"d":"¥23,400.00"},{"v":5850,"d":"¥5,850.00"},{"v":3900,"d":"¥3,900.00"},{"v":0,"d":"¥0.00"},{"v":2340,"d":"¥2,340.00"}]
[null,"项目 3",{"v":18000,"d":"¥18,000.00"},{"v":12000,"d":"¥12,000.00"},{"v":0,"d":"¥0.00"},{"v":25000,"d":"¥25,000.00"},{"v":0,"d":"¥0.00"},{"v":3000,"d":"¥3,000.00"},{"v":18000,"d":"¥18,000.00"},{"v":12000,"d":"¥12,000.00"},{"v":0,"d":"¥0.00"},{"v":25000,"d":"¥25,000.00"},{"v":0,"d":"¥0.00"},{"v":3000,"d":"¥3,000.00"}]
[null,"项目 4",{"v":5400,"d":"¥5,400.00"},{"v":10800,"d":"¥10,800.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1200,"d":"¥1,200.00"},{"v":900,"d":"¥900.00"},{"v":5220,"d":"¥5,220.00"},{"v":10440,"d":"¥10,440.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":1160,"d":"¥1,160.00"},{"v":870,"d":"¥870.00"}]
[null,"项目 5",{"v":9000,"d":"¥9,000.00"},{"v":3000,"d":"¥3,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":12000,"d":"¥12,000.00"},{"v":1500,"d":"¥1,500.00"},{"v":9180,"d":"¥9,180.00"},{"v":3060,"d":"¥3,060.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":12240,"d":"¥12,240.00"},{"v":1530,"d":"¥1,530.00"}]
[null,"总计",{"v":54000,"d":"¥54,000.00"},{"v":52200,"d":"¥52,200.00"},{"v":24000,"d":"¥24,000.00"},{"v":29000,"d":"¥29,000.00"},{"v":13200,"d":"¥13,200.00"},{"v":9000,"d":"¥9,000.00"},{"v":54360,"d":"¥54,360.00"},{"v":51540,"d":"¥51,540.00"},{"v":25650,"d":"¥25,650.00"},{"v":28900,"d":"¥28,900.00"},{"v":13400,"d":"¥13,400.00"},{"v":9060,"d":"¥9,060.00"}]