{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["work items","Sheet1"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":0,"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":"work items","index":0,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["序号","类型","标题","状态","负责人","提出人","计划开始时间","计划完成时间","优先级","提出日期","问题截图",null,"备注"]
[1,"Bug","检测-图库模式，相机扫描时点击颗粒图片无法定位的颗粒。需要改成打开预览界面定位到颗粒。双击方式定位的颗粒。本地图片不显示预览","待处理","王琦","林彬","2023-01-18","2023-02-03","高","2023-01-12",null,"已加云效"]
[2,"优化","检测-单滤膜，第一遍拼图结束数据处理时间较长。与测试电脑性能有一定关系。用AI电脑测试时两次扫描结束后，计算颗粒的时间约2分钟，时间过长。需要进行优化。","待处理","宋宏伟","林彬","2023-01-29","2023-02-03","高","2023-01-12",null,"已加云效","1、竞品软件20秒左右\n2、提出硬件配置方案"]
[3,"Bug","检测-单滤膜，阴影矫正还是有网格。会影响检测结果，在二值化时会被误认为是颗粒","待处理","宋学奎","林彬","2023-01-18","2023-02-03","高","2023-01-12",null,"已加云效"]
[4,"Bug","检测-单滤膜，颗粒拼完图数据处理时间长","待处理","宋宏伟","林彬","2023-01-29","2023-02-03","高","2023-01-12",null,"已加云效"]
[5,"Bug","检测-测试时关闭设置中载物台的调取","已完成","王琦","林彬",null,null,"高","2023-01-12",null,"已加云效"]
[6,"Bug","检测-聚焦补偿只需要在偏光下做一次即可","已完成","王琦","林彬",null,null,"高","2023-01-12",null,"已加云效"]
[7,"Bug","设置-电机运行速度能否调快","已完成","王琦","林彬",null,null,"高","2023-01-12",null,"已加云效","指定默认值"]
[8,"Bug","更换电脑未安装VS，清洁度插件无法显示","已完成","宋宏伟","林彬","2023-02-06","2023-02-07","高","2023-01-13",null,"缺少C++相关"]
[9,"Bug","检测-相机设置保存不上。增益、亮度、对比度，伽马值也存在同样问题。验证配置文件复制","待处理","王琦","林彬","2023-02-08","2023-02-10","高","2023-01-13",null,"已加云效","操作方式确认"]
[10,"变更需求","规程设置-物相提取参照AxioVision，灰度区域与峰值比例是二选一关系，不能同时设定。图片考虑加载大图（缩略图）否则无法满足要求。找到加载速度和背景灰度相对准确的一个压缩比。现在看加载小图无法满足要求","待处理","王琦","林彬","2023-02-06","2023-02-17","高","2023-01-13",null,"AxioVision中的图片"]
[11,"变更需求","规程管理-拼图设置增加预览，通过预览方式确定拼图范围，参考AxioVision","待处理","王琦","林彬","简版2023-01-18\n优版2023-03-01","简版2023-02-03\n优版2023-03-10","高","2023-01-13",null,null,"简易版"]
[12,"Bug","检测-相机设置中调整饱和度以后显示的颜色不对。彩色图像时。颗粒颜色能显示本来原因，背影应该可以正常显示。","待确认","王琦","林彬","2023-02-13","2023-02-17","高","2023-01-17"]
[13,"优化","拼图中间位置很好，边缘位置有错位，确认。偶尔不对（需要近一步测试）","待确认","宋学奎","林彬","2023-02-13","2023-02-17","高","2023-01-17"]
[14,"优化","聚焦补偿现在没有控制五个点，有出现在滤膜外面的情况。增加一个聚焦五个点距离拼图区域边缘的距离的设定。参照Zen软件","待确认","王琦","林彬","\n2023-02-20","\n2023-02-21","高","2023-01-17",null,null,"需要确认Margin的单位"]
[15,"Bug","检测-相机扫描过程中经常出现相机拍不到图片的情况，导致程序一直等待拍照，无法执行下去的情况","待处理","王琦","林彬","2023-01-18","2023-02-17","高","2023-01-17"]
[36,"优化","检测-第一次扫描结束在拼图时，影响第二次扫描的速度，会使第二次扫描变得卡顿","待处理","宋学奎","林彬","2023-02-06","2023-02-10","高","2023-01-17",null,null,"关注一下资源占用情况"]
[16,"Bug","检测-单滤膜，物相提取需要显示填充效果","已完成","王琦","林彬",null,null,"中","2023-01-12",null,"已加云效"]
[17,"新增需求","检测-预览画面增加自动聚焦按钮","已处理待验证","王琦","林彬","2023-01-18","2023-02-03","中","2023-01-13",null,"可以考虑放后或二期"]
[18,"Bug","设置-相机设置功能移到检测中，放到菜单的最后一项","已完成","王琦","林彬",null,null,"中","2023-01-13",null,"已加云效"]
[19,"Bug","设置-载物台功能中的位置修改，程序直接报错","已完成","王琦","林彬",null,null,"中","2023-01-13"]
[20,"Bug","设置-常规设置所有检测正常执行时是可以配置的，连硬件后检测如果出现问题，再点常规设置时界面中的显示与最初设置不一致。一定问题出现后，重启软件该界面显示还是不正确","已完成","宋珊珊","林彬",null,null,"中","2023-01-13",null,"已替换Nlog"]
[21,"Bug","设置-标尺标定，第一次打开软件，制作标尺报错，需要重启软件","待处理","赵天宇","林彬","转给Metis",null,"中","2023-01-12",null,"已加云效"]
[22,"Bug","设置-标尺标定，编辑标尺时，对标尺信息修改后，点击保存标尺后提示“标尺信息保存失败”","待处理","赵天宇","宋珊珊","转给Metis",null,"中","2023-01-13"]
[23,"更改配置","检测-相机配置方案中初始值“锐化”调整到10以下，大约为9。图像设置中的“水平镜像翻转”选中。亮度133，对比度34，伽码值2.55","待处理","宋珊珊","林彬","2023-01-28","2023-01-28","中","2023-01-17"]
[24,null,"检测-相机配置方案中如果选择“自动白平衡”，会不会每个小图都是自动白平衡后再拼图的？","待确认","宋学奎","林彬","无需处理",null,"中","2023-01-17",null,"对比测试"]
[25,"新增需求","在相机设置中拍个图片后，增加一个右键另存的功能，可以把图片保存下来。现在做标尺做不了，没有办法把拍下的图片保存。","待处理","王琦","林彬",null,null,"中","2023-01-17"]
[26,"优化","检测-图库模式，颗粒轮廓与颗粒不符，有的纤维未轮廓不全（需要近一步测试，存在硬件原因导致的情况）","待确认","宋宏伟","林彬","基本可以确定是硬件问题，无需修改",null,"中","2023-01-17",null,null,"初步分析是硬件原因，再测试"]
[27,"更改配置","设置-聚焦参数 步长20，间隔300，电机速度Z轴50。在规程中选择自动聚焦或是聚焦补偿时按这个初始设置","待处理","宋珊珊","林彬","2023-01-28","2023-01-28","中","2023-01-17"]
[28,"Bug","检测-物相提取交互界面，左侧拼图图片选择区域图片排序位置不对（后续如果用大图，此问题可以忽略）","待处理","王琦","林彬","\n2023-02-20","\n2023-02-24","中","2023-01-17"]
[29,"新增需求","规程管理-导入规程，可以批量导入","待处理","王琦","林彬","\n2023-02-27","\n2023-02-28","低","2023-01-13"]
[30,"新增需求","规程管理-导出规程，可以批量导出","待处理","王琦","林彬","\n2023-02-27","\n2023-02-28","低","2023-01-13"]
[31,"Bug","规程管理-图片来源中原本设定好阴影矫正图片，有时会调取不到，但目录位置有图片。扫描时会报错。再返回看规程图片名称没有显示。项目生成后，规程中的相机扫描，无法正确绑定阴影矫正图片。程序上也没有相应处理。\n","已处理","王琦","宋珊珊",null,null,"低","2023-01-16"]
[32,"更改配置","规程管理-参数设置，明场与偏光差设定值为50.","已处理","宋珊珊","林彬",null,null,"低","2023-01-17"]
[33,"优化","规程管理-拼图设置中滤膜尺寸如无实际用途可以考虑去掉。","关闭","王琦","林彬",null,null,"低","2023-01-17"]
[34,"优化","规程管理-拼图设置中范围设定中尺寸换成毫米增加单位。","关闭","王琦","林彬",null,null,"低","2023-01-17"]
[35,"Bug","检测-物相提取交互界面，切换“显示原图”颗粒填充被换成了轮廓了","已处理","王琦","林彬",null,null,"低","2023-01-17"]

{"sheet":"Sheet1","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["偏光和明场两张矫正图片"]
[]
[]
["竞品处理速度 正常样品：偏光+明场+出结果，7分钟左右"]
[]
[]
["玻璃样品盖申请一下，和孙总提。现在这个拍图是总是虚"]
[]
[]
["不聚焦的情况下从扫描到出结果10分钟。速度800的情况下。用AI那个机器"]