{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["封面","基本信息","技能需求计划","沟通","里程碑","风险","工作环境","质量控制","配置仓库","基线","测试计划","过程定义","度量项定义","度量目标及分析方法","项目预算","附录"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":18,"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":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":10}
[null,"变更记录",{"$nulls":5},"配置项状态记录"]
[null,"版本号","更新内容","作者","审批人","审批时间",null,"状态"]
[null,"V0.1","初稿","高才驰",null,null,null,"已入基线"]
[null,"V1.0","评审通过","高才驰","施展","2014-02-25"]

{"sheet":"基本信息","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,3],[22,5,22,6],[19,1,19,3],[19,5,19,6],[20,1,20,3],[20,5,20,6],[21,1,21,3],[21,5,21,6],[11,3,11,6],[14,1,14,2],[15,1,15,2],[18,1,18,3],[18,5,18,6],[10,3,10,6],[0,0,0,6],[1,0,1,6],[2,1,2,2],[2,4,2,6],[3,1,3,2],[3,4,3,6],[4,1,4,2],[4,4,4,6],[7,3,7,6],[8,3,8,6],[9,3,9,6]]}
["基本信息"]
["1. 概要"]
["项目编号","CJSD",null,"项目名称","南京长江隧道管养信息系统"]
["客户名称","南京长江隧道有限责任公司",null,"项目经理","高才驰"]
["计划开始时间","2014-02-20",null,"计划结束时间","2014-10-31"]
[]
["2.  关键人员"]
["姓名","类别","角色","对项目的影响"]
["孙晶晶","客户","验收负责人","项目需求的主要提供者，负责对项目最终成果进行组织验收，直接决定项目成败。"]
["施展","内部人员","项目主管","项目的汇报对象，为项目提供资源，协助项目解决重大问题，也是潜在的项目需求提出者，可能影响项目范围和实施进展。"]
["高才驰","内部人员","项目经理","项目实施负责人，控制项目质量、成本和进度。"]
[]
[]
["3.关键资源"]
["资源名称","说明"]
["巡点检终端仪器","系统需要通过巡点检终端仪器采集数据。"]
[]
["4. 交付物清单"]
["NO.","交付物名称",null,null,"要求交付时间","交付要求"]
[1,"系统安装包",null,null,"2014-07-31","可正常部署运行、所有功能需求都被满足"]
[2,"产品发布说明",null,null,"2014-07-31","完整部署流程、按照说明可正常部署"]
[3,"系统使用说明书",null,null,"2014-07-31","带图文的所有功能的使用说明"]
[4,"源代码",null,null,"2014-07-31","所有已知缺陷都被修复"]

{"sheet":"技能需求计划","index":2,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[34,2,34,3],[26,2,26,3],[29,2,29,3],[30,2,30,3],[34,4,34,5],[33,4,33,5],[30,4,30,5],[29,4,29,5],[26,4,26,5],[33,2,33,3],[27,4,27,5],[31,2,31,3],[31,4,31,5],[14,3,14,4],[14,5,14,6],[14,8,14,9],[15,3,15,4],[15,5,15,6],[15,8,15,9],[0,0,0,9],[2,0,3,0],[2,1,3,1],[2,2,3,5],[2,6,3,6],[2,7,2,9],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[13,3,13,4],[13,5,13,6],[13,8,13,9],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,11,7],[12,3,12,4],[12,5,12,6],[11,8,12,9],[19,3,19,4],[19,5,19,6],[18,3,18,4],[18,5,18,6],[18,8,18,9],[19,8,19,9],[16,3,16,4],[16,5,16,6],[16,8,16,9],[17,3,17,4],[17,5,17,6],[17,8,17,9],[24,4,24,5],[24,2,24,3],[20,3,20,4],[20,5,20,6],[20,8,20,9],[21,3,21,4],[21,5,21,6],[21,8,21,9]]}
["技能需求计划"]
["1.技能需求计划"]
["NO.","角色","职责",null,null,null,"人数","能力要求",null,null,"备注"]
[{"$nulls":7},"技术掌握程度","业务熟悉程度","公司规范掌握程度"]
[1,"后台编码","负责项目开发编码、需求分析、模块设计",null,null,null,4,"熟练J2EE开发，熟悉图表展示插件,熟悉solr等常用的搜索引擎","熟悉隧道设施设备盘点规则，评价，熟悉数据展示流程","熟悉公司工作制度、熟悉编码规范"]
[2,"前台","负责页面设计、美工工作",null,null,null,2,"熟练页面效果图的制作、PhotoShop使用熟练，熟悉html、css、js",null,"熟悉公司工作制度、熟悉编码规范"]
[4,"需求调研人员","需求分析",null,null,null,1,"沟通能力好，熟悉excel,熟悉学科分类业务流程","熟悉隧道设施设备盘点规则，评价，熟悉数据展示流程","熟悉公司工作制度"]
[5,"PM","负责项目管理、项目设计、系统开发、配置管理、风险管理、需求分析、模块设计",null,null,null,1,"有项目管理经验，精通J2ee、html、数据库","熟悉隧道设施设备盘点规则，评价，熟悉数据展示流程","熟悉公司工作制度"]
[6,"测试","测试设计、测试执行",null,null,null,1,"沟通能力里强，理解用户需求，熟悉测试用例方法，熟悉junit等测试工具的使用","熟悉隧道设施设备盘点规则，评价，熟悉数据展示流程","熟悉公司工作制度"]
[]
["2.人员技能现状"]
["NO.","姓名","角色","能力满足度",{"$nulls":4},"备注"]
[null,null,null,"技术",null,"业务",null,"公司规范"]
[1,"高才驰","PM，需求调研人员","满足",null,"满足",null,"满足"]
[2,"马英虎","前台，后台编码","满足",null,"满足",null,"满足"]
[3,"孙强","后台编码，需求调研，测试","满足",null,"solr不熟悉，java熟练",null,"满足"]
[4,"陈飞","后台编码","满足",null,"solr不熟悉，java熟练",null,"满足"]
[5,"戴鹏飞","需求调研人员","满足",null,"满足",null,"满足"]
[6,"张雁飞","需求调研人员","满足",null,"满足",null,"满足"]
[7,"潘虎","前台","满足",null,"满足",null,"满足"]
[8,"殷萍","测试","满足",null,"业务流程不够熟悉",null,"满足"]
[9,"王晓勇","需求调研人员、后台编码","满足",null,"业务非常熟悉，满足",null,"满足"]
[]
["3. 培训计划"]
["NO.","培训内容","讲师",null,"参加人",null,"时间","目标","备注"]
["技术培训"]
[1,"搜索引擎","高才驰",null,"马英虎、潘虎、孙强",null,"2014-04-30","掌握业务数据如何迁移至搜索引擎"]
[2,"安卓开发","肖常衍",null,"马英虎、潘虎、孙强、陈飞",null,"2014-05-26","熟悉安卓APP的开发过程"]
["业务培训"]
[1,"隧道设施设备编码规则","李红卫、王晓勇",null,"高才驰、马英虎、孙强、陈飞、潘虎",null,"2014-03-24","熟悉隧道内的各种类型设备，盘点规则，能够独立采集并编码设施设备"]
[2,"设施设备巡检规则","王晓勇",null,"高才驰、马英虎、孙强、陈飞、潘虎",null,"2014-04-21","将盘点后的设备对照养护规范编制巡检规则"]
[3,"设施设备盘点后复核","李红卫、王晓勇",null,"高才驰、马英虎、孙强、陈飞、潘虎",null,"2014-04-21","通过对照档案资料、cad图纸复核设备"]
["过程相关培训"]

{"sheet":"沟通","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["沟通计划"]
["1. 外部沟通计划"]
["NO","沟通内容","沟通方式","日期","项目方负责人","外部接口人"]
[1,"沟通需求","电话，邮件，会议","2014/2/26~2014/4/10","高才驰","孙晶晶"]
[2,"确认需求","会议","2014-04-10","高才驰","孙晶晶"]
[]
["2. 内部沟通计划"]
["NO","沟通方式","沟通内容","时间","负责人","参与人"]
[1,"项目例会","项目进展情况，前阶段工作总结，后阶段工作分配。\n里程碑达成后的第一次例会，需针对里程碑阶段工作进行相关总结讨论。","每两周一次","高才驰","项目经理、所有组员"]
[]
["3. 报告"]
["NO","报告名称","报告内容","报告时间","负责人","报告发送对象"]
[1,"里程碑报告","项目里程碑检讨报告","里程碑","高才驰","施展"]
[2,"总结报告","结项经验总结报告","项目结项","高才驰","施展"]

{"sheet":"里程碑","index":4,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["里程碑计划"]
["ID","里程碑名称","主要工作","工作产出","计划达成时间","备注"]
[1,"需求及设计里程碑","需求调研\n需求分析\n需求评审\n系统设计\n设计评审","调研记录\n需求规格说明书\n需求评审记录\n概要设计说明书\n设计评审记录\n模块开发管理表","2014-04-25"]
[2,"开发里程碑","编码\n测试","代码\n自测记录\n系统测试记录\n用户手册","2014-07-25"]
[3,"交付里程碑","系统部署\n系统验收","系统正式发布版\n验收报告","2014-08-15"]

{"sheet":"风险","index":5,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,0,13,12],[14,0,14,12],[11,0,11,12],[0,0,0,10]]}
["风险管理计划"]
["1、风险分析方法"]
["风险等级定义及分析方法参加公司的《风险管理指南》"]
[]
["2、应对策略选择原则："]
["数字","应对策略优先级"]
[1,"避免-->转移-->缓解"]
[2,"避免-->缓解-->转移"]
[3,"避免-->缓解-->转移"]
[4,"避免-->缓解-->转移"]
[]
["3、风险识别及跟踪时间频率："]
["每个里程碑做一次风险识别，每两周至少进行一次风险跟踪"]
[]
["4、风险管理负责人："]
["高才驰"]

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

{"sheet":"质量控制","index":7,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,6],[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,"发现的缺陷完全解决可以通过；或由项目经理负责评估"]
["源代码","自查","验证","开发走查",null,"发现的缺陷完全解决可以通过；或由项目经理负责评估"]
["发布测试版程序","模块测试","验证","由研发开发小组和测试人员执行黑盒测试 ",null,"检出足够的缺陷且解决后方能通过；或由项目负责人对其评估，并对其负责"]
[null,"集成测试","验证","由研发开发小组和测试人员执行黑盒测试 ",null,"检出足够的缺陷且解决后方能通过；或由项目负责人对其评估，并对其负责"]
["发布正式程序","验收测试","确认","由第三方专业测试人员执行全面测试并出具报告 ",null,"第三方测试报告结论是通过"]
["交付部署文档","实验","确认","安排小组外人员根据文档部署和使用软件产品",null,"能够成功部署并使用系统功能"]

{"sheet":"配置仓库","index":8,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,1,9,4],[0,0,0,11],[1,0,1,7],[2,0,2,2],[2,3,2,11],[3,0,3,2],[3,3,3,11],[4,0,4,2],[4,3,4,11],[6,0,6,7],[7,0,7,4],[8,0,8,4],[35,3,35,4],[10,2,10,4],[11,3,11,4],[12,3,12,4],[20,3,20,4],[21,3,21,4],[22,2,22,4],[23,3,23,4],[26,3,26,4],[27,3,27,4],[30,3,30,4],[31,3,31,4],[44,2,44,4],[45,1,45,4],[46,0,46,4],[48,0,48,7],[36,2,36,4],[37,1,37,4],[40,0,40,4],[41,1,41,4],[42,2,42,4],[43,2,43,4]]}
["配置仓库"]
["1 基本信息"]
["管理工具",null,null,"使用SVN管理。项目资料统一存储在公司SVN服务器上，客户端使用TSVN1.7"]
["访问地址",null,null,"https://192.168.30.100/svn/projects/cjsd"]
["维护负责人",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"]
[]
["9.3 各区域转换机制"]

{"sheet":"基线","index":9,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[8,0,9,0],[8,1,9,2],[8,3,9,3],[8,4,8,6],[0,0,0,10],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[25,1,25,2],[25,4,25,5],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[22,1,22,2],[22,4,22,5],[23,1,23,2],[23,4,23,5],[24,1,24,2],[24,4,24,5],[26,1,26,2],[26,4,26,5],[27,1,27,2],[27,4,27,5],[28,1,28,2],[28,4,28,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,4,33,5],[29,1,29,2],[29,4,29,5],[30,1,30,2],[30,4,30,5],[31,1,31,2],[31,4,31,5]]}
["基线计划"]
["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,"√"]
[]
["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":10,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["测试计划"]
["阶段","时间段","主要工作","负责人","参与人","产出物","准入标准","准出标准"]
["测试用例设计","2014/05/19~2014/05/30","1. 整理，评审并修改模块和集成测试用例。\n","高才驰","马英虎，殷萍","1.模块测试用例和集成测试用例。\n2.评审记录","1.需求评审通过。2.设施管理、巡检维护功能完成\n3.试验方业务培训已完成","1.每千行代码必须设计至少35个测试用例。\n2.测试用例覆盖设备设施巡检需求。"]
["第一阶段测试","2014/06/11～2014/07/01","1.执行数据收集模块测试用例\n2.执行数据收集集成测试用例\n","高才驰","孙强、马英虎","1测试用例执行记录\n2.缺陷列表\n3.测试报告 4.发布测试版本","测试版本发布、相关模块测试用例编写及评审通过、集成测试用例编写及评审通过","1.本阶段模块测试用例测试完成\n2.本阶段集成测试用例测试完成\n3.优先级为中以上的缺陷全部修复完毕"]
["第二阶段测试","2014/07/4～2014/07/21","1.执行第一阶段测试后的模块测试\n2.执行第一阶段测试后的集成测试用例\n","高才驰","孙强、马英虎、殷萍","1测试用例执行记录\n2.缺陷列表\n3.测试报告 4.发布试运行版本","测试版本发布、相关模块测试用例编写及评审通过、集成测试用例编写及评审通过","1.本阶段模块测试用例测试完成\n2.本阶段集成测试用例测试完成\n3.优先级为中以上的缺陷全部修复完毕"]
["验收测试","2013/08/4~2014/08/14","依据实际运行的要求组织测试，形成试运行版本","高才驰、孙晶晶（业主方）","江苏省信息安全测评中心（www.jnlab.com）","1测试用例执行记录\n2.缺陷列表\n3.测试报告","试运行版本发布、集成测试用例编写及评审通过","第三方测试报告结论为通过"]

{"sheet":"过程定义","index":11,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[7,0,14,0],[7,1,9,2],[10,1,14,2],[0,0,0,9],[4,0,6,0],[4,1,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[4,6,4,7],[4,8,6,8],[4,9,6,9],[4,10,4,12],[5,6,5,7],[5,10,6,10],[5,11,6,11],[5,12,6,12],[48,0,53,0],[48,1,50,2],[51,1,51,2],[52,1,53,2],[15,0,47,0],[15,1,33,1],[15,2,16,2],[17,2,21,2],[22,2,26,2],[27,2,33,2],[34,1,38,2],[39,1,43,2],[44,1,44,2],[45,1,47,2]]}
["过程定义"]
["项目生命周期：","瀑布型","注：项目仅能从组织已定义的生命周期类型中选择，生命周期各阶段的详细定义参见《过程裁剪说明书》"]
["项目规模：","小","注：项目规模定义参见《过程裁剪说明书》"]
[]
["阶段","活动",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":12,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,10],[1,11,1,13]]}
["度量项定义"]
["公司度量项定义",{"$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":13,"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":14,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["项目预算"]
["工作量预算（人天）",540]
["人力成本单价（元/人天）",300]
["人工成本（元）",{"$f":"B2*B3","v":162000}]
["差旅（元）",0]
["采购（元）",0]
["通信（元）",0]
["其他（元）",0]
["合计（元）",{"$f":"SUM(B4:B8)","v":162000}]

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