{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["FMEA A1","Sheet1"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"FMEA A1","index":0,"n_rows":70,"n_cols":24,"rows_kept":70,"merged":[[0,1,0,20],[1,1,1,20],[2,7,3,7],[2,8,3,9],[2,10,2,14],[2,15,2,20],[3,1,3,6],[3,10,3,14],[3,15,3,20],[4,1,4,6],[4,7,4,9],[4,10,4,14],[4,15,4,20],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,14],[5,15,6,15],[5,16,5,20],[17,1,17,19],[18,2,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[19,2,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[20,2,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[21,2,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[23,1,24,14],[26,1,26,2],[26,3,26,8],[26,9,26,13],[27,0,28,0],[27,1,27,2],[27,3,27,8],[27,9,27,13],[28,1,28,2],[28,3,28,8],[28,9,28,13],[29,1,29,2],[29,3,29,8],[29,9,29,13],[30,1,30,2],[30,3,30,8],[30,9,30,13],[31,1,31,2],[31,3,31,8],[31,9,31,13],[32,1,32,2],[32,3,32,8],[32,9,32,13],[33,1,33,2],[33,3,33,8],[33,9,33,13],[34,1,34,2],[34,3,34,8],[34,9,34,13],[35,1,35,2],[35,3,35,8],[35,9,35,13],[36,1,36,2],[36,3,36,8],[36,9,36,13],[37,1,37,2],[37,3,37,5],[37,6,37,8],[38,1,38,2],[38,3,38,5],[38,6,38,8],[39,1,40,20],[42,1,43,2],[42,3,43,8],[42,9,42,13],[42,14,43,18],[42,19,43,20],[43,11,43,13],[44,1,44,2],[44,3,44,8],[44,11,44,13],[44,14,44,18],[44,19,44,20],[45,1,45,2],[45,3,45,8],[45,11,45,13],[45,14,45,18],[45,19,45,20],[46,1,46,2],[46,3,46,8],[46,11,46,13],[46,14,46,18],[46,19,46,20],[47,1,47,2],[47,3,47,8],[47,11,47,13],[47,14,47,18],[47,19,47,20],[48,1,48,2],[48,3,48,8],[48,11,48,13],[48,14,48,18],[48,19,48,20],[49,1,49,2],[49,3,49,8],[49,11,49,13],[49,14,49,18],[49,19,49,20],[50,1,50,2],[50,3,50,8],[50,11,50,13],[50,14,50,18],[50,19,50,20],[51,1,51,2],[51,3,51,8],[51,11,51,13],[51,14,51,18],[51,19,51,20],[52,1,52,2],[52,3,52,8],[52,11,52,13],[52,14,52,18],[52,19,52,20],[53,1,53,2],[53,3,53,8],[53,11,53,13],[53,14,53,18],[53,19,53,20],[54,1,54,2],[54,3,54,20],[56,1,57,10],[59,1,59,4],[59,5,59,8],[60,1,61,4],[60,5,60,8],[61,5,61,8],[62,1,63,4],[62,5,62,8],[63,5,63,8],[64,1,66,4],[64,5,64,8],[65,5,65,8],[66,5,66,8],[67,1,68,4],[67,5,67,8],[68,5,68,8],[69,1,69,4],[69,5,69,8]],"flags":["formulas_cached_only"]}
[null,"潜在失效模式及后果分析"]
[null,"                   "]
[{"$nulls":7},"设计或过程责任部门:",null,null,"编号:",{"$nulls":4},"页码:            共 页"]
[null,"项目名称 ：",{"$nulls":8},"编制:    ",{"$nulls":4},"电话:   "]
[null,"核心小组："]
[null,"序号","     项目/功能","  潜在失效模式"," 潜在失效后果","严\n重\n度Sev","Class级别"," 潜在失效起因/机理","Occ频度"," 现行设计或过程控制                                                                               预防"," 现行设计或过程控制                                                               探测","Det探测度","RPN风险顺序数"," 建议措施",null,"责任目标及完成日期","Reasons措施结果"]
[{"$nulls":16},"采取的措施","S","O","D","R     P     N"]
[{"$nulls":12},"",{"$nulls":7},"",null,"△","▲"]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[{"$nulls":12},"",{"$nulls":7},""]
[]
[null,"版本\nRev.","变更内容",{"$nulls":5},"日期 Date",null,"编制",null,"审核",null,"批准"]
[null,"A0"]
[null,"A1","RPN风险顺序数、Reasons措施结果（RPN）加入计算公式；\n级别改为选△、▲（▲为关键特性，△为非关键特性）；严重度增加一套评分标准、不易探测度（D）评分增加推荐评分标准、频度（O）评分标准增加Cpk评分标准。"]
[]
[]
[null,"推荐的严重度（S）评分"]
[]
[]
[null,"后果",null,"评定准则一（顾客的后果）",{"$nulls":5},"评定准则二（制造∕装配的后果）",{"$nulls":4},"严重度S"]
[null,"无警告的严重危害",null,"这是一种非常严重的失效形式，它是在没有任何失效预兆的情况下影响到产品使用安全或违反了有关法律法规",{"$nulls":5},"当潜在的失效模式在无警告的情况下影响影响安全运行和∕或涉及不符合政府法规的情形时，严重定级非常高或可能在无警告的情况下对（机器或总成）操作者造成危害。",{"$nulls":4},10]
[null,"有警告的严重危害",null,"这是一种非常严重的失效形式，它是在有失效预兆的情况下影响到产品使用安全或违反了有关法律法规",{"$nulls":5},"当潜在的失效模式在有警告的情况下影响产品安全运行和∕或涉及不符合政府法规的情形时，严重定级非常高。或可能在有警告的情况下对（机器或总成）操作者造成危害。",{"$nulls":4},9]
[null,"很高",null,"产品（或系统）不能运行，丧失基本功能，顾客很不满意",{"$nulls":5},"产品∕项目不能工作（丧失基本功能）或100﹪的产品可能需要报废，或者产品\n∕项目需在返修部门返修 1 小时以上。",{"$nulls":4},8]
[null,"高",null,"产品（或系统）能运行，但性能下降，顾客不满意",{"$nulls":5},"产品∕项目可能运行但性能水平下降。顾客非常不满意，或产品需进行分检，一部分（小于100﹪）需报废，或产品∕项目在返修部门进行返修的时间在 0.5-1小时之间。",{"$nulls":4},7]
[null,"中等",null,"产品（或系统）能运行，但部分部件不能工作，\n顾客感觉不方便",{"$nulls":5},"产品∕项目可运行但舒适性∕便利性项目不能运行。顾客非常不方便。一部分（小于100%）产品可能需要报废，不需分检或者产品∕项目需在返修部门返修少于 0.5 小时。",{"$nulls":4},6]
[null,"低",null,"产品（或系统）能运行，但部分项目性能下降\n，顾客感觉有些不方便",{"$nulls":5},"产品／项目可运行，但舒适性／方便性项目的性能下降，顾客有些不满意。或100﹪的产品可能需要返工或者产品∕项目在线下返修，不需送往返修部门处理。",{"$nulls":4},5]
[null,"很低",null,"配合、或外观或杂声等项目不符合要求，\n大多数顾客发现有缺陷",{"$nulls":5},"配合、或外观或杂声等项目不舒服。多数（75%以上）顾客能发觉缺陷。或产品可能需要分检，无需报废，当部分产品（小于 100%）需返工。",{"$nulls":4},4]
[null,"轻微",null,"配合、外观或杂声等项目不符合要求，\n有一半顾客发现有缺陷",{"$nulls":5},"配合、外观或杂声等项目不舒服。50%的顾客能发觉缺陷。\n或部分（小于 100%）产品可能需要返工，无需报废，在生产线上其它工位返工。",{"$nulls":4},3]
[null,"很轻微",null,"配合、外观或杂声等项目不符合要求，但很少有顾客发现有缺陷",{"$nulls":5},"配合、外观或杂声等项目不舒服，有辨识力的顾客（25%以下）能发觉缺陷。或部分（小于 100%）产品可能需要返工，无报废，在生产线上原工位返工。",{"$nulls":4},2]
[null,"无",null,"无影响",{"$nulls":5},"无可辨识的影响。或对操作或操作者而言有轻微的不方便或无影响。",{"$nulls":4},1]
[]
[]
[null,"推荐的不易探测度（D）评分"]
[]
[]
[null,"探测性",null,"利用现行过程控制方法找出存在缺陷的可能性",{"$nulls":5},"检查类别",{"$nulls":4},"探测方法的推荐范围",{"$nulls":4},"不易探测度"]
[{"$nulls":9},"A ","B","C"]
[null,"几乎不可能",null,"没有已知的控制方法能找出失效模式",{"$nulls":7},"×",null,null,"不能探测或没有检查",{"$nulls":4},10]
[null,"很微小",null,"现行的控制方法找出失效模式的可能性很微小",{"$nulls":7},"×",null,null,"只能通过间接或随机检查来实现控制",{"$nulls":4},9]
[null,"微小",null,"现行的控制方法找出失效模式的可能性微小",{"$nulls":7},"×",null,null,"只通过目测检查来实现控制",{"$nulls":4},8]
[null,"很小",null,"现行的控制方法找出失效模式的可能性很小",{"$nulls":7},"×",null,null,"只通过双重目测检查来实现控制",{"$nulls":4},7]
[null,"小",null,"现行的控制方法找出失效模式的可能性小",{"$nulls":6},"×","×",null,null,"用制图的方法，如SPC（统计过程控制）来实现控制。",{"$nulls":4},6]
[null,"中等",null,"现行的控制方法找出失效模式的可能性中等",{"$nulls":6},"×",{"$nulls":3},"控制基于零件离开工位后的计量测量，或者零件离开工位后100%的止∕通测量。",{"$nulls":4},5]
[null,"中上",null,"现行的控制方法找出失效模式的可能性中等偏上",{"$nulls":5},"×","×",{"$nulls":3},"在后续工位上的误差探测，或在作业准备时进行测量和首件检查（仅适用于作业准备的原因）。",{"$nulls":4},4]
[null,"高",null,"现行的控制方法找出失效模式的可能性高",{"$nulls":5},"×","×",{"$nulls":3},"在工位上的误差探测，或利用多层验收在后续工序上进行误差探测：供应、选择、安装、确认。不能接受有差异的零件。",{"$nulls":4},3]
[null,"很高",null,"现行的控制方法找出失效模式的可能性很高",{"$nulls":5},"×","×",{"$nulls":3},"在工位上的误差探测，（自动测量并自动停机）。不能通过有差异的零件。",{"$nulls":4},2]
[null,"几乎肯定",null,"现行工艺控制方法几乎肯定能找出失效模式。",{"$nulls":5},"×",{"$nulls":4},"由于有关项目已通过过程∕产品设计采用了防错措施，有差异的零件不可能产出。",{"$nulls":4},1]
[null,"备注",null,"检验类别： A： 防错 B： 量具 C： 人工检验"]
[]
[null,"推荐的频度（O）评分标准"]
[]
[]
[null,"失效发生的可能性",{"$nulls":3},"可能的失效概率",{"$nulls":3},"CPK","频度（O）"]
[null,"很高：失效几乎是不可避免的",{"$nulls":3},"≥1/2",{"$nulls":3},"≤0.32",10]
[{"$nulls":5},0.3333333333333333,{"$nulls":3},"≥0.32",9]
[null,"高：反复发生的失效",{"$nulls":3},0.125,{"$nulls":3},"≥0.51",8]
[{"$nulls":5},"1/20",{"$nulls":3},"≥0.65",7]
[null,"中等：偶尔发生的失效",{"$nulls":3},"1/80",{"$nulls":3},"≥0.83",6]
[{"$nulls":5},"1/400",{"$nulls":3},"≥1.01",5]
[{"$nulls":5},"1/2000",{"$nulls":3},"≥1.16",4]
[null,"低",{"$nulls":3},"1/15000",{"$nulls":3},"≥1.33",3]
[{"$nulls":5},"1/150000",{"$nulls":3},"≥1.5",2]
[null,"极低：失效不太可能发生",{"$nulls":3},"≤1/1500000",{"$nulls":3},"≥1.67",1]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}