当前位置：文档之家 › CPK自动计算表格(多尺寸)

CPK自动计算表格(多尺寸)

  • 格式：xls
  • 大小：30.50 KB
  • 文档页数：1

Part No. :

Dwg. No. :

Part Name :Part No. :Parameter12345678910

Location

Spec.30.0000.500φ2.5

Max spec.30.100.582.60

Min spec.29.900.422.40

Max.30.030.532.54

Min.29.970.472.47

Mean30.0030.5052.502

Std Dev.0.0160.0150.018

Sample 130.020.522.51230.010.512.50330.030.532.53430.010.512.51529.980.532.51629.970.512.49730.010.492.51829.990.502.53930.010.502.511030.030.482.501130.000.492.491230.020.512.481330.010.502.491429.980.502.511529.990.512.521629.990.492.531730.010.492.511830.000.512.491929.990.502.492030.010.512.502129.990.532.482229.980.502.502330.000.532.532429.990.512.512529.990.532.542630.020.492.512730.010.492.472830.030.502.482930.010.512.493030.000.472.493130.010.492.473230.010.512.4933

34

35

Ca0.0310.0590.022CpU2.0781.6481.802CpL2.2121.8531.883Cp2.1451.7501.842Cpk2.0781.6481.802

COMMENTS :Approved byDateRim SbumFoxlinkRim Sbum

Rim SbumCpk Report

Cavity No.

Measured byCHENG UEI PRECISION IND. CO., LTD.

合集下载

CPK表格

CPK表格

廠商﹕20080508大項目區分檢測義器単位規格上限中心值規格下限2#模12345678910111213141516MAXMINRXbarσCPUCPLCPK判定備注﹕○﹕CPK≧1.33（制程能力足夠）△﹕1.0≦CPK＜1.33（制程能力尚可﹐應再努力）合格X﹕CPK＜1.0（制程能力應加以改善）C P K 值 計 算檢印

測定日﹕確認作成

尺寸1尺寸2尺寸3尺寸4品名﹕

16.5±0.18.0±0.2尺寸5尺寸6尺寸71234小項目13.8±0.110.0±0.2投影仪52+0/-0.19.45±0.088.4±0.057投影仪投影仪投影仪投影仪投影仪投影仪投影仪6MMMMMMMM投影仪投影仪MM13.9010.2016.601.602.009.53MMMM8.458.400.00.016.501.551.9513.8010.000.013.709.8016.401.501.909.379.458.3513.842.572.471.521.959.508.428.422.481.521.9413.852.5713.802.582.481.521.949.519.501.531.9413.802.578.428.4113.812.562.481.521.939.499.502.488.438.422.471.531.9413.802.5713.822.562.471.521.959.509.501.531.9413.812.578.428.4313.859.512.4813.8213.8513.8213.8213.8213.8313.840.02.481.531.9513.852.580.00.013.802.562.471.521.939.499.510.00.050.020.00.00.020.000.000.010.010.02############0.0013.822.572.481.521.949.500.020.010.010.020.018.42######0.01############1.42396.92909.664.913.061.500.01######0.012.31-376.121.50######################################################○X机种:

CPK计算表 格式

CPK计算表 格式

产品型号:控制点:量测工具:月份:平均值#DIV/0!中间值频次标准差#DIV/0!0.0000规格中心值0.0000上限0.0000下限0.0000最大值0.0000.0000最小值0.0000.0000极差0.0000.0000CaN/A0.0000CP#DIV/0!0.0000Cpk#DIV/0!0.0000No.ValueNo.ValueNo.ValueNo.ValueNo.Value121416181Average=X222426282323436383Standard Deviation=424446484 (X1-X)2+(X2-X)2+…+(Xn-X)2525456585n-1626466686727476787828486888Low Limit=SL929496989Ca=(X-u)/(T/2)----双边1030507090Ca=whithout -----单边1131517191Cp=T/6 sigma ----双边1232527292Cp=(Su-X)/(3*Stdev)1333537393 or (X-SL)/(3*Stdev) ----单边1434547494CPK= Cp*(1- Ca )---双边)1535557595 or = Cp ----单边16365676961737577797Target: CPK ≧1.331838587898Regular:1.0≦CPK<1.331939597999Improvement Needed: CPK<1.020406080100结果分析处置措施核准:审核:制表:制程能力（CPK）分析报告

