{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["作业进度一览","孙总及林工审查内容(2022-11-09)","额外作业","宋珊珊审核修改","王琦审核修改修改","沙永刚审核修改","王新贺审核修改","王琦2022年12月工作计划","宋珊珊2022年12月工作计划","王新贺2022年12月工作计划"],"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":192,"n_cols":13,"rows_kept":192,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,10,0,11],[162,4,162,5],[163,4,163,5]]}
[{"$nulls":7},{"$f":"\"总：\"&SUM(H3:H163)&\"人日\"&\" = \"&ROUND(SUM(H3:H163)/20,2)&\"人月\"","v":"总：891.1人日 = 44.56人月"},null,null,{"$f":"\"完成：\"&ROUND((SUM(H3:H92)-SUM(L3:L92))/SUM(H3:H92),4)*100&\"%\"","v":"完成：72.24%"}]
[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,0]
[null,{"$f":"ROW()-2","v":8},null,"操作确认画面","弹出","提示用户确认或者取消","高",1,"沙永刚","2022-06-30",1,0]
[null,{"$f":"ROW()-2","v":9},null,"系统初始化处理","-",null,"高",3,"王琦","2022-05-30",1,0]
[null,{"$f":"ROW()-2","v":10},"1.检测分析","检测画面","工作区","添加菜单、图标、按钮、动作迁移（处理空）","高",2,"王琦","2022-05-30",1,0]
[null,{"$f":"ROW()-2","v":11},null,"规程选择画面","弹出","列出所有规程，初始选择登录用户默认规程","中",2,"沙永刚","2022-07-30",0.85,0.3]
[null,null,"优化","梳理检测分析业务逻辑，完成检测模块测试书",{"$nulls":4},"宋珊珊","2022/12/5---2022/12/6",1]
[null,{"$f":"ROW()-2","v":13},null,"滤膜工位选择画面","弹出","1.所选工位信息执行过程全局存储设计","中",2,"王琦","2022-10-30",0.95,{"$f":"H15*(1-K15)","v":0.1},"①6个工位改为2个工位（注意位置）\n②未在硬件设备上调试\n③多滤膜暂时放到二期。"]
[null,{"$f":"ROW()-2","v":14},null,"滤膜信息输入画面","弹出","1.根据规程设置参数，动态生成该信息画面，有一定难度\n2.考虑多滤膜/单滤膜场合，画面表示差异\n3.录入信息存储设计(后续扫描、统计分析、生成报告均需要这些信息)","高",5,"王琦","2022-10-30",0.85,{"$f":"H16*(1-K16)","v":0.75},"①图片保存位置需要可调整\n②需要结合规程设置调试验证"]
[null,{"$f":"ROW()-2","v":15},null,"拼图进度展示画面","弹出","1.读取规程所有设置相关参数\n2.根据规程设置的拼图进行扫描拍照\n3.根据规程设置的相机设置，进行拍照（曝光、白平衡、阴影矫正等设置）\n4.根据规程设置的自动聚焦方式，进行自动聚焦处理（自动聚焦需要验证，聚焦补偿需要算法实现）\n5.涉及相关硬件控制：载物台、Z轴自动聚焦、相机拍照、偏光镜控制\n6.根据扫描进度，画面更新处理\n7.两遍扫描完成后，需要完成拼图处理\n8.拼图后，需要根据规程设置的分析区域，及参数设置，进行颗粒识别、分类、测量\n9.根据规程的分级设置，对测量结果进行分级统计分析\n10.需要对拼接后大图进行再拆分处理，并进行物理存储（不保存拼接大图及颗粒小图）","高",50,"王琦","2022-12-30",0.7,{"$f":"H17*(1-K17)","v":15},"\n①数据统计算法需要持续优化\n②数据库存储速度需要确认及优化\n③多测试多滤膜（多滤膜可二期进行）\n④需要对应新台子修改与调试（新台子代码开发中）\n⑤圆形拼图扫描修改及调试验证\n⑥台子结合扫描、拼图、测量后的精度待严重"]
[null,{"$f":"ROW()-2","v":16},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,{"$f":"H18*(1-K18)","v":15},"①拼图后有时有缝隙及拼接痕迹有些明显\n②第2遍拼接的明场图片要确保和第1遍拼接的偏光未完全重合(颗粒位置)\n③测量性能需要持续后续优化验证"]
[null,null,null,"优化",null,"宋部长计划16号将拼图程序发布一个新版本，收到版本程序后进行程序调试和测试，如果还有问题继续与宋部长沟通改正问题。",null,null,"王琦","2022/12/19---2022/12/30"]
[null,null,"review-bug","拼图和阴影校正再优化         发现者","发现人","王新贺",null,null,"宋学奎","2022/11/21---2022/12/16",1,null,"拼图错位、有缝，拼图后必须看不到那个拼缝，拼完之后再做完阴影校正，让人感觉像一个大的视场图一样，看不到每个小块，现在的图是：每块能看得见，这种是不行的。"]
[null,{"$f":"ROW()-2","v":19},null,null,null,"自动聚焦：逐点自动聚焦及间隔数点自动聚焦","低",3,"沙永刚","2022-11-30",0.7,{"$f":"H21*(1-K21)","v":0.9},"①有参照代码，本系统暂未实现"]
[null,null,null,"优化",null,"自动聚焦、聚焦补偿程序测试，问题修正。",null,null,"王琦","2022/12/5---2022/12/9",1]
[null,{"$f":"ROW()-2","v":21},null,null,null,"聚焦补偿：根据数个焦点位置确定多个空间平面，不同xy位置交于空间平面的z位置，即判定并计算为焦平面位置","低",5,"沙永刚","2022-11-30",0.7,{"$f":"H23*(1-K23)","v":1.5},"①有参照代码，本系统暂未实现"]
[null,{"$f":"ROW()-2","v":22},null,"颗粒编辑窗口","弹出","1.可改变颗粒类型、可切换图片为偏光或明场图片\n2.可对图片中颗粒进行添加、删除、切割、连接处理\n3.需要可对操作进行返回、重做、复原处理、可显示原图或编辑图\n4.可重新自动测量计算分析该视场相关颗粒数据","中",25,"王琦","2022-11-30",0.8,{"$f":"H24*(1-K24)","v":5},"①多个颗粒展示图片慢。\n②颗粒编辑后，不要直径统计分析，需点击重新计算按钮"]
[null,null,null,"优化",null,"颗粒定位（实时预览时，将样品台移动到颗粒位置）。",null,null,"王琦","2022/12/8---2022/12/9",1]
[null,{"$f":"ROW()-2","v":24},null,null,null,"颗粒编辑窗口，涉及相关图像处理：\n1.添加颗粒：手动操作，画轮廓添加（相关测量如何计算？）\n2.删除颗粒：手动操作，框在范围内的部分删除\n3.分割颗粒：手动操作，在框的范围内分割为两个颗粒\n4.连接颗粒：手动操作，在框的范围内拟合连接成一个颗粒","中",14,"洪冰","2022-08-30",0.85,{"$f":"H26*(1-K26)","v":2.1},"①林工认为部分操作不友好，后续有定论再研究"]
[null,null,null,"优化",null,"颗粒编辑后，重新计算报错问题跟踪和解决。",null,null,"王琦","2022/12/14---2022/12/16",1]
[null,{"$f":"ROW()-2","v":26},null,"实时预览画面","弹出","1.需要调研在Metis2.0上修改方法(或复制新的预览画面修改）\n2.主要添加偏光明场切换处理、拍照替换图片、实时测量并保存图片处理","高",10,"王琦","2022-10-30",0.8,{"$f":"H28*(1-K28)","v":2},"①需要可以根据选择不同颗粒，动态定位颗粒\n②需要预览窗口在最上边\n③需要实现照片替换功能（涉及处理较多，二期实现）"]
[null,27,null,"高度测量画面","弹出","1.需要参照Metis2.0的预览画面修改\n2.主要添加确定焦平面的处理","中",5,"王琦","2022-11-30",0.9,0.5,"①需要待新硬件开发完成后，重新修改和调试\n②确认更新高度值（画面和数据库）"]
[null,28,null,"存档确认画面","弹出","1.着重考虑数据存储设计","中",2,"王琦","2022-12-30",0.8,0.4,"①需要添加提示框，确认\n②存档后，变为查看模式，编辑等相关相关修改不可用"]
[null,29,null,"检测结果画面","工作区","1.自动分析后，自动打开结果画面并从数据库读取相关分析结果数据\n2.画面复杂度高，展示分为分级模式和图库模式\n3.工具栏命令对展示区的控制实现：如各种筛选过滤、排序、导入导出报告等操作\n4.柱状图实现、图片缩略图一览实现\n5.根据报告模板生成报告文档（报告文件格式？）宋珊珊","高",30,"王琦","2022-12-30",0.8,6,"\n①测量不同数量的展示时间需要优化\n②分级模式界面优化。\n③图库模式加拉伸长度列\n④图库模式增加最大灰度、平均灰度及灰度差值展示"]
[null,30,"2.项目管理","项目浏览画面","工作区","1.从数据库中读取历史检测项目并展示","中",6,"宋珊珊","2022-12-30",0.85,0.9,"①增加刷新按钮。\n②右侧展示与分级模式统一共用一个画面\n③合并的项目展示：右侧展示区右上角需要有数据源连接可查看"]
[null,31,null,"项目合并画面","弹出","1.需要列出可以合并的项目\n2.项目合并处理，并生成新的项目","低",5,"沙永刚","2022-11-30",0.8,1,"①相关数据合并处理\n②相关数据统计分级处理及展示\n③哪些项目可以合并未实现"]
[null,null,null,"优化",null,"项目文件中涉及使用规程处理方式调研",null,null,"宋珊珊","2022/12/13---2022/12/13",1]
[null,null,null,"优化",null,"项目浏览、标尺样式、快捷键设置等功能的剩余编码工作",null,null,"宋珊珊","2022/12/14---2022/12/18",1]
[null,{"$f":"ROW()-2","v":34},"3.规程管理","规程浏览设置画面","工作区","画面作成：\n1.每个Tab设置内容均需要配置文件进行保存\n2.画面复杂度高，可检索及修改规程，分为多个Tab页设定","高",5,"沙永刚","2022-06-30",0.85,{"$f":"H36*(1-K36)","v":0.75}]
[null,{"$f":"ROW()-2","v":35},null,null,null,"基本信息画面","高",1,"沙永刚","2022-06-30",0.85,{"$f":"H37*(1-K37)","v":0.15}]
[null,{"$f":"ROW()-2","v":36},null,null,null,"图片来源：本地图片、项目图库、相机扫描","高",20,"沙永刚","2022-11-30",0.8,{"$f":"H38*(1-K38)","v":4},"①检测时，项目来源本地图片及项目图库时，需要提供交互窗口"]
[null,{"$f":"ROW()-2","v":37},null,null,null,"信息模板画面","高",12,"沙永刚","2022-07-30",0.8,{"$f":"H39*(1-K39)","v":2.4}]
[null,{"$f":"ROW()-2","v":38},null,null,null,"执行流程画面：测量区域、物相提取","高",20,"沙永刚","2022-12-30",0.8,{"$f":"H40*(1-K40)","v":4},"①明场偏光灰度差判定应为或模式\n②阈值设定性能优化，目前单视场\n③碎屑删除系统内置最小值5（但需要有后门配置文件）"]
[null,null,null,"优化",null,"检测时的范围设定及物相提取处理方式调研",null,null,"宋珊珊","2022/12/12---2022/12/12",1]
[null,null,null,"优化",null,"物相提取等大界面需要优化",null,null,"宋珊珊","2022/12/19---2022/12/20"]
[null,{"$f":"ROW()-2","v":41},null,null,null,"参数设置画面","高",10,"沙永刚","2022-10-30",0.8,{"$f":"H43*(1-K43)","v":2},"①明场偏光灰度差判定应为或模式"]
[null,null,null,"优化",null,"修改规程切换时不保存设置参数问题。",null,null,"王琦","2022/12/12---2022/12/14",1]
[null,{"$f":"ROW()-2","v":43},null,null,null,"分级设置画面","高",10,"沙永刚","2022-12-30",0.8,{"$f":"H45*(1-K45)","v":2},"①需要根据标准ISO4406、ISO4407、ISO16232、VDA19.2作成对应内置规程设置（标准分级资料林斌提供）"]
[null,{"$f":"ROW()-2","v":44},null,null,null,"报告模板设置画面","高",1,"沙永刚","2022-10-30",0.8,{"$f":"H46*(1-K46)","v":0.2},"①该画面中选择报告模板需要确认是否有必要保留（目前出报告时会有预览画面，可选择不同模板进行预览）"]
[null,{"$f":"ROW()-2","v":45},null,null,null,"浏览画面：规程新建、克隆、导入、导出","高",15,"沙永刚","2022-12-30",0.8,{"$f":"H47*(1-K47)","v":3},"①规程导入功能、导出未实现\n②需要删除新建功能、增加内置系统规程"]
[null,null,null,"优化",null,"查找规程更改后，点击标尺标定报错问题。",null,null,"王琦","2022/12/13---2022/12/15",1]
[null,{"$f":"ROW()-2","v":47},null,"分析范围交互画面","弹出","扫描途中，弹出交互画面，展示拼图后滤膜，让用户设定滤膜分析范围","高",20,"沙永刚","2022-10-30",0.8,{"$f":"H49*(1-K49)","v":4},"①分析范围交互画面"]
[null,{"$f":"ROW()-2","v":48},null,"拼图设置画面","弹出","1.根据设置参数，动态展示拼图区域预览（背景滤膜轮廓信息）\n2.能实时看到拼图区域所在滤膜位置\n3.能通过鼠标在预览区控制拼图范围位置","高",20,"沙永刚","2022-12-30",0.73,{"$f":"H50*(1-K50)","v":5.4},"①行列不准确，需要调研"]
[null,{"$f":"ROW()-2","v":49},null,"标签选择画面","弹出","1.需要考虑系统内置标签，如客户信息、零部件信息等\n2.需要考虑系统没有的标签，作为新标签，以便输出报表可识别\n3.相关数据库设计重点考虑","中",5,"沙永刚","2022-10-30",0.8,{"$f":"H51*(1-K51)","v":1}]
[null,null,null,"优化修改",null,"标签选择画面剩余默认选项优化等剩余编码工作",null,null,"宋珊珊","2022/12/21---2022/12/22"]
[null,null,null,"优化",null,"规程管理代码的熟悉和清洁度程序联调过程中发现问题处理等。",null,null,"王琦","2022/12/5---2022/12/30"]
[2,{"$f":"ROW()-2","v":52},null,"清洁度编码设置画面","弹出","1.检测分析后，进行分级统计时，需要用到该画面设置的信息","中",2,"沙永刚","2022-10-30",0.8,{"$f":"H54*(1-K54)","v":0.4}]
[null,null,null,"优化",null,"清洁度编码设置画面剩余编码工作",null,null,"宋珊珊","2022/12/23---2022/12/23"]
[null,{"$f":"ROW()-2","v":54},"4.报告模板","报告模板母版设计（单滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",10,"宋珊珊","2022-10-30",0.9,{"$f":"H56*(1-K56)","v":1},"①需要使用归一化参数（已完成）\n②追加清洁度编码（已完成）"]
[null,{"$f":"ROW()-2","v":55},null,"报告模板母版设计（合并滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",8,"宋珊珊","2022-10-30",0.9,{"$f":"H57*(1-K57)","v":0.8},"①需要显示多张滤膜概图（已完成）\n②颗粒图片获取需要重新实现"]
[null,null,null,"优化",null,"报告数据源优化，动态配置",null,null,"宋珊珊","2022/12/28---2022/12/29"]
[null,{"$f":"ROW()-2","v":57},null,"报告模板编辑画面","弹出","1.重点是如何关联报表设计器并为清洁度设计报告模板\n2.检测分析后，相关数据如何传给报表模板，并生成报表\n3.需要支持图片（数量动态）、表格（数据动态），树状图，固定信息等\n4.结合项目检测结果输出报告（Metis2.0报告预览画面）","中",30,"宋珊珊","2022-10-30",1,{"$f":"H59*(1-K59)","v":0}]
[null,{"$f":"ROW()-2","v":58},"5.系统设置","系统设置菜单","工作区","1.添加菜单、图标、按钮、动作迁移（弹出空画面）","高",2,"宋珊珊","2022-10-30",0.9,{"$f":"H60*(1-K60)","v":0.2}]
[null,null,null,"优化修改",null,"设置模块测试书编写，梳理设置模块逻辑",null,null,"宋珊珊","2022/12/7---2022/12/8",1]
[null,{"$f":"ROW()-2","v":60},null,"常规设置画面","弹出","1.先期只实现日志输出控制，语言及主题先期只有默认（不可选）\n2.日志组件实现\n3.检测结果默认显示设置","高",3,"王新贺","2023-01-13",0.9,{"$f":"H62*(1-K62)","v":0.3}]
[null,null,null,"优化",null,"常规设置优化修改",null,null,"王新贺","2022/12/12---2022/12/16"]
[null,{"$f":"ROW()-2","v":62},null,"存储设置画面","弹出","1.先期只实现本地存储设置，服务器存储只做UI，后续再实现功能","中",1,"沙永刚","2022-10-30",0.8,{"$f":"H64*(1-K64)","v":0.2}]
[null,{"$f":"ROW()-2","v":63},null,"磁盘清理功能","弹出","1.跳转到需要清理的磁盘目录\n2.通过画面设定清理范围，点击清理按钮，自动完成清理工作","中",1,"沙永刚","2022-12-30",0.8,{"$f":"H65*(1-K65)","v":0.2},"①本期实现跳转到需要清理的磁盘目录"]
[null,null,null,"优化",null,"存储设置画面、磁盘清理功能界面剩余编码工作",null,null,"宋珊珊","2022/12/26---2022/12/27"]
[null,null,null,"优化",null,"调用Metis的相关窗体异常问题处理 ",null,null,"宋珊珊","2022/12/30---2022/12/30"]
[null,{"$f":"ROW()-2","v":66},null,"用户信息画面","弹出","1.实现及存储参照Metis2.0","中",3,"沙永刚","2022-10-30",0.8,{"$f":"H68*(1-K68)","v":0.6}]
[null,67,null,"标尺管理画面","弹出","1.实现及存储参照Metis2.0\n2.但需要将标尺一览的Dock窗口变为Dialog形式\n3.需要改造标尺一览画面：增加样式设定按钮","中",3,"宋珊珊","2022-10-30",1,0]
[null,68,null,"新建标尺画面","弹出","1.实现及存储参照Metis2.0","中",1,"宋珊珊","2022-10-30",1,0]
[null,69,null,"标尺样式画面","弹出","新作成清洁度专用样式设定画面","中",5,"宋珊珊","2022-10-30",0.9,0.5,"①考虑自己制作界面进行标尺等颜色设置（自定义文件）。\n②去掉原菜单中的标尺设置按钮。"]
[null,70,null,"快捷键设置画面","弹出","设置功能快捷键","低",1,"宋珊珊","2022-10-30",0.9,0.1,"①目前设定后，部分功能未调用\n②画面只需要列出清洁度相关菜单，其他不需要，如不能实现可去除该画面\n（目前调用的Metis中的控件）"]
[null,71,null,"测量设置画面","弹出","1.实现及存储参照Metis2.0，如要调查测量时如何使用","中",1,"宋珊珊","2022-10-30",1,0]
[null,72,null,"聚焦参数设置","弹出","1.实现及存储参照Metis2.0","低",1,"宋珊珊","2022-10-30",1,0]
[null,73,null,"相机设置画面","弹出","1.实现及存储参照Metis2.0\n2.但需要考虑相机设置方案条目的实现（可创建多个条目供选择使用，如偏光的，明场的）","高",20,"王琦","2022-12-30",0.8,4,"①目前问题：Metis中阴影矫正功能只能设置一次，不能保存。\n②若采用新型相机，相关设置需要重新调试（不包含开发新相机底层代码工作）"]
[null,74,null,"载物台设置画面","弹出","新型载物台（永新载物台）开发","高",30,"王琦","2022-11-30",0.8,6,"①新型显微镜载物台底层开发"]
[null,null,null,"优化",null,"永新样品台0.7接口到位后，调试和测试阴影矫正功能功能是否可行，如果不行还需要宋部长对程序进行修正。",null,null,"王琦","2022/12/14---2022/12/30"]
[null,{"$f":"ROW()-2","v":76},null,"电机参数设置画面","弹出","1.结合新型载物台实现相关接口","中",10,"王琦","2022-11-30",0.8,{"$f":"H78*(1-K78)","v":2},"①新型显微镜载物台底层开发"]
[null,{"$f":"ROW()-2","v":77},null,"物镜及光源设定画面","弹出","永新显微镜相关设置画面实现","中",3,"宋珊珊","2022-10-30",1,{"$f":"H79*(1-K79)","v":0},"暂定不需要该界面"]
[null,{"$f":"ROW()-2","v":78},null,"客户管理画面","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.9,{"$f":"H80*(1-K80)","v":0.2}]
[null,null,null,"优化",null,"客户管理优化修改",null,null,"王新贺","2022/12/12---2022/12/14"]
[null,{"$f":"ROW()-2","v":80},null,"零部件管理","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.9,{"$f":"H82*(1-K82)","v":0.2}]
[null,null,null,"优化",null,"部件管控模块编码",null,null,"王新贺","2022/12/5---2022/12/9",1]
[null,{"$f":"ROW()-2","v":82},null,"操作者管理画面","弹出","1.重点关注数据库存储设计","低",3,"王新贺","2022-10-30",0.9,{"$f":"H84*(1-K84)","v":0.3}]
[null,null,null,"优化",null,"操作者管理优化修改",null,null,"王新贺","2022/12/26---2022/12/30"]
[null,{"$f":"ROW()-2","v":84},null,"权限管理画面","弹出","1.重点关注数据库存储设计","低",1,"王新贺","2022-10-30",0.9,{"$f":"H86*(1-K86)","v":0.1}]
[null,null,null,"优化",null,"权限管理画面优化修改",null,null,"王新贺","2022/12/19---2022/12/23"]
[null,{"$f":"ROW()-2","v":86},"6.帮助","帮助目录画面","弹出","1.帮助文档","低",15,"王新贺","2023-01-13",0.51,{"$f":"H88*(1-K88)","v":7.35}]
[null,{"$f":"ROW()-2","v":87},null,"关于画面","弹出","1.固定信息","低",1,"王新贺","2022-12-30",0.9,{"$f":"H89*(1-K89)","v":0.1}]
[null,{"$f":"ROW()-2","v":88},"单体测试","功能测试、异常系测试、连台联调测试",null,null,"高",40,"全体开发者","2023-02-28",0,{"$f":"H90*(1-K90)","v":40}]
[null,null,null,"优化",null,"测试书编写过程中发现Bug修改及功能优化处理",null,null,"宋珊珊","2022/12/9---2022/12/9",0.7]
[null,{"$f":"ROW()-2","v":90},"结合测试","功能测试、软件稳定性、准确性及性能测试",null,null,"高",30,"杨欣瑜\n开发者对应","2023-02-28",0,{"$f":"H92*(1-K92)","v":30}]
[]
[]
[null,null,"额外工作",{"$nulls":4},{"$f":"SUM(H97:H127)","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]
{"$rows_empty":12}
[null,null,"线上会议"]
[null,null,"序号","类型","工作内容","日期","日期","用时（天）","参加者"]
[null,null,1,"会议","《Metis2框架下开发经验分享及代码审查》","2022-05-26","2022-05-26",0.4,"宋珊珊、王新贺"]
[null,null,2,"会议","《清洁度项目开发例会》","2022-06-30","2022-06-30",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,3,"会议","《清洁度培训会议》","2022-09-02","2022-09-02",0.4,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,4,"会议","《清洁度会议》","2022-09-22","2022-09-22",0.3,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,5,"会议","《清洁度会议》","2022-11-09","2022-11-09",0.3,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,6,"会议","会议纪要整理","2022-06-30","2022-06-30",0.1,"宋珊珊"]
[null,null,7,"会议","开会讨论图库模式及报告中所需图片的处理方式","2022-07-08","2022-07-08",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,8,"会议","参加清洁度数据结构调整会议","2022-07-19","2022-07-19",0.3,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,9,"会议","参加清洁度会议","2022-08-04","2022-08-04",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,10,"会议","参加清洁度项目会议","2022-08-23","2022-08-23",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,11,"会议","沟通合并项目数据结构","2022-09-27","2022-09-27",0.3,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,12,"会议","参加清洁度会议","2022-10-11","2022-10-11",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,13,"会议","参加清洁度会议","2022-10-18","2022-10-18",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,14,"会议","与沙哥沟通测试书编写","2022-11-08","2022-11-08",0.2,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,16,"会议","参加清洁度会议纪要问题讨论会议","2022-11-10","2022-11-09",0.3,"沙永刚、王琦、宋珊珊、王新贺"]
[null,null,17,"会议","参加清洁度会项目交接会议","2022-11-29","2022-11-29",0.3,"沙永刚、王琦、刘洪冰、宋珊珊、王新贺"]
[]
[null,null,null,"时间","2022/11/09 14:00-16:30"]
[null,null,null,"人员","孙总、王新贺、林斌、刘洪冰、宋珊珊、沙永刚、王琦"]
[null,null,null,"No","模块","内容","结论","区分","优先级","责任者","状态"]
[null,null,null,1,"全体","主工作区中的窗口，在较小屏幕（如笔记本）部分项目表示不全","画面使用滚动条","问题","中","宋珊珊"]
[null,null,null,2,"规程设置","规程设置-图片来源：倍率列表中选择项目应该系统标尺下的所有倍率","倍率选择删除，只保留标尺即可，因为标尺决定分辨率并关联了倍率","改善","中","沙永刚","完成"]
[null,null,null,3,"规程设置","规程设置-图片来源：阴影矫正选项中不要空选项","删除空项","问题","中","沙永刚","完成"]
[null,null,null,4,"规程设置\n项目管理","规程浏览、项目浏览加右键快捷菜单功能","需要追加","改善","中","宋珊珊"]
[null,null,null,5,"检测","检测结果-图库模式/分级模式的Grid需要可手动改变列宽","需要修改，无特殊要求的都需要按此展开修改","改善","中","宋珊珊"]
[null,null,null,6,"检测","提供颗粒参看功能（类似编辑画面）","提供查看模式，两种实现方式：一种是单独做个查看画面，可以缩放，囊括更多范围；另一种是在编辑画面，提供查看模式（不可编辑只可参看），编辑画面需提供缩放，以便囊括更多范围\n\n目前考虑，第二种方式","新需求","中","沙永刚"]
[null,null,null,7,"检测","提供拼接后大图查看功能（可放大查看细节），参照av的评估图","加分项，需要增加该功能，参照av实现，难点是大图加载性能问题","新需求","低",null,"二期"]
[null,null,null,8,"检测","颗粒图库显示颗粒数量一多，出结果的时候卡在数据处理\n\n关于颗粒图片，如图库浏览、颗粒编辑、报告颗粒图片，都是使用时拼接大图实时切割下来的，优点是切割幅度可以随意设定和动态调整，这种方式是否可以？\n另一个种是保存所有颗粒切割图，使用时直接使用该图，缺点是：一次检测会占用更多磁盘空间（可能30万颗粒的小图），切割幅度不能随意调整（调整重新从大图切割保存），\n\n是否需要在图库模式的缩略图和颗粒信息列表中显示所有颗粒：目前看显示所有会有性能问题，如显示30万颗粒","保持现状：不保存颗粒小图，需要时从大图实时切割颗粒小图；不需要在页面显示所有颗粒；\n\n但需要进行以下优化和修改：（图库模式性能优化相关）\n1.当切割图片超过一定限值时，进行压缩切割\n2.提供分页功能：每页可设定展示较少数量图片，分页显示","改善","高","王琦","完成"]
[null,null,null,9,"规程设置","规程设置-拼图设置：选择聚焦补偿的聚焦点数时，需要在右侧预览区域标记聚焦点位置","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,null,10,"全体","所有画面的ComboBox控件下拉框的宽度需要修改","要修改，全部画面展开检查","问题","中","沙永刚","完成"]
[null,null,null,11,"规程设置","规程设置-执行流程-物相提取：\n两个阈值场合，不同阈值识别的轮廓需要用不同颜色轮廓标识","现状OK","-","-","-","-"]
[null,null,null,12,"系统设置","物镜转盘设定：需要可动态设置增删改查倍率（不应让客户手动修改配置文件）","要修改，可手动设定倍率，而不仅仅是从下拉框选择\n设定物镜转盘后，其他有倍率选择画面，其倍率选择项目需要从物镜转盘内容中读取","改善","低","宋珊珊"]
[null,null,null,13,"设置","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","现状OK。可通过点击：设置-磁盘清理，跳转到图片存储目录，可手动清空（图片缓存区位置可由用户进行设置指定）","-","-","-","-"]
[null,null,null,13,"报告","缓存存在哪个路径，C盘每分析一个项目都会变大，怎么清空缓存","缓存区图片被清空后，不能图库模式查看图片，不可以出报告。\n报告需要修改：可参照图库模式，当对应图片不存在是，提示图库被清除，不能出报告信息（参照点击图库模式按钮处理）","问题","高","宋珊珊"]
[null,null,null,14,"规程设置\n检测","物相提取这里还是不能交互，无法根据实际情况调整提取阈值","要修改，提供检测时用户的交互设定阈值功能，难点是大图加载","新需求","高","沙永刚"]
[null,null,null,15,"规程设置\n检测","物相提取增加吸管功能","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,null,16,"检测","颗粒分割这里点击完成以后处理速度很慢；\n\n更改类型还是每改一个类型更新全部，重新计算功能没有起到作用；","需要修改：（编辑与重新计算相关）\n\n更改类型处理类似现状的编辑颗粒，每更改一个类型，就重新进行全部统计分析。该处理需要对应：更改后，不立即全部更新，而是重新计算后统一更新","改善","高","王琦","完成"]
[null,null,null,18,"检测","有些颗粒连接分割不上","现状OK。连接不上可能是一下两种情况：\n1.同时选定连接范围的颗粒数量大于或等于3个了（一次连接操作只可连接两个颗粒，超过时不进行处理）；\n2.选定需要连接的颗粒中不包含当前颗粒（编辑画面只允许编辑当前颗粒，连接的颗粒必须包含当前颗粒）；","-","-","-","-"]
[null,null,null,18,"检测","分割和连接，点击使用有时不起作用，需要再次点击一次按钮；有时候点击后切割不起作用，换不同位置反复测试，有时候就可以分割，有时不能分割","需要调查和修改","问题","高","刘洪冰"]
[null,null,null,19,"报告","这个版本点生成报告没反应","新版本OK","-","-","-","-"]
[null,null,null,20,"规程设置","相机扫描跟本地图片规程是否考虑可以合并","需要合并，大分支节点只有用户规程和系统规程区分","改善","中","沙永刚","完成"]
[null,null,null,21,"规程设置\n检测","各级分析结果通过与否是跟哪个数据比对","现状OK。根据规程设置-分级设置中指定【允许数量使用的归一化参数】一致","-","-","-","-"]
[null,null,null,22,"规程设置\n检测","关于归一化参数选择需要可设定","加分项，需要增加该功能","新需求","低",null,"二期"]
[null,null,null,23,"检测","没有某一颗粒不参与计算的选项","需要修改：只需在进行全部类型统计时，不参与计算的类型不参与全部类型的统计分析运算，但不参与全部类型计算的类型，自己的相关测量数据，及图库展示正常，与现状一致；另外全部类型的滤膜覆盖率包含不参与计算的颗粒类型","问题","高","沙永刚","完成"]
[null,null,null,24,"检测","图库模式，提供Grid列头点击排序（图库要联动）","因为分页设计到数据库重新检索问题，画面UI中统一为不可点击Grid列头排序","改善","中","王琦","完成"]
[null,null,null,25,"算法","测试压缩前后对比数据，得出数据","需要对比测试","改善","低","沙永刚"]
[null,null,null,26,"全体","多次测量分析等操作后，内存是否释放","需要优化分析，如有问题需要进行改善","改善","中","王新贺"]

{"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]

{"sheet":"宋珊珊审核修改","index":3,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":false,"merged":[[23,4,33,4],[35,4,36,4],[37,4,38,4],[39,4,40,4],[41,4,43,4],[51,4,52,4],[60,4,62,4],[83,4,84,4],[90,4,91,4]]}
["序号","类型","工作内容","日期","用时（天）"]
[1,"会议","《Metis2框架下开发经验分享及代码审查》","2022-05-26",0.4]
[2,"会议","《清洁度项目开发例会》","2022-06-30",0.2]
[3,"会议","《清洁度培训会议》","2022-09-02",0.4]
[4,"会议","《清洁度会议》","2022-09-22",0.3]
[5,"会议","《清洁度会议》","2022-11-09",0.3]
[6,"会议","会议纪要整理","2022-06-30",0.1]
[7,"会议","开会讨论图库模式及报告中所需图片的处理方式","2022-07-08",0.2]
[8,"会议","参加清洁度数据结构调整会议","2022-07-19",0.3]
[9,"会议","参加清洁度会议","2022-08-04",0.2]
[10,"会议","参加清洁度项目会议","2022-08-23",0.2]
[11,"会议","沟通合并项目数据结构","2022-09-27",0.3]
[12,"会议","参加清洁度会议","2022-10-11",0.2]
[13,"会议","参加清洁度会议","2022-10-18",0.2]
[14,"会议","与沙哥沟通测试书编写","2022-11-08",0.2]
[16,"会议","参加清洁度会议纪要问题讨论会议","2022-11-10",0.3]
[17,"调研","清洁度中菜单内的工具项要求可以用户进行配置。通过metis自定义界面功能中进行统一配置","2022-06-30",1]
[18,"调研","调研Metis中标尺设置功能","2022-09-21",0.7]
[19,"调研","Metis快捷键设置功能调研","2022-10-08",0.9]
[20,"调研","调研直方图控件","2022-10-25",1]
[21,"调研","调研实时预览中的相机设置处理过程","2022-11-08",0.7]
[22,"调研","调研清洁度中缩小屏幕内容显示不全的画面","2022-11-15",0.5]
[23]
[24,"Bug","浏览项目时，右侧展示区的文本框可以输入，应不可输入（可参照检测结果画面的分级模式）","2022-08-22",1]
[25,"代码规范","画面布局需要调整，包括控件对齐，文字显示不全等","2022-08-22"]
[26,"变更","左侧展示的项目列表，不以零部件名称展示，应以[项目编号:项目名称]形式展示","2022-08-22"]
[27,"变更","需要增加一个零件体积","2022-08-22"]
[28,"Bug","柱状图缺少横轴和竖轴的说明，可以参照检测结果画面","2022-08-22"]
[29,"代码规范","代码缩进未对齐","2022-08-22"]
[30,"代码规范","部分编码与规范不一致（多处）","2022-08-22"]
[31,"Bug","本地化资源定义需要适当调整","2022-08-22"]
[34,"Bug","页面初始化后，没有默认项目展示","2022-08-22"]
[35,"Bug","左侧树节点，节点应该时间倒序排列","2022-08-22"]
[32,"Bug","关于画面布局，如可能，则尽可能使用IDE属性面板设定，而不是在代码中设定；另外关于布局设定，不应该发生异常，不需要异常捕获","2022-08-22"]
[33,"Bug","循环内判断写法可以简化","2022-08-19",0.5]
[36,"Bug","检测时间，为检测项目创建时间(DB表Testing.CreateTime)","2022-09-02",0.5]
[37,"Bug","树控件过于靠画面左侧，需要调整","2022-09-02"]
[38,"Bug","项目查看时，界面标题与实际显示内容不一致.并且与通常设置中的检测结果默认显示方式不一致","2022-09-15",1]
[39,"Bug","项目查看时，显示内容为分极模式时，点击检测中的“图库模式”，切换模式时会报错","2022-09-15"]
[40,"变更","报告输出，缺少滤膜概图，缺少各类型颗粒图片及信息","2022-09-05",1]
[41,"Bug","报告中图片是黑色的，没有正确输出","2022-09-05"]
[42,"Bug","报告中图片尺寸，和规程设置不一致（如果报告中，固定每行只有两个照片，那么规程设置图片尺寸就没有太大用处，需要确认报告中多大尺寸合适）；报告中其他输出是否和规程中设置一致，需要确认","2022-09-07",1]
[43,"Bug","检测前设置的送检照片，报告中没有输出","2022-09-07"]
[44,"Bug","代码中的使用固定汉字作为输出内容了，需要国际化","2022-09-07"]
[45,"Bug","报告中出现空白页面（最后一页）","2022-09-20",0.1]
[46,"Bug","Detail中图表组合显示效果异常问题处理","2022-07-06",0.5]
[47,"Bug","清洁度中报告模板中文件路径及数据库连接相对路径处理","2022-08-10",0.3]
[48,"Bug","处理报告传参数问题","2022-08-24",1]
[49,"Bug","清洁度报告传参失败原因分析及处理","2022-08-31",0.5]
[50,"Bug","颗粒编辑中的分割功能bug处理","2022-10-11",0.2]
[51,"Bug","处理图库模式及分级模式两个画面显示不全问题","2022-11-15",1]
[52,"Bug","处理规程管理画面内容显示不全问题","2022-11-16",1]
[53,"Bug","规程管理中分级设置界面调整","2022-11-16"]
[54,"Bug","图库模式标尺显示问题处理","2022-11-17",1]
[55,"Bug","检测结果显示与通常设置中“检测结果默认显示”设置不一致","2022-09-15",0.8]
[56,"变更","制作林工提供的最新清洁度报告模板","2022-07-06",0.5]
[57,"变更","更新报告模板调用相关参数配置","2022-07-12",1]
[58,"变更","更新报告模板调用相关参数配置","2022-07-14",0.3]
[59,"变更","更新报告数据源处理相关代码","2022-07-18",1]
[60,"变更","清洁度报告数据结构调整后数据重新组织后测试及调整","2022-07-21",1.7]
[61,"变更","研究DetailReport的用法，解决数据重复显示问题","2022-07-25",1]
[62,"变更","修改清洁度报告模板，增加颗粒图片显示","2022-07-25"]
[63,"变更","修改报告数据源结构","2022-07-25"]
[64,"变更","更新报表数据组织相关代码","2022-08-01",1]
[65,"变更","颗粒图片截取、更新报告模板及测试","2022-08-02",1]
[66,"变更","颗粒图片上增加标尺","2022-08-03",1]
[67,"变更","清洁度报表中增加颗粒度类型配置功能","2022-08-04",0.5]
[68,"变更","清洁度报告模板增加动态样式调整功能","2022-08-08",0.5]
[69,"变更","清洁度报告模板中用DetailReport替换子报告","2022-08-24",1.2]
[70,"变更","更换清洁度设置模块中部分图标","2022-10-31",0.8]
[71,"变更","菜单中图标更换","2022-11-01",1]
[72,"变更","预览窗体中操作图标更换","2022-11-02",1]
[73,"变更","按要求更新项目管理模块测试书","2022-11-09",0.5]
[74,"变更","分析图库模式下表格无法调整列宽原因，实现调整列宽功能","2022-11-11",0.7]
[75,"变更","规程浏览、项目浏览加右键快捷菜单功能及图标","2022-11-14",0.9]
[76,"变更","报告中数量，以使用归一化参数为准","2022-09-23",0.3]
[77,"变更","CCC编码，需要追加到报告中","2022-09-23",0.1]
[78,"规范代码","清洁度代码调整","2022-08-30",0.3]
[79,"变更","优化图片上的标尺","2022-09-15",0.7]
[80,"变更","更新报告生成时的图片与标记样式相关部分","2022-09-20",0.1]
[81,"变更","更新报告生成时的图片与标记样式相关部分","2022-09-23",0.8]
[82,"变更","清洁度会议关于普通检测项目报告中修改内容处理","2022-09-26",0.9]
[83,"变更","颗粒图片显示标尺功能修改","2022-10-12",2]
[84,"变更","清洁度报告模板滤膜覆盖率调整","2022-10-17",1]
[85,"Bug","标尺样式设置界面修改","2022-10-17"]
[86,"Bug","修改form.recx中的错误项修改","2022-10-19",0.2]
[87,"规范代码","引用DLL确认，清理不使用的DLL","2022-10-20",0.2]
[88,"变更","清洁度报告中格式调整、变更数据项目等问题处理","2022-10-26",1]
[89,"新增","合并项目报告数据组织","2022-09-27",1.8]
[90,"新增","合并项目报告模板制作","2022-09-29",1]
[91,"新增","报告预览是两种模板兼容问题处理","2022-09-30",1]
[92,"新增","报告中控件动态调整功能","2022-09-30"]
[93,"调研","Devexpress 报表控件发布测试","2022-10-09",0.5]
[94,"新增","偏光设置功能需求调研","2022-10-21",1]
[95,"新增","亮度设置处理过程梳理","2022-10-26",0.5]
[96,"新增","更新清洁度额外工作记录","2022-11-07",0.1]
[97,"新增","增加清空缓存后相关位置的处理","2022-11-11",0.2]

{"sheet":"王琦审核修改修改","index":4,"n_rows":90,"n_cols":5,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["序号","类型","工作内容","日期","用时（天）"]
[1,"会议","《Metis2框架下开发经验分享及代码审查》","2022-05-26",0.4]
[2,"会议","《清洁度项目开发例会》","2022-06-30",0.2]
[3,"会议","开会讨论图库模式及报告中所需图片的处理方式","2022-07-08",0.2]
[4,"会议","参加清洁度数据结构调整会议","2022-07-19",0.3]
[5,"会议","参加清洁度会议","2022-08-04",0.2]
[6,"会议","参加清洁度项目会议","2022-08-23",0.2]
[7,"会议","参加清洁度项目会议","2022-09-05",0.3]
[8,"会议","参加清洁度项目会议","2022-09-15",0.3]
[9,"会议","参加清洁度项目会议","2022-09-21",0.2]
[10,"会议","参加清洁度会议","2022-10-11",0.2]
[11,"会议","参加清洁度会议","2022-10-18",0.2]
[12,"会议","参加清洁度会议纪要问题讨论会议","2022-11-10",0.3]
[13,"调研","Metis2.0菜单中下拉列表的使用等","2022-06-08",1]
[14,"调研","Metis2.0中如何调用蔡司相机(包括相机配置文件的切换等)和样品台","2022-06-09",2]
[15,"调研","Metis2.0中相机视场与标尺之间的换算关系","2022-06-13",0.5]
[16,"Bug","缺少控制Z轴移动按钮","2022-08-02",0.2]
[17,"Bug","未连接相机时，点击拍照设置相关按钮时发生异常","2022-08-02",0.2]
[18,"变更","更改高度测试界面","2022-08-02",0.2]
[19,"变更","高度测量界面不需要测量和保存，需要添加确定和取消按钮","2022-08-02",0.2]
[20,"Bug","多滤膜选择界面窗体可以被拉动改变大小","2022-08-03",0.2]
[21,"变更","分级模式柱状图区域可以再高一些，比如100-200像素","2022-08-04",0.1]
[22,"Bug","分级模式点击项目存档按钮，没有弹出确认提示框（因为存档后不可再编辑，因此需要弹出确认框让用户确认）","2022-08-05",0.2]
[23,"Bug","分级模式没有任何颗粒信息时，下方表格数据显示错误","2022-08-08",0.2]
[24,"Bug","分级模式分级最后是否通过，评判不正确\n颗粒为零时表示通过","2022-08-08",0.2]
[25,"Bug","分级模式用户能用鼠标拖动改变Grid行高（需要规定，不可改变）","2022-08-08",0.2]
[26,"Bug","分级模式当不同类型分级名称不完全相同时，柱状图横坐标标示错误","2022-08-09",0.3]
[27,"Bug","分级模式切换颗粒类型Tab时，柱状图位置发生变化了（应固定）","2022-08-09",0.2]
[28,"Bug","分级列表中内容可修改了（应不可手动修改）","2022-08-09",0.2]
[29,"Bug","分级模式需要追加一个是否存档表示项目","2022-09-05",0.2]
[30,"Bug","分级模式是否通过，数据库已有保存，该画面是否有必要重新计算？","2022-09-09",0.2]
[31,"Bug","分级模式列头缺少名称","2022-09-15",0.2]
[32,"变更","①缩略图区域背景颜色太浅\n②右上角显示图片区域加个细的边框，避免无图时无边界","2022-08-10",0.2]
[33,"Bug","图库模式画面布局问题","2022-08-10",0.2]
[34,"Bug","按钮高度未统一到25像素","2022-08-10",0.2]
[35,"Bug","图库模式颗粒类型转换按钮，只有在选中颗粒时才可用，并且只有该选中颗粒类型外的另外两种类型按钮才可用","2022-08-11",0.2]
[36,"Bug","①颗粒信息列表中[颗粒分类]列显示内容不正确\n②颗粒信息列表需要追加一列[分级]","2022-08-12",0.5]
[37,"Bug","颗粒信息列表中的灰度均值显示的都是0，确认是否正确","2022-08-15",0.1]
[38,"Bug","颗粒信息列表列头中缺少计量单位","2022-08-15",1]
[39,"Bug","需要将选中缩略图与颗粒信息表中对应数据行关联，即选中缩略图自动选择下边对应颗粒数据行；同理，选择下边数据行，需要自动选择上边缩略图","2022-08-16",0.4]
[40,"Bug","缩略图展示区滚动条问题：下方没有图片了，滚动条还可以拖动","2022-08-17",0.5]
[41,"Bug","出现缩略图表示不全的问题，建议至少显示一个完整颗粒","2022-08-17",0.5]
[42,"Bug","右键设置颗粒信息列表显示的时候，上边缩略图显示被刷新了（不应该刷新）","2022-08-18",0.2]
[43,"Bug","检测结果未归档时，弹出的对话框不正确：未使用MessageDialog共通画面，同时缺少[否]的按钮","2022-08-18",0.2]
[44,"Bug","未输出报告时，点击工具栏按钮不需要提示是否输出报告提示","2022-08-18",0.2]
[45,"Bug","没有检测结果表示使，点击工具栏存档等按钮，不需要有反应","2022-08-18",0.2]
[46,"Bug","颗粒标尺未使用系统设置的标尺样式","2022-08-19",0.5]
[47,"Bug","系统设置中，改变图片默认尺寸大小，图库模式的图片没有马上根据设置立即刷新大小（其他影响画面的设置生效后，也应刷新画面）","2022-08-19",1]
[48,"Bug","系统设置中，改变显示颗粒数量和最小尺寸后，再去图库模式改变颗粒幅度，发生异常（偶发，未找到规律）","2022-08-23",0.8]
[49,"Bug","通过图库模式左侧的下拉框，改变图片大小时，中间显示图片区域的刷新有性能问题，出现\"花屏\"了","2022-08-25",0.5]
[50,"Bug","没有任何颗粒信息时，点击是否显示轮廓CheckBox时发生异常","2022-08-26",0.2]
[51,"Bug","改变颗粒类型时，发生异常了","2022-08-26",0.3]
[52,"Bug","图片来源：本地图片的场合，实时预览及高度测量应不可用","2022-08-26",0.2]
[53,"Bug","右上角的偏光或明场RadioButton，要根据规程设置来控制其是否可用","2022-08-26",0.2]
[54,"Bug","右上角的颗粒预览按钮，修改下文字内容[颗粒预览]→[实时预览]","2022-08-26",0.1]
[55,"Bug","判断条件中，特征参数使用了硬编码，后续国际化后可能会有Bug","2022-08-29",1]
[56,"Bug","颗粒编辑后，返回图库模式，图片都变为黑色了","2022-08-30",0.4]
[57,"Bug","下边没有图片了，滚动条却还可以拖动","2022-08-30",0.2]
[58,"Bug","图库模式图片，默认需要显示明场图片，下边数据列表中数据的平均灰度需要用明场的平均灰度","2022-08-30",0.1]
[59,"Bug","使用[平均灰度]排序时，颗粒图片显示不正确","2022-08-30",0.3]
[60,"变更","重新计算按钮，是否需要保留，如不需要则删除","2022-11-15",4]
[61,"Bug","选择颗粒后，点击“删除颗粒”按钮后，颗粒信息依然存在","2022-08-31",0.5]
[62,"Bug","颗粒编辑画面布局中GroupBox间过于紧密","2022-08-31",0.1]
[63,"Bug","颗粒轮廓未对齐（使用林工图片，偏光[MD-Experiment-0001_p042.jpg]）","2022-08-31",0.2]
[64,"Bug","图片控件缺少边框，用户很难发现可以双击选择照片","2022-09-01",0.2]
[65,"Bug","多工位时，规程设置的共有项目，检测输入时，没有在各个滤膜间共有，需要一个输入了，对于共有项目，一个工位的输入了，其他工位的应自动变为相同（已最后输入为准）","2022-09-01",1.5]
[66,"Bug","对于规程设置的必要的项目，检测输入时如果未输入(0代表未输入），则需要提示","2022-09-05",0.3]
[67,"Bug","Tab键顺序不对，应该根据规程设置的Tab顺序设定（需要规程设置画面，增加Tab顺序属性）","2022-09-05",0.1]
[68,"Bug","保存信息时报错。","2022-09-05",0.1]
[69,"Bug","相机预览区域，不需要GroupBox","2022-09-06",0.1]
[70,"Bug","信息GroupBox过于拥挤","2022-09-06",0.1]
[71,"Bug","途中点击停止按钮后，确认对话框没有关闭","2022-09-06",0.2]
[72,"Bug","扫描信息展示内容需要调整","2022-09-06",0.2]
[73,"Bug","扫描信息中展示的滤膜背景色，需要和右侧扫描进度一致","2022-09-06",0.2]
[74,"Bug","点击多滤膜→选择工位→输入检测信息→弹出物镜提示框（不要点确定），此时点工具栏的停止按钮，再关闭物镜提示框的取消按钮；然后再去点工具栏的多滤膜重新开始检测，则出现扫描进展画面，没有动态展示扫描进度，如果这个时候点击单滤膜，则提示正在扫描检测了","2022-09-07",0.4]
[75,"Bug","检测时的信息输入，与规程设置不一致；另外ComboBox要求可以自由输入，不是不许从下拉框中选择","2022-09-07",0.4]
[76,"Bug","DAO层，事务处理使用不当，异常捕获使用不不当（该层通常不进行异常捕获，系统自动抛出即可）","2022-09-07",0.2]
[77,"Bug","关闭Tab页面的语句可以简化写法，TestingAction.cs内有两处类似代码，可参照如下修改：\n//关闭结果展示界面\nforeach (var no in new []{ \"\", \"1\",\"2\", \"3\",\"4\", \"5\",\"6\"})\n{\n    e.FormContext.ClosePage(ActionType.TestingBarDisplay + no);\n    e.FormContext.ClosePage(ActionType.TestingGrainDisplay + no);\n}","2022-09-08",0.1]
[78,"Bug","缺少偏光及明场切换的提示业务处理，该处理也是需要根据系统设置来判定是否弹出，也是需要判定是否有硬件控制器接口可调用\n\n需要在[设置-通常设置]画面增加，是否弹出该对话框的设置","2022-09-08",0.2]
[79,"Bug","预览区域背景色与其他区域背景色一致了，没有相机预览时，没有预览边界，需要将预览区域背景色适当深一点","2022-09-08",0.05]
[80,"Bug","点击图片模式后，发生异常","2022-09-08",0.1]
[81,"Bug","放大倍数下拉框显示的是倍数，不应该是标尺名称，下拉框内容应从配置文件读取","2022-09-08",0.1]
[82,"Bug","标尺，应该显示可选下拉框，下拉框内容为标尺名","2022-09-08",0.1]
[83,"Bug","需要增加一个分辨率表示项（不可输入）","2022-09-08",0.05]
[84,"Bug","需要追加一个测量设置按钮，弹出测量设置画面","2022-09-08",0.1]
[85,"Bug","改变画面尺寸后，画面布局不合理。建议该画面可以最大化（无最小化）","2022-09-08",0.05]
[86,"Bug","重新测量按钮的图标不易理解，可以换成类似带返回复原箭头的图标","2022-09-08",0.05]
[87,"变更","图库模式分页显示","2022-11-10",3]
[88,"变更","颗粒编辑后切换其他界面处理功能","待完成"]
[89,"需求增加","检测物镜转盘是否与规程相同，不同则弹出对话框选择。","待完成"]

{"sheet":"沙永刚审核修改","index":5,"n_rows":147,"n_cols":5,"rows_kept":147,"cut":false,"hidden":false,"merged":[]}
["序号","类型","工作内容","日期","用时（天）"]
[1,"会议","清洁度相关业务确认及审查","2022-05-12",0.3]
[2,"会议","清洁度相关业务确认及审查","2022-05-26",0.3]
[3,"会议","清洁度相关业务确认及审查","2022-06-30",0.3]
[4,"会议","清洁度相关业务确认及审查","2022-07-19",0.3]
[5,"会议","清洁度相关业务确认及审查","2022-07-28",0.3]
[6,"审查","代码审查CheckList作成，并全员讲解","2022-08-01",0.5]
[7,"审查","系统初始化","2022-08-02",0.5]
[8,"审查","检测画面：包括工具栏各个按钮功能","2022-08-03",0.5]
[9,"审查","图片选择画面","2022-08-04",0.5]
[10,"会议","清洁度相关业务确认及审查","2022-08-05",0.3]
[11,"审查","项目选择画面","2022-08-05",0.5]
[12,"会议","清洁度相关业务确认及审查","2022-08-08",0.3]
[13,"审查","滤膜工位选择画面","2022-08-08",0.5]
[14,"审查","滤膜信息输入画面","2022-08-09",0.5]
[15,"审查","拼图进度展示画面","2022-08-10",0.5]
[16,"审查","算法部分：1.拼图、2.测量、3.轮廓、4.图片分割","2022-08-11",0.5]
[17,"审查","颗粒编辑窗口","2022-08-12",0.5]
[18,"审查","实时预览画面","2022-08-15",0.5]
[19,"审查","高度测量画面","2022-08-16",0.5]
[20,"审查","检测结果-图库模式","2022-08-17",0.5]
[21,"审查","检测结果-分级模式","2022-08-18",0.5]
[22,"审查","项目浏览画面：包括工具栏上各个按钮功能","2022-08-19",0.5]
[23,"会议","清洁度相关业务确认及审查","2022-08-23",0.3]
[24,"会议","清洁度相关业务确认及审查","2022-09-02",0.3]
[25,"审查","项目合并确认画面","2022-09-05",0.5]
[26,"审查","报告模板","2022-09-06",0.5]
[27,"会议","清洁度相关业务确认及审查","2022-09-07",0.3]
[28,"审查","存储设置画面","2022-09-07",0.5]
[29,"审查","实验室信息画面","2022-09-08",0.5]
[30,"审查","标尺设置画面","2022-09-09",0.5]
[31,"会议","清洁度相关业务确认及审查","2022-09-15",0.3]
[32,"审查","测量设置画面","2022-09-19",0.5]
[33,"审查","聚焦参数设置","2022-09-20",0.5]
[34,"审查","客户管理画面","2022-09-21",0.5]
[35,"会议","清洁度相关业务确认及审查","2022-09-22",0.3]
[36,"审查","零部件管理","2022-09-22",0.5]
[37,"审查","用户管理画面","2022-09-23",0.5]
[38,"审查","帮助目录画面","2022-09-23",0.5]
[39,"审查","关于画面","2022-09-23",0.5]
[40,"Bug","规程设置-执行流程设置修改","2022-09-28",0.5]
[41,"Bug","图库模式Grid增加灰度相关列","2022-09-28",0.5]
[42,"需求增加","分析范围交互画面","2022-09-28",3]
[43,"Bug","分析范围交互设定","2022-09-29",0.5]
[44,"Bug","合并项目滤膜覆盖率计算","2022-09-29",0.5]
[45,"Bug","项目合并画面","2022-09-29",0.5]
[46,"Bug","分析处理流程共通化","2022-09-29",0.5]
[47,"Bug","分级性能优化","2022-09-30",0.5]
[48,"Bug","规程设置-报告模板页修改","2022-10-08",0.5]
[49,"Bug","增加合并分析处理","2022-10-08",0.5]
[50,"Bug","手动停止处理、归档后处理、数据库更新","2022-10-09",0.5]
[51,"会议","清洁度相关业务确认及审查","2022-10-11",0.3]
[52,"Bug","检测分析流程抽象化","2022-10-11",0.5]
[53,"Bug","规程管理","2022-10-12",0.5]
[54,"Bug","交互分析范围设定","2022-10-12",0.5]
[55,"Bug","设置菜单","2022-10-12",0.5]
[56,"Bug","分析范围画面作成","2022-10-13",0.5]
[57,"Bug","图库模式Grid点击列头异常修改、规程设置-物相提取算法更换","2022-10-13",0.5]
[58,"Bug","检测统计分析","2022-10-13",0.5]
[59,"Bug","窗口状态、图标、ESC动作等","2022-10-13",0.5]
[60,"Bug","分级设置修改","2022-10-17",0.5]
[61,"Bug","项目参看问题修改","2022-10-17",0.5]
[62,"Bug","颗粒编辑、算法更新","2022-10-17",0.5]
[63,"会议","清洁度相关业务确认及审查","2022-10-18",0.3]
[64,"Bug","图片来源设置","2022-10-20",0.5]
[65,"Bug","删除规程新建按钮处理，增加系统内置规程","2022-10-20",0.5]
[66,"Bug","参数设置修改","2022-10-20",0.5]
[67,"Bug","检测分析修改","2022-10-21",0.5]
[68,"Bug","规程导入导出","2022-10-24",0.5]
[69,"Bug","阴影矫正规程设置、照片来源文件时尺寸限制","2022-10-24",0.5]
[70,"Bug","载物台配置关联修改、颗粒位置计算、其他","2022-10-24",0.5]
[71,"Bug","滤膜覆盖率修改","2022-10-24",0.5]
[72,"Bug","分级模式修改","2022-10-25",0.5]
[73,"Bug","清洁度编码格式错误修正","2022-10-25",0.5]
[74,"Bug","清洁度编码错误修正","2022-10-25",0.5]
[75,"Bug","参数名修改","2022-10-25",0.5]
[76,"Bug","测量参数类型调整","2022-10-25",0.5]
[77,"Bug","规程设置-信息模板更新","2022-10-26",0.5]
[78,"Bug","报告处理","2022-10-26",0.5]
[79,"Bug","规程设置","2022-10-26",0.5]
[80,"Bug","信息模板支持小数位设定","2022-10-26",0.5]
[81,"Bug","信息模板及报告相关","2022-10-26",0.5]
[82,"Bug","扫描进展画面","2022-10-27",0.5]
[83,"Bug","报告处理","2022-10-27",0.5]
[84,"Bug","工位选择画面","2022-10-27",0.5]
[85,"Bug","检测分析菜单","2022-10-27",0.5]
[86,"Bug","颗粒编辑及分析最小尺寸限定相关","2022-10-28",0.5]
[87,"Bug","颗粒编辑相关","2022-10-28",0.5]
[88,"Bug","分析范围交互画面","2022-10-28",0.5]
[89,"Bug","主菜单选择函数实现方式修改","2022-10-31",0.5]
[90,"Bug","系统规程","2022-10-31",0.5]
[91,"Bug","选择菜单函数：函数名及参数名修改","2022-10-31",0.5]
[92,"Bug","根据框架事件触发机制，修改原事件注册方式（清洁度相关）","2022-10-31",0.5]
[93,"Bug","信息输入模板","2022-10-31",0.5]
[94,"Bug","实时预览、物镜转盘、倍率设定","2022-11-01",0.5]
[95,"Bug","实时预览","2022-11-01",0.5]
[96,"Bug","图库模式","2022-11-02",0.5]
[97,"Bug","颗粒编辑","2022-11-02",0.5]
[98,"Bug","测量算法更新","2022-11-02",0.5]
[99,"Bug","工程修改","2022-11-02",0.5]
[100,"Bug","修改主菜单[硬件显示的]控制","2022-11-02",0.5]
[101,"Bug","工程修改","2022-11-02",0.5]
[102,"Bug","标尺样式设定问题","2022-11-03",0.5]
[103,"Bug","图库模式过滤筛选、颗粒编辑","2022-11-03",0.5]
[104,"Bug","默认规程","2022-11-04",0.5]
[105,"Bug","规程设置菜单","2022-11-04",0.5]
[106,"Bug","分析范围","2022-11-04",0.5]
[107,"Bug","是否删除扫描小图处理","2022-11-04",0.5]
[108,"Bug","高度测量","2022-11-04",0.5]
[109,"Bug","信息模板输入","2022-11-07",0.5]
[110,"Bug","拼图及阴影矫正算法","2022-11-07",0.5]
[111,"Bug","以标尺为准筛选倍率","2022-11-08",0.5]
[112,"Bug","物镜转盘设定","2022-11-08",0.5]
[113,"Bug","ComboBox下拉框宽度调整","2022-11-08",0.5]
[114,"Bug","存储设置","2022-11-08",0.5]
[115,"会议","清洁度相关业务确认及审查","2022-11-09",0.3]
[116,"Bug","合并项目处理","2022-11-09",0.5]
[117,"Bug","主工作区Grid列宽可以用户拖动改变","2022-11-09",0.5]
[118,"Bug","规程设置-相机方案及阴影矫正","2022-11-09",0.5]
[119,"Bug","规程设置-图片来源，放大倍率问题","2022-11-09",0.5]
[120,"Bug","颗粒编辑，复原时轮廓丢失问题","2022-11-09",0.5]
[121,"Bug","不参与计算颗粒类型处理","2022-11-09",0.5]
[122,"会议","清洁度相关业务确认及审查","2022-11-10",0.3]
[123,"Bug","不参与总体计算问题修改","2022-11-10",0.5]
[124,"Bug","规程管理","2022-11-10",0.5]
[125,"Bug","规程设置","2022-11-10",0.5]
[126,"Bug","测量算法修正","2022-11-11",0.5]
[127,"需求增加","颗粒参看功能，可放大缩小视场范围","2022-11-14",3]
[128,"Bug","颗粒编辑","2022-11-15",0.5]
[129,"Bug","颗粒编辑","2022-11-15",0.5]
[130,"Bug","颗粒查看","2022-11-15",0.5]
[131,"Bug","实时预览","2022-11-15",0.5]
[132,"Bug","相机预览","2022-11-15",0.5]
[133,"Bug","通用设置","2022-11-16",0.5]
[134,"Bug","图库模式性能优化","2022-11-16",0.5]
[135,"Bug","阴影矫正","2022-11-16",0.5]
[136,"Bug","颗粒编辑","2022-11-16",0.5]
[137,"Bug","通用设置","2022-11-17",0.5]
[138,"Bug","分析范围设定","2022-11-17",0.5]
[139,"Bug","图库模式","2022-11-17",0.5]
[140,"Bug","物相提取交互","2022-11-18",0.5]
[141,"需求增加","物相提取设定画面","2022-11-18",4]
[142,"Bug","物相提取交互（预览与实际压缩比例同步）","2022-11-21",0.5]
[143,"Bug","物相提取交互","2022-11-21",0.5]
[144,"Bug","物相提取设定交互画面","2022-11-21",0.5]
[145,"Bug","物相提取交互","2022-11-22",0.5]
[146,"Bug","颗粒编辑","2022-11-22",0.5]

{"sheet":"王新贺审核修改","index":6,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["序号","类型","工作内容","日期","用时（天）"]
[1,"会议","《Metis2框架下开发经验分享及代码审查》","2022-05-26",0.4]
[2,"会议","《清洁度项目开发例会》","2022-06-30",0.2]
[3,"会议","《清洁度培训会议》","2022-09-02",0.4]
[4,"会议","《清洁度会议》","2022-09-22",0.3]
[5,"会议","《清洁度会议》","2022-11-09",0.3]
[7,"会议","开会讨论图库模式及报告中所需图片的处理方式","2022-07-08",0.2]
[8,"会议","参加清洁度数据结构调整会议","2022-07-19",0.3]
[9,"会议","参加清洁度会议","2022-08-04",0.2]
[10,"会议","参加清洁度项目会议","2022-08-23",0.2]
[11,"会议","参加清洁度会议","2022-09-27",0.3]
[12,"会议","参加清洁度会议","2022-10-11",0.2]
[13,"会议","参加清洁度会议","2022-10-18",0.2]
[14,"会议","与沙哥沟通测试书编写","2022-11-08",0.2]
[15,"会议","参加清洁度会议纪要问题讨论会议","2022-11-10",0.3]
[16,"审核修改","常规设置画面","2022-11-21",2.5]
[17,"审核修改","客户管理画面","2022-09-10",2]
[18,"审核修改","零部件管理","2022-08-19",2.5]
[19,"审核修改","操作者管理画面","2022-08-25",2]
[20,"审核修改","权限管理画面","2022-09-20",3]
[21,"审核修改","帮助目录画面","2022-10-26",2]
[22,"审核修改","关于画面","2022-08-15",0.4]

{"sheet":"王琦2022年12月工作计划","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"王琦12月工作计划"]
[null,"No.","工作内容","负责人","开始时间","结束时间"]
[null,1,"自动聚焦、聚焦补偿程序测试，问题修正。","王琦","2022-12-05","2022-12-09"]
[null,2,"颗粒定位（实时预览时，将样品台移动到颗粒位置）。","王琦","2022-12-08","2022-12-09"]
[null,2,"修改规程切换时不保存设置参数问题。","王琦","2022-12-12","2022-12-14"]
[null,3,"查找规程更改后，点击标尺标定报错问题。","王琦","2022-12-13","2022-12-15"]
[null,4,"永新样品台0.7接口到位后，调试和测试阴影矫正功能功能是否可行，如果不行还需要宋部长对程序进行修正。","王琦","2022-12-14","2022-12-30"]
[null,5,"颗粒编辑后，重新计算报错问题跟踪和解决。","王琦","2022-12-14","2022-12-16"]
[null,6,"宋部长计划16号将拼图程序发布一个新版本，收到版本程序后进行程序调试和测试，如果还有问题继续与宋部长沟通改正问题。","王琦","2022-12-19","2022-12-30"]
[null,7,"规程管理代码的熟悉和清洁度程序联调过程中发现问题处理等。","王琦","2022-12-05","2022-12-30"]

{"sheet":"宋珊珊2022年12月工作计划","index":8,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,2,2,2],[3,2,4,2],[1,3,2,3],[3,3,4,3]]}
["序号","工作内容","开始时间","结束时间"]
[1,"梳理检测分析业务逻辑","2022-12-05","2022-12-06"]
[2,"完成检测模块测试书"]
[3,"设置模块测试书编写","2022-12-07","2022-12-08"]
[4,"梳理设置模块逻辑"]
[5,"测试书编写过程中发现Bug修改及功能优化处理","2022-12-09","2022-12-09"]
[6,"检测时的范围设定及物相提取处理方式调研","2022-12-12","2022-12-12"]
[7,"项目文件中涉及使用规程处理方式调研","2022-12-13","2022-12-13"]
[8,"项目浏览、标尺样式、快捷键设置等功能的剩余编码工作","2022-12-14","2022-12-16"]
[9,"物相提取等大界面需要优化","2022-12-19","2022-12-20"]
[10,"标签选择画面剩余默认选项优化等剩余编码工作","2022-12-21","2022-12-22"]
[11,"清洁度编码设置画面、用户信息画面剩余编码工作","2022-12-23","2022-12-23"]
[12,"存储设置画面、磁盘清理功能界面剩余编码工作（主要中存储项目组织优化）","2022-12-26","2022-12-27"]
[13,"报告数据源优化，动态配置","2022-12-28","2022-12-29"]
[14,"调用Metis的相关窗体异常问题处理","2022-12-30","2022-12-30"]

{"sheet":"王新贺2022年12月工作计划","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["王新贺12月工作计划"]
["No.","工作内容","负责人","开始时间","结束时间"]
[1,"部件管控模块编码","王新贺","2022-12-05","2022-12-09"]
[2,"常规设置优化修改","王新贺","2022-12-12","2022-12-16"]
[3,"客户管理优化修改","王新贺","2022-12-12","2022-12-14"]
[4,"权限管理画面优化修改","王新贺","2022-12-19","2022-12-23"]
[5,"操作者管理优化修改","王新贺","2022-12-26","2022-12-30"]
[6,"帮助目录优化修改","王新贺","2022-12-19","2022-12-30"]
[7,"交叉测试修改问题","王新贺","2022-12-05","2022-12-30"]