全套SPC控制图制作-EXCEL版.xls

文档编号：30858290
上传时间：2024-04-09
格式：XLS
页数：23
大小：999KB

《全套SPC控制图制作-EXCEL版.xls》由会员分享，可在线阅读，更多相关《全套SPC控制图制作-EXCEL版.xls（23页珍藏版）》请在冰豆网上搜索。

全套SPC控制图制作-EXCEL版.xls

XR控控制制图图控制图编号：

产品件号规格标准每组大小控制X图R图制造部门期间产品名称上限USL上限UCL0.00控制项目中心限CL总组数中心限CL0.00机组抽样方法随机测量单位下限LSL下限LCL0.00测量者日期3月2日日期/时间合计批号12345678910111213141516171819202122232425样本测计量数值的判定条件定USL蓝色值USL蓝色USL蓝色值USL蓝色值USL蓝色值USL蓝色LSL红色平均0.00預估不良率（PPM）#VALUE!

製程能力分析P控控制制图图控制图编号：

产品名称部门上限UCL#VALUE!

中心限CL下限LCL#VALUE!

子組数26样本上限704过程名称机组纪录者日期P0.00%样本容量n563样本下限423日期1234567891011121314151617181920212223242526合计备注检查数量50045050065050055050065050050070050050065050070050065050060050070050070050065014650不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!

#VALUE!

P控制图备注及原因跟踪:

12345678910111213141516171819202122232425260.0%10.0%20.0%30.0%40.0%50.0%60.0%70.0%80.0%90.0%100.0%nP控控制制图图控制图编号：

产品名称部门上限UCL0.00中心限CL0.00下限LCL0.00子組数26样本上限188过程名称机组纪录者日期nP0.00本容量n150样本下限113日期1234567891011121314151617181920212223242526合計备注检查数量1501501501501501501501501501501501501501501501501501501501501501501501501501503900不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!

#VALUE!

P控制图备注及原因跟踪:

123456789101112131415161718192021222324252600000111111C控控制制图图控制图编号：

产品名称部门上限UCL0.00中心限CL0.00下限LCL0.00子組数26样本上限3过程名称机组纪录者日期C0.00样本容量n2样本下限2日期1234567891011121314151617181920212223242526合计备注检查数量2222222222222222222222222252不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!

#VALUE!

P控制图备注及原因跟踪:

123456789101112131415161718192021222324252600000111111U控控制制图图控制图编号：

产品名称部门上限UCL0.00中心限CL0.00下限LCL0.00子組数26样本上限11过程名称机组记录者日期U0.00样本容量n9样本下限6日期1234567891011121314151617181920212223242526合计备注检查数量87979810797981099791098107108108221不良內容及数量00000000总不良数000000000000000000000000000不良率%#VALUE!

#VALUE!

P控制图备注及原因跟踪:

12345678910111213141516171819202122232425260.00.10.20.30.40.50.60.70.80.91.0控控制制图图的的常常数数和和公公式式表表-图图-s-s图图均均值值图图全全距距图图均均值值图图标标准准差差图图子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数nA2d2D3D4A3c4B3B421.8801.128-3.2672.6590.7979-3.27631.0231.693-2.5711.9540.8862-2.56840.7292.059-2.2821.6280.9213-2.26650.5772.326-2.1141.4270.9400-2.08960.4832.543-2.0041.2870.95150.0301.97070.4192.7040.0761.9241.1820.95940.1181.88280.3732.8470.1361.8641.0990.96500.1851.81590.3372.9700.1841.8161.0320.96930.2391.761100.3083.0780.2231.7770.9750.97270.2841.716110.2853.1730.2561.7440.9270.97540.3211.679120.2663.2580.2831.7170.8860.97760.3541.640130.2493.3360.3071.6930.8500.97940.3821.618140.2353.4070.3281.6720.8170.98100.4061.594150.2233.4720.3471.6530.7890.98230.4281.572160.2123.5320.3631.6370.7630.98350.4481.552170.2033.5880.3781.6220.7390.98450.4461.534180.1943.6400.3911.6080.7180.98540.4821.518190.1873.6890.4031.5970.6980.98620.4971.503200.1803.7350.4151.5850.6800.98690.5101.490210.1733.7780.4251.5750.6630.98760.5231.477220.1673.8190.4341.5660.6470.98820.5341.466230.1623.8580.4431.5570.6330.98870.5451.455240.1573.8950.4511.5480.6190.98920.5551.445250.1533.9310.4591.5410.6060.98960.5651.435UCLUCLXX,LCL,LCLXX=XAXA22RRUCLUCLXX,LCL,LCLXX=XAXA22RRUCLUCLRR=DD44RRUCLUCLSS=BB44ssLCLLCLRR=DD33RRLCLLCLSS=BB33ss=R/D=R/D22=s/cs/c44中中位位数数图图单单值值图图中中位位数数图图全全距距图图单单值值图图全全距距图图子子组组容容量量计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数计计算算控控制制限限用用的的系系数数标标准准差差估估计计值值的的除除数数计计算算控控制制限限用用的的系系数数nnAA22dd22DD33DD44EE22dd22DD33DD44221.8801.8801.1281.128-3.2673.2672.6602.6601.1281.128-3.2673.267331.1871.1871.6931.693-2.5742.5741.7721.7721.6931.693-2.5742.574440.7960.7962.0592.059-2.2822.2821.4571.4572.0592.059-2.2822.282550.6910.6912.3262.326-2.1142.1141.2901.2902.3262.326-2.1142.114660.5480.5482.5342.534-2.0042.0041.1841.1842.5342.534-2.0042.004770.5080.5082.7042.7040.0760.0761.9241.9241.1091.1092.7042.7040.0760.0761.9241.924880.4330.4332.8472.8470.1360.1361.8641.8641.0541.0542.8472.8470.1360.1361.8641.864990.4120.4122.9702.9700.1840.1841.8161.8161.0101.0102.9702.9700.1840.1841.8161.81610100.3620.3623.0783.0780.2230.2231.7771.7770.9750.9753.0783.0780.2230.2231.7771.777UCLUCLXX,LCL,LCLXX=XAXA22RRUCLUCLXX,LCL,LCLXX=XEXE22RRUCLUCLRR=DD44RRUCLUCLMRMR=DD44RRLCLLCLRR=DD33RRLCLLCLMRMR=DD33RR=R/d=R/d22=R/dR/d22UCLUCLPP,LCL,LCLPP=UCLUCLnpnp,LCL,LCLnpnp=UCLUCLCC,LCL,LCLCC=UCLUCLUU,LCL,LCLUU=CpkCpk（11kk）CpCp或或MINMINCPU,CPLCPU,CPLPpkPpk（11kk）PpPp或或MINMINPPU,PPLPPU,PPL单单边边规规格格（设设计计规规格格）因因没没有有规规格格上上限限或或下下限限,没没有有规规格格下下限限CpCpCPUCPUCpk,Cpk,没没有有规规格格上上限限CpCpCPLCPLCpkCpknPPP/13nPPP13PPnPn13nUU3CC3单单边边规规格格（设设计计规规格格）因因没没有有规规格格上上限限或或下下限限,没没有有规规格格下下限限CpCpCPUCPUCpk,Cpk,没没有有规规格格上上限限CpCpCPLCPLCpkCpk标准正态分布z过程输出超过特殊规定值（如工程规范限）的比例，這個特殊规定值与过程均值相差为z个标准查单位（针对处于统计控制状态并呈现正态分布的过程）。

如-2.17，则z0.0150或1.5，在任何实际情况下，该比例为近似值。

