当前位置：文档之家 › CPK格式

CPK格式

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

机种名:D186模具号:No.1Ver:A品名:前框注塑日期:2010/2/1测量工具：卡尺料号:J34G8B49-FM-A1S测量日期:2010/2/3测量人：田萌CPK值对应等级（A：位置尺寸A尺寸B基本尺寸441.90441.90规格上限442.20442.20规格下限441.60441.60中心尺寸441.90441.90最大值441.98441.78最小值441.62441.63平均值441.826441.682标准差0.0990.045制程准确度-0.247-0.727制程精密度1.0142.245制程能力CPK0.7640.613所属等级DEDRL%1.10%3.30%DRR%0.01%0.00%DR%1.11%3.30%样品1441.95441.75样品2441.92441.72样品3441.86441.66样品4441.86441.66样品5441.78441.65样品6441.92441.72样品7441.96441.76样品8441.85441.65样品9441.78441.63样品10441.62441.63样品11441.85441.65样品12441.67441.65样品13441.86441.66样品14441.95441.75样品15441.78441.67样品16441.75441.66RangeFrequencyNormalDist.RangeFrequencyNormal Dist.样品17441.65441.78441.530000.0449441.548300.0995样品18441.75441.67441.567000.1290441.565000.2857样品19441.86441.66441.604000.3218441.581700.7127样品20441.65441.66441.641010.6974441.598401.5445样品21441.87441.67441.678041.3131441.615102.9081样品22441.86441.66441.715002.1482441.631824.7574样品23441.98441.78441.752023.0532441.648506.7616样品24441.87441.67441.789053.7702441.6652178.3495样品25441.78441.65441.825904.0448441.681948.9577样品26441.65441.72441.8629113.7702441.698608.3495样品27441.86441.66441.899923.0532441.715306.7616样品28441.85441.65441.936922.1482441.732034.7574样品29441.95441.75441.973941.3131441.748702.9081样品30441.78441.66442.010910.6974441.765441.5445样品31441.86441.66442.047900.3218441.782120.7127样品32441.85441.65442.121800.04492.133600.0000comments:尺寸A尺寸B Process Capability & Normal Distribution Worksheet0.00.51.01.52.02.53.03.54.04.5024681012441.53441.57441.60441.64441.68441.71441.75441.79441.83441.86441.90441.94441.97442.01442.05442.12尺寸A常态分布图0.001.002.003.004.005.006.007.008.009.0010.00024681012141618441.55441.56441.58441.60441.62441.63441.65441.67441.68441.70441.72441.73441.75441.77441.782.13尺寸B常态分布图

合集下载

CPK-报告格式

CPK-报告格式

1234567891032.1532.1532.1532.1532.1532.1532.1532.1532.1532.1531.8531.8531.8531.8531.8531.8531.8531.8531.8531.8532.06032.02032.02032.02032.06032.04032.04032.04032.04032.04032.04031.98031.98031.96031.96031.98031.98031.96032.06032.04031.96032.04032.02031.96031.98032.02032.02032.04031.98031.98031.98031.98032.02031.98031.98032.02031.96032.02032.04031.96032.02032.06032.02032.02031.96032.04032.04032.02031.98031.98032.04032.06032.02031.96031.98031.96032.02032.02032.04032.04032.02031.98032.02031.96031.98032.02032.02031.98031.98031.98032.04031.98031.98031.96032.04031.98031.96031.98031.96032.04032.02032.04032.02031.96031.98031.98032.02031.98031.98031.98032.02031.98031.98031.98032.04031.96032.04032.04032.02032.04032.02032.04032.04031.98031.96031.98031.96031.98032.04032.04031.98031.96031.98031.96032.02031.98031.96032.04031.96031.96032.04032.02031.98031.98032.02032.06031.98032.06031.96031.98031.98031.98032.02031.96032.04031.96032.06031.96032.04031.96032.04031.98031.98031.98031.96031.96031.96032.06031.96031.96032.06032.04031.96031.98031.98031.96031.98031.96031.98031.98032.02031.98031.98031.96032.04032.06031.98032.06032.04032.06032.06032.04032.06031.98031.98032.06032.04031.96031.98031.98031.96032.02032.04032.04032.04032.06031.96031.98032.04032.04031.96032.06031.96031.96031.98032.02032.06032.04031.98031.98032.04031.98031.98032.02031.96032.04032.04031.98031.98031.98032.06032.04031.96031.96031.98031.96032.06032.04031.96032.04032.02031.98031.98031.96031.98031.96032.02031.98032.04031.98032.02032.04031.96032.02032.04032.02032.06032.04032.02032.06031.98032.02032.06032.04031.98031.98032.02031.96031.96031.98031.98032.06032.06031.96032.04031.98031.96031.96031.96032.02032.04032.04031.98031.98032.02031.96032.02031.98031.98032.02032.02031.96032.06031.96032.04031.96031.98032.02031.96032.04031.98031.98031.96031.98031.96032.02031.98031.96031.98031.96031.98032.02031.98031.98032.04032.04031.98031.98032.04032.04031.96031.98032.06031.96032.02031.96032.02031.96032.02031.96032.04031.96032.06032.02032.04031.98031.98031.98031.96031.98032.060032.060032.060032.040032.060032.060032.060032.060032.060032.060031.960031.960031.960031.960031.960031.960031.960031.960031.960031.960032.013832.009432.005631.980632.002531.998832.005032.000631.997532.00250.03310.03410.03560.02610.03360.03700.03560.03610.03470.03511.511.471.401.911.491.351.411.391.441.421.371.381.351.671.461.341.361.381.421.40MIN.AVERAGESTDEVCPCpkTOOLING(测量工具)2829303132MAX.222324252627161718192021101112131415456789Dim. Designator(尺寸序号)Upper Limit(规格上限)Lower Limit(规格下限)123Tool Number(模号)Inches/MM(英寸/毫米)32Revision(版本)A/0Date(日期)2017-11-15 CPK ReportPart Number(料号)ZQ00005479Vendor(供应商)鑫裕朗Description(零件名称)散热器Inspected(确认者)张明建

