{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["作业进度一览","孙总及林工审查内容(2022-11-09)","额外作业"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"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":141,"n_cols":13,"rows_kept":141,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,10,0,11],[71,3,71,4],[72,3,72,4],[73,3,73,4]]}
[{"$nulls":7},{"$f":"\"总：\"&SUM(H3:H184)&\"人日\"&\" = \"&ROUND(SUM(H3:H184)/20,2)&\"人月\"","v":"总：887人日 = 44.35人月"},null,null,{"$f":"\"完成：\"&ROUND((SUM(H3:H69)-SUM(L3:L69))/SUM(H3:H69),4)*100&\"%\"","v":"完成：67.17%"}]
[null,"No","功能模块","画面名","表示方式","主要功能点","优先级","工作量","责任者","计划期限","进度","剩余工作量","后续作业内内容（20220927记入）"]
[null,{"$f":"ROW()-2","v":1},"0.共通部分","系统框架相关",null,"开发过程中设计Metis2.0相关问题调研、沟通、确认、改修、调试等工作","低",10,"全体","2022-12-30",1,{"$f":"H3*(1-K3)","v":0}]
[null,null,null,"清洁度立项审批报告",{"$nulls":4},"王新贺","2022-04-30",1,0]
[null,null,null,"项目初期启动会议",{"$nulls":4},"全体","2022/4/25-2022/4/30",1,0]
[null,{"$f":"ROW()-2","v":4},null,"数据库设计相关","-","数据调整","低",5,"全体","2022-12-30",1,0]
[null,{"$f":"ROW()-2","v":5},null,"需求确认及对应","-","与林斌沟通、确认及调整","低",15,"沙永刚","2022-12-30",1,0]
[null,null,null,"清洁度进展现状预定的会议",{"$nulls":4},"全体","2022-05-12",1,0]
[null,{"$f":"ROW()-2","v":7},null,"信息提示画面","弹出","通用提示框：信息、警告、错误","高",2,"沙永刚","2022-06-30",1,{"$f":"H9*(1-K9)","v":0}]
[null,8,null,"操作确认画面","弹出","提示用户确认或者取消","高",1,"沙永刚","2022-06-30",1,0]
[null,9,null,"系统初始化处理","-",null,"高",3,"王琦","2022-05-30",1,0]
[null,10,"1.检测分析","检测画面","工作区","添加菜单、图标、按钮、动作迁移（处理空）","高",2,"王琦","2022-05-30",0.85,0.30000000000000004]
[null,11,null,"规程选择画面","弹出","列出所有规程，初始选择登录用户默认规程","中",2,"沙永刚","2022-07-30",0.85,0.30000000000000004]
[null,12,null,"滤膜工位选择画面","弹出","1.所选工位信息执行过程全局存储设计","中",2,"王琦","2022-10-30",0.8,0.39999999999999991,"①6个工位改为2个工位（注意位置）\n②未在硬件设备上调试"]
[null,13,null,"滤膜信息输入画面","弹出","1.根据规程设置参数，动态生成该信息画面，有一定难度\n2.考虑多滤膜/单滤膜场合，画面表示差异\n3.录入信息存储设计(后续扫描、统计分析、生成报告均需要这些信息)","高",5,"王琦","2022-10-30",0.6,2,"①图片保存位置需要可调整\n②需要结合规程设置调试验证"]
[null,14,null,"拼图进度展示画面","弹出","1.读取规程所有设置相关参数\n2.根据规程设置的拼图进行扫描拍照\n3.根据规程设置的相机设置，进行拍照（曝光、白平衡、阴影矫正等设置）\n4.根据规程设置的自动聚焦方式，进行自动聚焦处理（自动聚焦需要验证，聚焦补偿需要算法实现）\n5.涉及相关硬件控制：载物台、Z轴自动聚焦、相机拍照、偏光镜控制\n6.根据扫描进度，画面更新处理\n7.两遍扫描完成后，需要完成拼图处理\n8.拼图后，需要根据规程设置的分析区域，及参数设置，进行颗粒识别、分类、测量\n9.根据规程的分级设置，对测量结果进行分级统计分析\n10.需要对拼接后大图进行再拆分处理，并进行物理存储（不保存拼接大图及颗粒小图）","高",50,"王琦","2022-12-30",0.55000000000000004,22.499999999999996,"\n①数据统计算法需要持续优化\n②数据库存储速度需要确认及优化\n③多测试多滤膜（多滤膜可二期进行）\n④需要对应新台子修改与调试（新台子代码开发中）\n⑤圆形拼图扫描修改及调试验证\n⑥台子结合扫描、拼图、测量后的精度待严重"]
[null,15,null,null,null,"拼图进度展示画面，涉及图像相关处理：\n1.拼图：6*7,19*23，？\n2.测量：\n   ·最大卡规直径（FeretMax） \n   ·最小卡规直径（FeretMin） \n   ·拉伸长度（StretchLengh） \n   ·外接矩形长（BoundingRectLength）\n   ·外界矩形宽（BoundingRectWidth） \n   ·长宽比（AspectRatio） \n   ·等效圆直径（ECD） \n   ·内切圆直径（MaxInscribeCircle） \n   ·面积（Area） \n   ·最大灰度（GrayMax）\n   ·平均灰度（GrayMean）\n   ·颗粒所在图片左侧距离（ParticleBoundImageLeft）\n   ·颗粒所在图片上侧距离（ParticleBoundImageTop）\n   ·颗粒所在图片上的宽度（ParticleBoundImageWidth）\n   ·颗粒所在图片上的高度（ParticleBoundImageHeight）\n3.轮廓：需要给出颗粒轮廓信息，以便系统显示或不显示颗粒轮廓\n4.图片分割：颗粒图片切割、大图拆分切割",null,60,"宋学奎","2022-08-30",0.75,15,"①拼图后有时有缝隙及拼接痕迹有些明显\n②第2遍拼接的明场图片要确保和第1遍拼接的偏光未完全重合(颗粒位置)\n③测量性能需要持续后续优化验证"]
[null,null,"review-bug","拼图和阴影校正再优化","发现人","王新贺",null,null,"宋学奎","2022/11/21---2022/11/30",0,null,"拼图错位、有缝，拼图后必须看不到那个拼缝，拼完之后再做完阴影校正，让人感觉像一个大的视场图一样，看不到每个小块，现在的图是：每块能看得见，这种是不行的。"]
[null,{"$f":"ROW()-2","v":17},null,null,null,"自动聚焦：逐点自动聚焦及间隔数点自动聚焦","低",3,"沙永刚","2022-11-30",0.45,{"$f":"H19*(1-K19)","v":1.6500000000000001},"①有参照代码，本系统暂未实现"]
[null,{"$f":"ROW()-2","v":18},null,null,null,"聚焦补偿：根据数个焦点位置确定多个空间平面，不同xy位置交于空间平面的z位置，即判定并计算为焦平面位置","低",5,"沙永刚","2022-11-30",0.5,{"$f":"H20*(1-K20)","v":2.5},"①有参照代码，本系统暂未实现"]
[null,{"$f":"ROW()-2","v":19},null,"颗粒编辑窗口","弹出","1.可改变颗粒类型、可切换图片为偏光或明场图片\n2.可对图片中颗粒进行添加、删除、切割、连接处理\n3.需要可对操作进行返回、重做、复原处理、可显示原图或编辑图\n4.可重新自动测量计算分析该视场相关颗粒数据","中",25,"王琦","2022-11-30",0.7,{"$f":"H21*(1-K21)","v":7.5000000000000009},"\n①多个颗粒展示图片慢。\n②颗粒编辑后，不要直径统计分析，需点击重新计算按钮"]
[null,{"$f":"ROW()-2","v":20},null,null,null,"颗粒编辑窗口，涉及相关图像处理：\n1.添加颗粒：手动操作，画轮廓添加（相关测量如何计算？）\n2.删除颗粒：手动操作，框在范围内的部分删除\n3.分割颗粒：手动操作，在框的范围内分割为两个颗粒\n4.连接颗粒：手动操作，在框的范围内拟合连接成一个颗粒","中",14,"洪冰","2022-08-30",0.8,{"$f":"H22*(1-K22)","v":2.7999999999999994},"①林工认为部分操作不友好，后续有定论再研究"]
[null,null,null," 清洁度预定的会议",{"$nulls":4},"全体","2022-09-22",null,1]
[null,{"$f":"ROW()-2","v":22},null,"实时预览画面","弹出","1.需要调研在Metis2.0上修改方法(或复制新的预览画面修改）\n2.主要添加偏光明场切换处理、拍照替换图片、实时测量并保存图片处理","高",10,"王琦","2022-10-30",0.7,{"$f":"H24*(1-K24)","v":3.0000000000000004},"①需要可以根据选择不同颗粒，动态定位颗粒\n②需要预览窗口在最上边\n③需要实现照片替换功能（涉及处理较多，二期实现）"]
[null,23,null,"高度测量画面","弹出","1.需要参照Metis2.0的预览画面修改\n2.主要添加确定焦平面的处理","中",5,"王琦","2022-11-30",0.7,1.5000000000000002,"①需要待新硬件开发完成后，重新修改和调试\n②确认更新高度值（画面和数据库）"]
[null,24,null,"存档确认画面","弹出","1.着重考虑数据存储设计","中",2,"王琦","2022-12-30",0.8,0.39999999999999991,"①需要添加提示框，确认\n②存档后，变为查看模式，编辑等相关相关修改不可用"]
[null,25,null,"检测结果画面","工作区","1.自动分析后，自动打开结果画面并从数据库读取相关分析结果数据\n2.画面复杂度高，展示分为分级模式和图库模式\n3.工具栏命令对展示区的控制实现：如各种筛选过滤、排序、导入导出报告等操作\n4.柱状图实现、图片缩略图一览实现\n5.根据报告模板生成报告文档（报告文件格式？）宋珊珊","高",30,"王琦","2022-12-30",0.8,5.9999999999999982,"\n①测量不同数量的展示时间需要优化\n②分级模式界面优化。\n③图库模式加拉伸长度列\n④图库模式增加最大灰度、平均灰度及灰度差值展示"]
[null,26,"2.项目管理","项目浏览画面","工作区","1.从数据库中读取历史检测项目并展示","中",6,"宋珊珊","2022-12-30",0.8,1.1999999999999997,"①增加刷新按钮。\n②右侧展示与分级模式统一共用一个画面\n③合并的项目展示：右侧展示区右上角需要有数据源连接可查看"]
[null,27,null,"项目合并画面","弹出","1.需要列出可以合并的项目\n2.项目合并处理，并生成新的项目","低",5,"沙永刚","2022-11-30",0.8,0.99999999999999978,"①相关数据合并处理\n②相关数据统计分级处理及展示\n③哪些项目可以合并未实现"]
[null,28,"3.规程管理","规程浏览设置画面","工作区","画面作成：\n1.每个Tab设置内容均需要配置文件进行保存\n2.画面复杂度高，可检索及修改规程，分为多个Tab页设定","高",5,"沙永刚","2022-06-30",0.8,0.99999999999999978]
[null,29,null,null,null,"基本信息画面","高",1,"沙永刚","2022-06-30",0.85,0.15000000000000002]
[null,30,null,null,null,"图片来源：本地图片、项目图库、相机扫描","高",20,"沙永刚","2022-11-30",0.8,3.9999999999999991,"①检测时，项目来源本地图片及项目图库时，需要提供交互窗口"]
[null,31,null,null,null,"信息模板画面","高",12,"沙永刚","2022-07-30",0.8,2.3999999999999995]
[null,32,null,null,null,"执行流程画面：测量区域、物相提取","高",20,"沙永刚","2022-12-30",0.8,3.9999999999999991,"①明场偏光灰度差判定应为或模式\n②阈值设定性能优化，目前单视场\n③碎屑删除系统内置最小值5（但需要有后门配置文件）"]
[null,33,null,null,null,"参数设置画面","高",10,"沙永刚","2022-10-30",0.8,1.9999999999999996,"①明场偏光灰度差判定应为或模式"]
[null,34,null,null,null,"分级设置画面","高",10,"沙永刚","2022-12-30",0.8,1.9999999999999996,"①需要根据标准ISO4406、ISO4407、ISO16232、VDA19.2作成对应内置规程设置（标准分级资料林斌提供）"]
[null,35,null,null,null,"报告模板设置画面","高",1,"沙永刚","2022-10-30",0.8,0.19999999999999996,"①该画面中选择报告模板需要确认是否有必要保留（目前出报告时会有预览画面，可选择不同模板进行预览）"]
[null,36,null,null,null,"浏览画面：规程新建、克隆、导入、导出","高",15,"沙永刚","2022-12-30",0.8,2.9999999999999991,"①规程导入功能、导出未实现\n②需要删除新建功能、增加内置系统规程"]
[null,37,null,"分析范围交互画面","弹出","扫描途中，弹出交互画面，展示拼图后滤膜，让用户设定滤膜分析范围","高",20,"沙永刚","2022-10-30",0.8,3.9999999999999991,"①分析范围交互画面"]
[null,38,null,"拼图设置画面","弹出","1.根据设置参数，动态展示拼图区域预览（背景滤膜轮廓信息）\n2.能实时看到拼图区域所在滤膜位置\n3.能通过鼠标在预览区控制拼图范围位置","高",20,"沙永刚","2022-12-30",0.7,6.0000000000000009,"①行列不准确，需要调研"]
[null,39,null,"标签选择画面","弹出","1.需要考虑系统内置标签，如客户信息、零部件信息等\n2.需要考虑系统没有的标签，作为新标签，以便输出报表可识别\n3.相关数据库设计重点考虑","中",5,"沙永刚","2022-10-30",0.8,0.99999999999999978]
[2,40,null,"清洁度编码设置画面","弹出","1.检测分析后，进行分级统计时，需要用到该画面设置的信息","中",2,"沙永刚","2022-10-30",0.8,0.39999999999999991]
[null,null,null,"清洁度会议",{"$nulls":4},"全体","2022-11-09",1,0]
[null,{"$f":"ROW()-2","v":42},"4.报告模板","报告模板母版设计（单滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",10,"宋珊珊","2022-10-30",0.9,{"$f":"H44*(1-K44)","v":0.99999999999999978},"①需要使用归一化参数\n②追加清洁度编码"]
[null,43,null,"报告模板母版设计（合并滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",8,"宋珊珊","2022-10-30",0.9,0.79999999999999982,"①需要显示多张滤膜概图\n②颗粒图片获取需要重新实现"]
[null,44,null,"报告模板编辑画面","弹出","1.重点是如何关联报表设计器并为清洁度设计报告模板\n2.检测分析后，相关数据如何传给报表模板，并生成报表\n3.需要支持图片（数量动态）、表格（数据动态），树状图，固定信息等\n4.结合项目检测结果输出报告（Metis2.0报告预览画面）","中",30,"宋珊珊","2022-10-30",1,0]
[null,45,"5.系统设置","系统设置菜单","工作区","1.添加菜单、图标、按钮、动作迁移（弹出空画面）","高",2,"宋珊珊","2022-10-30",0.85,0.30000000000000004]
[null,46,null,"常规设置画面","弹出","1.先期只实现日志输出控制，语言及主题先期只有默认（不可选）\n2.日志组件实现\n3.检测结果默认显示设置","高",3,"王新贺","2023-01-13",0.85,0.45000000000000007]
[null,47,null,"存储设置画面","弹出","1.先期只实现本地存储设置，服务器存储只做UI，后续再实现功能","中",1,"沙永刚","2022-10-30",0.8,0.19999999999999996]
[null,48,null,"磁盘清理功能","弹出","1.跳转到需要清理的磁盘目录\n2.通过画面设定清理范围，点击清理按钮，自动完成清理工作","中",1,"沙永刚","2022-12-30",0.8,0.19999999999999996,"①本期实现跳转到需要清理的磁盘目录"]
[null,49,null,"用户信息画面","弹出","1.实现及存储参照Metis2.0","中",3,"沙永刚","2022-10-30",0.8,0.59999999999999987]
[null,50,null,"标尺管理画面","弹出","1.实现及存储参照Metis2.0\n2.但需要将标尺一览的Dock窗口变为Dialog形式\n3.需要改造标尺一览画面：增加样式设定按钮","中",3,"宋珊珊","2022-10-30",1,0]
[null,51,null,"新建标尺画面","弹出","1.实现及存储参照Metis2.0","中",1,"宋珊珊","2022-10-30",1,0]
[null,52,null,"标尺样式画面","弹出","新作成清洁度专用样式设定画面","中",5,"宋珊珊","2022-10-30",0.8,0.99999999999999978,"①考虑自己制作界面进行标尺等颜色设置（自定义文件）。\n②去掉原菜单中的标尺设置按钮。"]
[null,53,null,"快捷键设置画面","弹出","设置功能快捷键","低",1,"宋珊珊","2022-10-30",0.6,0.4,"①目前设定后，部分功能未调用\n②画面只需要列出清洁度相关菜单，其他不需要，如不能实现可去除该画面"]
[null,54,null,"测量设置画面","弹出","1.实现及存储参照Metis2.0，如要调查测量时如何使用","中",1,"宋珊珊","2022-10-30",1,0]
[null,55,null,"聚焦参数设置","弹出","1.实现及存储参照Metis2.0","低",1,"宋珊珊","2022-10-30",1,0]
[null,56,null,"相机设置画面","弹出","1.实现及存储参照Metis2.0\n2.但需要考虑相机设置方案条目的实现（可创建多个条目供选择使用，如偏光的，明场的）","高",20,"王琦","2022-12-30",0.7,6.0000000000000009,"①目前问题：Metis中阴影矫正功能只能设置一次，不能保存。\n②若采用新型相机，相关设置需要重新调试（不包含开发新相机底层代码工作）"]
[null,57,null,"载物台设置画面","弹出","新型载物台（永新载物台）开发","高",30,"王琦","2022-11-30",0.6,12,"①新型显微镜载物台底层开发"]
[null,58,null,"电机参数设置画面","弹出","1.结合新型载物台实现相关接口","中",10,"王琦","2022-11-30",0.8,1.9999999999999996,"①新型显微镜载物台底层开发"]
[null,59,null,"物镜及光源设定画面","弹出","永新显微镜相关设置画面实现","中",3,"宋珊珊","2022-10-30",1,0,"暂定不需要该界面"]
[null,60,null,"客户管理画面","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.9,0.19999999999999996]
[null,61,null,"零部件管理","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.9,0.19999999999999996]
[null,62,null,"操作者管理画面","弹出","1.重点关注数据库存储设计","低",3,"王新贺","2022-10-30",0.9,0.29999999999999993]
[null,63,null,"权限管理画面","弹出","1.重点关注数据库存储设计","低",1,"王新贺","2022-10-30",0.9,9.9999999999999978E-2]
[null,64,"6.帮助","帮助目录画面","弹出","1.帮助文档","低",15,"王新贺","2023-01-13",0.22,11.700000000000001]
[null,65,null,"关于画面","弹出","1.固定信息","低",1,"王新贺","2022-12-30",0.8,0.19999999999999996]
[null,66,"单体测试","功能测试、异常系测试、连台联调测试",null,null,"高",40,"全体开发者","2023-02-28",0,40]
[null,67,"结合测试","功能测试、软件稳定性、准确性及性能测试",null,null,"高",30,"杨欣瑜\n开发者对应","2023-02-28",0,30]
[]
[]
[null,null,"会议","清洁度会议"]
[null,null,"时间","2022/11/09 14:00-16:30"]
[null,null,"人员","孙总、王新贺、林斌、刘洪冰、宋珊珊、沙永刚、王琦"]
[null,null,"No","模块","内容","结论","区分","优先级","责任者","状态"]
[null,null,1,"全体","主工作区中的窗口，在较小屏幕（如笔记本）部分项目表示不全","画面使用滚动条","问题","中","宋珊珊"]
[null,null,2,"规程设置","规程设置-图片来源：倍率列表中选择项目应该系统标尺下的所有倍率","倍率选择删除，只保留标尺即可，因为标尺决定分辨率并关联了倍率","改善","中","沙永刚","完成"]
[null,null,3,"规程设置","规程设置-图片来源：阴影矫正选项中不要空选项","删除空项","问题","中","沙永刚","完成"]
[null,null,4,"规程设置\n项目管理","规程浏览、项目浏览加右键快捷菜单功能","需要追加","改善","中","宋珊珊"]
[null,null,5,"检测","检测结果-图库模式/分级模式的Grid需要可手动改变列宽","需要修改，无特殊要求的都需要按此展开修改","改善","中","宋珊珊"]
[null,null,6,"检测","提供颗粒参看功能（类似编辑画面）","提供查看模式，两种实现方式：一种是单独做个查看画面，可以缩放，囊括更多范围；另一种是在编辑画面，提供查看模式（不可编辑只可参看），编辑画面需提供缩放，以便囊括更多范围\n\n目前考虑，第二种方式","新需求","中","沙永刚"]
[null,null,7,"检测","提供拼接后大图查看功能（可放大查看细节），参照av的评估图","加分项，需要增加该功能，参照av实现，难点是大图加载性能问题","新需求","低",null,"二期"]
[null,null,8,"检测","颗粒图库显示颗粒数量一多，出结果的时候卡在数据处理\n\n关于颗粒图片，如图库浏览、颗粒编辑、报告颗粒图片，都是使用时拼接大图实时切割下来的，优点是切割幅度可以随意设定和动态调整，这种方式是否可以？\n另一个种是保存所有颗粒切割图，使用时直接使用该图，缺点是：一次检测会占用更多磁盘空间（可能30万颗粒的小图），切割幅度不能随意调整（调整重新从大图切割保存），\n\n是否需要在图库模式的缩略图和颗粒信息列表中显示所有颗粒：目前看显示所有会有性能问题，如显示30万颗粒","保持现状：不保存颗粒小图，需要时从大图实时切割颗粒小图；不需要在页面显示所有颗粒；\n\n但需要进行以下优化和修改：（图库模式性能优化相关）\n1.当切割图片超过一定限值时，进行压缩切割\n2.提供分页功能：每页可设定展示较少数量图片，分页显示","改善","高","王琦"]
[null,null,9,"规程设置","规程设置-拼图设置：选择聚焦补偿的聚焦点数时，需要在右侧预览区域标记聚焦点位置","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,10,"全体","所有画面的ComboBox控件下拉框的宽度需要修改","要修改，全部画面展开检查","问题","中","沙永刚","完成"]
[null,null,11,"规程设置","规程设置-执行流程-物相提取：\n两个阈值场合，不同阈值识别的轮廓需要用不同颜色轮廓标识","现状OK","-","-","-","-"]
[null,null,12,"系统设置","物镜转盘设定：需要可动态设置增删改查倍率（不应让客户手动修改配置文件）","要修改，可手动设定倍率，而不仅仅是从下拉框选择\n设定物镜转盘后，其他有倍率选择画面，其倍率选择项目需要从物镜转盘内容中读取","改善","低","宋珊珊"]
[null,null,13,"设置","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","现状OK。可通过点击：设置-磁盘清理，跳转到图片存储目录，可手动清空（图片缓存区位置可由用户进行设置指定）","-","-","-","-"]
[null,null,13,"报告","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","缓存区图片被清空后，不能图库模式查看图片，不可以出报告。\n报告需要修改：可参照图库模式，当对应图片不存在是，提示图库被清除，不能出报告信息（参照点击图库模式按钮处理）","问题","高","宋珊珊"]
[null,null,14,"规程设置\n检测","物相提取这里还是不能交互，无法根据实际情况调整提取阈值","要修改，提供检测时用户的交互设定阈值功能，难点是大图加载","新需求","高","沙永刚"]
[null,null,15,"规程设置\n检测","物相提取增加吸管功能","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,16,"检测","颗粒分割这里点击完成以后处理速度很慢；\n\n更改类型还是每改一个类型更新全部，重新计算功能没有起到作用；","需要修改：（编辑与重新计算相关）\n\n更改类型处理类似现状的编辑颗粒，每更改一个类型，就重新进行全部统计分析。该处理需要对应：更改后，不立即全部更新，而是重新计算后统一更新","改善","高","王琦"]
[null,null,18,"检测","有些颗粒连接分割不上","现状OK。连接不上可能是一下两种情况：\n1.同时选定连接范围的颗粒数量大于或等于3个了（一次连接操作只可连接两个颗粒，超过时不进行处理）；\n2.选定需要连接的颗粒中不包含当前颗粒（编辑画面只允许编辑当前颗粒，连接的颗粒必须包含当前颗粒）；","-","-","-","-"]
[null,null,18,"检测","分割和连接，点击使用有时不起作用，需要再次点击一次按钮；有时候点击后切割不起作用，换不同位置反复测试，有时候就可以分割，有时不能分割","需要调查和修改","问题","高","刘洪冰"]
[null,null,19,"报告","这个版本点生成报告没反应","新版本OK","-","-","-","-"]
[null,null,20,"规程设置","相机扫描跟本地图片规程是否考虑可以合并","需要合并，大分支节点只有用户规程和系统规程区分","改善","中","沙永刚","完成"]
[null,null,21,"规程设置\n检测","各级分析结果通过与否是跟哪个数据比对","现状OK。根据规程设置-分级设置中指定【允许数量使用的归一化参数】一致","-","-","-","-"]
[null,null,22,"规程设置\n检测","关于归一化参数选择需要可设定","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,23,"检测","没有某一颗粒不参与计算的选项","需要修改：只需在进行全部类型统计时，不参与计算的类型不参与全部类型的统计分析运算，但不参与全部类型计算的类型，自己的相关测量数据，及图库展示正常，与现状一致；另外全部类型的滤膜覆盖率包含不参与计算的颗粒类型","问题","高","沙永刚","完成"]
[null,null,24,"检测","图库模式，提供Grid列头点击排序（图库要联动）","因为分页设计到数据库重新检索问题，画面UI中统一为不可点击Grid列头排序","改善","中","王琦"]
[null,null,25,"算法","测试压缩前后对比数据，得出数据","需要对比测试","改善","低","沙永刚"]
[null,null,26,"全体","多次测量分析等操作后，内存是否释放","需要优化分析，如有问题需要进行改善","改善","中","王新贺"]
[]
[]
[null,null,"额外工作",{"$nulls":4},{"$f":"SUM(H107:H137)","v":126}]
[null,null,"No","项目","内容","担当","月份","工作量(人日)"]
[null,null,1,"矿研院","高倍(500X)扫描自动聚焦调研、调试、优化","沙永刚",5,3]
[null,null,2,"矿研院","聚焦补偿算法调研、实现、验证、优化","沙永刚",5,8]
[null,null,3,"Metis2.0","自动聚焦及聚焦补偿实现及调试","沙永刚",5,2]
[null,null,4,"Metis2.0","M3H样品台既存问题修改","沙永刚",5,1]
[null,null,5,"Metis2.0","相机和样品台问题测试","王琦",5,5]
[null,null,6,"PCB手动测量","需求分析、制定开发计划，出差深圳","宋珊珊","5月",11]
[null,null,7,"自动PCB接口","需求分析，源代码了解","宋珊珊","5月",1.5]
[null,null,8,"Metis2.0","自动景深扩展问题调查","沙永刚",6,1]
[null,null,9,"PCB手动测量","多方案制定及功能点补充及细化","宋珊珊","6月",5]
[null,null,10,"自动PCB接口","接口需求确认、方案设计、功能开发、测试、现场调试、用户培训","宋珊珊","6月",8.5]
[null,null,11,"Metis2.0","需求优化、Bug修改","宋珊珊","7月",6.5]
[null,null,12,"Metis2.0","载物台一定速度调查优化","沙永刚",7,3]
[null,null,13,"Metis2.0","专业分析-不锈钢α相面积测量","沙永刚",8,3]
[null,null,14,"Metis2.0","自动分析-夹杂物、晶粒度、带状组织报告功能","宋珊珊",8,6]
[null,null,15,"朗铎自动化","现场配合测试、软件问题修改和相关文档的编写","王琦",7,5]
[null,null,16,"朗铎自动化","动态库的生成和使用说明书的编写","王琦","8月",2]
[null,null,17,"永新样品台","根据相关命令编写测试Demo程序和简单测试","王琦","8月",5]
[null,null,18,"煤岩","熟悉煤岩软件代码。与光镜工程师学习软件使用。","王琦","8月",3]
[null,null,19,"Metis2.0","框架中Menu及Tab切换改修","沙永刚",9,1]
[null,null,20,"Metis2.0","需求优化、Bug修改","沙永刚",9,2]
[null,null,21,"永新样品台","根据Metis2.0相关规则开发永新样品台接口。","王琦",9,8]
[null,null,22,"永新样品台","开发永新样品台接口程序","王琦","10月",10]
[null,null,23,"拍照","拍照测试","王琦","10月",5]
[null,null,24,"永新样品台","硬件联调，加拍照拼图等测试。","王琦","11月",5]
[null,null,25,"朗铎自动化","CLI接口测试及相关会议讨论等。","王琦","11月",3]
[null,null,26,"Metis2.0","AI中增加自动分析通用报告功能","宋珊珊","9月",1]
[null,null,27,"自动切片","Office导出报告异常等问题处理、去掉公司相关信息等","宋珊珊","9月",2]
[null,null,28,"裂变项目","了解裂变项目相关资料","宋珊珊","9月",2]
[null,null,29,"铝合金报告","需求调研、工作量评估、模板制作","宋珊珊","10月",3.5]
[null,null,30,"铝合金报告","数据源设定、报告调试、打印样式调试","宋珊珊","11月",3.5]
[null,null,31,"裂变项目会议","裂变项目现有功能演示及与老师进行确认","宋珊珊","11月",0.5]
[null,null,32,"Metis2.0","增加新的晶粒度报告模板","宋珊珊","11月",0.5]
[null,null,33,"宽动态摄像机之事","宽动态摄像机对接光镜李明与王琦","王新贺",9,0.5]
[null,null,34,"煤岩项目","录制贾工讲解煤岩操作视频","王新贺","8月",1]
[null,null,35,"机械手项目",null,"王新贺","11月",3]

{"sheet":"孙总及林工审查内容(2022-11-09)","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3]]}
[]
[null,"会议","清洁度会议"]
[null,"时间","2022/11/09 14:00-16:30"]
[null,"人员","孙总、王新贺、林斌、刘洪冰、宋珊珊、沙永刚、王琦"]
[null,"No","模块","内容","结论","区分","优先级","责任者","状态"]
[null,1,"全体","主工作区中的窗口，在较小屏幕（如笔记本）部分项目表示不全","画面使用滚动条","问题","中","宋珊珊"]
[null,2,"规程设置","规程设置-图片来源：倍率列表中选择项目应该系统标尺下的所有倍率","倍率选择删除，只保留标尺即可，因为标尺决定分辨率并关联了倍率","改善","中","沙永刚","完成"]
[null,3,"规程设置","规程设置-图片来源：阴影矫正选项中不要空选项","删除空项","问题","中","沙永刚","完成"]
[null,4,"规程设置\n项目管理","规程浏览、项目浏览加右键快捷菜单功能","需要追加","改善","中","宋珊珊"]
[null,5,"检测","检测结果-图库模式/分级模式的Grid需要可手动改变列宽","需要修改，无特殊要求的都需要按此展开修改","改善","中","宋珊珊"]
[null,6,"检测","提供颗粒参看功能（类似编辑画面）","提供查看模式，两种实现方式：一种是单独做个查看画面，可以缩放，囊括更多范围；另一种是在编辑画面，提供查看模式（不可编辑只可参看），编辑画面需提供缩放，以便囊括更多范围\n\n目前考虑，第二种方式","新需求","中","沙永刚","完成"]
[null,7,"检测","提供拼接后大图查看功能（可放大查看细节），参照av的评估图","加分项，需要增加该功能，参照av实现，难点是大图加载性能问题","新需求","低",null,"二期"]
[null,8,"检测","颗粒图库显示颗粒数量一多，出结果的时候卡在数据处理\n\n关于颗粒图片，如图库浏览、颗粒编辑、报告颗粒图片，都是使用时拼接大图实时切割下来的，优点是切割幅度可以随意设定和动态调整，这种方式是否可以？\n另一个种是保存所有颗粒切割图，使用时直接使用该图，缺点是：一次检测会占用更多磁盘空间（可能30万颗粒的小图），切割幅度不能随意调整（调整重新从大图切割保存），\n\n是否需要在图库模式的缩略图和颗粒信息列表中显示所有颗粒：目前看显示所有会有性能问题，如显示30万颗粒","保持现状：不保存颗粒小图，需要时从大图实时切割颗粒小图；不需要在页面显示所有颗粒；\n\n但需要进行以下优化和修改：（图库模式性能优化相关）\n1.当切割图片超过一定限值时，进行压缩切割\n2.提供分页功能：每页可设定展示较少数量图片，分页显示","改善","高","王琦"]
[null,9,"规程设置","规程设置-拼图设置：选择聚焦补偿的聚焦点数时，需要在右侧预览区域标记聚焦点位置","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,10,"全体","所有画面的ComboBox控件下拉框的宽度需要修改","要修改，全部画面展开检查","问题","中","沙永刚","完成"]
[null,11,"规程设置","规程设置-执行流程-物相提取：\n两个阈值场合，不同阈值识别的轮廓需要用不同颜色轮廓标识","现状OK","-","-","-","-"]
[null,12,"系统设置","物镜转盘设定：需要可动态设置增删改查倍率（不应让客户手动修改配置文件）","要修改，可手动设定倍率，而不仅仅是从下拉框选择\n设定物镜转盘后，其他有倍率选择画面，其倍率选择项目需要从物镜转盘内容中读取","改善","低","宋珊珊"]
[null,13,"设置","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","现状OK。可通过点击：设置-磁盘清理，跳转到图片存储目录，可手动清空（图片缓存区位置可由用户进行设置指定）","-","-","-","-"]
[null,13,"报告","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","缓存区图片被清空后，不能图库模式查看图片，不可以出报告。\n报告需要修改：可参照图库模式，当对应图片不存在是，提示图库被清除，不能出报告信息（参照点击图库模式按钮处理）","问题","高","宋珊珊"]
[null,14,"规程设置\n检测","物相提取这里还是不能交互，无法根据实际情况调整提取阈值","要修改，提供检测时用户的交互设定阈值功能，难点是大图加载","新需求","高","沙永刚","开发中"]
[null,15,"规程设置\n检测","物相提取增加吸管功能","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,16,"检测","颗粒分割这里点击完成以后处理速度很慢；\n\n更改类型还是每改一个类型更新全部，重新计算功能没有起到作用；","需要修改：（编辑与重新计算相关）\n\n更改类型处理类似现状的编辑颗粒，每更改一个类型，就重新进行全部统计分析。该处理需要对应：更改后，不立即全部更新，而是重新计算后统一更新","改善","高","王琦"]
[null,18,"检测","有些颗粒连接分割不上","现状OK。连接不上可能是一下两种情况：\n1.同时选定连接范围的颗粒数量大于或等于3个了（一次连接操作只可连接两个颗粒，超过时不进行处理）；\n2.选定需要连接的颗粒中不包含当前颗粒（编辑画面只允许编辑当前颗粒，连接的颗粒必须包含当前颗粒）；","-","-","-","-"]
[null,18,"检测","分割和连接，点击使用有时不起作用，需要再次点击一次按钮；有时候点击后切割不起作用，换不同位置反复测试，有时候就可以分割，有时不能分割","需要调查和修改","问题","高","刘洪冰"]
[null,19,"报告","这个版本点生成报告没反应","新版本OK","-","-","-","-"]
[null,20,"规程设置","相机扫描跟本地图片规程是否考虑可以合并","需要合并，大分支节点只有用户规程和系统规程区分","改善","中","沙永刚","完成"]
[null,21,"规程设置\n检测","各级分析结果通过与否是跟哪个数据比对","现状OK。根据规程设置-分级设置中指定【允许数量使用的归一化参数】一致","-","-","-","-"]
[null,22,"规程设置\n检测","关于归一化参数选择需要可设定","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,23,"检测","没有某一颗粒不参与计算的选项","需要修改：只需在进行全部类型统计时，不参与计算的类型不参与全部类型的统计分析运算，但不参与全部类型计算的类型，自己的相关测量数据，及图库展示正常，与现状一致；另外全部类型的滤膜覆盖率包含不参与计算的颗粒类型","问题","高","沙永刚","完成"]
[null,24,"检测","图库模式，提供Grid列头点击排序（图库要联动）","因为分页设计到数据库重新检索问题，画面UI中统一为不可点击Grid列头排序","改善","中","王琦"]
[null,25,"算法","测试压缩前后对比数据，得出数据","需要对比测试","改善","低","沙永刚"]
[null,26,"全体","多次测量分析等操作后，内存是否释放","需要优化分析，如有问题需要进行改善","改善","中","王新贺"]

{"sheet":"额外作业","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":6},{"$f":"SUM(G3:G33)","v":126}]
[null,"No","项目","内容","担当","月份","工作量(人日)"]
[null,1,"矿研院","高倍(500X)扫描自动聚焦调研、调试、优化","沙永刚",5,3]
[null,2,"矿研院","聚焦补偿算法调研、实现、验证、优化","沙永刚",5,8]
[null,3,"Metis2.0","自动聚焦及聚焦补偿实现及调试","沙永刚",5,2]
[null,4,"Metis2.0","M3H样品台既存问题修改","沙永刚",5,1]
[null,5,"Metis2.0","相机和样品台问题测试","王琦",5,5]
[null,6,"PCB手动测量","需求分析、制定开发计划，出差深圳","宋珊珊","5月",11]
[null,7,"自动PCB接口","需求分析，源代码了解","宋珊珊","5月",1.5]
[null,8,"Metis2.0","自动景深扩展问题调查","沙永刚",6,1]
[null,9,"PCB手动测量","多方案制定及功能点补充及细化","宋珊珊","6月",5]
[null,10,"自动PCB接口","接口需求确认、方案设计、功能开发、测试、现场调试、用户培训","宋珊珊","6月",8.5]
[null,11,"Metis2.0","需求优化、Bug修改","宋珊珊","7月",6.5]
[null,12,"Metis2.0","载物台一定速度调查优化","沙永刚",7,3]
[null,13,"Metis2.0","专业分析-不锈钢α相面积测量","沙永刚",8,3]
[null,14,"Metis2.0","自动分析-夹杂物、晶粒度、带状组织报告功能","宋珊珊",8,6]
[null,15,"朗铎自动化","现场配合测试、软件问题修改和相关文档的编写","王琦",7,5]
[null,16,"朗铎自动化","动态库的生成和使用说明书的编写","王琦","8月",2]
[null,17,"永新样品台","根据相关命令编写测试Demo程序和简单测试","王琦","8月",5]
[null,18,"煤岩","熟悉煤岩软件代码。与光镜工程师学习软件使用。","王琦","8月",3]
[null,19,"Metis2.0","框架中Menu及Tab切换改修","沙永刚",9,1]
[null,20,"Metis2.0","需求优化、Bug修改","沙永刚",9,2]
[null,21,"永新样品台","根据Metis2.0相关规则开发永新样品台接口。","王琦",9,8]
[null,22,"永新样品台","开发永新样品台接口程序","王琦","10月",10]
[null,23,"拍照","拍照测试","王琦","10月",5]
[null,24,"永新样品台","硬件联调，加拍照拼图等测试。","王琦","11月",5]
[null,25,"朗铎自动化","CLI接口测试及相关会议讨论等。","王琦","11月",3]
[null,26,"Metis2.0","AI中增加自动分析通用报告功能","宋珊珊","9月",1]
[null,27,"自动切片","Office导出报告异常等问题处理、去掉公司相关信息等","宋珊珊","9月",2]
[null,28,"裂变项目","了解裂变项目相关资料","宋珊珊","9月",2]
[null,29,"铝合金报告","需求调研、工作量评估、模板制作","宋珊珊","10月",3.5]
[null,30,"铝合金报告","数据源设定、报告调试、打印样式调试","宋珊珊","11月",3.5]
[null,31,"裂变项目会议","裂变项目现有功能演示及与老师进行确认","宋珊珊","11月",0.5]
[null,32,"Metis2.0","增加新的晶粒度报告模板","宋珊珊","11月",0.5]
[null,33,"宽动态摄像机之事","宽动态摄像机对接光镜李明与王琦","王新贺",9,0.5]
[null,34,"煤岩项目","录制贾工讲解煤岩操作视频","王新贺","8月",1]
[null,35,"机械手项目","锻锤-锤断铁块后传送带到位置后，机械手识别扫描等等","王新贺","11月",4]