SPC-MSA数据生成工具-20180815

PartNumber（零件型号）GageNumber(量规编号)AppraiserA（评价人A）25679098DN002WQPartName（零件名称）GageName(量规名称)AppraiserB（评价人B）9098尾管带表卡尺ZMCharacteristicClassification（被检测特性分类）GageType(量测内容)AppraiserC（评价人C）特殊特性Spection(规格）：GKMTrials(次数)Parts(零件数)Appraisers（检测人数）Max：DatePerformed（完成日期）3103MIN：2015.3.1112345678910164.8465.0864.9064.6864.8064.9864.9265.1265.0664.9064.928264.8665.1064.9264.7064.8264.9864.9465.1265.0864.9264.944364.8465.1064.9264.6864.8065.0064.9465.1465.0864.9264.942平均值Xbar64.84765.09364.91364.68764.80764.98764.93365.12765.07364.91364.938极差R0.0200.0200.0200.0200.0200.0200.0200.0200.0200.0200.020164.8665.1064.9264.7064.8265.0064.9265.1265.0864.9264.944264.8465.0864.9264.7064.8265.0064.9465.1465.0664.9064.940364.8665.1064.9264.7064.8265.0064.9465.1465.0864.9264.948平均值Xbar64.85365.09364.92064.70064.82065.00064.93365.13365.07364.91364.944极差R0.0200.0200.0000.0000.0000.0000.0200.0200.0200.0200.012164.8665.1064.9264.7064.8265.0064.9465.1465.0864.9064.946264.8665.1064.9264.7064.8065.0064.9465.1265.0864.9064.942364.8665.1064.9064.7064.8265.0064.9465.1465.0864.9264.946平均值Xbar64.86065.10064.91364.70064.81365.00064.94065.13365.08064.90764.945极差R0.0000.0000.0200.0000.0200.0000.0000.0200.0000.0200.00864.85365.09664.91664.69664.81364.99664.93665.13165.07664.91164.942[MAXXp-MINXp]=RPRp=0.4356[RbarA+RbarB+RbarC]/[评价人数=3]=RdoublebarRdoublebar=0.0133[MAXXbar-MINXbar]=XbarDIFFXbarDIFF=0.0067[RdoublebarXD4*]=UCLRUCLR=0.0344[RdoublebarXD3*]=LCLRLCLR=0.0000C零件平均值（Xp）XbarofPats*2次试验时D4=3.267，3次试验时D4=2.574。7次试验以内D3=0；UCLR代表单个的R的极限*圈出极限的值，查明原因XXXXXXXXXXXX有限公司MSAAnalyseReport（GR&R）-DataSheet评价人/试验次数Appraisers/Times零件Parts平均值XbarABPrepared：Approve：Page1of9PartNumber（零件型号）GageNumber(量规编号)AppraiserA（评价人A）25679098DN002WQPartName（零件名称）GageName(量规名称)AppraiserB（评价人B）9098尾管带表卡尺ZMCharacteristicClassification（被检测特性分类）GageType(量测内容)AppraiserC（评价人C）特殊特性Spection(规格）：GKMTrials(次数)Parts(零件数)Appraisers（检测人数）Max：DatePerformed（完成日期）3103MIN：2015.3.11XXXXXXXXXXXX有限公司MSAAnalyseReport（GR&R）-DataSheetMeasurementUnitAnalysis/测量单元分析%总变差TotalVariation（TV）EquipmentVariation（EV）/重复性—设备变差EV=RdoublebarxK1K1%EV=100(EV/TV)=0.013×0.5910.8862=100×(0.0077/0.137)=0.00770.5908=5.60%AppraisersVariation（AV）/再现性—评价人变差AV=(XbarDIFFxK2)2-(EV2/nr)%AV=100(AV/TV)'=(0.00667×0.523)^2-0.0077^2/(10×3)=100×(0.0032/0.1373)=0.003223=2.33%0.70710.5231Repeatability&Reproducibility（R&R）/重复性和再现性R&R=EV2+AV2%R&R=100(R&R/TV)'=0.008^2+0.003^2零件PartsK3=100×(0.0083/0.1373)=0.008323.65=6.06%PartVariation(PV)/零件变差30.7071PV=RpxK340.5231%PV=100(PV/TV)=0.436×0.314650.4467=100×(0.1370/0.1373)=0.137060.3742=99.82%TotalVariation(TV)/总变差70.3534TV=R&R2+PV280.3375=0.008^2+0.137^290.3249=0.1373100.3146=23AcceptanceCriteria/接受准则：%R&R＜10%,ndc≥5Conclusion:/结论：Thismeasurementsystemcanbeaccepted./此测量系统可以接受。Thismeasurementsystemcan'tbeaccepted./此测量系统不可接受。3评价人AppraisersK2ndc=1.41(PV/GRR)TheNumberofDistinctCategories试验次数TrialTimes2Prepared：Approve：Page2of9PartNumber（零件型号）GageNumber(量规编号)AppraiserA（评价人A）25679098DN002WQPartName（零件名称）GageName(量规名称)AppraiserB（评价人B）9098尾管带表卡尺ZMCharacteristicClassification（被检测特性分类）GageType(量测内容)AppraiserC（评价人C）特殊特性Spection(规格）：GKMTrials(次数)Parts(零件数)Appraisers（检测人数）Max：DatePerformed（完成日期）3103MIN：2015.3.11XXXXXXXXXXXX有限公司MSAAnalyseReport（GR&R）-DataSheet评价人平均值与极差分布趋势图评价人A平均值图与极差图n2345678910D43.272.572.282.1121.921.861.821.78D3*****0.080.140.180.22A21.881.020.730.580.480.420.370.340.31平均值UCL=X+A2*R=LCL=X-A2*R=极差UCL=D4R=0.065LCL=D3R=64.9864.9864.9864.9864.9864.9864.9864.9864.9864.9864.9064.9064.9064.9064.9064.9064.9064.9064.9064.900.0650.0650.0650.0650.0650.0650.0650.0650.0650.065评价人B平均值图与极差图平均值UCL=X+A2*R=LCL=X-A2*R=极差UCL=D4R=0.039LCL=D3R=64.9764.9764.9764.9764.9764.9764.9764.9764.9764.9764.9264.9264.9264.9264.9264.9264.9264.9264.9264.920.0390.0390.0390.0390.0390.0390.0390.0390.0390.039评价人C平均值图与极差图平均值UCL=X+A2*R=LCL=X-A2*R=极差UCL=D4R=0.026LCL=D3R=64.9664.9664.9664.9664.9664.9664.9664.9664.9664.9664.9364.9364.9364.9364.9364.9364.9364.9364.9364.930.0260.0260.0260.0260.0260.0260.0260.0260.0260.02664.9665664.92164.9597164.93064.9756064.90064.4064.5064.6064.7064.8064.9065.0065.1065.2012345678910系…0.000.010.020.030.040.050.060.0712345678910系列164.4064.5064.6064.7064.8064.9065.0065.1065.2012345678910系…0.000.010.020.030.040.0512345678910系列164.4064.5064.6064.7064.8064.9065.0065.1065.2012345678910系…0.000.010.010.020.020.030.0312345678910系列1Prepared：Approve：Page3of9PartNumber（零件型号）GageNumber(量规编号)AppraiserA（评价人A）25679098DN002WQPartName（零件名称）GageName(量规名称)AppraiserB（评价人B）9098尾管带表卡尺ZMCharacteristicClassification（被检测特性分类）GageType(量测内容)AppraiserC（评价人C）特殊特性Spection(规格）：GKMTrials(次数)Parts(零件数)Appraisers（检测人数）Max：DatePerformed（完成日期）3103MIN：2015.3.1112345678910165.0565.2765.0365.1065.0165.2765.1765.2864.7064.8065.068265.0665.2865.0465.1165.0165.2865.1865.2964.7064.8165.076365.0665.2865.0565.1165.0265.2865.1965.3064.7064.8165.080平均值Xbar65.05765.27765.04065.10765.01365.27765.18065.29064.70064.80765.075极差R0.0100.0100.0200.0100.0100.0100.0200.0200.0000.0100.012165.0765.2965.0465.1065.0165.2865.1765.3064.7164.8265.079265.076