{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["作业进度一览","额外作业"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,10,0,11]]}
[{"$nulls":7},{"$f":"\"总：\"&SUM(H3:H178)&\"人日\"&\" = \" &ROUND(SUM(H3:H178)/20,2)&\"人月\"","v":"总：630人日 = 31.5人月"},null,null,{"$f":"\"完成：\"&ROUND((SUM(H3:H63)-SUM(L3:L63))/SUM(H3:H63),4) * 100 &\"%\"","v":"完成：62.2%"}]
[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,2,null,"数据库设计相关","-","数据调整","低",5,"全体","2022-12-30",1,{"$f":"H4*(1-K4)","v":0}]
[null,3,null,"需求确认及对应","-","与林斌沟通、确认及调整","低",15,"沙永刚","2022-12-30",1,0]
[null,4,null,"信息提示画面","弹出","通用提示框：信息、警告、错误","高",2,"沙永刚","2022-06-30",1,0]
[null,5,null,"操作确认画面","弹出","提示用户确认或者取消","高",1,"沙永刚","2022-06-30",1,0]
[null,6,null,"系统初始化处理","-",null,"高",3,"王琦","2022-05-30",1,0]
[null,7,"1.检测分析","检测画面","工作区","添加菜单、图标、按钮、动作迁移（处理空）","高",2,"王琦","2022-05-30",0.8,0.39999999999999991]
[null,8,null,"规程选择画面","弹出","列出所有规程，初始选择登录用户默认规程","中",2,"沙永刚","2022-07-30",0.8,0.39999999999999991]
[null,9,null,"滤膜工位选择画面","弹出","1.所选工位信息执行过程全局存储设计","中",2,"王琦","2022-10-30",0.55000000000000004,0.89999999999999991,"①6个工位改为2个工位（注意位置）\n②未在硬件设备上调试"]
[null,10,null,"滤膜信息输入画面","弹出","1.根据规程设置参数，动态生成该信息画面，有一定难度\n2.考虑多滤膜/单滤膜场合，画面表示差异\n3.录入信息存储设计(后续扫描、统计分析、生成报告均需要这些信息)","高",5,"王琦","2022-10-30",0.55000000000000004,2.25,"①图片保存位置需要可调整\n②需要结合规程设置调试验证"]
[null,11,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,12,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    阴影矫正\n    2^30大图拼图处理\n\n\n② 测量性能需要持续后续优化验证"]
[null,13,null,null,null,"自动聚焦：逐点自动聚焦及间隔数点自动聚焦","低",3,"沙永刚","2022-11-30",0.4,1.7999999999999998,"①有参照代码，本系统暂未实现"]
[null,14,null,null,null,"聚焦补偿：根据数个焦点位置确定多个空间平面，不同xy位置交于空间平面的z位置，即判定并计算为焦平面位置","低",5,"沙永刚","2022-11-30",0.4,3,"①有参照代码，本系统暂未实现"]
[null,15,null,"颗粒编辑窗口","弹出","1.可改变颗粒类型、可切换图片为偏光或明场图片\n2.可对图片中颗粒进行添加、删除、切割、连接处理\n3.需要可对操作进行返回、重做、复原处理、可显示原图或编辑图\n4.可重新自动测量计算分析该视场相关颗粒数据","中",25,"王琦","2022-11-30",0.55000000000000004,11.249999999999998,"\n①多个颗粒展示图片慢。\n②颗粒编辑后，不要直径统计分析，需点击重新计算按钮"]
[null,16,null,null,null,"颗粒编辑窗口，涉及相关图像处理：\n1.添加颗粒：手动操作，画轮廓添加（相关测量如何计算？）\n2.删除颗粒：手动操作，框在范围内的部分删除\n3.分割颗粒：手动操作，在框的范围内分割为两个颗粒\n4.连接颗粒：手动操作，在框的范围内拟合连接成一个颗粒","中",14,"洪冰","2022-08-30",0.8,2.7999999999999994,"①林工认为部分操作不友好，后续有定论再研究"]
[null,17,null,"实时预览画面","弹出","1.需要调研在Metis2.0上修改方法(或复制新的预览画面修改）\n2.主要添加偏光明场切换处理、拍照替换图片、实时测量并保存图片处理","高",10,"王琦","2022-10-30",0.6,4,"①需要可以根据选择不同颗粒，动态定位颗粒\n②需要预览窗口在最上边\n③需要实现照片替换功能（涉及处理较多，二期实现）"]
[null,18,null,"高度测量画面","弹出","1.需要参照Metis2.0的预览画面修改\n2.主要添加确定焦平面的处理","中",5,"王琦","2022-11-30",0.6,2,"①需要待新硬件开发完成后，重新修改和调试\n②确认更新高度值（画面和数据库）"]
[null,19,null,"存档确认画面","弹出","1.着重考虑数据存储设计","中",2,"王琦","2022-12-30",0.8,0.39999999999999991,"①需要添加提示框，确认\n②存档后，变为查看模式，编辑等相关相关修改不可用"]
[null,20,null,"检测结果画面","工作区","1.自动分析后，自动打开结果画面并从数据库读取相关分析结果数据\n2.画面复杂度高，展示分为分级模式和图库模式\n3.工具栏命令对展示区的控制实现：如各种筛选过滤、排序、导入导出报告等操作\n4.柱状图实现、图片缩略图一览实现\n5.根据报告模板生成报告文档（报告文件格式？）宋珊珊","高",30,"王琦","2022-12-30",0.8,5.9999999999999982,"\n①测量不同数量的展示时间需要优化\n②分级模式界面优化。\n③图库模式加拉伸长度列\n④图库模式增加最大灰度、平均灰度及灰度差值展示"]
[null,21,"2.项目管理","项目浏览画面","工作区","1.从数据库中读取历史检测项目并展示","中",6,"宋珊珊","2022-12-30",0.8,1.1999999999999997,"①增加刷新按钮。\n②右侧展示与分级模式统一共用一个画面\n③合并的项目展示：右侧展示区右上角需要有数据源连接可查看"]
[null,22,null,"项目合并画面","弹出","1.需要列出可以合并的项目\n2.项目合并处理，并生成新的项目","低",5,"沙永刚","2022-11-30",0.8,0.99999999999999978,"①相关数据合并处理\n②相关数据统计分级处理及展示\n③哪些项目可以合并未实现"]
[null,23,"3.规程管理","规程浏览设置画面","工作区","画面作成：\n1.每个Tab设置内容均需要配置文件进行保存\n2.画面复杂度高，可检索及修改规程，分为多个Tab页设定","高",5,"沙永刚","2022-06-30",0.8,0.99999999999999978]
[null,24,null,null,null,"基本信息画面","高",1,"沙永刚","2022-06-30",0.8,0.19999999999999996]
[null,25,null,null,null,"图片来源：本地图片、项目图库、相机扫描","高",20,"沙永刚","2022-11-30",0.7,6.0000000000000009,"①检测时，项目来源本地图片及项目图库时，需要提供交互窗口"]
[null,26,null,null,null,"信息模板画面","高",12,"沙永刚","2022-07-30",0.8,2.3999999999999995]
[null,27,null,null,null,"执行流程画面：测量区域、物相提取","高",20,"沙永刚","2022-12-30",0.7,6.0000000000000009,"①明场偏光灰度差判定应为或模式\n②阈值设定性能优化，目前单视场\n③碎屑删除系统内置最小值5（但需要有后门配置文件）"]
[null,28,null,null,null,"参数设置画面","高",10,"沙永刚","2022-10-30",0.8,1.9999999999999996,"①明场偏光灰度差判定应为或模式"]
[null,29,null,null,null,"分级设置画面","高",10,"沙永刚","2022-12-30",0.55000000000000004,4.5,"①需要根据标准ISO4406、ISO4407、ISO16232、VDA19.2作成对应内置规程设置（标准分级资料林斌提供）"]
[null,30,null,null,null,"报告模板设置画面","高",1,"沙永刚","2022-10-30",0.8,0.19999999999999996,"①该画面中选择报告模板需要确认是否有必要保留（目前出报告时会有预览画面，可选择不同模板进行预览）"]
[null,31,null,null,null,"浏览画面：规程新建、克隆、导入、导出","高",15,"沙永刚","2022-12-30",0.7,4.5000000000000009,"①规程导入功能、导出未实现\n②需要删除新建功能、增加内置系统规程"]
[null,32,null,"分析范围交互画面","弹出","扫描途中，弹出交互画面，展示拼图后滤膜，让用户设定滤膜分析范围","高",20,"沙永刚","2022-10-30",0.8,3.9999999999999991,"①分析范围交互画面"]
[null,33,null,"拼图设置画面","弹出","1.根据设置参数，动态展示拼图区域预览（背景滤膜轮廓信息）\n2.能实时看到拼图区域所在滤膜位置\n3.能通过鼠标在预览区控制拼图范围位置","高",20,"沙永刚","2022-12-30",0.55000000000000004,9,"①行列不准确，需要调研"]
[null,34,null,"标签选择画面","弹出","1.需要考虑系统内置标签，如客户信息、零部件信息等\n2.需要考虑系统没有的标签，作为新标签，以便输出报表可识别\n3.相关数据库设计重点考虑","中",5,"沙永刚","2022-10-30",0.8,0.99999999999999978]
[2,35,null,"清洁度编码设置画面","弹出","1.检测分析后，进行分级统计时，需要用到该画面设置的信息","中",2,"沙永刚","2022-10-30",0.8,0.39999999999999991]
[null,36,"4.报告模板","报告模板母版设计（单滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",10,"宋珊珊","2022-10-30",0.8,1.9999999999999996,"①需要使用归一化参数\n②追加清洁度编码"]
[null,37,null,"报告模板母版设计（合并滤膜）","弹出","1.报告模板设计及实现（按需求设计一套完整模板模板）","中",8,"宋珊珊","2022-10-30",0.8,1.5999999999999996,"①需要显示多张滤膜概图\n②颗粒图片获取需要重新实现"]
[null,38,null,"报告模板编辑画面","弹出","1.重点是如何关联报表设计器并为清洁度设计报告模板\n2.检测分析后，相关数据如何传给报表模板，并生成报表\n3.需要支持图片（数量动态）、表格（数据动态），树状图，固定信息等\n4.结合项目检测结果输出报告（Metis2.0报告预览画面）","中",30,"宋珊珊","2022-10-30",1,0]
[null,39,"5.系统设置","系统设置菜单","工作区","1.添加菜单、图标、按钮、动作迁移（弹出空画面）","高",2,"宋珊珊","2022-10-30",0.8,0.39999999999999991]
[null,40,null,"常规设置画面","弹出","1.先期只实现日志输出控制，语言及主题先期只有默认（不可选）\n2.日志组件实现\n3.检测结果默认显示设置","高",3,"王新贺","2023-01-13",0.8,0.59999999999999987]
[null,41,null,"存储设置画面","弹出","1.先期只实现本地存储设置，服务器存储只做UI，后续再实现功能","中",1,"沙永刚","2022-10-30",0.8,0.19999999999999996]
[null,42,null,"磁盘清理功能","弹出","1.跳转到需要清理的磁盘目录\n2.通过画面设定清理范围，点击清理按钮，自动完成清理工作","中",1,"沙永刚","2022-12-30",0.8,0.19999999999999996,"①本期实现跳转到需要清理的磁盘目录"]
[null,43,null,"用户信息画面","弹出","1.实现及存储参照Metis2.0","中",3,"沙永刚","2022-10-30",0.8,0.59999999999999987]
[null,44,null,"标尺管理画面","弹出","1.实现及存储参照Metis2.0\n2.但需要将标尺一览的Dock窗口变为Dialog形式\n3.需要改造标尺一览画面：增加样式设定按钮","中",3,"宋珊珊","2022-10-30",1,0]
[null,45,null,"新建标尺画面","弹出","1.实现及存储参照Metis2.0","中",1,"宋珊珊","2022-10-30",1,0]
[null,46,null,"标尺样式画面","弹出","新作成清洁度专用样式设定画面","中",5,"宋珊珊","2022-10-30",0.8,0.99999999999999978,"①考虑自己制作界面进行标尺等颜色设置（自定义文件）。\n②去掉原菜单中的标尺设置按钮。"]
[null,47,null,"快捷键设置画面","弹出","设置功能快捷键","低",1,"宋珊珊","2022-10-30",0.6,0.4,"①目前设定后，部分功能未调用\n②画面只需要列出清洁度相关菜单，其他不需要，如不能实现可去除该画面"]
[null,48,null,"测量设置画面","弹出","1.实现及存储参照Metis2.0，如要调查测量时如何使用","中",1,"宋珊珊","2022-10-30",1,0]
[null,49,null,"聚焦参数设置","弹出","1.实现及存储参照Metis2.0","低",1,"宋珊珊","2022-10-30",1,0]
[null,50,null,"相机设置画面","弹出","1.实现及存储参照Metis2.0\n2.但需要考虑相机设置方案条目的实现（可创建多个条目供选择使用，如偏光的，明场的）","高",20,"王琦","2022-12-30",0.55000000000000004,9,"①目前问题：Metis中阴影矫正功能只能设置一次，不能保存。\n②若采用新型相机，相关设置需要重新调试（不包含开发新相机底层代码工作）"]
[null,51,null,"载物台设置画面","弹出","新型载物台（永新载物台）开发","高",30,"王琦","2022-11-30",0.5,15,"①新型显微镜载物台底层开发"]
[null,52,null,"电机参数设置画面","弹出","1.结合新型载物台实现相关接口","中",10,"王琦","2022-11-30",0.5,5,"①新型显微镜载物台底层开发"]
[null,53,null,"物镜及光源设定画面","弹出","永新显微镜相关设置画面实现","中",3,"宋珊珊","2022-10-30",1,0,"暂定不需要该界面"]
[null,54,null,"客户管理画面","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.8,0.39999999999999991]
[null,55,null,"零部件管理","弹出","1.重点关注数据库存储设计","中",2,"王新贺","2022-10-30",0.8,0.39999999999999991]
[null,56,null,"操作者管理画面","弹出","1.重点关注数据库存储设计","低",3,"王新贺","2022-10-30",0.8,0.59999999999999987]
[null,57,null,"权限管理画面","弹出","1.重点关注数据库存储设计","低",1,"王新贺","2022-10-30",0.8,0.19999999999999996]
[null,58,"6.帮助","帮助目录画面","弹出","1.帮助文档","低",15,"王新贺","2023-01-13",0.05,14.25]
[null,59,null,"关于画面","弹出","1.固定信息","低",1,"王新贺","2022-12-30",0.8,0.19999999999999996]
[null,60,"单体测试","功能测试、异常系测试、连台联调测试",null,null,"高",40,"全体开发者","2023-02-28",0,40]
[null,61,"结合测试","功能测试、软件稳定性、准确性及性能测试",null,null,"高",30,"杨欣瑜\n开发者对应","2023-02-28",0,30]

{"sheet":"额外作业","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":6},{"$f":"SUM(G3:G33)","v":108.5}]
[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,"永新样品台","根据Metis2.0相关规则开发永新样品台接口。","王琦",10,8]
[null,23,"拍照","为图像识别拍偏光和明场的图片。","王琦",10,10]