PPK计算模板

PROCESSISCAPABLE'01PSW'!A21'07CAV'!A6'01PSW'!H6'01PSW'!A6'01PSW'!A14'01PSW'!D10'01PSW'!A8LOCATIONFactoryDepartmentPARTDrawingNO.ProjsctNameDimensionTOOLToolnumberCavitiesDIMENSIONDescriptionNominalPLUSLSL规格值SPECEng.chg.levelPPK（ProcessCapability）StudiesReportMicrometer3.35+0.04/-0.050.043.33.352.00003.00004.00005.00006.00007.00008.00009.000010.000011.00003.35002345678910112.00003.00004.00005.00006.00007.00008.00009.000010.00003.323.3253.333.3353.343.3453.353.3553.363.3653.371234567891011AverageAverage(Xchart)DataValuesUCLxAveXLCLx0.03832.00003.00004.00005.00006.00007.00008.00009.000010.000023456789100.010.0150.020.0250.030.0350.040.045RangeRange(Rchart)Twosidedspec(bilateral)Onesided(MIN)Onesided(MAX)n12345678913.363.353.373.343.363.353.353.363.3523.363.363.353.363.343.343.363.343.3533.343.353.353.343.353.353.363.353.3443.353.363.353.363.353.343.353.363.3353.363.353.363.353.353.353.343.343.35Average3.3543.3543.3563.353.353.3463.3523.353.344Range0.020.010.020.020.020.010.020.020.02123Author：NOTES:00.0050.011234567891011DataValuesUCLrAveRLCLrPROCESSISCAPABLEPROCESSINFORMATIONSignificanttrendsofdatapoints:X图ChartR图ChartRUNLENGTH22HOWMANYRUNS87UnitmmRUNLENGTH33MINUSHOWMANYRUNS41USLOutofcontrollimits00SmcomagnetsPPK（ProcessCapability）StudiesReportGrindingmachineIncreasingDecreasing0.040.053.353.393.363410.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00001112131415161718192021222324253.336610.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.0000111213141516171819202122232425DataPointsAverage(Xchart)10.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.0000111213141516171819202122232425Range(Rchart)101112131415161718193.353.363.363.363.343.343.353.343.363.353.353.353.353.353.353.353.353.343.363.343.353.343.353.363.363.353.363.353.353.343.353.353.353.353.343.353.363.363.343.343.363.343.363.343.353.353.353.353.353.353.3523.3483.3543.3523.3483.3483.3543.3483.3523.3440.010.020.010.020.020.010.010.020.020.01Checker:0.0168111213141516171819202122232425DataPointsJL2.4---07Date:DESCRIPTIVESTATISTICSVALUESPPU1.68113Numberofreadings125PPL2.10142Lowerspeclimit(LSL)3.3000Nominal3.3500Upperspeclimit(USL)3.3900Totalsum418.7500Averagereadings(X)3.3500Maximum3.3700Minimum3.3300ReadingsbelowLSL0ReadingsaboveUSL0AverageRange(R)0.0168D2ValueN=52.3260Uppercapabilityindex(CPU)1.8460D11Lowercapabilityindex(CPL)2.3075M11Capabilityindex(Cp)2.0768UCLxProcessCapability(Cpk)1.8460AveXCapabilityratio(CR)2.6051LCLxStdDeviation(n-1)0.0079UCLrStdDeviation(n)0.0079AveRVariance(n-1)0.0001LCLrVariance(n)0.0001XGoUPPerformanceindex(PP)1.8913XAcumUPPerformanceratio(PR)0.5287XAcumDwPerformanceindex(Ppk)1.6811XMaxUPXMaxDownXHMUpsXHMDwsRGoUPRAcumUPRAcumDwRMaxUPRMaxDownRHMUpsRHMDwssample#AboveUCLxBelowLCLxAboveUCLrPPK（ProcessCapability）StudiesReport2013/9/5256529203040506070FrequencyHISTOGRAMBelowLCLrXAboveXBelowRAboveRBelowXACounter202122232425XBCounter3.333.353.363.353.353.36RACounter3.353.353.353.333.343.35RBCounter3.353.373.353.343.353.343.333.353.353.353.363.35MaxXA3.353.363.353.353.353.35MaxXB3.3423.3563.3523.3443.353.35MaxRA0.020.020.010.020.020.02MaxRBTochart:DataX0025025035023025035038056061000003230ADDING040000200103.333.343.343.353.353.363.363.373.373.383.38SubgroupsDataPointsDistributionShape3.330.00AJ040COUNTIF($B$40:$U$44,3.33)3.333.344.00AJ054COUNTIF($B$40:$U$44,3.335)3.343.344.00AJ060COUNTIF($B$40:$U$44,3.34)3.343.3529.00AJ0725COUNTIF(B56:Z60,3.345)3.353.3529.00AJ080COUNTIF(B56:U60,3.35)3.353.3694.00AJ0965COUNTIF(N56:Z60,3.355)3.363.3694.00AJ100COUNTIF(B56:X60,3.36)3.363.37123.00AJ1129COUNTIF($B$40:$U$44,3.365)3.373.37123.00AJ120COUNTIF($B$40:$U$44,3.37)3.373.38125.00AJ132COUNTIF($B$40:$U$44,3.375)3.383.38125.00AJ140COUNTIF($B$40:$U$44,3.38)125AveX3.350UCLx3.363Min3.3303.330LCLx3.337Max3.3703.370AveR0.017UCLr0.038Diff0.040DataValuesLCLr0.000Class0.0053.3633.3633.3633.3633.3633.3633.3633.3633.3633.3633.3503.3503.3503.3503.3503.3503.3503.3503.3503.3503.3373.3373.3373.3373.3373.3373.3373.3373.3373.3370.0380.0380.0380.0380.0380.0380.0380.0380.0380.0380.0170.0170.0170.0170.0170.0170.0170.0170.0170.0170.0000.0000.0000.0000.0000.0000.0000.0000.0000.000010001001XAcumUP010001001XAcumDw1010101202AF293AF3084010001000RAcumUP010001000RAcumDw1000100012AF363AF3771123456789100AJ160AJ170AJ180AJ191110001001000001001010111011100100010001123111111101111111111112311231011111111133点连续在均值中心线之上consecutivedatapointsaboveaverageX22点连续在均值中心线之下consecutivedatapointsbelowaverageX33点连续在极差中心线之上consecutivedatapointsaboveaverageR22点连续在极差中心线之下consecutivedatapointsbelowaverageR3.353.353.363.353.353.353.353.353.343.35已超出规定范围,产品不合格--初始过程能力不足-均值有向上的趋势-TrendUP(X)-均值有向下的趋势TrendDOWN(X)-均值超出控制限Outofcontrollimits(X)-极差有向上的趋势TrendUP(R)-极差有向下的趋势TrendDOWN(R)-极差超出控制限Outofcontrollimits(R)-过程变异Proc.variation(Ppnot1.67)-过程不集中或能力不够Proc.notcentered/capable(Ppknot1.67)-过程能力不足，需要提高Processsubstandard,needsimprove