欢迎来到冰点文库! | 帮助中心 分享价值,成长自我!
冰点文库
全部分类
  • 临时分类>
  • IT计算机>
  • 经管营销>
  • 医药卫生>
  • 自然科学>
  • 农林牧渔>
  • 人文社科>
  • 工程科技>
  • PPT模板>
  • 求职职场>
  • 解决方案>
  • 总结汇报>
  • ImageVerifierCode 换一换
    首页 冰点文库 > 资源分类 > XLS文档下载
    分享到微信 分享到微博 分享到QQ空间

    全套SPC表格(很全面).xls

    • 资源ID:2893470       资源大小:860KB        全文页数:41页
    • 资源格式: XLS        下载积分:10金币
    快捷下载 游客一键下载
    账号登录下载
    微信登录下载
    三方登录下载: 微信开放平台登录 QQ登录
    二维码
    微信扫一扫登录
    下载资源需要10金币
    邮箱/手机:
    温馨提示:
    快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。
    如填写123,账号就是123,密码也是123。
    支付方式: 支付宝    微信支付   
    验证码:   换一换

    加入VIP,免费下载
     
    账号:
    密码:
    验证码:   换一换
      忘记密码?
        
    友情提示
    2、PDF文件下载后,可能会被浏览器默认打开,此种情况可以点击浏览器菜单,保存网页到桌面,就可以正常下载了。
    3、本站不支持迅雷下载,请使用电脑自带的IE浏览器,或者360浏览器、谷歌浏览器下载即可。
    4、本站资源下载后的文档和图纸-无水印,预览文档经过压缩,下载后原文更清晰。
    5、试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。

    全套SPC表格(很全面).xls

    1、 X R 控控制制图图控制图编号:製 品H104PCH104PC規 格標 準群組數大小管 制X 圖R圖製 造 部 門时间名 稱上限 USL0.905上限 UCL0.820.38管制項目溝槽寬度中心限CL0.70總組數中心限CL0.720.18機 別抽樣方法随机測量單位下限 LSL0.5025下限 LCL0.610.00測 定 者日 期2011/2/12日期/時間合計批號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)部部 門門:機機 台台:操操 作作 者者:日日 期期:2011/2/12料料 號號:總總組組數數(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.55557081545064

    15、450.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.800034334

    16、76394890.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:Mi

    17、nimumMaximumdelta140.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.

    18、59210.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.7513

    19、5.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.95

    20、90.254115003500.9710.150835061510.9830.087268275.5007.6381742252023/5/4 64a4362447529fb131f1e26bcce79b9e.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

    26、040.72050.000210.720500010.72050.7205000.00050.15951560.70740.00034050.72530.00062 0-1000.72530.7253000.005250.154750570.70860.00045060.73000.00174 0-1000.73000.7300000.010.150580.70980.0006070.73480.00459 0-1000.73480.7348000.014750.145250590.71100.00078080.73950.011470.739500110.73950.7395010.0195

    27、0.14050600.71220.00102090.74430.02722 1-1000.74430.7443100.024250.135750610.71340.001330100.74900.0612 1-1000.74900.7490100.0290.1310620.71460.001720110.75380.13049 1-1000.75380.7538100.033750.126250630.71580.002210120.75850.263770.758500110.75850.7585110.03850.12150640.71690.002850130.76330.50548 1

    28、-1000.76330.7633200.043250.116750650.71810.003640140.76800.91838 1-1000.76800.7680200.0480.1120660.71930.004650150.77281.58187 1-1000.77280.7728200.052750.107250670.72050.00590160.77752.583180.777500210.77750.7775220.05750.10250680.72170.007470170.78233.99923 2-1000.78230.7823400.062250.097750690.72

    29、290.009420180.78705.86994 2-1000.78700.7870400.0670.0930700.72410.011830190.79188.16823 2-1000.79180.7918400.071750.088250710.72530.01480200.796510.7760.7965001110.79650.7965430.07650.08350720.72640.018450210.801313.4779 11-1000.80130.8013700.081250.078750730.72760.02290220.806015.9818 11-1000.80600

    30、.8060780.0860.0740740.72880.028310230.810817.9665 11-1000.81080.81081500.090750.069250750.73000.034860240.815519.14870.8155002610.81550.815515160.09550.06450760.73120.042770250.820319.3486 26-1000.82030.82033100.100250.059750770.73240.052250260.825018.5352 26-1000.82500.82503100.1050.0550780.73360.0

    31、63590270.829816.8337 26-1000.82980.829831100.109750.050250790.73480.077070280.834514.49440.834500910.83450.83454100.11450.04550800.73590.093030290.839311.8319 9-1000.83930.83934170.119250.040750810.73710.111840300.84409.15687 9-1000.84400.84404800.1240.0360820.73830.133910310.84886.71854 9-1000.8488

    32、0.84884820.128750.031250830.73950.159670320.85354.673470.853500010.85350.85355000.13350.02650840.74070.18960330.85833.08205 0-1000.85830.85835000.138250.021750850.74190.22420340.86301.92697 0-1000.86300.86305000.1430.0170860.74310.264010350.86781.14222 0-1000.86780.86785000.147750.012250870.74430.30

    33、9570360.87250.641890.872500010.87250.87255000.15250.00750880.74540.361460370.87730.34198 0-1000.87730.87735000.157250.002750890.74660.420240380.88200.17274 0-1000.88200.88205000.1620.0021900.74780.486470390.88680.08272 0-1000.88680.88685000.166750.006750910.74900.560681400.89150.037550.891500010.89150.89155000.17150.01150920.75020.643391410.89630.01616 0-1000.89630.89635000.176250.016250930.75140.


    注意事项

    本文(全套SPC表格(很全面).xls)为本站会员主动上传,冰点文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知冰点文库(点击联系客服),我们立即给予删除!

    温馨提示:如果因为网速或其他原因下载失败请重新下载,重复下载不扣分。




    关于我们 - 网站声明 - 网站地图 - 资源地图 - 友情链接 - 网站客服 - 联系我们

    copyright@ 2008-2023 冰点文库 网站版权所有

    经营许可证编号:鄂ICP备19020893号-2


    收起
    展开