SPC&CPK_超全EXCEL模板

X—R管制圖管制圖編號：製品R圖名稱管制項目測量單位日期/時間批號12345678910111213141516171819202122232425ΣＸ＝3224.81樣125.7725.8425.8325.8225.8025.8125.8225.8225.8325.8325.8125.8225.7925.7825.7725.8125.8225.8125.8425.7925.8025.7725.8225.8225.77ΣＲ＝1.20本225.7725.8025.7925.7925.7825.8025.8125.7925.7725.8325.7925.8025.7925.8025.8025.7925.7925.8025.8225.7825.8225.7925.8125.7725.82測325.8325.8025.7925.8225.8125.7925.7825.8325.7825.7625.8125.8025.7925.8225.7925.8025.8425.8225.7725.8025.8025.7825.7925.7825.81定425.7925.7925.7725.8025.8025.7925.8125.8025.7725.8025.8025.7925.7925.7825.7825.7725.8125.7825.7625.8125.7825.8225.7925.8125.79USL藍色值525.7625.8025.7625.7925.8425.7825.7925.8025.8325.7925.7725.8025.7825.8125.8225.8125.8125.8025.8025.8325.7825.8025.7725.7825.82LSL紅色Ｎ＝125ΣＸ128.92129.03128.95129.02129.03128.97129.01129.04128.99129.01128.97129.01128.94128.99128.96128.98129.07129.01128.99129.01128.98128.96128.99128.97129.01Ｘ25.7825.8125.7925.8025.8125.7925.8025.8125.8025.8025.7925.8025.7925.8025.7925.8025.8125.8025.8025.8025.8025.7925.8025.7925.80Ｘ＝25.80R0.060.060.070.040.070.020.040.040.060.080.040.030.010.040.050.040.050.040.070.050.040.050.050.050.05R=0.05xStd.Dev.=0.02Sigma=0.02RＰＰＫ=1.69PP=1.71Ca=1.22%ＣＰＫ=1.60CP=1.62B1製程能力分析預估不良率(PPM)Grade=合　　　計備註及原因追查:量測數值的判定條件日期1月25日25.770.00測定者平　均ＴＰ０５抽樣方法隨機下限LSL25.70下限LCL25H104PC規格標準群組數大小管制X圖期間上限USLＣＮＣ溝槽寬度中心限CL25.80中心限CL總組數25.800.0525.90上限UCL管制圖管制圖製造部門25.830.105機別0.000.050.100.151234567891011121314151617181920212223242525.6025.7025.8025.9026.0012345678910111213141516171819202122232425部門:料號:總組數(SubGroup)25總數(Count)125平均值(Average)25.80最小值(Minimum)25.76最大值(Maximum)25.84中位數(Median)25.80群組數大小(n)5規格上限USL25.90規格下限LSL25.70管制上限UCL(X)25.83管制下限LCL(X)25.77標準差(Std.Dev.)0.02標準差(SigmaHat)0.02偏度(Skewness)0.23峰度(Kurtosis)-0.64預估不良率〈PPM〉(OutofSpec.)1Ca1.22%CPU1.60CPL1.64Cp1.62Cpk1.60機台:製程能力分析(Capabilities)2020/1/25日期:操作者:-3S25.80+3S25.9025.70010203040506025.65025.70025.75025.80025.85025.90025.9502020/1/251579960193994PROCESSCAPABILITYSTUDYP/NO:96179248USL:0.88INSP:P/NAME:G/K-GEARSHIFTLSL:0.72DATE:PROCESS:TOL:0.16MINUNIT:0.001ITEM:MEAN:0.8Xo:0.81000.81000.82000.83000.82000.82000.74000.82000.82000.80000.83000.83000.81000.84000.84000.81000.83000.76000.85000.84000.82000.83000.84000.81000.78000.83000.84000.85000.80000.84000.82000.83000.81000.83000.78000.81000.82000.82000.82000.80000.82000.83000.82000.82000.81000.82000.82000.82000.84000.8300AVG=0.8188MIN=0.74MAX=0.85N=50σ=0.0206Cp=1.30Cpk=0.99k=0.23PC%=77.1%PCk%=100.8%OUTOFUPPERSPEC=0.15%OUTOFLOWERSPEC=0.00%KURTOSIS=7.40SKEWNESS=-1.69SPREADRANGE(6σ)=0.757~0.881DISTRIBUTIONCURVE0510152025300.7015000.7205000.7395000.7585000.7775000.7965000.8155000.8345000.8535000.8725000.8915000.9105000.929500X—S管制圖管制圖編號：製品S圖名稱管制項目測量單位日期/時間批號12345678910111213141516171819202122232425ΣＸ＝樣ΣS＝#VALUE!本測定USL藍色值LSL紅色Ｎ＝ΣＸ0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Ｘ#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!Ｘ＝S#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!S=#VALUE!xStd.Dev.=Sigma=#VALUE!SＰＰＫ=PP=Ca=ＣＰＫ=CP=管制圖管制圖製造部門#VALUE!上限UCL中心限CL中心限CL總組數#VALUE!規格標準群組數大小管制X圖期間上限USL抽樣方法下限LSL下限LCL機別合　　　計備註及原因追查:量測數值的判定條件日期1月25日#VALUE!測定者平　均#VALUE!製程能力分析預估不良率(PPM)Grade=0.000.200.400.600.801.00123456789101112131415161718192021222324250.000.200.400.600.801.0012345678910111213141516171819202122232425X和R中位數圖管制圖編號：製品R圖名稱管制項目測量單位日期/時間批號12345678910111213141516171819202122232425ΣＸ＝樣ΣＲ＝0.00本測定USL藍色值LSL紅色Ｎ＝ΣＸ0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Ｘ#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!Ｘ＝R0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00R=0.00xStd.Dev.=Sigma=0.00RＰＰＫ=PP=Ca=ＣＰＫ=CP=管制圖管制圖製造部門0.00機別中心限CL中心限CL總組數0.00上限UCL規格標準群組數大小管制X圖期間上限USL抽樣方法下限LSL下限LCL合　　　計備註及原因追查:量測數值的判定條件日期1月25日0.00測定者平　均#VALUE!製程能力分析預估不良率(PPM)Grade=0.000.200.400.600.801.00123456789101112131415161718192021222324250.000.501.001234567891011121314151617181920212223242526部門:料號:總組數(SubGroup)總數(Count)平均值(Average)最小值(Minimum)最大值(Maximum)中位數(Median)群組數大小(n)規格上限USL規格下限LSL管制上限UCL(X)管制下限LCL(X)標準差(Std.Dev.)標準差(SigmaHat)0.00偏度(Skewness)峰度(Kurtosis)預估不良率〈PPM〉(OutofSpec.)#VALUE!CaCPUCPLCpCpk機台:製程能力分析(Capabilities)2020/1/25日期:操作者:-3S+3S0.0000.000-1.2-1-0.8-0.6-0.4-0.200.0005.00010.00015.00020.00025.00030.000管制圖編號：製品MR圖名稱管制項目測量單位日期/時間批號12345678910111213141516171819202122232425ΣＸ＝樣ΣＲ＝0.00本測定USL藍色值LSL紅色Ｎ＝ΣＸ0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00Ｘ#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALU