SPC全套Excel版模版[编号G49W].xls

X R 控控制制图图控制图编号：製 品H104PCH104PC規 格標 準群組數大小管 制X 圖R圖製 造 部 門时间名 稱上限 USL0.905上限 UCL0.820.38管制項目溝槽寬度中心限CL0.70總組數中心限CL0.720.18機 別抽樣方法随机測量單位下限 LSL0.5025下限 LCL0.610.00測 定 者日 期2005/11/4日期/時間合計批號1234567891011121314151617181920212223242589.50樣10.650.750.750.600.700.600.750.600.650.600.800.850.700.650.900.750.750.750.650.600.500.600.800.650.654.45本20.700.850.800.700.750.750.800.700.800.700.750.750.700.700.800.800.700.700.650.600.550.800.650.600.70測30.650.750.800.700.650.750.650.800.850.600.900.850.750.850.800.750.850.600.850.650.650.650.750.650.70量測數值的判定條件定40.650.850.700.750.850.850.750.750.850.800.500.650.750.750.750.800.700.700.650.600.800.650.650.600.60 USL 藍色值50.850.650.750.650.800.700.700.750.750.650.800.700.700.600.850.650.800.600.700.650.800.750.650.700.65 LSL 紅色 1253.50 3.85 3.80 3.40 3.75 3.65 3.65 3.60 3.90 3.35 3.75 3.80 3.60 3.55 4.10 3.75 3.80 3.35 3.50 3.10 3.30 3.45 3.50 3.20 3.30 平 均0.70 0.77 0.76 0.68 0.75 0.73 0.73 0.72 0.78 0.67 0.75 0.76 0.72 0.71 0.82 0.75 0.76 0.67 0.70 0.62 0.66 0.69 0.70 0.64 0.660.72R0.20 0.20 0.10 0.15 0.20 0.25 0.15 0.20 0.20 0.20 0.40 0.20 0.05 0.25 0.15 0.15 0.15 0.15 0.20 0.05 0.30 0.20 0.15 0.10 0.10R=0.18x預估不良率(PPM)管制圖10355製程能力分析 Std.Dev.=0.09 Sigma =0.08R=0.72管制圖 PP=0.78 Ca=8.00%=0.80 CP=0.87Grade=D備註及原因追查:123456789101112131415161718192021222324250.00 0.10 0.20 0.30 0.40 0.50 123456789101112131415161718192021222324250.40 0.50 0.60 0.70 0.80 0.90 1.00 n2345678910d21.131.692.062.332.532.72.852.973.082.33D3000000.080.140.180.220D43.272.572.282.11 2.001.921.861.821.782.11A21.881.020.730.580.480.420.370.340.310.58XUCL0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82CL0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72LCL0.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.610.61#0.42 0.56 0.56 0.36 0.49 0.36 0.56 0.36 0.42 0.36 0.64 0.72 0.49 0.42 0.81 0.56 0.56 0.56 0.42 0.36 0.25 0.36 0.64 0.42 0.42 0.00#0.49 0.72 0.64 0.49 0.56 0.56 0.64 0.49 0.64 0.49 0.56 0.56 0.49 0.49 0.64 0.64 0.49 0.49 0.42 0.36 0.30 0.64 0.42 0.36 0.49 0.00#0.42 0.56 0.64 0.49 0.42 0.56 0.42 0.64 0.72 0.36 0.81 0.72 0.56 0.72 0.64 0.56 0.72 0.36 0.72 0.42 0.42 0.42 0.56 0.42 0.49 0.00#0.42 0.72 0.49 0.56 0.72 0.72 0.56 0.56 0.72 0.64 0.25 0.42 0.56 0.56 0.56 0.64 0.49 0.49 0.42 0.36 0.64 0.42 0.42 0.36 0.36 0.00#0.72 0.42 0.56 0.42 0.64 0.49 0.49 0.56 0.56 0.42 0.64 0.49 0.49 0.36 0.72 0.42 0.64 0.36 0.49 0.42 0.64 0.56 0.42 0.49 0.42 0.00#0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.000.00RUCL0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38CL0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18 0.18LCL0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00USL0.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.900.90LSL0.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.500.50製製 程程 能能 力力 分分 析析 (Capabilities)(Capabilities)部部 門門:機機 台台:操操 作作 者者:日日 期期:2005/11/4料料 號號:總總組組數數(Sub Group)25總總數數(Count)125平平均均值值(Average)0.72最最小小值值(Minimum)0.50最最大大值值(Maximum)0.90中中位位數數(Median)0.70群群組組數數大大小小(n)5規規格格上上限限 USL0.90規規格格下下限限 LSL0.50管管制制上上限限UCL(X)0.82管管制制下下限限LCL(X)0.61標標準準差差(Std.Dev.)0.09標標準準差差(Sigma Hat)0.08偏偏度度(Skewness)-0.01峰峰度度(Kurtosis)-0.56預預估估不不良良率率PPM(Out of Spec.)10355Ca 8.00%CPU 0.80CPL 0.94Cp 0.87Cpk0.80-3S0.72+3S 0.90 0.50 1.100 1.000 0.900 0.800 0.700 0.600 0.500 0.400 0.300 0.200 0.100 0.000 0.433340.494450.555570.616690.677800.738920.800030.861150.922270.98338其他0102030405060=Range組界組界頻率XNormal=0.433339055793991=0.37222317596566520.433340.43334020.3840.0032419890.48733.6=0.494454935622318=0.43333905579399130.494450.49445030.3970.0064095360.4870=0.555570815450644=0.49445493562231840.555570.55557340.4090.0123516160.5630=0.61668669527897=0.55557081545064450.616690.616691550.4210.0232008040.56324=0.677802575107296=0.6166866952789760.677800.677802760.4330.0424780270.5630=0.738918454935622=0.67780257510729670.738920.738922270.4460.0758067190.6400=0.800034334763948=0.73891845493562280.800030.800034380.4580.1318660890.64024=0.861150214592274=0.80003433476394890.861150.861151390.4700.2235839440.6400=0.9222660944206=0.861150214592274100.922270.922272100.4820.3695133730.7160=0.983381974248926=0.9222660944206110.983380.983380110.4940.5952532420.71648.00其他其他0120.5070.9346638370.7160130.5191.4305108990.7920DescriptionValueThe limits are calculated as:MinimumMaximumdelta140.5312.134071490.79224Sigma0.076Selected0.4101.0220.061150.5433.1031932220.7920Mean0.716X0.5000.900160.5564.3983595980.8690Delta0.061LCL or UCL for X0.6130.819170.5686.0765168950.86924Multiplier7.639LSL or USL0.5000.900180.5808.1827775990.8690Maximum48.004*Sig+Median0.4101.022190.59210.740607510.9450200.60413.741653930.94533.6210.61717.13685920.9450220.62920.8307790.9000230.64124.680949060.90048.00240.65328.503635850.9000250.66632.086380380.5000260.67835.206532680.50048.00270.69037.653716180.5000280.70239.25314831290.71439.88624999300.72739.50517408310.73938.13878155320.75135.8890291330.76332.91839608340.77629.43050298350.78825.64712944360.80021.7852177370.81218.03711632380.82414.556413390.83711.45048003400.8498.779607061410.8616.561581477420.8734.779957488430.8863.394076318440.8982.349098536450.9101.584757903460.9221.042093481470.9340.667932374480.9470.417292298490.9590.254115003500.9710.150835061510.9830.087268275.5007.6381742252024/9/23 aefdac7556722be8f8b1555b6a815c3b.xls TYPE OF TOLERENCE:BOTH SIDE 1,MAX TOL.3,MIN TOL 4,BCOLUMN INPUT.BEFORE TIME BEFORE DATA DELETE.PROCESSPROCESS CAPABILITYCAPABILITY STUDYSTUDYPART NO:96179248P/NO:9.6E+07USL:0.88 INSP:PART NAMEG/K-GEARSHIFTP/NAME:G/K-GEARSHIFTLSL:0.72 DATE:OP.NOPROCESS:TOL:0.16MIN UNIT:0.001CHECK ITEMITEM:MEAN:0.8Xo:TYPE OF TOL.10.81000.81000.82000.83000.82000.82000.74000.82000.82000.8000USL0.8800.83000.83000.81000.84000.84000.81000.83000.76000.85000.8400LSL0.7200.82000.83000.84000.81000.78000.83000.84000.85000.80000.8400INSPECTOR0.82000.83000.81000.83000.78000.81000.82000.82000.82000.8000DATE0.82000.83000.82000.82000.81000.82000.82000.82000.84000.8300UNIT0.001 Xo :DATA NO.10.81 20.81 30.82 40.83 50.82 60.82 70.74 80.82 90.82 100.8 110.83 120.83 130.81 140.84AVG=0.8188MIN=0.74MAX=0.85N=50150.84 =0.0206 Cp=1.30 Cpk=0.99 k=0.23160.81 PC%=77.1%PCk%=100.8%170.83 OUT OF UPPER SPEC=0.15%OUT OF LOWER SPEC =0.00%180.76 KURTOSIS=7.40 SKEWNESS=-1.69190.85 SPREAD RANGE(6)=0.7570.881200.84210.82DISTRIBUTIONDISTRIBUTION CURVECURVE220.83230.84240.81250.78260.83270.84280.85290.8300.84310.82320.83330.81340.83350.78360.81370.82380.82390.82400.8410.82MAX+SL/20.8505MIN.UNIT0.001420.83X+3s0.881Max0.85430.82US0.88Min0.746.83883440.82MIN-SL/20.7395KIND QTYT111CLASS QTY6450.81X-3s0.757GRADE KIND18GRADE KIND r18.5460.82LS0.72grade width0.019470.82a0.7221.026320.6954480.82b0.88058.447490.72490.84h0.0032110.00049500.830.001190.023250.18325510.70158.1E-05000.70151.7E-060.701500010.70150.7015000.01850.17850520.70270.00011010.70636.1E-06 0-1000.70630.7063000.013750.173750530.70390.00015020.71102.1E-05 0-1000.71100.7110000.0090.1690540.70510.0002030.71586.9E-05 0-1000.71580.7158000.004250.164250550.70630.00026040.72050.000210.720500010.72050.7205000.00050.15951560.70740.00034050.72530.00062 0-1000.72530.7253000.005250.154750570.70860.00045060.73000.00174 0-1000.73000.7300000.010.150580.70980.0006070.73480.00459 0-1000.73480.7348000.014750.145250590.71100.00078080.73950.011470.739500110.73950.7395010.01950.14050600.71220.00102090.74430.02722 1-1000.74430.7443100.024250.135750610.71340.001330100.74900.0612 1-1000.74900.7490100.0290.1310620.71460.001720110.75380.13049 1-1000.75380.7538100.033750.126250630.71580.002210120.75850.263770.758500110.75850.7585110.03850.12150640.71690.002850130.76330.50548 1-1000.76330.7633200.043250.116750650.71810.003640140.76800.91838 1-1000.76800.7680200.0480.1120660.71930.004650150.77281.58187 1-1000.77280.7728200.052750.107250670.72050.00590160.77752.583180.777500210.77750.7775220.05750.10250680.72170.007470170.78233.99923 2-1000.78230.7823400.062250.097750690.72290.009420180.78705.86994 2-1000.78700.7870400.0670.0930700.72410.011830190.79188.16823 2-1000.79180.7918400.071750.088250710.72530.01480200.796510.7760.7965001110.79650.7965430.07650.08350720.72640.018450210.801313.4779 11-1000.80130.8013700.081250.078750730.72760.02290220.806015.9818 11-1000.80600.8060780.0860.0740740.72880.028310230.810817.9665 11-1000.81080.81081500.090750.069250750.73000.034860240.815519.14870.8155002610.81550.815515160.09550.06450760.73120.042770250.820319.3486 26-1000.82030.82033100.100250.059750770.73240.052250260.825018.5352 26-1000.82500.82503100.1050.0550780.73360.063590270.829816.8337 26-1000.82980.829831100.109750.050250790.73480.077070280.834514.49440.834500910.83450.83454100.11450.04550800.73590.093030290.839311.8319 9-1000.83930.83934170.119250.040750810.73710.111840300.84409.15687 9-1000.84400.84404800.1240.0360820.73830.133910310.84886.71854 9-1000.84880.84884820.128750.031250830.73950.159670320.85354.673470.853500010.85350.85355000.13350.02650840.74070.18960330.85833.08205 0-1000.85830.85835000.138250.021750850.74190.22420340.86301.92697 0-1000.86300.86305000.1430.0170860.74310.264010350.86781.14222 0-1000.86780.86785000.147750.012250870.74430.309570360.87250.641890.872500010.87250.87255000.15250.00750880.74540.361460370.87730.34198 0-1000.87730.87735000.157250.002750890.74660.420240380.88200.17274 0-1000.88200.88205000.1620.0021900.74780.486470390.88680.08272 0-1000.88680.88685000.166750.006750910.74900.560681400.89150.037550.891500010.89150.89155000.17150.01150920.75020.643391410.89630.01616 0-1000.89630.89635000.176250.016250930.75140.735031420.90100.0066 0-1000.90100.90105000.1810.0210940.75260.835981430.90580.00255 0-1000.90580.90585000.185750.025750950.75380.946521440.91050.000940.910500010.91050.91055000.19050.03050960.75491.066791450.91530.00033 0-1000.91530.91535000.195250.035250970.75611.196831460.92000.00011 0-1000.92000.92005000.20.040980.75731.33651470.92483.4E-05 0-1000.92480.92485000.204750.044750990.75851.485481480.92959.9E-060.929500010.92950.92955000.20950.049501000.75971.643252490.92951501010.76091.809082501020.76211.982012511030.76332.160872521040.76442.344232531050.76562.530463541060.76682.717723551070.76802.903983561080.76923.087093571090.77043.264783581100.77163.434763591110.77283.594754601120.77393.742594611130.77513.876284621140.77633.994124631150.77754.094764641160.77874.177314651170.77994.241434661180.78114.287424671190.78234.316284681200.78344.329784691210.78464.330514701220.78584.321924711230.78704.308264721240.78824.294624731250.78944.286844741260.79064.291424751270.79184.315454761280.79294.366394771290.79414.451964781300.79534.579915791310.79654.757825801320.79774.992855811330.79895.291535821340.80015.659476831350.80136.10126841360.80246.619877851370.80367.21717861380.80487.892838871390.80608.645149881400.80729.47029891410.808410.3623#901420.809611.3136#911430.810812.3146#921440.811913.3542#931450.813114.4193#941460.814315.4959#951470.815516.5688#961480.816717.6221#971490.817918.6395#981500.819119.6048#991510.820320.5021#1001520.821421.316#1011530.822622.0325#1021540.823822.639#1031550.825023.1243#1041560.826223.4795#1051570.827423.6977#1061580.828623.7744#1071590.829823.7074#1081600.830923.4971#1091610.832123.1463#1101620.833322.66#1111630.834522.0454#1121640.835721.3118#1131650.836920.47#1141660.838119.5324#1151670.839318.5126#1161680.840417.425#1171690.841616.2843#1181700.842815.1058#1191710.844013.9044#1201720.845212.6945#1211730.846411.49#1221740.847610.3039#1231750.84889.1479391241760.84998.0326881251770.85116.9672971261780.85235.9594661271790.85355.0153751281800.85474.1397141291810.85593.3357231301820.85712.6052231311830.85831.9487421321840.85941.3656311331850.86060.8541711341860.86180.4117301351870.86300.0349101361880.8642#1371890.8654#1381900.8666#1391910.8678#1401920.8689#1411930.8701#1421940.8713#1431950.8725#1441960.8737#1451970.8749#1461980.8761#1471990.8773#1482000.8784#1490.8796#1500.8808#1510.8820#1520.8832#1530.8844#1540.8856#1550.8868#1560.8879#1570.8891#1580.8903#1590.8915#1600.8927#1610.8939#1620.8951#1630.8963#1640.8974#1650.8986#1660.8998#1670.9010#1680.9022#1690.9034#1700.9046#1710.9058#1720.9069#1730.9081#1740.9093#1750.9105#1760.9117#1770.9129#1780.9141#1790.9153#1800.9164#1810.9176#1820.9188#1830.9200#1840.9212#1850.9224#1860.9236#1870.9248#1880.9259#1890.9271#1900.9283#1910.9295#1920.701500 0.720500 0.739500 0.758500 0.777500 0.796500 0.815500 0.834500 0.853500 0.872500 0.891500 0.910500 0.929500051015202530合計 XS 管 制 圖管制圖編號：群組數大小 管 制X 圖S圖 製 造 部 門期 間5上限 UCL17.813 4.202 總組數 中心限CL15.093 1.902 機 別 抽樣方法25下限 LCL12.373 0.000 測 定 者 日 期 2005/11/40200400600800100012001400160018002000批 號 1 2 3 4 5 6 7 8 9 10樣 1 16.00 16.00 16.00 15.00 16.0013.00 13.00 14.00 13.00 15.00本 2 14.00 15.00 13.00 13.00 15.0013.00 11.00 16.00 17.00 14.00測 3 13.00 13.00 16.00 13.00 16.0014.00 15.00 17.00 14.00 17.00定 4 12.00 15.00 15.00 13.00 14.0017.00 17.00 14.00 17.00 20.00值 5 17.00 17.00 15.00 14.00 17.0018.00 13.00 14.00 13.00 18.00 72.00 76.00 75.00 68.00 78.0075.00 69.00 75.00 74.00 84.00 14.40 15.20 15.00 13.60 15.60 15.0013.80 15.00 14.80 16.80S 2.07 1.48 1.22 0.89 1.14 2.35 2.281.41 2.05 2.39 X S 管管 制制 圖圖管制圖編號：製 品規 格標 準群組數大小管 制X 圖S圖製 造 部 門期 間名 稱上限 USL46.0505上限 UCL17.8134.202管制項目中心限CL45.650總組數中心限CL15.0931.902機 別抽樣方法測量單位下限 LSL45.25025下限 LCL12.3730.000測 定 者日 期2005/11/4日期/時間合計批號123456789101112131415161718192021222324251870.00樣116.0016.0016.0015.0016.0013.0013.0014.0013.0015.0011.0017.0020.0018.0012.0011.0017.0013.0019.0014.0013.0016.0018.0014.0015.00S47.55本214.0015.0013.0013.0015.0013.0011.0016.0017.0014.0019.0016.0019.0016.0013.0020.0017.0015.0013.0014.0017.0015.0018.0015.0014.00測313.0013.0016.0013.0016.0014.0015.0017.0014.0017.0014.0014.0018.0013.0015.0014.0015.0018.0010.0016.0017.0014.0017.0016.0016.00量測數值的判定條件定412.0015.0015.0013.0014.0017.0017.0014.0017.0020.0015.0011.0019.0015.0012.0017.0013.0011.0012.0014.0016.0017.0017.0015.0014.00 USL 藍色值517.0017.0015.0014.0017.0018.0013.0014.0013.0018.0017.0016.0016.0013.0013.009.0015.0013.0014.0013.0014.0016.0013.0014.0014.00 USL 藍色值517.0017.0015.0014.0017.0018.0013.0014.0013.0018.0017.0016.0016.0013.0013.009.0015.0013.0014.0013.0014.0016.0013.0014.0014.00 LSL 紅色 12572.00 76.00 75.00 68.00 78.00 75.00 69.00 75.00 74.00 84.00 76.00 74.00 92.00 75.00 65.00 71.00 77.00 70.00 68.00 71.00 77.00 78.00 83.00 74.00 73.00 平 均14.40 15.20 15.00 13.60 15.60 15.00 13.80 15.00 14.80 16.80 15.20 14.80 18.40 15.00 13.00 14.20 15.40 14.00 13.60 14.20 15.40 15.60 16.60 14.80 14.6015.09R5.00 4.00 3.00 2.00 3.00 5.00 6.00 3.00 4.00 6.00 8.00 6.00 4.00 5.00 3.0011.004.00 7.00 9.00 3.00 4.00