CPK

CPK

以下10组数据是公司在为苹果iPhone生产手机面板时，在灌注液晶后，经行封口作业时的渗胶深度值。（一次量测5片，量10次）。

USL=0.8 , LSL=0.2, u=0.5.

0.60 0.60 0.65 0.60 0.65

0.60 0.60 0.65 0.65 0.65

0.60 0.60 0.60 0.65 0.65

0.60 0.60 0.65 0.60 0.65

0.65 0.60 0.60 0.60 0.65

0.65 0.60 0.60 0.60 0.60

0.60 0.60 0.60 0.60 0.65

0.60 0.60 0.60 0.60 0.60

0.60 0.60 0.65 0.65 0.60

0.60 0.60 0.65 0.60 0.60

将这些数据输入公司的SPC系统后，就会产生如下的CPK信息：

最大值 0.65

最小值 0.6

平均值 0.62

标准差 0.02 (R-Bar/d2)

Ca 0.39

Cp 5.17

Cpk 3.17

其中的Ca=（0.616-0.6）/（（0.8-0.2）/2）= 0.3866 （和0.39差不多）

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

SPC&CPK计算公式及格式

SPC&CPK计算公式及格式

X—R 管 制 圖管制圖編號： 製 品R圖名 稱管制項目測量單位日期/時間批號12345678910111213141516171819202122232425ΣＸ＝3224.77樣125.7825.7925.8325.8025.8225.8025.8225.8225.7725.7625.8025.7925.7725.8225.7925.8125.8125.8025.7925.8225.8225.7925.8025.7825.83ΣＲ＝1.08本225.8025.8125.8225.7925.7825.7925.8025.7825.7925.8325.7925.8125.8025.8125.8225.7925.8025.8125.8025.7725.8025.7725.8025.8225.78測325.8125.7825.8125.8425.7725.8025.8025.7925.8025.8025.7725.7825.8025.8025.7725.8025.8125.8025.8125.8025.7925.8125.8125.7925.80定425.8225.8025.7925.8025.8025.8025.8125.8325.7825.7925.8325.7825.8425.7925.7825.7825.7625.8025.7925.7725.8125.7825.7825.7925.80> USL 藍色值525.7825.8125.8325.8125.8125.8025.8225.7725.7825.8125.8325.8025.8225.7825.8125.7925.8025.8025.8025.8125.7625.7925.7825.8325.79< LSL 紅色 Ｎ＝125ΣＸ128.99128.99129.08129.04128.97128.99129.06128.99128.92128.99129.01128.97129.02129.00128.97128.96128.97129.00128.99128.96128.98128.94128.97129.01129.01Ｘ25.8025.8025.8225.8125.7925.8025.8125.8025.7825.8025.8025.7925.8025.8025.7925.7925.7925.8025.8025.7925.8025.7925.7925.8025.80Ｘ＝25.80R0.040.040.040.050.050.010.030.060.030.070.060.040.070.040.050.030.050.020.020.050.050.040.030.060.05R=0.04x