Cmk-计算表格表格文件下载.xls

1、K=ABS2AVE（X）-TU-TL/（TU-TL）=#DIV/0!公差缩小标准偏差：=0.75*STDEV（X1X50）=#DIV/0!过程更改机器能力指数：Cmk=（1-k）*（T/8）=#DIV/0!设备大修如需要可采取以下措施（Cmk1.67时）异地生产 调整中心（分布中心与标准中心趋于重合）Cmk 长期停产 放宽公差（需经顾客同意）Cm 定期测定 改用更高精度设备Cm 顾客要求 其它：统计/日期：批准/日期：表单编号:1611162126313641463737.00437.00837.01237.01637.0237.02437.02837.03237.036分布中心1611162

2、126313641463737.00437.00837.01237.01637.0237.02437.02837.03237.036分布中心Cmk REPORTWorkstationPart NameQuality CharacteristicsProcess NameDrawing No.NominalMachine ModelSampling Qty.USLMachine NumberDateLSLIndividual Readings12345678910ConditionNew PODistribution Center#DIV/0!CL0.0000New ToolingMachine

3、 Capability Index（Cmk1.67）New MachineCOV:k=ABS2AVE（X）-TU-TL/（TU-TL）=#DIV/0!Tighten ToleranceStandard Deviation:Process ChangeMachine Capability Index:Major BreakdownPlease take the following actions when Cmk1.67Location Change Shift process center to CL as close as possible CmkStop Production Reques

4、t customer to loosen tolerance Cmk Periodical Inspection Change to more precision tooling or equipment CmkCustomer Requirement Others:Prepare/Date:Check/Date:Report No.:A Machine Capability Study is not,strictly speaking,part of Statistical Process Control,as it doesnot detect the presence or absenc

5、e of special causes.Instead,it provides a snapshot of oneparticular component of a process,often a machine（hence the title）.This could well be of use inthe context of,for example,carrying out a trial run on a machine before agreeing to buy it（liketest driving a car）.A Machine Capability Study is ess

6、entially a way of establishing the capability of thecomponent/machine by assessing how it operates:over a very short period of time in an ideal environmentBy an ideal environment,we mean one in which:the machine is set as close as possible to its optimum values it is being operated by an experienced

7、 member of staff it is isolated from the normal working environment（and thus unlikely to be affected by specialcause variation）the study takes place over a very short period of timeTypically,about 50 outputs of the process would provide data for a Machine Capability Study.Thismay vary depending on the outputs.For example,an hours output of nails might be more thanenough,whereas producing 50 back axles might not be practical.