CPK、PPK和SPC(X-R控制图)模板

,,,,,,,过程能力认证报告,,,,,,,,,,,,,[注意查看第2页],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

规格设定：,,,,,,,,,单组数据个数,,,,5,,,过程通知,,,,,,,,,,1,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,

,,,,,,,,,,,,,,,,数据趋势,,,X值,R值,,Xbar,LowerR,UpperR,,,,,,,"""",,35.94415,35.9433,35.945,1,AJ04,1,,,,0,0,0,0,AS04,0,AA3=0ifnone,,,,,,,

部门,,,,,,,,统计,,,,日期,,,,增加,运转周期,,3,3,n,a2,d3,d4,,,,PPU,-3476.123718,,,,35.94585,35.945,35.9467,2,AJ05,1,,,,0,0,0,0,AS05,0,AA3=1ifbilateral,,,,,,,

零件图号,,,,,,,,审核,,,,日期,,,,,,,1,1,2,1.88,0,3.267,,,,PPL,3476.123718,,,,35.94755,35.9467,35.9484,9,AJ06,7,,,,0,0,0,0,AS06,0,AA3=2ifMin,,,,,,,

零件名称,,,,,,,,操作人员,,,,,,,,减少,运转周期,,3,3,3,1.023,0,2.574,,,,,,,,,35.94925,35.9484,35.9501,27,AJ07,18,,,,0,0,0,0,AS07,0,AA3=3ifMax,,,,,,,

检测器具,,,,,,,,设备标号,,,,,,,,,,,3,3,4,0.729,0,2.282,,,,,,,,,35.95095,35.9501,35.9518,49,AJ08,22,,,,0,0,0,0,AS08,0,,,,,,,,

描述,,,,,,,,,,,单位,,,,,失控限制,,,0,0,5,0.577,0,2.114,,,,,,,,,35.95265,35.9518,35.9535,74,AJ09,25,,,,0,0,0,0,AS09,0,,,,,,,,

公称尺寸,,,,,,上公差,,,,,下公差,,,,,连续数据高于平均值,,,3,4,6,0.483,0,2.004,,,,,,,,,35.95435,35.9535,35.9552,93,AJ10,19,,,,0,0,0,0,AS10,0,,,,,,,,

下限尺寸,,,0.0,,,名义尺寸,,0.0,,,上限尺寸,,0.0,,,连续数据低于平均值,,,3,3,7,0.419,0.076,1.924,,,,,,,,,35.95605,35.9552,35.9569,106,AJ11,13,,,,0,0,0,0,AS11,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,8,0.373,0.136,1.864,,,,,,,,,35.95775,35.9569,35.9586,117,AJ12,11,,,,0,0,0,0,AS12,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,9,0.337,0.184,1.816,,,,,,,,,35.95945,35.9586,35.9603,123,AJ13,6,,,,0,0,0,0,AS13,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,10,0.308,0.223,1.777,,,,,,,,,35.96115,35.9603,35.962,125,AJ14,2,,,,0,0,0,0,AS14,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,123,,,,,,,,,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,1to5,0.577,0,2.114,,,,,,,AveX,35.953032,,UCLx,35.9579942,,Min,35.945,0,,,LHterm,RHterm,Lowend,Highend,Min,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,6andup,,,,,,,,,,,,,LCLx,35.9480698,,Max,35.962,125,,,0,0,0,0,Max,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,Final,0.577,0,2.114,,,,,,D11,AveR,0.0086,,UCLr,0.0181804,,Diff,0.017,,,,,,,,Diff,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,M11,DataValues,,,LCLr,0,,Class,0.0017,,,,,,,,Class,0,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,UCLx,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942,35.9579942

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,AveX,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032,35.953032

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,LCLx,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698,35.9480698

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,UCLr,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804,0.0181804

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,AveR,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086,0.0086

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,LCLr,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XGoUP,,1,0,1,1,0,1,0,1,0,1,0,0,1,0,0,1,0,1,0,1,0,1,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XAcumUP,,1,0,1,2,0,1,0,1,0,1,0,0,1,0,0,1,0,1,0,1,0,1,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XAcumDw,,0,1,0,0,1,0,1,0,1,0,1,2,0,1,2,0,1,0,1,0,1,0,1,2

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XMaxUP,3,AF29,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XMaxDown,3,AF30,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XHMUps,1,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XHMDws,3,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RGoUP,,0,1,0,0,1,0,1,0,1,0,0,1,1,0,1,0,0,1,0,1,0,1,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RAcumUP,,0,1,0,0,1,0,1,0,1,0,0,1,2,0,1,0,0,1,0,1,0,1,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RAcumDw,,1,0,0,1,0,1,0,1,0,1,2,0,0,1,0,1,2,0,1,0,1,0,1,2

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RMaxUP,3,AF36,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RMaxDown,3,AF37,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RHMUps,1,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RHMDws,3,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,sample#,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,上控制线UCLx,0,AJ16,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,下控制线LCLx,0,AJ17,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,上控制线UCLr,0,AJ18,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,下控制线LCLr,0,AJ19,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XAbove,0,1,0,1,1,0,1,1,1,0,1,1,0,1,1,0,0,0,1,0,1,1,1,0,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XBelow,1,0,1,0,0,1,0,0,0,1,0,0,1,0,0,1,1,1,0,1,0,0,0,1,1

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RAbove,1,0,1,1,0,0,0,1,0,1,0,0,0,1,1,1,1,0,1,0,1,0,1,1,0

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,RBelow,0,1,0,0,1,1,1,0,1,0,1,1,1,0,0,0,0,1,0,1,0,1,0,0,1

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XACounter,0,1,1,1,2,1,1,2,3,1,1,2,1,1,2,1,1,1,1,1,1,2,3,1,1

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,XBCounter,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,2,3,1,1,1,1,1,1,2

部门,,,,,,,,统计,,,,日期,,,统计描述,,,,数值,,,,,,,,,,,RACounter,1,1,1,2,1,1,1,1,1,1,1,1,1,1,2,3,4,1,1,1,1,1,1,2,1

零件图号,,,,,,,,审核,,,,日期,,,数据个数n,,,,125,,,,,,,,,,,RBCounter,0,1,1,1,1,2,3,1,1,1,1,2,3,1,1,1,1,1,1,1,1,1,1,1,1

零件名称,,,,,,,,操作人员,,,,,,,尺寸下限(LSL),,,,0.0000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

检测器具,,,,,,,,设备标号,,,,,,,公称值,,,,0.0000,,,,,,,,,,,MaxXA,3,3,连续高于均值X数据个数,,,,,,,,,,,,,,,,,,,,,,

描述,,,,,,,,,,,单位,,,,尺寸上限(USL),,,,0.0000,,,,,,,,,,,MaxXB,3,3,连续低于均值X数据个数,,,,,,,,,,,,,,,,,,,,,,

公称尺寸,,,,,,上公差,,,,,下公差,,,,数据总数,,,,"4,494.1290",,,,,,,,,,,MaxRA,4,4,连续高于极差R数据个数,,,,,,,,,,,,,,,,,,,,,,

下限尺寸,,,0.0,,,名义尺寸,,0.0,,,上限尺寸,,0.0,,平均均值(X),,,,35.9530,,,,,,,,,,,MaxRB,3,3,连续低于极差R数据个数,,,,,,,,,,,,,,,,,,,,,,

样本柱状分布图,,,,,,,,控制线柱状分布图,,,,,,,最大值Max,,,,35.9620,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,LSL,,,,USL,,最小值Min,,,,35.9450,,,,,,,,,,,图表数据X,35.9518,35.9538,35.9498,35.9532,35.9546,35.9514,35.954,35.9534,35.9538,35.951,35.955,35.9542,35.9512,35.954,35.9538,35.9516,35.953,35.9528,35.9548,35.952,35.9542,35.9536,35.9546,35.9524,35.9518

,,,,,,,,,,,,,,,低于下限数据个数,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,高于上限数据个数,,,,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,0.0000,,,,0.0000,,平均极差(R),,,,0.0086,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,D2，n=5,n=,5,,2.3260,,,d2value,nfrom2-5,2.326,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,高能力指数(CPU),,,,"-3,241.3470",,,,nfrom6-10,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,低能力指数(CPL),,,,"3,241.3470",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,过程能力指数(Cp),,,,0.0000,,,,,,,,,13,,0,-(X)值连续7点向上-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,过程能力(Cpk),,,,"-3,241.3470",,,,,,,,,13,,0,-(X)值连续7点向下-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,过程比率(CR),,,,#DIV/0!,,,,,,,,,9,,0,-(X)值失控-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,标准偏差(n-1),,,,0.0034,,,,,,,,,13,,0,-(R)值连续7点向上-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,标准偏差(n),,,,0.0034,,,,,,,,,13,,0,-(R)值连续7点向下-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,方差(n-1),,,,0.0000,,,,,,,,,9,,0,-(R)值失控-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,方差(n),,,,0.0000,,,,,,,,,,23,1,-过程极度变化(Pp<1.67)-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,性能指数(PP),,,,0.0000,,,,,,,,,,44,0,-过程能力不足(1.33<=PPk<=1.67，CPk<1.33)-,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,性能比率(PR),,,,#DIV/0!,,,,,,,,,,23,1,过程不规范，需要改进(PPk<1.33)。,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,性能指数(Ppk),,,,"-3,476.1237",,,,,,,,,,,0,-(X)值7点以上连续向下-,,,,,,,,,,,,,,,,,,,,,,,,

分组数据,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,-(X)值7点以上连续向上-,,,,,,,,,,,,,,,,,,,,,,,,

n,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,,,,,,,,,,0,-(R)值7点以上连续向下-,,,,,,,,,,,,,,,,,,,,,,,,

1,35.949,35.956,35.949,35.951,35.956,35.951,35.951,35.956,35.951,35.951,35.953,35.951,35.951,35.951,35.955,35.949,35.951,35.951,35.952,35.953,35.956,35.952,35.951,35.949,35.953,,,,,0,-(R)值7点以上连续向上-,,,,,,,,,,,,,,,,,,,,,,,,

2,35.959,35.957,35.946,35.958,35.954,35.947,35.956,35.947,35.955,35.949,35.952,35.956,35.956,35.957,35.960,35.959,35.953,35.957,35.961,35.947,35.958,35.949,35.953,35.958,35.95,,,70,90,2,FINALCALL,,,,,,,,,,,,,,,,,,,,,,,,

3,35.947,35.952,35.949,35.949,35.955,35.951,35.956,35.956,35.956,35.957,35.960,35.951,35.949,35.960,35.951,35.951,35.960,35.954,35.955,35.952,35.955,35.957,35.954,35.951,35.952,,,,,ADDING,,,,,,,,,,,,,,,,,,,,,,,,,

4,35.951,35.949,35.950,35.953,35.953,35.953,35.953,35.953,35.953,35.948,35.953,35.955,35.949,35.953,35.952,35.951,35.951,35.950,35.950,35.955,35.957,35.954,35.953,35.953,35.956,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

5,35.953,35.955,35.955,35.955,35.955,35.955,35.954,35.955,35.954,35.950,35.957,35.958,35.951,35.949,35.951,35.948,35.950,35.952,35.956,35.953,35.945,35.956,35.962,35.951,35.948,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,-过程极度变化(Pp<1.67)-,,,,,,,,,,,,,,,,,,,,,,,,

均值X,35.9518,35.9538,35.9498,35.9532,35.9546,35.9514,35.954,35.9534,35.9538,35.951,35.955,35.9542,35.9512,35.954,35.9538,35.9516,35.953,35.9528,35.9548,35.952,35.9542,35.9536,35.9546,35.9524,35.9518,,,,,,-过程极度变化(Pp<1.67)-,,,,,,,,,,,,,,,,,,,,,,,,

极差R,0.012,0.008,0.009,0.009,0.003,0.008,0.005,0.009,0.005,0.009,0.008,0.007,0.007,0.011,0.009,0.011,0.01,0.007,0.011,0.008,0.013,0.008,0.011,0.009,0.008,,,,,,-过程极度变化(Pp<1.67)-过程不