MSA测量系统分析表格模板第五版(自动计算)表格文件下载.xls
《MSA测量系统分析表格模板第五版(自动计算)表格文件下载.xls》由会员分享,可在线阅读,更多相关《MSA测量系统分析表格模板第五版(自动计算)表格文件下载.xls(2页珍藏版)》请在冰点文库上搜索。
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.2954.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.3354.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.0010RB0.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.00200.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=R*D3=0.00193*0.000LCLR=0.00000OPERATORNAMENOTE:
IthasbeenstatisticallyproventhattheToleranceMethodisbetterA李峰todeterminemeasurementequipmentreliability.EvenwithnegativeB王鹏Kurtosisdatasets,therecordedmeasurementswillbelessthan1%awayC叶军fromthetruevalueifGR&
Risbelow30%.ContactQualityGroupifyouGOODUNTILGAGEECL/revisionCHANGEneedmoreinformation.FROMDATASHEET:
R=0.00193XDIFF=0.00020RPART=0.07722MeasurementUnitAnalysisBasedontheTOLERANCEMethodRepeatibility-EquipmentVariation(EV)EV=R*K1%EV=100EV/TolEV=0.00590TrialsK1%EV=5.9033.05Reproducibility-AppraiserVariation(AV)AV=(XDIFF*K2)2-(EV2/nr)(nparts,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.00590PartVariation(PV)PV=RPART*K3PartsK3%PV=100PV/TolPV=0.12510101.62%PV=125.10TotalVariation(TV)1.62TV=(R&
R2+PV2)#REF!
GAGEISREJECTEDTV=0.12524RANGESOUTOFUCLrUsingTOLERANCEmethodUsingParttoPartvariationDETERMINETHERISKPRIORITYNUMBER(RPN)FROMTHEFMEAASSOCIATEDBREAKPOINT=RPN#x%GRR/100WITHTHEDIMENSIONBEINGGAGED.TYPETHERPN#UNDERTHERPN#FIELDPROVIDED(RIGHT)ANDFOLLOWINSTRUCTIONOFUSAGEINNEXTROW:
1.18=20.0x0.05897CONCLUSIONIS.GAGESYSTEMNEEDSIMPROVEMENTNotes:
Guidelinesforacceptanceofgagerepeatabilityandreproducibility(%R&
R):
UNDER10%ERROR:
GagesystemOK10%to30%ERROR:
Maybeacceptablebaseduponimportanceofapplication.Calculatebreakpoint=RPNx(%GageR&
R/100)andcheckthatislessthan37.8and(%GageR&
R)lessthan30%.Seenextpageforconclusionofusage.OVER30%ERROR:
Gagesystemneedsimprovement.Identifytheproblemsandhavethemcorrected.AverageRunChart123456789104.23004.25004.27004.29004.31004.33004.35004.3700PartAverage李峰王鹏叶军0.00499RangeChartbyoperator123456789100.000000.001000.002000.003000.004000.005000.00600PartRange李峰王鹏叶军UCLrREPEATIBILITYANDREPRODUCIBILITYANALYSISREPORTPartCertificationNONDESTRUCTIVETESTPLEASESPECIFYTHEFOLLOWINGPARAMETERSANDCOMPLETETHEFORMACCORDINGLYPARAMETERSAREK1NumberofTrialsMustbeeither2or33OKK2NumberofOperatorsMustbeeither2or33OKK3NumberofPartsCanbeanyvaluebetween2and1010OKOutofUCLrA4B201PSW!
百分表Phone#Tolerance(Tol)0.1000mmGageECL/revisionDateUsingTOLERANCEmethodUsingParttoPartvariation