{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["封面 ","规模功能点估算","工作量估算","成本估算","估算工作书 "],"not_rendered":{"external_links":4,"defined_names":9},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"封面 ","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[2,0,2,7],[4,0,4,7],[16,1,16,2],[16,3,16,4],[16,5,16,7],[17,1,17,2],[17,3,17,4],[17,5,17,7],[18,1,18,2],[18,3,18,4],[18,5,18,7],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4]],"flags":["formulas_cached_only"]}
[]
[]
["上海柏维信息技术有限公司"]
[]
["项目定义过程"]
[]
[]
[{"$nulls":4},"文件编号：","ORG_PP_PDP"]
[{"$nulls":4},"版本：","1.0"]
[{"$nulls":4},"用户：","内部员工"]
[{"$nulls":4},"分类：","模板"]
[]
[{"$nulls":4},"状态：","正式发布"]
[{"$nulls":4},"密级：","内部公开"]
[]
["文档信息"]
["创建日期：","2023-3-12",null,"更新日期：2023-3-12"]
["编制：","胡志军\n",null,"生效日期：2023-3-12"]
["审核：","胡志军\n",null,"批准：陆军"]
[]
["修订文档历史记录"]
["日期","版本号","修订说明",null,null,"修订人","审核人","批准人"]
["2023-3-12","1.0","创建",null,null,"胡志军\n","胡志军\n","陆军"]

{"sheet":"规模功能点估算","index":1,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,1,1,7],[2,1,2,7],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[33,6,33,7],[34,1,34,7],[35,1,35,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,1,39,7],[40,1,40,7],[41,1,41,7],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[46,1,46,7],[47,1,47,7]],"flags":["formulas_cached_only"]}
[]
[null,"WBS规模估算　项目策划"]
[]
[null,"       规模分解","专家A","专家B","专家C","专家D","规模估算\n（包含复用的功能点个数）","功能复杂度分解"]
[]
[null,"1. XXXX",{"$nulls":4},{"$error":"#DIV/0!"},"简单功能点 个，中等功能点  个，复杂功能点  个"]
[null,"2. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"3. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"4. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"5. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"6. XXXX"]
[null,"7. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"8. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"9. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"10. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"11. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"12. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"13. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"14. XXXX"]
[null,"15. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"16. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"17. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"18. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"19. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"20. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"21. XXXX"]
[null,"22. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"23. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"24. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"25. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"26. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"27. XXXX",{"$nulls":4},{"$error":"#DIV/0!"}]
[null,"总功能点数",0,0,0,0,{"$error":"#DIV/0!"}]
[null,null,"偏差=",{"$error":"#DIV/0!"},null,"结论：","偏差为XXX%，小于±10%?，符合要求?。"]
[]
[null,"使用说明："]
[null,"1.是否通过的条件为判断偏差值的数据范围，默认的通过条件为偏差小于10%,根据每个项目的特征可以进行适当的调整。"]
[null,"2.偏差的计算公式为：stdev(X1:Xn)/AVERAGE(X1:Xn)*100%"]
[null,"3.如果一直不能达成一致（10%之内），需要重新组织专家估计。"]
[null,"德尔菲法介绍：德尔菲法(Delphi technique)是最流行的专家评估技术，在没有历史数据的情况下，这种方式适用于评定过去与将来、新技术与特定程序之间的差别，但专家“专”的程度及对项目的理解程度是工作中的难点，尽管德尔菲技术可以减轻这种偏差，在评定一个新软件实际成本时通常用得不多，但是，这种方式对决定其他模型的输入时特别有用。德尔菲法鼓励参加者就问题相互讨论。德尔菲法的步骤是："]
[null,"(1)协调人向各专家提供项目规格和估算表格；"]
[null,"(2)协调人召集小组会和各专家讨论与规模相关的因素；"]
[null,"(3)各专家匿名填写迭代表格；"]
[null,"(4)协调人整理出一个估算总结，以迭代表的形式返回给专家；"]
[null,"(3)协调人召集小组会，讨论较大的估算差异；"]
[null,"(6)专家复查估算总结并在迭代表上提交另一个匿名估算；"]
[null,"(7)重复4～6，直到最低估算和最高估算一致。"]
[null,"这种方法的优点主要是简便易行，具有一定科学性和实用性，可以避免会议讨论时产生的害怕权威随声附和，或固执已见，或因顾虑情面不愿与他人意见冲突等弊病；同时也可使大家发表的意见较快收敛，参加者也易接受结论，具有一定程度综合意见的客观性。但缺点是由于专家一般的时间紧，回答总是往往比较草率，同时由于预测主要依靠专家，因此归根到底仍属专家们的集体主观判断。此外，在选择合适的专家方面也较困难，征询意见的时间较长，对于需要快速判断的预测难于使用等。尽管如此，本方法因简便可靠，仍不失为一种人们常用的定性预测方法。根据目前的现状，我们可以从以下几个方面考虑：成本、工作量、项目规模、技术难点、风险列表、以往项目中可借鉴的地方。"]

{"sheet":"工作量估算","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[0,1,0,5],[1,4,1,5],[20,1,20,2]],"flags":["formulas_cached_only"]}
["                WBS工作量估算 项目策划","WBS工作量估算  项目策划"]
[null,"序号","工作任务名称","估计工作量(人月)","备注"]
[null,1,"需求",{"$error":"#DIV/0!"},"占开发工作量的"]
[null,2,"设计",{"$error":"#DIV/0!"},"占开发工作量的"]
[null,3,"编码",{"$error":"#DIV/0!"},"占开发工作量的"]
[null,4,"测试",{"$error":"#DIV/0!"},"占开发工作量的"]
[null,5,"试运行及验收",{"$error":"#DIV/0!"},"占开发工作量的"]
[null,null,"开发工作量合计",{"$error":"#DIV/0!"},"占总工作量的"]
[null,6,"立项管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,7,"项目规划",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,8,"项目监控",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,9,"风险管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,10,"评审管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,11,"配置管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,12,"质量保证",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,13,"培训管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,14,"结项管理",{"$error":"#DIV/0!"},"占管理工作量的"]
[null,null,"管理工作量合计",{"$error":"#DIV/0!"},"占总工作量的"]
[null,null,"工作量总计",{"$error":"#DIV/0!"}]
[]
[null,"平均生产率（功能点/人月）="]

{"sheet":"成本估算","index":3,"n_rows":49,"n_cols":5,"rows_kept":49,"merged":[[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[7,1,7,4],[27,1,27,4],[28,1,28,2],[28,3,28,4],[29,1,29,2],[29,3,29,4],[30,1,30,2],[30,3,30,4],[31,1,31,2],[31,3,31,4],[32,1,32,2],[32,3,32,4],[33,1,33,2],[33,3,33,4],[35,3,35,4],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2]],"flags":["formulas_cached_only"]}
[]
[null,"项目名称："]
[null,"项目周期："]
[null,"项目经理："]
[null,"编制日期："]
[null,"部门经理签字："]
[]
[null,"1.人员成本"]
[null,"工作任务名称","职责人","标准成本(元)","估算成本(元)"]
[null,"需求",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"设计",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"编码",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"测试",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"试运行及验收",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"开发成本合计",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"立项管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"项目规划",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"项目监控",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"风险管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"评审管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"配置管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"质量保证",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"培训管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"结项管理",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"管理成本合计",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"总计",null,null,{"$error":"#DIV/0!"}]
[]
[null,"2.其他成本"]
[null,"加班费用（元）"]
[null,"差旅费用（人数，次数，时间）"]
[null,"招待费（元）"]
[null,"采购费用（元）"]
[null,"其他费用（元）"]
[null,"其他成本合计",null,0]
[]
[null,"项目总成本估算：",null,{"$error":"#DIV/0!"}]
[]
[null,"项目经理成本（元/天）",null,400]
[null,"需求人员成本（元/天）",300,300]
[null,"设计人员成本（元/天）",300,300]
[null,"初级开发工程师成本（元/天）",200,150]
[null,"中级开发工程师成本（元/天）",null,250]
[null,"高级开发工程师成本（元/天）",250,350]
[null,"测试人员成本（元/天）",200,150]
[null,"QA人员成本（元/天）",150,150]
[null,"CM人员成本（元/天）",120,150]
[null,"培训人员成本（元/天）",150,120]
[null,"采购人员成本（元/天）",150,120]
[null,"部门经理成本（元/天）",500,450]

{"sheet":"估算工作书 ","index":4,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[0,0,0,5],[1,0,2,1],[1,2,2,3],[1,4,1,5],[3,0,3,1],[3,2,3,3],[4,0,6,1],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,0,8,1],[7,2,7,3],[8,2,8,3],[9,0,13,1],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,0,14,1],[14,2,14,5],[15,0,21,1],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,0,24,1],[22,2,22,3],[23,2,23,3],[24,2,24,3]],"flags":["formulas_cached_only"]}
["项目估算工作书"]
["分类",null,"估算对象（单位）",null,"项目策划阶段"]
[{"$nulls":4},"估算依据（估算假设）","预计"]
["规模",null,"功能点个数(个)",null,"历史经验（专家法）",{"$error":"#DIV/0!"}]
["工作量",null,"总工作量（人月）",null,"规模/平均生产率＝工作量（参考公司度量库中的员工平均生率，假设本项目使用的员工平均生产率为?(个/人月)）",{"$error":"#DIV/0!"}]
[null,null,"开发工作量（人月）",null,"参照公司度量库的数据，开发工作量＝70%*总工作量",{"$error":"#DIV/0!"}]
[null,null,"管理工作量（人月）",null,"参照公司度量库的数据，开发工作量＝30%*总工作量",{"$error":"#DIV/0!"}]
["人员成本",null,"管理人员成本（元）",null,"按照度量库中的标准人工成本估算",{"$error":"#DIV/0!"}]
[null,null,"开发人员成本（元）",null,"按照度量库中的标准人工成本估算",{"$error":"#DIV/0!"}]
["其他成本",null,"加班费用（元）",null,"期间可能加班费用，估计?次，每次费用约?元",0]
[null,null,"差旅费用（人数，次数，时间）",null,"出差?次，每次费用约?元",0]
[null,null,"招待费（元）",null,"出差?次，每次费用?元",0]
[null,null,"采购费用（元）",null,"涉及采购的费用",0]
[null,null,"其他费用（元）",null,"除以上之外的费用",0]
["项目总成本"]
["进度",null,"项目立项",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"项目策划",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"需求",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"设计",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"编码",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"测试",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
[null,null,"试运行及验收",null,"将总工作量进行WBS分解到项目各阶段任务，根据不同阶段参与人的个数，计算出该阶段完成的进度","实际情况"]
["关键计算机资源",null,"PC机（台）",null,"按项目开发人员使用的机器台数估算","实际情况"]
[null,null,"服务器（台）",null,"按项目实际需要估算","实际情况"]
[null,null,"其他设备（台）",null,null,"实际情况"]