SPC全套Excel版模版[编号Y52U].xls
《SPC全套Excel版模版[编号Y52U].xls》由会员分享,可在线阅读,更多相关《SPC全套Excel版模版[编号Y52U].xls(41页珍藏版)》请在咨信网上搜索。
1、 X R 控控制制图图控制图编号:製 品H104PCH104PC規 格標 準群組數大小管 制X 圖R圖製 造 部 門时间名 稱上限 USL0.905上限 UCL0.820.38管制項目溝槽寬度中心限CL0.70總組數中心限CL0.720.18機 別抽樣方法随机測量單位下限 LSL0.5025下限 LCL0.610.00測 定 者日 期2005/11/4日期/時間合計批號1234567891011121314151617181920212223242589.50樣10.650.750.750.600.700.600.750.600.650.600.800.850.700.650.900.750.
2、750.750.650.600.500.600.800.650.654.45本20.700.850.800.700.750.750.800.700.800.700.750.750.700.700.800.800.700.700.650.600.550.800.650.600.70測30.650.750.800.700.650.750.650.800.850.600.900.850.750.850.800.750.850.600.850.650.650.650.750.650.70量測數值的判定條件定40.650.850.700.750.850.850.750.750.850.800.500.6
3、50.750.750.750.800.700.700.650.600.800.650.650.600.60 USL 藍色值50.850.650.750.650.800.700.700.750.750.650.800.700.700.600.850.650.800.600.700.650.800.750.650.700.65 LSL 紅色 1253.50 3.85 3.80 3.40 3.75 3.65 3.65 3.60 3.90 3.35 3.75 3.80 3.60 3.55 4.10 3.75 3.80 3.35 3.50 3.10 3.30 3.45 3.50 3.20 3.30 平
4、均0.70 0.77 0.76 0.68 0.75 0.73 0.73 0.72 0.78 0.67 0.75 0.76 0.72 0.71 0.82 0.75 0.76 0.67 0.70 0.62 0.66 0.69 0.70 0.64 0.660.72R0.20 0.20 0.10 0.15 0.20 0.25 0.15 0.20 0.20 0.20 0.40 0.20 0.05 0.25 0.15 0.15 0.15 0.15 0.20 0.05 0.30 0.20 0.15 0.10 0.10R=0.18x預估不良率(PPM)管制圖10355製程能力分析 Std.Dev.=0.09
5、Sigma =0.08R=0.72管制圖 PP=0.78 Ca=8.00%=0.80 CP=0.87Grade=D備註及原因追查:123456789101112131415161718192021222324250.00 0.10 0.20 0.30 0.40 0.50 123456789101112131415161718192021222324250.40 0.50 0.60 0.70 0.80 0.90 1.00 n2345678910d21.131.692.062.332.532.72.852.973.082.33D3000000.080.140.180.220D43.272.572.
6、282.11 2.001.921.861.821.782.11A21.881.020.730.580.480.420.370.340.310.58XUCL0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82CL0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.
7、72 0.72 0.72 0.72 0.72 0.72 0.72 0.72LCL0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.61#0.42 0.56 0.56 0.36 0.49 0.36 0.56 0.36 0.42 0.36 0.64 0.72 0.49 0.42 0.81 0.56 0.56 0.56 0.42 0.36 0.25 0.36 0.64 0.42 0.42 0.00#0.49 0.72 0.64 0.49 0.56
8、0.56 0.64 0.49 0.64 0.49 0.56 0.56 0.49 0.49 0.64 0.64 0.49 0.49 0.42 0.36 0.30 0.64 0.42 0.36 0.49 0.00#0.42 0.56 0.64 0.49 0.42 0.56 0.42 0.64 0.72 0.36 0.81 0.72 0.56 0.72 0.64 0.56 0.72 0.36 0.72 0.42 0.42 0.42 0.56 0.42 0.49 0.00#0.42 0.72 0.49 0.56 0.72 0.72 0.56 0.56 0.72 0.64 0.25 0.42 0.56
9、0.56 0.56 0.64 0.49 0.49 0.42 0.36 0.64 0.42 0.42 0.36 0.36 0.00#0.72 0.42 0.56 0.42 0.64 0.49 0.49 0.56 0.56 0.42 0.64 0.49 0.49 0.36 0.72 0.42 0.64 0.36 0.49 0.42 0.64 0.56 0.42 0.49 0.42 0.00#0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
10、0.00 0.00 0.00 0.00 0.000.00RUCL0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38CL0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18LCL0.000
11、.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00USL0.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.90LSL0.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.5
12、00.500.500.50製製 程程 能能 力力 分分 析析 (Capabilities)(Capabilities)部部 門門:機機 台台:操操 作作 者者:日日 期期:2005/11/4料料 號號:總總組組數數(Sub Group)25總總數數(Count)125平平均均值值(Average)0.72最最小小值值(Minimum)0.50最最大大值值(Maximum)0.90中中位位數數(Median)0.70群群組組數數大大小小(n)5規規格格上上限限 USL0.90規規格格下下限限 LSL0.50管管制制上上限限UCL(X)0.82管管制制下下限限LCL(X)0.61標標準準差差(St
13、d.Dev.)0.09標標準準差差(Sigma Hat)0.08偏偏度度(Skewness)-0.01峰峰度度(Kurtosis)-0.56預預估估不不良良率率PPM(Out of Spec.)10355Ca 8.00%CPU 0.80CPL 0.94Cp 0.87Cpk0.80-3S0.72+3S 0.90 0.50 1.100 1.000 0.900 0.800 0.700 0.600 0.500 0.400 0.300 0.200 0.100 0.000 0.433340.494450.555570.616690.677800.738920.800030.861150.922270.98
14、338其他0102030405060=Range組界組界頻率XNormal=0.433339055793991=0.37222317596566520.433340.43334020.3840.0032419890.48733.6=0.494454935622318=0.43333905579399130.494450.49445030.3970.0064095360.4870=0.555570815450644=0.49445493562231840.555570.55557340.4090.0123516160.5630=0.61668669527897=0.555570815450644
15、50.616690.616691550.4210.0232008040.56324=0.677802575107296=0.6166866952789760.677800.677802760.4330.0424780270.5630=0.738918454935622=0.67780257510729670.738920.738922270.4460.0758067190.6400=0.800034334763948=0.73891845493562280.800030.800034380.4580.1318660890.64024=0.861150214592274=0.8000343347
16、6394890.861150.861151390.4700.2235839440.6400=0.9222660944206=0.861150214592274100.922270.922272100.4820.3695133730.7160=0.983381974248926=0.9222660944206110.983380.983380110.4940.5952532420.71648.00其他其他0120.5070.9346638370.7160130.5191.4305108990.7920DescriptionValueThe limits are calculated as:Min
17、imumMaximumdelta140.5312.134071490.79224Sigma0.076Selected0.4101.0220.061150.5433.1031932220.7920Mean0.716X0.5000.900160.5564.3983595980.8690Delta0.061LCL or UCL for X0.6130.819170.5686.0765168950.86924Multiplier7.639LSL or USL0.5000.900180.5808.1827775990.8690Maximum48.004*Sig+Median0.4101.022190.5
18、9210.740607510.9450200.60413.741653930.94533.6210.61717.13685920.9450220.62920.8307790.9000230.64124.680949060.90048.00240.65328.503635850.9000250.66632.086380380.5000260.67835.206532680.50048.00270.69037.653716180.5000280.70239.25314831290.71439.88624999300.72739.50517408310.73938.13878155320.75135
19、.8890291330.76332.91839608340.77629.43050298350.78825.64712944360.80021.7852177370.81218.03711632380.82414.556413390.83711.45048003400.8498.779607061410.8616.561581477420.8734.779957488430.8863.394076318440.8982.349098536450.9101.584757903460.9221.042093481470.9340.667932374480.9470.417292298490.959
20、0.254115003500.9710.150835061510.9830.087268275.5007.6381742252024/9/23 50da255865a6bc6e6e61296afcbd7a07.xls TYPE OF TOLERENCE:BOTH SIDE 1,MAX TOL.3,MIN TOL 4,BCOLUMN INPUT.BEFORE TIME BEFORE DATA DELETE.PROCESSPROCESS CAPABILITYCAPABILITY STUDYSTUDYPART NO:96179248P/NO:9.6E+07USL:0.88 INSP:PART NAM
21、EG/K-GEARSHIFTP/NAME:G/K-GEARSHIFTLSL:0.72 DATE:OP.NOPROCESS:TOL:0.16MIN UNIT:0.001CHECK ITEMITEM:MEAN:0.8Xo:TYPE OF TOL.10.81000.81000.82000.83000.82000.82000.74000.82000.82000.8000USL0.8800.83000.83000.81000.84000.84000.81000.83000.76000.85000.8400LSL0.7200.82000.83000.84000.81000.78000.83000.8400
22、0.85000.80000.8400INSPECTOR0.82000.83000.81000.83000.78000.81000.82000.82000.82000.8000DATE0.82000.83000.82000.82000.81000.82000.82000.82000.84000.8300UNIT0.001 Xo :DATA NO.10.81 20.81 30.82 40.83 50.82 60.82 70.74 80.82 90.82 100.8 110.83 120.83 130.81 140.84AVG=0.8188MIN=0.74MAX=0.85N=50150.84 =0.
23、0206 Cp=1.30 Cpk=0.99 k=0.23160.81 PC%=77.1%PCk%=100.8%170.83 OUT OF UPPER SPEC=0.15%OUT OF LOWER SPEC =0.00%180.76 KURTOSIS=7.40 SKEWNESS=-1.69190.85 SPREAD RANGE(6)=0.7570.881200.84210.82DISTRIBUTIONDISTRIBUTION CURVECURVE220.83230.84240.81250.78260.83270.84280.85290.8300.84310.82320.83330.81340.8
24、3350.78360.81370.82380.82390.82400.8410.82MAX+SL/20.8505MIN.UNIT0.001420.83X+3s0.881Max0.85430.82US0.88Min0.746.83883440.82MIN-SL/20.7395KIND QTYT111CLASS QTY6450.81X-3s0.757GRADE KIND18GRADE KIND r18.5460.82LS0.72grade width0.019470.82a0.7221.026320.6954480.82b0.88058.447490.72490.84h0.0032110.0004
25、9500.830.001190.023250.18325510.70158.1E-05000.70151.7E-060.701500010.70150.7015000.01850.17850520.70270.00011010.70636.1E-06 0-1000.70630.7063000.013750.173750530.70390.00015020.71102.1E-05 0-1000.71100.7110000.0090.1690540.70510.0002030.71586.9E-05 0-1000.71580.7158000.004250.164250550.70630.00026
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 编号Y52U 完整版 SPC 全套 Excel 模版 编号 Y52U
1、咨信平台为文档C2C交易模式,即用户上传的文档直接被用户下载,收益归上传人(含作者)所有;本站仅是提供信息存储空间和展示预览,仅对用户上传内容的表现方式做保护处理,对上载内容不做任何修改或编辑。所展示的作品文档包括内容和图片全部来源于网络用户和作者上传投稿,我们不确定上传用户享有完全著作权,根据《信息网络传播权保护条例》,如果侵犯了您的版权、权益或隐私,请联系我们,核实后会尽快下架及时删除,并可随时和客服了解处理情况,尊重保护知识产权我们共同努力。
2、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确),网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据,个别因单元格分列造成显示页码不一将协商解决,平台无法对文档的真实性、完整性、权威性、准确性、专业性及其观点立场做任何保证或承诺,下载前须认真查看,确认无误后再购买,务必慎重购买;若有违法违纪将进行移交司法处理,若涉侵权平台将进行基本处罚并下架。
3、本站所有内容均由用户上传,付费前请自行鉴别,如您付费,意味着您已接受本站规则且自行承担风险,本站不进行额外附加服务,虚拟产品一经售出概不退款(未进行购买下载可退充值款),文档一经付费(服务费)、不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
4、如你看到网页展示的文档有www.zixin.com.cn水印,是因预览和防盗链等技术需要对页面进行转换压缩成图而已,我们并不对上传的文档进行任何编辑或修改,文档下载后都不会有水印标识(原文档上传前个别存留的除外),下载后原文更清晰;试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓;PPT和DOC文档可被视为“模板”,允许上传人保留章节、目录结构的情况下删减部份的内容;PDF文档不管是原文档转换或图片扫描而得,本站不作要求视为允许,下载前自行私信或留言给上传者【二***】。
5、本文档所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用;网站提供的党政主题相关内容(国旗、国徽、党徽--等)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。
6、文档遇到问题,请及时私信或留言给本站上传会员【二***】,需本站解决可联系【 微信客服】、【 QQ客服】,若有其他问题请点击或扫码反馈【 服务填表】;文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“【 版权申诉】”(推荐),意见反馈和侵权处理邮箱:1219186828@qq.com;也可以拔打客服电话:4008-655-100;投诉/维权电话:4009-655-100。