PPK计算公式表格模板

,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,工厂车间,,,,,,工序名称,,,,质量特性,,,,公差上限,,397.10,,组容/频率,,4pcs/连续,,生产形态,,□试生产,,

,零件名称,,,,,,机器编号,,,,规格值,,395.10,,公差下限,,393.10,,图号,,,,日期,,2018.01.08,,

,●,X=AVE（X）=,,,395.09,,,,UCLX=X+A2R=,,,395.34,,,,LCLX=X-A2R=,,,394.85,,,,说明栏,,,,

,AVERAGES（XBARCHART）,,,,,,,,,,,,,,,,,,,,,,●对特殊原因采取措施说明,,,,

,,,,,,,,,,,,,,,,,,,,,,,*任何超出控制限的点,,,,

,,,,,,,,,,,,,,,,,,,,,,,*连续7点在中心线之上或之下,,,,

,,,,,,,,,,,,,,,,,,,,,,,*连续7点上升/下降,,,,

,,,,,,,,,,,,,,,,,,,,,,,*任何其它明显非随机的图形,,,,

,,,,,,,,,,,,,,,,,,,,,,,●采取措施的说明,,,,

,,,,,,,,,,,,,,,,,,,,,,,①不要对过程做不必要改变,,,,

,,,,,,,,,,,,,,,,,,,,,,,②注明对过程因素（人机料法环,,,,

,,,,,,,,,,,,,,,,,,,,,,,或MS）所做的调整,,,,

,,,,,,,,,,,,,,,,,,,,,,,③,,,,

,,,,,,,,,,,,,,,,,,,,,,,组容,A2,D3,D4,d2

,,,,,,,,,,,,,,,,,,,,,,,2,1.88,*,3.27,

,●,R=AVE（R）=,,,0.34,,,,UCLR=D4R=,,,0.77,,,,LCLR=D3R=,,,0.00,,,,3,1.02,*,2.57,

,RANGES（RCHART）,,,,,,,,,,,,,,,,,,,,,,4,0.73,*,2.28,

,,,,,,,,,,,,,,,,,,,,,,,5,0.58,*,2.11,

,,,,,,,,,,,,,,,,,,,,,,,6,0.48,*,2.00,

,,,,,,,,,,,,,,,,,,,,,,,7,0.42,0.08,1.92,

,,,,,,,,,,,,,,,,,,,,,,,8,0.37,0.14,1.86,

,,,,,,,,,,,,,,,,,,,,,,,9,0.34,0.18,1.82,

,,,,,,,,,,,,,,,,,,,,,,,10,0.31,0.22,1.78,

,,,,,,,,,,,,,,,,,,,,,,,1.连续取样,,,,

,,,,,,,,,,,,,,,,,,,,,,,2.组容＜7时没有极差下控制限,,,,

,,,,,,,,,,,,,,,,,,,,,,,●Ppk=Min(,,USL-X,X-LSL,)≥1.67

,,,,,,,,,,,,,,,,,,,,,,,,,3σ,3σ,

,,,,,,,,,,,,,,,,,,,,,,,=Min,7.73,7.68,)=,7.68

,日期班次,,01-1,01-2,01-3,01-4,01-5,01-6,01-7,01-8,01-9,01-10,01-11,01-12,01-13,01-14,01-15,01-16,01-17,01-18,01-19,01-20,01-21,01-22,01-23,01-24,01-25

,检查记录,1,395.36,395.12,395.12,395.20,394.84,394.98,395.30,394.96,395.22,395.10,395.16,394.98,395.32,394.84,395.20,395.10,395.30,395.30,394.98,395.22,394.92,395.36,395.12,395.12,394.66

,,2,395.28,394.84,394.88,395.22,395.00,395.18,395.16,395.28,394.98,395.12,395.18,394.98,395.42,395.14,394.96,395.12,395.26,395.22,394.84,395.30,394.94,395.28,394.84,394.88,395.22

,,3,395.12,395.34,395.26,395.14,394.96,394.94,395.22,394.88,394.96,395.30,395.30,395.10,395.22,395.20,394.84,395.14,395.02,394.98,395.12,395.10,395.14,395.12,395.34,395.26,395.14

,,4,394.92,394.98,394.72,394.94,394.96,395.10,395.12,395.10,395.28,395.14,394.84,395.12,395.22,395.32,394.86,395.20,395.22,394.96,395.16,395.12,395.12,394.92,394.98,394.72,394.94

,,5,,,,,,,,,,,,,,,,,,,,,,,,,

,TOTAL,,1580.68,1580.28,1579.98,1580.50,1579.76,1580.20,1580.80,1580.22,1580.44,1580.66,1580.48,1580.18,1581.18,1580.50,1579.86,1580.56,1580.80,1580.46,1580.10,1580.74,1580.12,1580.68,1580.28,1579.98,1579.96

,AVERAGE,,395.17,395.07,395.00,395.13,394.94,395.05,395.20,395.06,395.11,395.17,395.12,395.05,395.30,395.13,394.97,395.14,395.20,395.12,395.03,395.19,395.03,395.17,395.07,395.00,394.99

,MAX-MIN,,0.44,0.50,0.54,0.28,0.16,0.24,0.18,0.40,0.32,0.20,0.46,0