{"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":8,"n_cols":2,"rows_kept":8}
[null,"关于此模板"]
[]
[null,"使用此工作表跟踪律师事务所在项目规划期间的项目参数、项目详细信息和项目汇总。"]
[null,"在“项目参数”工作表中填写你自己的公司名称，它将会自动更新至其他工作表中。"]
[null,"在“项目参数”和“项目详细信息”工作表中输入相关信息，以更新柱形图。“项目汇总”工作表中的数据透视表将会自动更新。"]
[null,"注释：  "]
[null,"每个工作表的 A 列提供了其他说明。此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关该工作表中各表格的详细信息，请在表格内按 Shift+F10，选择“表格”选项，然后选择“替换文本”。对于“项目汇总”工作表中的数据透视表，请在表格内按 SHIFT+F10，选择“数据透视表”选项，然后选择“替换文本”选项卡。"]

{"sheet":"项目参数","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
[null,"Mitchell, Morris, Ward, & Cook"]
[null,"适合于律师事务所的项目规划"]
[null,{"$f":"B1&\" 机密\"","v":"Mitchell, Morris, Ward, & Cook 机密"}]
[null,"已为你计算带底纹的单元格。无需在其中输入任何内容。"]
[null,"项目类型","普通合伙人","商业律师","辩护律师","知识产权律师","破产律师","管理人员","总计"]
[null,"公司成立",{"v":0.1,"d":"¥0"},{"v":0.4,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.5,"d":"¥1"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"业务并购",{"v":0.1,"d":"¥0"},{"v":0.4,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.1,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.4,"d":"¥0"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"产品责任抗辩",{"v":0.2,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.5,"d":"¥1"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.3,"d":"¥0"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"专利申请",{"v":0.1,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.6,"d":"¥1"},{"v":0,"d":"¥0"},{"v":0.3,"d":"¥0"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"员工诉讼",{"v":0.2,"d":"¥0"},{"v":0.1,"d":"¥0"},{"v":0.4,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.3,"d":"¥0"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"破产",{"v":0.1,"d":"¥0"},{"v":0.2,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0,"d":"¥0"},{"v":0.4,"d":"¥0"},{"v":0.3,"d":"¥0"},{"$f":"SUM(参数[[#This Row],[普通合伙人]:[管理人员]])","v":{"v":1,"d":"¥1"}}]
[null,"混合费率",{"v":350,"d":"¥350"},{"v":250,"d":"¥250"},{"v":300,"d":"¥300"},{"v":275,"d":"¥275"},{"v":225,"d":"¥225"},{"v":125,"d":"¥125"}]
[]
[]
[]
[null,"计划成本",{"$f":"SUBTOTAL(109,详细信息[普通合伙人])","v":{"v":78750,"d":"¥78,750.00"}},{"$f":"SUBTOTAL(109,详细信息[商业律师])","v":{"v":66250,"d":"¥66,250.00"}},{"$f":"SUBTOTAL(109,详细信息[辩护律师])","v":{"v":105000,"d":"¥105,000.00"}},{"$f":"SUBTOTAL(109,详细信息[知识产权律师])","v":{"v":35750,"d":"¥35,750.00"}},{"$f":"SUBTOTAL(109,详细信息[破产律师])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,详细信息[管理人员])","v":{"v":66250,"d":"¥66,250.00"}}]
[null,"实际成本",{"$f":"SUBTOTAL(109,详细信息[普通合伙人 2])","v":{"v":79275,"d":"¥79,275.00"}},{"$f":"SUBTOTAL(109,详细信息[商业律师 2])","v":{"v":67375,"d":"¥67,375.00"}},{"$f":"SUBTOTAL(109,详细信息[辩护律师 2])","v":{"v":105600,"d":"¥105,600.00"}},{"$f":"SUBTOTAL(109,详细信息[知识产权律师 2])","v":{"v":34650,"d":"¥34,650.00"}},{"$f":"SUBTOTAL(109,详细信息[破产律师 2])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,详细信息[管理人员 2])","v":{"v":67000,"d":"¥67,000.00"}}]
[null,"计划工时",{"$f":"C16/$C$12","v":{"v":225,"d":"225.00"}},{"$f":"D16/$C$12","v":{"v":189.28571428571428,"d":"189.29"}},{"v":300,"d":"300.00"},{"v":102.14285714285714,"d":"102.14"},{"v":0,"d":"0.00"},{"v":189.28571428571428,"d":"189.29"}]
[null,"实际工时",{"$f":"C17/$C$12","v":{"v":226.5,"d":"226.50"}},{"$f":"D17/$C$12","v":{"v":192.5,"d":"192.50"}},{"$f":"E17/$C$12","v":{"v":301.7142857142857,"d":"301.71"}},{"$f":"F17/$C$12","v":{"v":99,"d":"99.00"}},{"$f":"G17/$C$12","v":{"v":0,"d":"0.00"}},{"$f":"H17/$C$12","v":{"v":191.42857142857142,"d":"191.43"}}]

{"sheet":"项目详细信息","index":2,"n_rows":10,"n_cols":25,"rows_kept":10,"merged":[[1,24,8,28]]}
[null,{"$f":"项目参数!B1","v":"Mitchell, Morris, Ward, & Cook"}]
[null,{"$f":"项目参数!B2","v":"适合于律师事务所的项目规划"},{"$nulls":22},"信息：\n若要添加一行，请选择该表主体（不是汇总行）最右下方的单元格，在想要插入行的位置在表格内按 SHIFT+F10 键，然后选择“在上方/下方插入 | 表行”。\n请确保已删除所有未使用的行，因为“项目汇总”数据透视表将使用所有表格单元格，如未删除，则可能会出现错误结果。"]
[null,{"$f":"项目参数!B3","v":"Mitchell, Morris, Ward, & Cook 机密"}]
[null,"项目名称","项目类型","估计开始时间","估计完成时间","实际开始时间","实际完成时间","估计工时","实际工时","估计工期","实际工期","普通合伙人","商业律师","辩护律师","知识产权律师","破产律师","管理人员","普通合伙人 2","商业律师 2","辩护律师 2","知识产权律师 2","破产律师 2","管理人员 2"]
[null,"欧罗巴","公司成立",{"$f":"TODAY()","v":"2023-03-31"},{"$f":"TODAY()+60","v":"2023-05-30"},{"$f":"TODAY()+10","v":"2023-04-10"},{"$f":"TODAY()+65","v":"2023-06-04"},200,220,{"$f":"DAYS360(详细信息[[#This Row],[估计开始时间]],详细信息[[#This Row],[估计完成时间]],FALSE)","v":60},{"$f":"DAYS360(详细信息[[#This Row],[实际开始时间]],详细信息[[#This Row],[实际完成时间]],FALSE)","v":54},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[估计工时]]","v":{"v":7000,"d":"¥7,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":20000,"d":"¥20,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":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":12500,"d":"¥12,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":7700,"d":"¥7,700"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[商业律师]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[商业律师]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":22000,"d":"¥22,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":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":13750,"d":"¥13,750"}}]
[null,"金鱼","业务并购",{"$f":"TODAY()+30","v":"2023-04-30"},{"$f":"TODAY()+100","v":"2023-07-09"},{"$f":"TODAY()+40","v":"2023-05-10"},{"$f":"TODAY()+110","v":"2023-07-19"},400,390,{"$f":"DAYS360(详细信息[[#This Row],[估计开始时间]],详细信息[[#This Row],[估计完成时间]],FALSE)","v":69},{"$f":"DAYS360(详细信息[[#This Row],[实际开始时间]],详细信息[[#This Row],[实际完成时间]],FALSE)","v":69},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[估计工时]]","v":{"v":14000,"d":"¥14,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":40000,"d":"¥40,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":11000,"d":"¥11,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":20000,"d":"¥20,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":13650,"d":"¥13,650"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[商业律师]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[商业律师]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":39000,"d":"¥39,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":10725,"d":"¥10,725"}},{"$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":19500,"d":"¥19,500"}}]
[null,"钴","产品责任抗辩",{"$f":"TODAY()+150","v":"2023-08-28"},{"$f":"TODAY()+150","v":"2023-08-28"},{"$f":"TODAY()+150","v":"2023-08-28"},{"$f":"TODAY()+170","v":"2023-09-17"},500,500,{"$f":"DAYS360(详细信息[[#This Row],[估计开始时间]],详细信息[[#This Row],[估计完成时间]],FALSE)","v":0},{"$f":"DAYS360(详细信息[[#This Row],[实际开始时间]],详细信息[[#This Row],[实际完成时间]],FALSE)","v":19},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[估计工时]]","v":{"v":35000,"d":"¥35,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":75000,"d":"¥75,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":18750,"d":"¥18,750"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":35000,"d":"¥35,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":75000,"d":"¥75,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":18750,"d":"¥18,750"}}]
[null,"虹膜","专利申请",{"$f":"TODAY()+200","v":"2023-10-17"},{"$f":"TODAY()+230","v":"2023-11-16"},{"$f":"TODAY()+230","v":"2023-11-16"},{"$f":"TODAY()+230","v":"2023-11-16"},150,145,{"$f":"DAYS360(详细信息[[#This Row],[估计开始时间]],详细信息[[#This Row],[估计完成时间]],FALSE)","v":29},{"$f":"DAYS360(详细信息[[#This Row],[实际开始时间]],详细信息[[#This Row],[实际完成时间]],FALSE)","v":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":5250,"d":"¥5,250"}},{"$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":24750,"d":"¥24,750"}},{"$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":5625,"d":"¥5,625"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":5075,"d":"¥5,075"}},{"$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":23925,"d":"¥23,925"}},{"$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":5437.5,"d":"¥5,438"}}]
[null,"Python","员工诉讼",{"$f":"TODAY()+220","v":"2023-11-06"},{"$f":"TODAY()+250","v":"2023-12-06"},{"$f":"TODAY()+230","v":"2023-11-16"},{"$f":"TODAY()+259","v":"2023-12-15"},250,255,{"$f":"DAYS360(详细信息[[#This Row],[估计开始时间]],详细信息[[#This Row],[估计完成时间]],FALSE)","v":30},{"$f":"DAYS360(详细信息[[#This Row],[实际开始时间]],详细信息[[#This Row],[实际完成时间]],FALSE)","v":29},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[估计工时]]","v":{"v":17500,"d":"¥17,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":6250,"d":"¥6,250"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[辩护律师]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[辩护律师]],参数[#Headers],0))*详细信息[[#This Row],[估计工时]]","v":{"v":30000,"d":"¥30,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":9375,"d":"¥9,375"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[普通合伙人]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":17850,"d":"¥17,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":6375,"d":"¥6,375"}},{"$f":"INDEX(参数[],MATCH(详细信息[[#This Row],[项目类型]],参数[项目类型],0),MATCH(详细信息[[#Headers],[辩护律师]],参数[#Headers],0))*INDEX(项目参数!$B$12:$H$12,1,MATCH(详细信息[[#Headers],[辩护律师]],参数[#Headers],0))*详细信息[[#This Row],[实际工时]]","v":{"v":30600,"d":"¥30,600"}},{"$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":9562.5,"d":"¥9,563"}}]
[null,"汇总",{"$nulls":5},{"$f":"SUBTOTAL(109,详细信息[估计工时])","v":1500},{"$f":"SUBTOTAL(109,详细信息[实际工时])","v":1510},{"$f":"SUBTOTAL(109,详细信息[估计工期])","v":188},{"$f":"SUBTOTAL(109,详细信息[实际工期])","v":171}]

{"sheet":"项目总计","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"merged":[[3,2,3,7],[3,8,3,13]]}
[null,{"$f":"项目参数!B1","v":"Mitchell, Morris, Ward, & Cook"}]
[null,{"$f":"项目参数!B2","v":"适合于律师事务所的项目规划"}]
[null,{"$f":"项目参数!B3","v":"Mitchell, Morris, Ward, & Cook 机密"}]
[null,null,"估计",{"$nulls":5},"实际"]
[null,"项目名称","普通合伙人 ","商业律师 ","知识产权律师 ","辩护律师 ","破产律师 ","管理人员 ","普通合伙人  ","商业律师  ","辩护律师  ","知识产权律师  ","破产律师  ","管理人员  "]
[null,"欧罗巴",{"v":7000,"d":"¥7,000.00"},{"v":20000,"d":"¥20,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":12500,"d":"¥12,500.00"},{"v":7700,"d":"¥7,700.00"},{"v":22000,"d":"¥22,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":13750,"d":"¥13,750.00"}]
[null,"金鱼",{"v":14000,"d":"¥14,000.00"},{"v":40000,"d":"¥40,000.00"},{"v":11000,"d":"¥11,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":20000,"d":"¥20,000.00"},{"v":13650,"d":"¥13,650.00"},{"v":39000,"d":"¥39,000.00"},{"v":0,"d":"¥0.00"},{"v":10725,"d":"¥10,725.00"},{"v":0,"d":"¥0.00"},{"v":19500,"d":"¥19,500.00"}]
[null,"钴",{"v":35000,"d":"¥35,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":75000,"d":"¥75,000.00"},{"v":0,"d":"¥0.00"},{"v":18750,"d":"¥18,750.00"},{"v":35000,"d":"¥35,000.00"},{"v":0,"d":"¥0.00"},{"v":75000,"d":"¥75,000.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":18750,"d":"¥18,750.00"}]
[null,"虹膜",{"v":5250,"d":"¥5,250.00"},{"v":0,"d":"¥0.00"},{"v":24750,"d":"¥24,750.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":5625,"d":"¥5,625.00"},{"v":5075,"d":"¥5,075.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":23925,"d":"¥23,925.00"},{"v":0,"d":"¥0.00"},{"v":5437.5,"d":"¥5,437.50"}]
[null,"Python",{"v":17500,"d":"¥17,500.00"},{"v":6250,"d":"¥6,250.00"},{"v":0,"d":"¥0.00"},{"v":30000,"d":"¥30,000.00"},{"v":0,"d":"¥0.00"},{"v":9375,"d":"¥9,375.00"},{"v":17850,"d":"¥17,850.00"},{"v":6375,"d":"¥6,375.00"},{"v":30600,"d":"¥30,600.00"},{"v":0,"d":"¥0.00"},{"v":0,"d":"¥0.00"},{"v":9562.5,"d":"¥9,562.50"}]
[null,"总计",{"v":78750,"d":"¥78,750.00"},{"v":66250,"d":"¥66,250.00"},{"v":35750,"d":"¥35,750.00"},{"v":105000,"d":"¥105,000.00"},{"v":0,"d":"¥0.00"},{"v":66250,"d":"¥66,250.00"},{"v":79275,"d":"¥79,275.00"},{"v":67375,"d":"¥67,375.00"},{"v":105600,"d":"¥105,600.00"},{"v":34650,"d":"¥34,650.00"},{"v":0,"d":"¥0.00"},{"v":67000,"d":"¥67,000.00"}]