XR图.xls.xls

x-r 产产品品型型号号 1701331-mr506a01 零零件件名名称称中间轴三档齿轮零零件件图图号号过过程程 卡号 1车车间间/工工段段机机床床编编号号样样本本容容量量5频频次次计计算算控控制制限限日日期期 特特性性值值58.34上上偏偏差差0.02下下偏偏差差-0.02控控制制图图使使用用日日期期 cp cpk 日期序号前期cp值 时间1 2.222.22-6470.97-6470.97特殊2 测量值(mm) 158.35058.34558.34358.33558.34158.34958.34558.34258.34358.33858.34558.3483 258.34858.34258.34258.33458.34258.34258.34358.34158.34558.33758.34658.350评评 判判 准准 则则 358.34558.34358.33458.33858.34158.34358.34458.33558.34658.33058.34758.347 458.35358.33758.33758.33658.34358.34558.34658.33458.34258.33758.34258.348 558.35258.33558.33058.33958.34658.34158.34758.33258.34558.33658.34358.346 平均值x(mm)=(1+2+3+4+5)/n58.35058.34058.33758.33658.34358.34458.34558.33758.34458.33658.34558.348 极差r(mm)=最大值-最小值0.0080.0100.0130.0050.0050.0080.0040.0100.0040.0080.0050.004 组组 1 12 23 34 45 56 67 78 89 91010111112121313141415151616171718181919202021212222232324242525 ucl(mm) 58.35858.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.4 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 58.3 lcl(mm) 58.322 rul(mm) 0.020.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 12345678910111213141516171819202122232425 58.320 58.340 58.360 x图(mm) 12345678910111213141516171819202122232425 0.000 0.005 0.010 0.015 0.020 0.025 正常(过程受控) 上限 下限 不正常(确定原因、改进、检证) 上限 下限 过程不受控,停产 123456789 上限 下限 控制极限计算 系 数 表 x = x i =58.3420 平均值控制上限uclx = x + a2 r =58.3461取样数量a2d2d3d4 子组数21.881.1303.27 平均值控制下限lclx = x a2 r =58.338031.021.6902.57 r = r i =0.0070 40.732.0602.28 子组数极差的控制上限uclr = d4 r =0.014850.582.3302.11 60.482.5302 极差的控制下限lclr = d3 r =0.000070.422.70.081.92 80.372.850.141.86 工序能力指数计算90.342.970.181.82 s=r / d2 = 0.0030100.313.080.221.78 双 边 容 差单 边 容 差选取值0.582.3302.11 cp= usl-lsl =2.2190 只有规范上限时备注: 6s cpku= usl-x = cpku= usl-x =-6470.9666 3s 3s 只有规范下限时 cpkl= x-lsl =6475.4047 3s cpkl= x -lsl = 3s cpk=-6470.9666 x-r 产产品品型型号号 1701331-mr506a01 零零件件名名称称中间轴三档齿轮零零件件图图号号过过程程 卡号 1车车间间/工工段段机机床床编编号号样样本本容容量量5频频次次计计算算控控制制限限日日期期 特特性性值值58.34上上偏偏差差0.02下下偏偏差差-0.02控控制制图图使使用用日日期期 cp cpk 日期序号前期cp值 时间1 #ref!#ref!#ref!#ref!特殊2 测量值(mm) 10.0100.0050.003-0.0080.0010.0090.0050.0020.003-0.0020.0050.008-0.0020.0050.0083 20.0080.0080.002-0.0060.0020.0020.0030.0010.005-0.0030.0060.010-0.0030.0060.010评评 判判 准准 则则 30.0050.002-0.006-0.0050.0010.0030.004-0.0050.006-0.0100.0070.007-0.0100.0070.007 40.0130.001-0.003-0.0040.0030.0050.006-0.0060.002-0.0030.0020.008-0.0030.0020.008 50.012-0.005-0.008-0.0060.0060.0010.007-0.0080.005-0.0040.0030.006-0.0040.0030.006 平均值x(mm)=(1+2+3+4+5)/n0.0100.002-0.002-0.0060.0030.0040.005-0.0030.004-0.0040.0050.008-0.0040.0050.008 极差r(mm)=最大值-最小值0.0080.0130.0110.0040.0050.0080.0040.0100.0040.0080.0050.0040.005#ref!0.004 组组 1 12 23 34 45 56 67 78 89 91010111112121313141415151616171718181919202021212222232324242525 ucl(mm) 0.0180.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0000000000000000000000000 -0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0 lcl(mm) -0.018 rul(mm) 0.020.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 12345678910111213141516171819202122232425 0.000 0.005 0.010 0.015 0.020 0.025 正常(过程受控) 上限 下限 不正常(确定原因、改进、检证) 上限 下限 过程不受控,停产 123456789 上限 下限 12345678910111213141516171819202122232425 -0.020 -0.015 -0.010 -0.005 0.000 0.005 0.010 0.015 0.020 x图(mm) 控制极限计算 系 数 表 x = x i =0.0021 平均值控制上限uclx = x + a2 r =#ref!取样数量a2d2d3d4 子组数21.881.1303.27 平均值控制下限lclx = x a2 r =#ref!31.021.6902.57 r = r i =#ref! 40.732.0602.28 子组数极差的控制上限uclr = d4 r =#ref!50.582.3302.11 60.482.5302 极差的控制下限lclr = d3 r =#ref!70.422.70.081.92 80.372.850.141.86 工序能力指数计算90.342.970.181.82 s=r / d2 = #ref!100.313.080.221.78 双 边 容 差单 边 容 差选取值0.582.3302.11 cp= usl-lsl =#ref! 只有规范上限时备注: 6s cpku= usl-x = cpku= usl-x =#ref! 3s 3s 只有规范下限时 cpkl= x-lsl =#ref! 3s cpkl= x -lsl = 3s cpk=#ref! x-r 产产品品型型号号 1701331-mr506a01 零零件件名名称称中间轴三档齿轮零零件件图图号号过过程程 卡号 1车车间间/工工段段机机床床编编号号样样本本容容量量5频频次次1次/10件计计算算控控制制限限日日期期 特特性性值值58.34上上偏偏差差0.02下下偏偏差差-0.02控控制制图图使使用用日日期期 cp cpk 日期序号前期cp值 时间1 #div/0!#div/0!#div/0!#div/0!特殊2 测量值(mm) 13 2评评 判判 准准 则则 3 4 5 平均值x(mm)=(1+2+3+4+5)/n 极差r(mm)=最大值-最小值 组组 1 12 23 34 45 56 67 78 89 91010111112121313141415151616171718181919202021212222232324242525 ucl(mm) 0.0150.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0000000000000000000000000 -0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0 lcl(mm) -0.015 rul(mm) 0.020.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 0.02 12345678910111213141516171819202122232425 0.000 0.005 0.010 0.015 0.020 0.025 正常(过程受控) 上限 下限 不正常(确定原因、改进、检证) 上限 下限 过程不受控,停产 123456789 上限 下限 12345678910111213141516171819202122232425 -0.020 -0.015 -0.010 -0.005 0.000 0.005 0.010 0.015 0.020 x图(mm) 控制极限计算 系 数 表 x = x i =#div/0! 平均值控制上限uclx = x + a2 r =#div/0!取样数量a2d2d3d4 子组数21.881.1303.27 平均值控制下限lclx = x a2 r =#div/0!31.021.6902.57 r = r i =#div/0! 40.732.0602.28 子组数极差的控制上限uclr = d4 r =#div/0!50.582.3302.11 60.482.5302 极差的控制下限lclr = d3 r =#div/0!70.422.70.081.92 80.372.850.141.86 工序能力指数计算90.342.970.181.82 s=r / d2 = #div/0!100.313.080.221.78 双 边 容 差单 边 容 差选取值0.582.3302.11 cp= usl-lsl =#div/0! 只有规范上限时备注: 6s cpku= usl-x = cpku= usl-x =#div/0! 3s 3s 只有规范下限时 cpkl= x-lsl =#div/0! 3s cpkl= x -lsl = 3s cpk=#div/0! x-r 产产品品型型号号 1701331-mr506a01零 零件件名名称称中间轴三档齿轮零零件件图图号号过过程程剃齿 卡号 1车车间间/工工段段机机床床编编号号样样本本容容量量5频频次次5件/4小时计计算算控控制制限限日日期期 特特性性值值58.34上上偏偏差差0.02下下偏偏差差-0.02控控制制图图使使用用日日期期 cp cpk 日期序号前期cp值 时间1 #div/0!#div/0!#div/0!#div/0!特殊2 测量值(mm) 13 2评评 判判 准准 则则 3 4 5 平均值x(mm)=(1+2+3+4+5)/n 极差r(mm)=最大值