Upper Limit=Su0.0000.0000.0000.0000.0000.0000.0000.0000.0000.00000000000000.0000.2000.4000.6000.8001.00012345678910FrequencyValues at mid-points of cellsHISTOGRAM

CPK与Ppk计算表(双边_望目值)

CPK与Ppk计算表(双边_望目值)

XR均值和极差图控制图数据表及图零件号：CG125进气门供应商：中山市正洲汽门有限公司 数 据 采 集 时 段零件名称:CG125进气门部门：品保部机器编号：样本容量/频率：125pcs工序：成品工 程最 大USL=3.2过程能力指数要求：Cpk>1.33規 格规 范最 小LSL=0序时 测 量 数 据 计 算 备号间 X1 X2 X3 X4 X5 R注11.291.241.331.251.071.2360.26021.311.381.091.241.411.2860.32031.211.341.291.261.161.2520.18041.331.331.391.101.181.2660.29051.041.151.291.101.351.1860.31060.951.131.361.431.381.2500.48071.300.901.181.301.361.2080.46081.281.191.341.381.111.2600.27091.021.161.121.221.301.1640.280101.451.170.921.451.261.2500.530111.070.991.261.341.161.1640.350121.251.201.301.271.151.2340.150131.290.991.050.931.341.1200.410141.280.951.340.951.391.1820.440151.371.181.201.241.281.2540.190161.261.241.441.341.441.3440.200171.081.341.081.251.351.2200.270181.521.071.501.411.251.3500.450191.451.430.931.211.151.2340.520201.071.231.281.231.191.2000.210211.041.151.291.101.351.1860.310220.951.131.361.431.381.2500.480231.300.901.181.301.361.2080.460241.281.191.341.381.111.2600.270251.021.161.121.221.301.1640.280n 0.143931 总 计30.7288.37040.143319 平 均50.5772.1150.42991.229120.33480 控 制 图 R 控 制 图13.693271.4223UCL=D5R=0.708102 8.5396768.5396761.22912 CL=R=0.334813.75171.03594LCL不予考虑 8.5761118.576111非随机图落在控制限三分之一的中间区域的点百分比0.762.846559形 判 断R落在控制限三分之一的中间区域的点百分比0.562.858704群體Ca=-0.2318群體Cp=3.705492群體Cpk=2.846559樣本Ca=-0.2318樣本Cp=3.721301樣本Ppk=2.858704自2010年2月5日9：00至2010年2月5日10：00中山市正洲汽门有限公司

CPK-自动生成图表及判定(精典型)

CPK-自动生成图表及判定(精典型)

編號：注意：公式說明Instrument代碼CodeDC順序圖紙位置單位順序CMM(Order)Drawing No.(unit)(Order)CpCplCpuCpkOMM1E4mm1#VALUE!#VALUE!黑體字WithinSpecHG2mm2MIC1mm3黑體字WithinSpecHG2mm4MIC5mm5綠體字TooLowPG6mm6Note:LC7mm71. 單邊規格沒8899101012345678910111213141516171819202122232425262728293031323334351234567891011121314151617181920212223242526272829303132333435123456789備註：Prep0.20Parts Name（名稱）

張建軍 2017/4/12陳小鳳 2014/4/12Customer（客戶）Sample stage（階段）Sample size （樣本大小）EVT DVT PVT2.600Cpk Result：大於1.33：藍字，小於1.33：紅字Std DevMeanUSL上規格28-Mar-170.15

Approved bySample no.(樣品編號)Time（時間）14:45Part No （料號）Nominal Dim.LSL下規格標稱值chen xiaofeng2.4002.750Version（版本）Tol. Min. (-)負公差Tol. Max. (+)正公差CMMCpk ReportCMMAMinMeasured by（量測員）InstrumentDate（日期）066EWD-1066EWD-1名稱Name2. 單邊規格利用Cpl 或Cpu求得Cpk值。例如：有LSL，用Cpl求得Cpk值；有USL，用Cpu求得Cpk值CMMCMMCMMCMMCMMOthers （其他）:Max量測設備30PCS