或x.x0x.x1x.x2x.x3x.x4x.x5x.x6x.x74.00.000033.90.000050.000050.000040.000040.000040.000040.000040.000043.80.000070.000070.000070.000060.000060.000060.000060.000053.70.000110.000100.000100.000100.000090.000090.000080.000083.60.000160.000150.000150.000140.000140.000130.000130.000123.50.000230.000220.000220.000210.000200.000190.000190.000183.40.000340.000320.000310.000300.000290.000280.000270.000263.30.000480.000470.000450.000430.000420.000400.000390.000383.20.000690.000660.000640.000620.000600.000580.000560.000543.10.000970.000940.000900.000870.000840.000820.000790.000763.00.001350.001310.001260.001220.001180.001140.001110.001072.90.00190.00180.00180.00170.00160.00160.00150.00152.80.00260.00250.00240.00230.00230.00220.00210.00212.70.00350.00340.00330.00320.00310.00300.00290.00282.60.00470.00450.00440.00430.00410.00400.00390.00382.50.00620.00600.00590.00570.00550.00540.00520.00512.40.00820.00800.00780.00750.00730.00710.00690.00682.30.01070.01040.01020.00990.00960.00940.00910.00892.20.01390.01360.01320.01290.01250.01220.01190.01162.10.01790.01740.01700.01660.01620.01580.01540.01502.00.02280.02220.02170.02120.02070.02020.01970.01921.90.02870.02810.02740.02680.02620.02560.02500.02441.80.03590.03510.03440.03360.03290.03220.03140.03071.70.04460.04360.04270.04180.04090.04010.03920.03841.60.05480.05370.05260.05160.05050.04950.04850.04751.50.06680.06550.06430.06300.06180.06060.05940.05821.40.08080.07930.07780.07640.07490.07350.07210.07081.30.09680.09510.09340.09180.09010.08850.08690.08531.20.11510.11310.11120.10930.10750.10560.10380.10201.10.13570.13350.13140.12920.12710.12510.12300.12101.00.15870.15620.15390.15150.14920.14690.14460.14230.90.18410.18140.17880.17620.17360.17110.16850.16600.80.21190.20900.20610.20330.20050.19770.19490.19220.70.24200.23890.23580.23270.22970.22660.22360.22060.60.27430.27090.26760.26430.26110.25780.25460.2514zSLPzXzSLPzX0.50.30850.30500.30150.29810.29460.29120.28770.28430.40.34460.34090.33720.33360.33000.32640.32280.31920.30.38210.37830.37450.37070.36690.36320.35940.35570.20.42070.41680.41290.40900.40520.40130.39740.39360.10.46020.45620.45220.44830.44430.44040.43640.43250.00.50000.49600.49200.48800.48400.48010.47610.4721x.x8x.x90.000030.000030.000050.000050.000080.000080.000120.000110.000170.000170.000250.000240.000360.000350.000520.000500.000740.000710.001040.001000.00140.00140.00200.00190.00270.00260.00370.00360.00490.00480.00660.00640.00870.00840.01130.01100.01460.01430.01880.01830.02390.02330.03010.02940.03750.03670.04650.04550.05710.05590.06940.06810.08380.08230.10030.09850.11900.11700.14010.13790.16350.16110.18940.18670.21770.21480.24830.2451z过程输出超过特殊规定值（如工程规范限）的比例，這個特殊规定值与过程均值相差为z个标准查单位（针对处于统计控制状态并呈现正态分布的过程）。

如-2.17，则z0.0150或1.5，在任何实际情况下，zSLPzX0.28100.27760.31560.31210.35200.34830.38970.38590.42860.42470.46810.4641控控制制图图选选用用指指南南程程序序否否是是是否否是是否否是是否是否是使用-图使用-图确定要制定控制图的特性是计量型数据吗？

关心的是不合格品-即坏零件百分比吗？

样品容量是否恒定关心的是不合格数-即单位零件不合格数吗？

样品容量是否恒定使用图使用图使用n或图使用中位数图性质上是否是均勻或不能按子组取样-例如化学溶液，批量油漆等子组均值是否能方便地计算？

使用单值图-子组容量大于或等于吗？

是否能方便地计算组的值？

使用-图使用或图