CPK过程能力指数表格模板(自动计算)

PROCESSCAPABILITYCERTIFICATIONREPORT(seeifanynotesareonpage2)PartCertificationNumberofreadingspersubgroup5PROCESSINFORMATION'01PSW'!A21'07CAV'!A6'01PSW'!H6'01PSW'!A6'01PSW'!A14'01PSW'!D10'01PSW'!A8Significanttrendsofdatapoints:XChartRChartLOCATIONPlant信帮机械Dept:qualitydept.Date:2010.06.28IncreasingRUNLENGTH23PARTPartnumber:齿轮Partdescription位置度HOWMANYRUNS111DrawingnumberS005Eng.chg.levelDecreasingRUNLENGTH33TOOLToolnumber#CavitiesHOWMANYRUNS24DIMENSIONDescription三坐标测量仪UnitsmmOutofcontrollimits11SPEC0.0PLUS0.2MINUS0.0Consecutivedatapointsaboveavg.97LwrSpecLimit0.00NOMINAL0.00UprSpecLimit0.20Consecutivedatapointsbelowavg.311CPK0.12522.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00000.103723456789101112131415161718192021222324250.08212.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.000000.020.040.060.080.10.120.1412345678910111213141516171819202122232425AverageDataPointsAverage(Xchart)DataValuesUCLxAveXLCLx0.07902.00003.00004.00005.00006.00007.00008.00009.000010.000011.000012.000013.000014.000015.000016.000017.000018.000019.000020.000021.000022.000023.000024.000025.00000.037323456789101112131415161718192021222324250.00000.01000.02000.03000.04000.05000.06000.07000.08000.09000.100012345678910111213141516171819202122232425RangeDataPointsRange(Rchart)DataValuesUCLrAveRLCLrTwosidedspec(bilateral)Onesided(MIN)Onesided(MAX)PROCESSCAPABILITYCERTIFICATIONREPORT(seeifanynotesareonpage2)CPKLOCATIONPlant信帮机械Dept:qualitydept.Date:2010.06.28DESCRIPTIVESTATISTICSVALUESPARTPartnumber:齿轮Partdescription位置度Numberofreadings125DrawingnumberS005Eng.chg.level0Lowerspeclimit(LSL)0.0000TOOLToolnumber0#CavitiesNominal0.0000DIMENSIONDescription三坐标测量仪UnitsmmUpperspeclimit(USL)0.2000SPEC0.0PLUS0.2MINUS0.0Totalsum12.9576LwrSpecLimit0.000NOMINAL0.000UprSpecLimit0.200Averagereadings(X)0.1037HISTOGRAMWITHOUTLIMITSHISTOGRAMWITHLIMITSMaximum0.1364LSLUSLMinimum0.0112ReadingsbelowLSL0ReadingsaboveUSL00.00000.2000AverageRange(R)0.037347D2Valuen=52.3260Uppercapabilityindex(CPU)2.0000Lowercapabilityindex(CPL)2.1520Capabilityindex(Cp)2.0760ProcessCapability(Cpk)2.0000Capabilityratio(CR)0.4817StdDeviation(n-1)0.0158StdDeviation(n)0.0157Variance(n-1)0.0002Variance(n)0.0002Performanceindex(PP)2.1140Performanceratio(PR)0.4730Performanceindex(Ppk)2.0366SUBGROUPSn123456789101112131415161718192010.13210.11260.09870.13580.11230.08420.12580.09840.11250.11870.09850.09130.09520.12320.12310.11230.08960.10320.11230.112320.08430.10210.09840.10850.08940.12560.09540.11230.09250.09450.12450.11580.11560.08420.10250.09630.10230.09560.12350.082330.10320.09440.10260.08750.10520.11250.08750.10280.12350.10250.11230.10290.10210.10650.09630.10230.11250.11630.09580.096740.09850.11350.09740.12330.09130.13640.12390.08460.08530.09850.09750.09870.09260.09850.08920.12350.09530.10580.08640.102550.07640.08480.01120.09210.13210.08750.08740.12540.10580.12540.08950.13580.11020.11250.10560.09560.12110.11230.10210.0987Average0.0990.1010.0820.1090.1060.1090.1040.1050.1040.1080.1040.1090.1030.1050.1030.1060.1040.1070.1040.099Range0.05570.02870.09140.04830.04270.05220.03840.04080.03820.03090.03500.04450.02300.03900.03390.02790.03150.02070.03710.0300n2122232425NOTES10.09870.09120.11230.12350.102520.10980.12540.09690.11250.098730.12350.10280.10250.09520.106540.09590.11250.08540.10580.115850.11250.09870.08750.08790.0963Average0.1080.1060.0970.1050.104Range0.02760.03420.02690.03560.0195编制：批准100000946263112051015202530354045500.0050.0170.0300.0430.0550.0680.0800.0930.1050.1180.130001110221000020406080100120-0.060-0.0200.0200.0600.1000.1400.1800.2200.260READINGSREADINGSREPEATIBILITYANDREPRODUCIBILITYANALYSISREPORTPartCertificationNONDESTRUCTIVETESTPLEASESPECIFYTHEFOLLOWINGPARAMETERSANDCOMPLETETHEFORMACCORDINGLYPARAMETERSAREK1NumberofTrialsMustbeeither2or33OKK2NumberofOperatorsMustbeeither2or33OKK3NumberofPartsCanbeanyvaluebetween2and1010OK'01PSW'!H6'01PSW'!A6'01PSW'!A21'01PSW'!A54'01PSW'!H54PartnumberPartnamePlant：宁波东睦新材料集团股份有限公司CharacteristicGagenumberCoordby闫增儿ToleranceUnitsmmGagenamePhone#0086-0574-87841339Tolerance(Tol)GageECL/revision Date2007/10/9OPERATORPARTRESULTSTRIAL#12345678910AVGA1A12A23A3AverageXARangeRAB1B12B23B3AverageXBRangeRBC1C12C23C3AverageXCRangeRCPartAvgxPART=PartRangeRPART=R=RA+RB+RC/Noofoperators=++/3R=XDIFF=[Max(X)ABC]-[Min(X)ABC]=-XDIFF=UCLR=R*D4=*2.580UCLR=LCLR=R*D3=*0.000LCLR=OPERATORNAMENOTE:IthasbeenstatisticallyproventhattheToleranceMethodisbetterA陈梅莲todeterminemeasurementequipmentreliability.EvenwithnegativeB蒋洪Kurtosisdatasets,therecordedmeasurementswillbelessthan1%awayC任玉珍fromthetruevalueifGR&Risbelow30%.ContactQualityGroupifyouGOODUNTILGAGEECL/revisionCHANGEneedmoreinformation.FROMDATASHEET:R=XDIFF=RPART=MeasurementUnitAnalysisBasedontheTOLERANCEMethodRepeatibility-EquipmentVariation(EV)EV=R*K1%EV=100[EV/Tol]EV=TrialsK1%EV=33.05Reproducibility-Appraiser