MSA测量系统分析表格模板第五版(自动计算)表格文件下载.xls

1、A2101PSW!A5401PSW!H54GAGESYSTEMNEEDSIMPROVEMENTPartnumberSL001Partname凸轮轴链轮Plant:Characteristic:4.3Gagenumber0013474Coordby:QCDepartmentTolerance:0.1000mmGagename:百分表Phone#Tolerance（Tol）0.1000mmGageECL/revisionDateOPERATORPARTRESULTSTRIAL#12345678910AVGA14.3354.2984.2874.3364.3524.3124.2874.2834.295

2、4.274A14.30624.3324.2974.2864.3344.3504.3104.2864.2844.2964.273A24.30534.3334.2984.2864.3314.3514.3134.2874.2834.2954.274A34.305Average4.33334.29774.28634.33374.35104.31174.28674.28334.29534.2737XA4.30527Range0.00300.00100.00100.00500.00200.00300.00100.00100.00100.0010RA0.00190B14.3334.2954.2854.335

3、4.3534.31304.2874.2844.2944.275B14.3054024.3364.2904.2874.3374.3524.31204.2854.2854.2934.276B24.3053034.3324.2934.2874.3364.3524.31404.2864.2854.2954.275B34.30550Average4.33374.29274.28634.33604.35234.31304.28604.28474.29404.2753XB4.30540Range0.00400.00500.00200.00200.00100.00200.00200.00100.00200.0

4、010RB0.00220C14.3334.2964.2864.3354.3514.31304.2864.2854.2954.275C14.3055024.3304.2944.2874.3364.3524.31404.2874.2844.2964.274C24.3054034.3324.2954.2874.3374.3534.31304.2854.2834.2954.275C34.30550Average4.33174.29504.28674.33604.35204.31334.28604.28404.29534.2747XC4.30547Range0.00300.00200.00100.002

5、00.00200.00100.00200.00200.00100.0010RC0.00170PartAvg4.33294.29514.28644.33524.35184.31274.28624.28404.29494.2746xPART=4.30538PartRangeRPART=0.07722R=RA+RB+RC/Noofoperators=0.00190+0.00220+0.00170/3R=0.00193XDIFF=Max（X）ABC-Min（X）ABC=4.30547-4.30527XDIFF=0.00020UCLR=R*D4=0.00193*2.580UCLR=0.00499LCLR

6、=R*D3=0.00193*0.000LCLR=0.00000OPERATORNAMENOTE:IthasbeenstatisticallyproventhattheTolerance MethodisbetterA李峰todeterminemeasurementequipmentreliability.EvenwithnegativeB王鹏Kurtosisdatasets,therecordedmeasurementswillbelessthan1%awayC叶军fromthetruevalueifGR&Risbelow30%.ContactQualityGroupifyouGOODUNTI

7、LGAGEECL/revisionCHANGEneedmoreinformation.FROM DATA SHEET:R=0.00193XDIFF=0.00020RPART=0.07722MeasurementUnitAnalysisBased on the TOLERANCE MethodRepeatibility-Equipment Variation（EV）EV=R*K1%EV=100EV/TolEV=0.00590TrialsK1%EV=5.9033.05Reproducibility-Appraiser Variation（AV）AV=（XDIFF*K2）2-（EV2/nr）（npa

8、rts,rtrials）%AV=100AV/TolAV=0.00000OperK2%AV=0.0032.70Repeatibility&Reproducibility（R&R）%R&R=100R&R/TolR&R=（EV2+AV2）%R&R=5.90R&R=0.00590Part Variation（PV）PV=RPART*K3PartsK3%PV=100PV/TolPV=0.12510101.62%PV=125.10Total Variation（TV）1.62TV=（R&R2+PV2）#REF!GAGE IS REJECTEDTV=0.12524RANGES OUT OF UCLrUsin

9、g TOLERANCE methodUsing Part to Part variationDETERMINETHERISKPRIORITYNUMBER（RPN）FROMTHEFMEAASSOCIATEDBREAKPOINT=RPN#x%GRR/100WITHTHEDIMENSIONBEINGGAGED.TYPETHERPN#UNDERTHE RPN#FIELDPROVIDED（RIGHT）ANDFOLLOWINSTRUCTIONOFUSAGEINNEXTROW:1.18=20.0 x0.05897CONCLUSIONIS.GAGESYSTEMNEEDSIMPROVEMENTNotes:Gui

10、delines for acceptance of gage repeatability and reproducibility（%R&R）:UNDER 10%ERROR:Gage system OK10%to 30%ERROR:May be acceptable based upon importance of application.Calculate breakpoint=RPN x（%Gage R&R/100）andcheck that is less than 37.8 and（%Gage R&R）less than 30%.See next page for conclusion

11、of usage.OVER 30%ERROR:Gage system needs improvement.Identify the problems and have them corrected.Average Run Chart123456789104.23004.25004.27004.29004.31004.33004.35004.3700PartAverage李峰王鹏叶军0.00499Range Chart by operator123456789100.000000.001000.002000.003000.004000.005000.00600PartRange李峰王鹏叶军UCL

12、rREPEATIBILITYANDREPRODUCIBILITYANALYSISREPORTPart CertificationNONDESTRUCTIVETESTPLEASESPECIFYTHEFOLLOWINGPARAMETERSANDCOMPLETETHEFORMACCORDINGLYPARAMETERSAREK1NumberofTrialsMustbeeither2or33OKK2NumberofOperatorsMustbeeither2or33OKK3NumberofPartsCanbeanyvaluebetween2and1010OKOutofUCLrA4B201PSW!百分表Phone#Tolerance（Tol）0.1000mmGageECL/revisionDateUsing TOLERANCE methodUsing Part to Part variation