{"text_format":"2","workbook":"xlsx","n_sheets":13,"sheets":["封面","基本信息","技能需求计划","工作环境","质量控制","配置仓库","基线","测试计划","过程定义","度量项定义","度量目标及分析方法","项目预算","附录"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":9,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"封面","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":10}
[null,"变更记录",{"$nulls":5},"配置项状态记录"]
[null,"版本号","更新内容","作者","审批人","审批时间",null,"状态"]
[null,"V0.1","初稿","肖敏",null,null,null,"已入基线"]
[null,"V1.0","评审通过","肖敏","施展","2014-04-15"]
[null,"V1.1","调整资源","肖敏","施展","2014-05-10"]

{"sheet":"基本信息","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,1,2,2],[2,4,2,6],[3,1,3,2],[3,4,3,6],[19,1,19,3],[19,5,19,6],[4,1,4,2],[4,4,4,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,3,11,6],[14,1,14,2],[15,1,15,2],[18,1,18,3],[18,5,18,6],[20,1,20,3],[20,5,20,6],[21,1,21,3],[21,5,21,6],[22,1,22,3],[22,5,22,6]]}
["基本信息"]
["1. 概要"]
["项目编号","GJXC",null,"项目名称","江苏广靖锡澄高速公路营运管理平台"]
["客户名称","江苏广靖锡澄高速公路有限责任公司",null,"项目经理","肖敏"]
["计划开始时间","2014-04-07",null,"计划结束时间","2015-01-05"]
[]
["2.  关键人员"]
["姓名","类别","角色","对项目的影响"]
["陈长龙","客户","验收负责人","项目需求的主要提供者，负责对项目最终成果进行组织验收，直接决定项目成败。"]
["施展","内部人员","项目主管","项目的汇报对象，为项目提供资源，协助项目解决重大问题，也是潜在的项目需求提出者，可能影响项目范围和实施进展。"]
["肖敏","内部人员","项目经理","项目实施负责人，控制项目质量、成本和进度。"]
[]
[]
["3.关键资源"]
["资源名称","说明"]
["海康视频系统\n中威视频系统","系统需要通过这两种视频系统进行视频展示及播放"]
[]
["4. 交付物清单"]
["NO.","交付物名称",null,null,"要求交付时间","交付要求"]
[1,"系统安装包",null,null,"2014-08-31","可正常部署运行、所有功能需求都被满足"]
[2,"产品发布说明",null,null,"2014-08-31","完整部署流程、按照说明可正常部署"]
[3,"系统使用说明书",null,null,"2014-08-31","带图文的所有功能的使用说明"]
[4,"源代码",null,null,"2014-08-31","所有已知缺陷都被修复"]

{"sheet":"技能需求计划","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,10,3,12],[9,10,9,12],[9,2,9,5],[27,3,27,4],[27,5,27,6],[27,8,27,9],[4,10,4,12],[5,10,5,12],[6,10,6,12],[7,10,7,12],[8,10,8,12],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[0,0,0,9],[2,0,3,0],[2,1,3,1],[2,2,3,5],[2,6,3,6],[2,7,2,9],[16,5,16,6],[16,8,16,9],[13,8,14,9],[19,3,19,4],[19,5,19,6],[19,8,19,9],[15,3,15,4],[15,5,15,6],[15,8,15,9],[18,3,18,4],[18,5,18,6],[18,8,18,9],[17,3,17,4],[17,5,17,6],[16,3,16,4],[17,8,17,9],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,13,7],[14,3,14,4],[14,5,14,6],[24,3,24,4],[24,5,24,6],[24,8,24,9],[30,4,30,5],[30,2,30,3],[26,8,26,9],[32,4,32,5],[32,2,32,3],[26,3,26,4],[26,5,26,6],[33,2,33,3],[33,4,33,5],[20,3,20,4],[20,5,20,6],[20,8,20,9],[25,3,25,4],[31,0,31,8],[21,8,21,9],[21,5,21,6],[22,3,22,4],[22,5,22,6],[21,3,21,4],[25,5,25,6],[25,8,25,9],[22,8,22,9],[23,3,23,4],[23,5,23,6],[23,8,23,9],[34,0,34,8],[36,0,36,8],[37,4,37,5],[37,2,37,3],[35,2,35,3],[35,4,35,5]]}
["技能需求计划"]
["1.技能需求计划"]
["NO.","角色","职责",null,null,null,"人数","能力要求",null,null,"备注"]
[{"$nulls":7},"技术掌握程度","业务熟悉程度","公司规范掌握程度"]
[1,"开发","负责项目需求分析、模块设计、开发编码、集成",null,null,null,6,"熟练J2EE开发，熟悉图表展示插件、熟悉超图工具开发","熟悉高速公路日常营运业务","熟悉公司工作制度、熟悉编码规范"]
[2,"页面设计","负责页面设计、美工工作",null,null,null,1,"熟练页面效果图的制作、PhotoShop使用熟练","熟悉高速公路日常营运业务","熟悉公司工作制度"]
[3,"需求调研","需求分析",null,null,null,2,"沟通能力好，熟悉excel","熟悉高速公路日常营运业务","熟悉公司工作制度"]
[4,"PM","负责项目策划、需求分析、系统设计、系统开发、配置管理、问题管理、风险管理、决策分析",null,null,null,1,"有项目管理经验，精通J2ee、html、数据库","熟悉高速公路日常营运业务","熟悉公司工作制度"]
[5,"测试","测试设计、测试执行",null,null,null,2,"沟通能力里强，理解用户需求，熟悉测试用例方法","熟悉高速公路日常营运业务","熟悉公司工作制度"]
[6,"配置管理员","项目配置管理、基线发布",null,null,null,1,"熟悉配置管理工具的使用，可根据项目基线计划进行基线发布工作","熟悉配置管理工作","熟悉公司工作制度"]
[]
[]
["2.人员技能现状"]
["NO.","姓名","角色","能力满足度",{"$nulls":4},"备注"]
[null,null,null,"技术",null,"业务",null,"公司规范"]
[1,"侍凡","开发","对系统框架、超图工具不够熟悉",null,"业务流程不够熟悉",null,"不满足"]
[2,"陈继伟","开发","对系统框架、超图工具不够熟悉",null,"业务流程不够熟悉",null,"不满足"]
[3,"高宇庭","开发","对系统框架、超图工具不够熟悉",null,"业务流程不够熟悉",null,"不满足"]
[4,"徐永刚","开发","对超图工具不够熟悉",null,"业务流程不够熟悉",null,"不满足"]
[5,"潘彩侠","开发","对系统框架、超图工具不够熟悉",null,"业务流程不够熟悉",null,"不满足"]
[6,"王晖","需求调研","满足",null,"满足",null,"满足"]
[7,"朱红军","需求调研","满足",null,"业务流程不够熟悉",null,"满足"]
[8,"顾丽郡","页面设计","满足",null,"业务流程不够熟悉",null,"不满足"]
[9,"曹碧蓉","开发","满足",null,"业务流程不够熟悉",null,"不满足"]
[10,"肖敏","PM","满足",null,"满足",null,"满足"]
[11,"秦洁","测试","满足",null,"业务流程不够熟悉",null,"满足"]
[12,"朱玲","测试","满足",null,"业务流程不够熟悉",null,"满足"]
[13,"袁晓冬","配置管理员","满足",null,"满足",null,"满足"]
[]
["3. 培训计划"]
["NO.","培训内容","讲师",null,"参加人",null,"时间","目标","备注"]
["技术培训"]
[1,"系统框架","徐永刚",null,"后台编码人员",null,"2014-05-05","可使用系统框架进行编码"]
[2,"超图培训","超图培训讲师",null,"后台编码人员",null,"2014-05-16","可使用超图工具进行开发"]
["业务培训"]
[1,"系统业务流程","王晖",null,"全体人员",null,"2014-04-28","可根据需求编写详细设计说明书\n测试人员可根据需求编写测试用例"]
["公司规范相关培训"]
[1,"项目规范","肖敏",null,"全体人员",null,"2014-04-28","熟悉公司相关规范"]

{"sheet":"工作环境","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,3,2,4],[2,0,3,0],[0,0,0,4]]}
["工作环境"]
[]
["环境分类","组织标准环境",null,"自定义工作环境"]
[null,"硬件","软件","硬件","软件"]
["基础办公环境","台式机(AMD 2GHZ+内存2G+硬盘250G）","win 7\noffice2010\nAdobe Reader 8.0","无","无"]
["开发环境","同上","JDK7\nPLSQLDeveloper\noracle11g","无","myeclipse10\n超图deskpro"]
["测试环境","同上","IE11\nChrome 4.3\nFirefox 2.2\noracle11g","无","无"]
["集成环境","台式机（AMD 4GHZ_内存4G+硬盘500G）","eclipse\nJDK7\nTomcat 6","无","无"]
["验收环境","台式机（AMD 4GHZ_内存4G+硬盘500G）","JDK7\noracle11g","无","无"]
["配置环境","台式机(AMD 2GHZ+内存2G+硬盘250G）","SubVersion 1.7.4\nTSVN 1.7.0","无","无"]
["评审环境","DELL笔记本电脑","office2010\nAdobe Reader 8.0","无","超图deskpro"]

{"sheet":"质量控制","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,3,1,4],[1,5,1,6],[3,5,3,6],[4,5,4,6],[2,3,2,4],[2,5,2,6],[9,3,9,4],[9,5,9,6],[6,0,7,0],[3,3,3,4],[4,3,4,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[5,3,5,4],[5,5,5,6]]}
["质量控制"]
["工作产品","质量控制方式","类别","方法",null,"通过标准",null,"备注"]
["项目整体计划","评审","验证","邀请业主，项目管理单位、项目监理单位开会评审",null,"会议结论为通过或会议中提出的问题修改后经业主确认"]
["需求文档","评审","验证","邀请业主，项目管理单位、项目监理单位开会评审",null,"会议结论为通过或会议中提出的问题修改后经业主确认"]
["设计文档","评审","验证","邀请业主，专家开会评审",null,"发现的缺陷完全解决可以通过；或由项目经理负责评估"]
["源代码","单元测试","验证","由个人编写Junit测试用例并执行。",null,"测试用例全部通过"]
["编译程序","功能测试","验证","由研发开发小组和测试人员执行黑盒测试 ",null,"检出足够的缺陷且解决后方能通过；或由项目负责人对其评估，并对其负责"]
[null,"集成测试","验证","由研发开发小组和测试人员执行黑盒测试 ",null,"检出足够的缺陷且解决后方能通过；或由项目负责人对其评估，并对其负责"]
["待发布程序","验收测试","确认","由第三方专业测试人员执行全面测试并出具报告 ",null,"第三方测试报告结论是通过"]
["交付部署文档","实验","确认","安排小组外人员根据文档部署和使用软件产品",null,"能够成功部署并使用系统功能"]

{"sheet":"配置仓库","index":5,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,0,0,11],[35,3,35,4],[36,2,36,4],[37,1,37,4],[21,3,21,4],[22,2,22,4],[23,3,23,4],[27,3,27,4],[31,3,31,4],[30,3,30,4],[2,0,2,2],[3,0,3,2],[4,0,4,2],[2,3,2,11],[3,3,3,11],[4,3,4,11],[11,3,11,4],[7,0,7,4],[6,0,6,7],[8,0,8,4],[9,1,9,4],[10,2,10,4],[12,3,12,4],[48,0,48,7],[45,1,45,4],[20,3,20,4],[26,3,26,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[41,1,41,4],[40,0,40,4],[46,0,46,4]]}
["配置仓库"]
["1 基本信息"]
["管理工具",null,null,"使用SVN管理。项目资料统一存储在公司SVN服务器上，客户端使用TSVN1.7"]
["访问地址",null,null,"https://192.168.30.100/svn/projects/gjxc"]
["维护负责人",null,null,"袁晓冬"]
[]
["2 配置仓库目录结构及访问权限"]
["目录",{"$nulls":4},"说明","产出物","项目经理","编码人员","测试人员","配置管理员","QA"]
["1.文档",{"$nulls":4},"文档管理区"]
[null,"1.工作区",null,null,null,"工作区，所有相关人员可读写与自己工作相关的文件"]
[null,null,"1.项目管理"]
[null,null,null,"1.项目启动",null,"用于存放项目计划文档，主要是项目章程、项目整体计划、项目详细进度计划、测试计划、品质保证计划。","开工报告\n项目整体计划\n详细进度计划","R/W","R","R","R","R/W"]
[null,null,null,"2.项目监控"]
[{"$nulls":4},"1.沟通记录","用于存放项目组会议记录、与客户的沟通记录、项目状态报告。",null,"R/W","R/W","R/W","R","R/W"]
[{"$nulls":4},"2.评审管理","用于存放评审记录及相关材料。","评审通知\n评审检查单及评审总结","R/W","R/W","R","R","R"]
[{"$nulls":4},"3.项目问题管理","用于存放项目问题管理表，及与问题相关的参考资料。","项目问题管理表","R/W","R","R","R","R"]
[{"$nulls":4},"4.变更控制","用于存放变更申请单和变更记录。","变更申请单\n变更管理表","R/W","R","R","RW","R"]
[{"$nulls":4},"5.风险管理","用于存放项目风险跟踪记录等。","项目风险管理表","R/W","R","R","R","R"]
[{"$nulls":4},"6.里程碑报告","用于存放项目里程碑报告。","里程碑报告","R/W","R","R","R","R"]
[{"$nulls":4},"7.度量数据","用于存放项目度量管理表及相关资料。","项目度量数据收集表","R/W","R","R","R","R"]
[null,null,null,"3.项目收尾",null,"用于存放项目总结报告等。","项目总结报告","R/W","R","R","R","R"]
[null,null,null,"4.其他",null,"用于存放项目管理类但不能归类到以上各个目录的文档。","项目状态报告-xxx项目.xlsx\n项目估计表-xxx项目.xlsx\n工作日志.xls","R/W","R/W","R/W","R","R/W"]
[null,null,"2.软件开发"]
[null,null,null,"1.需求开发"]
[{"$nulls":4},"1.客户需求","用于存放客户提供的各种需求文档（包含功能需求、非功能需求以及技术需求等）。","调研记录\n调研报告","R/W","R/W","R/W","R","R"]
[{"$nulls":4},"2.项目需求","用于存放项目组产生的需求相关文档，诸如：用户需求文档、评审记录、客户确认证明等。","需求规格说明书","R/W","R/W","R","R","R"]
[null,null,null,"2.软件设计",null,"用于存放各类设计文档","概要设计说明书\n详细设计说明书\n数据库设计说明书\n模块开发管理表","R/W","R/W","R","R","R"]
[null,null,null,"3.软件实现",null,null,null,"R/W","R/W","R","R","R"]
[{"$nulls":4},"1.编码规范","用于存放项目的编码规范、配合工具使用的编码规范的配置档等。","编码规范"]
[{"$nulls":4},"2.代码检查","用于存放代码走查记录等","自测记录\n单元测试记录"]
[null,null,null,"4.手册",null,"用于存放软件使用手册。","用户手册\n安装部署说明","R/W","R","R","R","R"]
[null,null,null,"5.软件测试",null,null,null,"R/W","R","R/W","R","R"]
[{"$nulls":4},"1.测试案例","用于存放测试案例、测试数据、案例执行记录等。","功能测试用例\n集成测试用例"]
[{"$nulls":4},"2.测试报告","用于测试结果分析、测试报告等。","测试报告"]
[{"$nulls":4},"3.缺陷记录","用于存放代码走查、集成测试、用户验收测试、上线等阶段发现的所有缺陷记录。","缺陷管理表"]
[null,null,null,"6.其他",null,"用于存放软件开发类但不能归类到以上各个目录的文档。客户提供的资料以及研究参考资料。","产品发布说明\n验收报告","R/W","R/W","R/W","R","R/W"]
[null,null,"3.品质保证",null,null,"用于存放品质审计记录等、品质分析报告等。","项目QA检查记录","R","R","R","R","R/W"]
[null,"2.评审区",null,null,null,"存放待评审及评审通过的文档，只有项目经理有修改权限，其他人员只能查看",null,"R/W","R","R","R","R"]
[null,null,"1.待评审",null,null,"用于存放待评审的文档。","待评审的文档"]
[null,null,"2.评审定稿",null,null,"用于存放评审通过，但未纳入极限管理的文档。","评审通过后的文档"]
["2.代码",{"$nulls":4},"代码管理区"]
[null,"1.开发区",null,null,null,"所有开发人员可读写",null,"R/W","R/W","R","R","R"]
[null,null,"1.Trunk",null,null,"用于存放主干代码"]
[null,null,"2.Tag",null,null,"用于存放打标签后的代码"]
[null,null,"3.Branch",null,null,"用于存放分支代码"]
[null,"2.发布区",null,null,null,"用于存放供测试或交付使用的编译程序、支持数据等。仅项目经理有修改权限，其他人员只能查看",null,"R/W","R","R","R","R"]
["3.基线",{"$nulls":4},"用于存放各类基线，仅项目经理有修改权限，其他人员只能查看","基线发布记录\n基线各配置项","R","R","R","RW","R"]
[]
["3 各区域转换机制"]

{"sheet":"基线","index":6,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[19,1,19,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[29,4,29,5],[30,4,30,5],[28,1,28,2],[29,1,29,2],[30,1,30,2],[34,1,34,2],[32,4,32,5],[31,1,31,2],[32,1,32,2],[33,1,33,2],[31,4,31,5],[33,4,33,5],[34,4,34,5],[27,1,27,2],[27,4,27,5],[28,4,28,5],[15,1,15,2],[16,1,16,2],[17,1,17,2],[23,4,23,5],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[24,4,24,5],[25,4,25,5],[26,4,26,5],[18,1,18,2],[20,1,20,2],[8,4,8,6],[0,0,0,10],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[8,0,9,0],[8,1,9,2],[8,3,9,3]]}
["基线计划"]
["1 基线分类"]
["基线名称","内容说明",null,"首次发布时机","作废时机","命名规则"]
["需求基线","将作为后续设计和编码依据的所有需求调研及分析的成果物",null,"全部需求评审通过","设计阶段发布后","需求基线-yyyyMMDD"]
["设计基线","将作为后续编码的指导的需求及设计成果物",null,"所有模块设计完成并评审通过","交付阶段基线发布后","设计基线-yyyyMMDD"]
["交付基线","所有的需求、设计、编码相关成果物以及初验交付产品",null,"初验通过后",null,"交付基线-yyyyMMDD"]
[]
["2 配置项识别"]
["配置项类别","说明",null,"命名规则","所属基线"]
[{"$nulls":4},"需求基线","设计基线","交付基线"]
["项目整体计划","项目整体计划，单个文件",null,"项目整体计划-【项目名称】","√","√","√"]
["调研报告","需求调研后的总结性文档，单个文件",null,"调研报告-【项目名称】","√","√","√"]
["需求文档","需求规格说明书，单个文件",null,"需求规格说明书-【项目名称】","√","√","√"]
["概要设计","概要设计说明书，单个文件",null,"概要设计说明书-【项目名称】",null,"√","√"]
["详细设计","详细设计说明书，单个文件",null,"详细设计说明书-【项目名称】",null,"√","√"]
["测试设计","测试案例设计，及相关测试数据，如有多个文件，打包后作为单一配置项。",null,"测试用例-【项目名称】",null,null,"√"]
["源代码","源代码，打包后作为一个单独的配置项",null,"源代码-【项目名称】",null,null,"√"]
["缺陷清单","缺陷管理表，单一文件",null,"缺陷管理表-【项目名称】",null,null,"√"]
["发布的产品","发布的运行程序及运行环境相关工具。打包后作为单一配置项。",null,"【项目名称】-【版本号】",null,null,"√"]
["技术支持文件","用户手册、安装指南等，每个文件为单独配置项。",null,"用户手册-【项目名称】",null,null,"√"]
["发布说明","发布说明，单一文件",null,"发布说明-【项目名称】-【版本号】",null,null,"√"]
[]
["10.3 基线发布前检查事项"]
["NO.","检查事项",null,"检查人","备注"]
[1,"基线名称是否符合要求？",null,"肖敏"]
[2,"配置项名称是否符合要求？",null,"肖敏"]
[3,"所有文件是否安全无病毒？",null,"肖敏"]
[4,"所有文件是否能正常打开？",null,"肖敏"]
[5,"所有文件是否获取的是正确版本？",null,"肖敏"]
[6,"进入基线库的文档是否通过了评审？",null,"肖敏"]
[7,"进入基线库的代码程序是否经过了测试？",null,"肖敏"]
[8,"所有文件内容是否与需求跟踪管理表描述一致？",null,"肖敏"]
[9,"若是基线更新，是否能找到对应的配置变更记录？",null,"肖敏","检查后记录找到的配置变更记录编号"]
[10,"若是基线更新，对应的配置变更跟踪记录显示当前状态是否是已完成？",null,"肖敏"]
[11,"若是基线更新，配置项内容是否与对应的配置变更跟踪记录的变更结果一致？",null,"肖敏"]
[]
[]
[]
["CCB成员","所有项目变更需经过所有CCB成员一致通过方可生效"]
["施展"]
["肖敏"]
["袁晓冬"]
[]
[]
["基线内容变更处理流程"]
[1,"变更申请人填写变更申请单的“变更说明”及“变更评估”部分，提交至配置管理员"]
[2,"配置管理员将变更申请单提交至CCB进行审核"]
[3,"CCB对变更申请单进行审核，并将审核结果通知配置管理员，配置管理员根据审核结果更新变更管理表"]
[4,"若不通过，本次变更流程终止"]
[5,"若通过，由项目经理安排具体变更活动"]
[6,"变更完成后，由执行人跟新变更申请单跟踪部分的“执行人”、“执行日期”栏位，并通知CCB对变更结果进行审批。"]
[7,"CCB对变更结果确认后更新变更申请单中“执行确认人”、“执行确认时间”栏位，并通知配置管理员。"]
[8,"配置管理员根据执行确认结果更新变更管理表，并更新本次变更受影响基线。"]
[]
["基线发布流程："]
["1、达到整体计划中基线建立的时机，PM通知CM准备建立基线，填写基线发布；"]
["2、CM从工作区取出对应的配置项，放到基线区，填写《基线发布记录》中配置项内容，然后通知PM做检查；"]
["3、PM使用检查单检查基线内容，检查通过后更新《基线发布记录》中的审计记录，并通知CM；"]
["4、CM发布基线"]

{"sheet":"测试计划","index":7,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["项目整体计划"]
["11. 测试"]
["阶段","时间段","主要工作","负责人","参与人","产出物","准入标准","准出标准"]
["测试用例设计","2014/6/11~2014/7/25","1. 整理，评审并修改功能和集成测试用例。\n","肖敏、朱玲","邰淳亮、秦洁","1.功能测试用例和集成测试用例。\n2.评审记录","1.需求评审通过。\n2.业务培训已完成","1.测试用例覆盖全部需求。"]
["第一阶段测试","2014/6/23～2014/6/27","1.执行第一批开发功能的功能测试用例\n2.执行第一批开发功能的集成测试用例\n","肖敏、朱玲","翟越、王晖、秦洁","1.测试用例执行记录\n2.缺陷列表\n3.测试报告","测试版本发布、相关功能测试用例编写及评审通过、集成测试用例编写及评审通过","1.本阶段功能测试用例测试完成\n2.本阶段集成测试用例测试完成\n3.优先级为中以上的缺陷全部修复完毕"]
["系统测试","2014/8/21～2014/8/25","1.执行整体的功能及集成测试用例\n","肖敏、朱玲","翟越、王晖、秦洁","1.测试用例执行记录\n2.缺陷列表\n3.测试报告","测试版本发布、相关功能测试用例编写及评审通过、集成测试用例编写及评审通过","1.本阶段系统测试用例测试完成\n2.优先级为中以上的缺陷全部修复完毕"]
["验收测试","2014/9/22~2013/9/30","1.执行功能测试用例\n2.执行集成测试用例\n3.根据验收标准检查交付物","高洋","第三方测试人员","1.测试用例执行记录\n2.缺陷列表\n3.测试报告","测试版本发布、验收测试用例编写及评审通过","1.测试用例测试完成\n2.所有缺陷全部修复完毕\n3.产品所有功能都全部实现，满足需求说明书的要求。\n4.产品的所有业务流程能够通畅运行。\n5.达到预定的性能要求。"]

{"sheet":"过程定义","index":8,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[48,0,53,0],[48,1,50,2],[51,1,51,2],[52,1,53,2],[7,0,14,0],[7,1,9,2],[10,1,14,2],[15,0,47,0],[15,1,33,1],[22,2,26,2],[27,2,33,2],[34,1,38,2],[39,1,43,2],[45,1,47,2],[15,2,16,2],[17,2,21,2],[5,10,6,10],[5,11,6,11],[5,12,6,12],[4,10,4,12],[4,0,6,0],[4,1,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[44,1,44,2],[0,0,0,9],[4,6,4,7],[4,8,6,8],[4,9,6,9],[5,6,5,7]]}
["过程定义"]
["项目生命周期：","《项目管理章程》","注：项目仅能从组织已定义的生命周期类型中选择，生命周期各阶段的详细定义参见《过程裁剪说明书》"]
["项目规模：","大","注：项目规模定义参见《过程裁剪说明书》"]
[]
["阶段","活动",null,"产出物","组织提供模板","负责人角色","执行要求",null,"裁剪指南","备注","本项目裁剪结果"]
[{"$nulls":6},"瀑布型生命周期",null,null,null,"是否执行","是否使用模板","裁剪说明"]
[{"$nulls":6},"小型项目","大型项目"]
[null,"需求调研",null,"调研记录","否","需求调研及分析人员","可选执行","可选执行","形式不限，无调研活动的项目可不执行。","所有与客户沟通的需求内容均应留下书面记录以备后续分析使用。","是","否"]
[null,null,null,"调研报告","否","需求调研及分析人员","严格执行","严格执行","无固定格式，根据客户要求，及客户理解能力，选择适当形式撰写。",null,"是","否"]
[null,null,null,"确认记录","否","需求调研及分析人员","严格执行","严格执行",null,null,"是","否"]
[null,"项目规划",null,"开工报告","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目估计表","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目整体计划","是","项目经理","严格执行","严格执行",null,null,"是","是","客户要求编写项目章程，其内容包含了项目基本信息、里程碑、风险、沟通相关计划，因此项目整体计划中不在重复规划以上内容。"]
[null,null,null,"项目整体计划评审记录","是","项目经理","严格执行","严格执行","1.中大型项目必须采取会议形式集中评审\n2.大型项目必须邀请至少一位项目组以外的有较多项目管理经验的专家参加",null,"是","是"]
[null,null,null,"项目详细进度计划","是","项目经理","严格执行","严格执行",null,null,"是","是"]
["执行","软件开发","需求分析","需求规格说明书","是","需求调研及分析人员","严格执行","严格执行","1.若系统无交互界面，或客户对交互界面无明确要求，可省略第3部分“主要界面需求”\n2.若系统不存在与其他系统的交互，则可省略第4部分“与其他系统的交互”",null,"是","是"]
[null,null,null,"需求评审记录","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,"系统设计","概要设计说明书","是","技术负责人","严格执行","严格执行","若系统不存在与其他系统的交互，则可省略“外部接口规格”",null,"是","否","使用客户提供的模板"]
[null,null,null,"详细设计说明书","否","技术负责人","可选执行","严格执行",null,null,"是","否"]
[null,null,null,"数据库设计","否","技术负责人","可选执行","可选执行","1.无数据库的系统开发项目可不执行\n2.可与概要设计、详细设计文档合并。",null,"否","否","已在概要设计说明书中加入数据库设计内容。"]
[null,null,null,"设计评审记录","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"模块开发管理表","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,"编码实现","开发环境及测试环境","无","技术负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"编码规范","无","技术负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"源代码","无","开发人员","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"代码自查记录","是","开发人员","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"模块开发管理表","是","测试负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,"测试及缺陷修复","模块开发管理表","是","测试负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"功能测试用例","是","测试人员","简化执行","严格执行","小型项目，功能测试与集成测试用例可合并",null,"是","是"]
[null,null,null,"集成测试用例","是","测试负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"测试版本","是","技术负责人","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"测试用例执行记录","是","测试人员","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"缺陷记录","是","测试人员","严格执行","严格执行","可使用系统平台管理缺陷，但必须包含产出物关键要素",null,"是","否","使用禅道管理系统管理缺陷"]
[null,null,null,"测试报告","是","测试负责人","严格执行","严格执行","大型项目：功能测试阶段及集成测试阶段必须分别编写当前阶段测试报告",null,"是","是"]
[null,"项目监控",null,"详细进度计划","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目状态报告","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目度量管理表","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目风险管理表","是","项目经理","严格执行","严格执行","风险识别频率要求：\n里程碑节点处至少识别一次，若里程碑周期超过3个月，则至少每2个月识别一次。",null,"是","否","使用监理单位提供的的模板"]
[null,null,null,"里程碑总结报告","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,"工作产品管理",null,"基线","无","项目经理","严格执行","严格执行","1.所有项目必须形成需求基线和产品基线\n2.中大型项目必须形成设计基线",null,"是","是"]
[null,null,null,"基线发布记录","是","项目经理","严格执行","严格执行","变更后基线发布，必须填写变更说明，否则克省略。",null,"是","是"]
[null,null,null,"基线发布通知","否","项目经理","严格执行","严格执行","变更后基线发布，必须填写变更说明，否则克省略。",null,"是","是"]
[null,null,null,"变更申请单","是","变更申请人（负责1，2）\n项目经理（负责3，4）","可选执行","可选执行","若项目组发布基线后，基线内的配置项未发生变更，则不需执行",null,"是","是"]
[null,null,null,"变更管理表","是","项目经理","可选执行","可选执行","若项目组无变更申请，则不需执行",null,"是","是"]
[null,"决策分析",null,"决策分析报告","是","项目经理","可选执行","可选执行","项目若有《决策分析指南》中规定的场景，则需要进行决策分析。",null,"是","是","技术框架选型"]
[null,"产品和过程审计",null,"项目QA检查单","是","QA人员","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目QA检查记录","是","QA人员","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"不符合问题管理表","是","QA人员","严格执行","严格执行",null,null,"是","是"]
["收尾","验收",null,"产品发布说明","是","技术负责人","严格执行","严格执行","4，5可单独编写手册",null,"是","是"]
[null,null,null,"客户问题记录","是","项目经理","严格执行","严格执行","可使用系统平台管理缺陷，但必须包含产出物关键要素",null,"是","是"]
[null,null,null,"客户验收证明","否","项目经理","严格执行","严格执行",null,null,"是","否"]
[null,"维护",null,"客户问题记录","是","项目经理","严格执行","严格执行","同验收活动客户问题记录",null,"是","是"]
[null,"项目总结",null,"项目总结报告","是","项目经理","严格执行","严格执行",null,null,"是","是"]
[null,null,null,"项目归档资料","是","项目经理","严格执行","严格执行",null,null,"是","是"]

{"sheet":"度量项定义","index":9,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,11,1,13],[1,0,1,10]]}
["度量项定义"]
["公司度量项定义",{"$nulls":10},"本项目执行"]
["编号","名称","说明","类别","单位","收集方法","数据来源","收集时机","数据存储位置","是否必\n须收集","裁剪指南","是否\n收集","收集\n负责人","备注"]
["M1","里程碑进度偏差率","里程碑实际开始日期与计划完成日期的差距占里程碑计划工期的比例","衍生","⁄","里程碑进度偏差率=(里程碑实际完成日期-里程碑计划完成日期)/(里程碑计划完成日期-里程碑计划开始日期)",null,"里程碑阶段结束","项目度量表","是",null,"是","肖敏"]
["M2","里程碑计划开始日期","里程碑的计划开始日期","基本","⁄","从《项目整体计划》中“里程碑计划”表里，获取当前里程碑阶段的计划开始日期，计算该时间范围包含的工作日天数","项目整体计划","整体计划评审通过或里程碑计划重新修订并评审通过后","项目度量表","是",null,"是","肖敏"]
["M3","里程碑计划完成日期","里程碑的计划完成日期","基本","⁄","从《项目整体计划》中“里程碑计划”表里，获取当前里程碑阶段的计划结束日期","项目整体计划","整体计划评审通过或里程碑计划重新修订并评审通过后","项目度量表","是",null,"是","肖敏"]
["M4","里程碑实际完成日期","里程碑的实际完成日期","基本","⁄","从详细进度及跟踪表中，获取当前里程碑阶段最后一个任务的实际完成时间。","详细进度计划及跟踪表","里程碑阶段结束","项目度量表","是",null,"是","肖敏"]
["M5","需求工作量","需求开发、需求分析工作及相关评审活动的实际消耗工作量","基本","人时","从《详细进度计划及跟踪表》筛选需求开发、需求分析工作及相关评审活动等所有与需求相关的任务，统计这些任务实际工作量的总和","详细进度计划及跟踪表","结项","项目度量表","是",null,"是","肖敏"]
["M6","设计工作量","系统设计、模块设计及相关评审工作的实际消耗工作量","基本","人时","从《详细进度计划及跟踪表》筛选系统设计、模块设计及相关评审工作等所有与设计相关的任务，统计这些任务实际工作量的总和","详细进度计划及跟踪表","结项","项目度量表","是",null,"是","肖敏"]
["M7","实现工作量","编码、代码走查、代码自测、测试设计、测试执行、缺陷追踪等工作的实际消耗工作量","基本","人时","从《详细进度计划及跟踪表》筛选编码、代码走查、代码自测等所有与编码相关的任务，统计这些任务实际工作量的总和","详细进度计划及跟踪表","结项","项目度量表","是",null,"是","肖敏"]
["M8","交付工作量","部署、验收等工作的实际消耗工作量","基本","人时","从《详细进度计划及跟踪表》筛选测试设计、测试执行、缺陷追踪等所有与测试相关的任务，统计这些任务实际工作量的总和","详细进度计划及跟踪表","结项","项目度量表","是",null,"是","肖敏"]
["M9","总工作量","项目截止验收的实际消耗总工作量","基本","人时","统计《详细进度计划及跟踪表》所有验收完成之前任务的实际工作量的总和","详细进度计划及跟踪表","每周及结项","项目度量表","是",null,"是","肖敏"]
["M10","整体生产率","单位时间内创造的产品价值","衍生","行/人时","整体生产率 = 有效代码总行数/总工作量",null,"结项","项目度量表","是",null,"是","肖敏"]
["M11","有效代码总行数","软件代码除注释行及空行以外的总行数","基本","行","使用工具sourcecounter，统计软件所有代码的总行数","源代码","里程碑阶段结束\n结项","项目度量表","是",null,"是","肖敏"]
["M12","编码阶段生产率","单位时间内生产的代码行数","衍生","行/人时","编码阶段生产率 = 有效代码总行数/编码工作量",null,"结项","项目度量表","否","收集整体生产率即可","否","肖敏"]
["M13","测试案例密度","单位代码行对应的测试案例个数","衍生","个/千行代码","测试案例密度 = （测试案例个数/有效代码总行数）*1000",null,"里程碑阶段结束\n结项","项目度量表","是",null,"是","肖敏"]
["M14","测试案例个数","所有测试用例的总和","基本","个","统计所有功能测试用例及集成测试用例个数的总和","功能测试用例\n集成测试用例","里程碑阶段结束\n结项","项目度量表","是",null,"是","肖敏"]
["M15","外部缺陷率","单位代码行数对应的外部缺陷个数","衍生","个/千行代码","外部缺陷率 = （外部缺陷个数/有效代码总行数）*1000",null,"结项","项目度量表","是",null,"是","肖敏"]
["M16","外部缺陷个数","产品交付后客户提出的缺陷个数","基本","个","从产品问题管理表中筛选交付后类型为缺陷的问题","产品问题管理表","结项","项目度量表","是",null,"是","肖敏"]
["M17","内部缺陷个数","产品交付前发现的缺陷","基本","个","从产品问题管理表中筛选交付前类型为缺陷的问题","产品问题管理表","集成测试阶段结束","项目度量表","是",null,"是","肖敏"]
["M18","内部缺陷率","单位代码行数对应的内部缺陷个数","衍生","个/千行代码","内部缺陷率 = （内部缺陷个数/有效代码总行数）*1000",null,"集成测试阶段结束","项目度量表","是",null,"是","肖敏"]
["M19","千行代码测试用例数","单位代码行数对应的测试用例个数","衍生","个/千行代码","千行代码测试用例数 = （测试用例总数/有效代码总行数）*1000",null,"集成测试阶段结束","项目度量表","是",null,"是","肖敏"]
["M20","集成测试用例执行率","已执行集成测试用例占总集成测试用例比率","衍生","/","集成测试用例执行率 = 已执行集成测试用例个数/总集成测试用例个数",null,"集成测试阶段结束","项目度量表","是",null,"是","肖敏"]

{"sheet":"度量目标及分析方法","index":10,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,0,10,0],[6,4,10,4],[6,5,10,5],[6,6,10,6],[0,0,0,6],[2,0,5,0],[2,4,5,4],[2,5,5,5],[2,6,5,6],[20,0,25,0],[20,4,25,4],[20,5,25,5],[20,6,25,6],[11,0,16,0],[11,4,16,4],[11,5,16,5],[11,6,16,6],[17,0,19,0],[17,4,19,4],[17,5,19,5],[17,6,19,6]]}
["度量分析方法"]
["度量目标","《项目管理章程》","度量项","所需基础数据","分析方法","分析结果通报途径","通报对象"]
["1.判断项目进度是否正常","M1","里程碑进度偏差率",null,"里程碑进度偏差率在-10%~10%内，视为正常；\n否则，视为异常，项目经理必须分析偏差原因，并给出应对措施","里程碑报告","项目经理，高层管理者"]
[null,"M2",null,"里程碑计划开始日期"]
[null,"M3",null,"里程碑计划完成日期"]
[null,"M4",null,"里程碑实际完成日期"]
["2.收集项目各类工作的工作量分布，用于新项目的工作量估算","M5","需求工作量",null,"1.项目结项时，计算各类工作的工作量占总工作量的比例。\n2.每年汇总所有结项项目工作量数据，剔除异常项目数据，计算同类型项目各类工作占总工作量占比的平均值。","1.项目总结报告\n2.年度EPG工作总结\n3.估算参考数据表","1.项目经理，高层管理者\n2.高层管理者\n3.项目经理"]
[null,"M6","设计工作量"]
[null,"M7","实现工作量"]
[null,"M8","交付工作量"]
[null,"M9","总工作量"]
["3.了解项目生产率状况，并用于新项目的工作量估算","M10","整体生产率",null,"1.每年汇总所有结项项目生产率数据，提出异常项目数据，计算同类型项目平均生产率；\n2.项目结项时，计算本项目生产率，与公司平均生产率进行比较，如差异较大，则需分析差异原因。","1.项目总结报告\n2.年度EPG工作总结","1.项目经理，高层管理者\n2.高层管理者"]
[null,"M11",null,"代码行数"]
[null,"M9",null,"总工作量"]
[null,"M12","编码阶段生产率"]
[null,"M11",null,"代码行数"]
[null,"M7",null,"编码工作量"]
["4.了解案例数量是否充足","M13","测试案例密度",null,"项目在测试设计结束时，测试案例数量小于公司要求的最低标准，视为不符合要求，必须补足案例数量。","里程碑报告","项目经理，高层管理者"]
[null,"M14",null,"测试案例个数"]
[null,"M11",null,"代码行数"]
["5.了解项目质量状况，判断测试工作的效果及充分性","M15","外部缺陷率",null,"1.每年汇总所有结项项目缺陷率数据，提出异常项目数据，计算同类型项目平均外部缺陷率；\n2.项目结项时，计算本项目内、外部缺陷率，与公司平均缺陷率进行比较，如差异较大，则需分析差异原因；\n3.项目测试阶段中，项目经理依据当前内部缺陷率状况，判断测试工作是否足够有效发现问题，是否已经发现足够多的问题。","1.项目总结报告\n2.年度EPG工作总结\n3.里程碑报告","1.项目经理，高层管理者\n2.高层管理者"]
[null,"M16",null,"外部缺陷个数"]
[null,"M11",null,"代码行数"]
[null,"M17","内部缺陷率"]
[null,"M18",null,"内部缺陷个数"]
[null,"M11",null,"代码行数"]

{"sheet":"项目预算","index":11,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["项目预算"]
["工作量预算（人天）",681]
["人力成本单价（元/人天）",300]
["人工成本（元）",{"$f":"B2*B3","v":204300}]
["差旅（元）",0]
["采购（元）",0]
["通信（元）",0]
["其他（元）",0]
["合计（元）",{"$f":"SUM(B4:B8)","v":204300}]

{"sheet":"附录","index":12,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["附录"]
["1、","《项目管理章程》"]
["2、","《项目估计表》"]