SPC全套Excel版模版.xls

SPC全套Excel版模版.xls

《SPC全套Excel版模版.xls》由会员分享，可在线阅读，更多相关《SPC全套Excel版模版.xls（41页珍藏版）》请在冰点文库上搜索。

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

製品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.60USL藍色值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.65LSL紅色1253.503.853.803.403.753.653.653.603.903.353.753.803.603.554.103.753.803.353.503.103.303.453.503.203.30平均0.700.770.760.680.750.730.730.720.780.670.750.760.720.710.820.750.760.670.700.620.660.690.700.640.660.72R0.200.200.100.150.200.250.150.200.200.200.400.200.050.250.150.150.150.150.200.050.300.200.150.100.10R=0.18x預估不良率（PPM）管制圖10355製程能力分析Std.Dev.=0.09Sigma=0.08R=0.72管制圖PP=0.78Ca=8.00%=0.80CP=0.87Grade=D備註及原因追查:

123456789101112131415161718192021222324250.000.100.200.300.400.50123456789101112131415161718192021222324250.400.500.600.700.800.901.00n2345678910d21.131.692.062.332.532.72.852.973.082.33D3000000.080.140.180.220D43.272.572.282.112.001.921.861.821.782.11A21.881.020.730.580.480.420.370.340.310.58XUCL0.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.820.82CL0.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.720.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.420.560.560.360.490.360.560.360.420.360.640.720.490.420.810.560.560.560.420.360.250.360.640.420.420.00#0.490.720.640.490.560.560.640.490.640.490.560.560.490.490.640.640.490.490.420.360.300.640.420.360.490.00#0.420.560.640.490.420.560.420.640.720.360.810.720.560.720.640.560.720.360.720.420.420.420.560.420.490.00#0.420.720.490.560.720.720.560.560.720.640.250.420.560.560.560.640.490.490.420.360.640.420.420.360.360.00#0.720.420.560.420.640.490.490.560.560.420.640.490.490.360.720.420.640.360.490.420.640.560.420.490.420.00#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.000.000.00RUCL0.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.380.38CL0.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.180.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料料號號:

總總組組數數（SubGroup）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標標準準差差（SigmaHat）0.08偏偏度度（Skewness）-0.01峰峰度度（Kurtosis）-0.56預預估估不不良良率率PPM（OutofSpec.）10355Ca8.00%CPU0.80CPL0.94Cp0.87Cpk0.80-3S0.72+3S0.900.501.1001.0000.9000.8000.7000.6000.5000.4000.3000.2000.1000.0000.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.7920DescriptionValueThelimitsarecalculatedas:

MinimumMaximumdelta140.5312.134071490.79224Sigma0.076Selected0.4101.0220.061150.5433.1031932220.7920Mean0.716X0.5000.900160.5564.3983595980.8690Delta0.061LCLorUCLforX0.6130.819170.5686.0765168950.86924Multiplier7.639LSLorUSL0.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.6381742252023/4/306967edf640d7ca551656ef959c8100fb.xlsTYPEOFTOLERENCE:

BOTHSIDE1,MAXTOL.3,MINTOL4,BCOLUMNINPUT.BEFORETIMEBEFOREDATADELETE.PROCESSPROCESSCAPABILITYCAPABILITYSTUDYSTUDYPARTNO:

96179248P/NO:

9.6E+07USL:

0.88INSP:

PARTNAMEG/K-GEARSHIFTP/NAME:

G/K-GEARSHIFTLSL:

0.72DATE:

OP.NOPROCESS:

TOL:

0.16MINUNIT:

0.001CHECKITEMITEM:

MEAN:

0.8Xo:

TYPEOFTOL.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.001Xo:

DATANO.10.8120.8130.8240.8350.8260.8270.7480.8290.82100.8110.83120.83130.81140.84AVG=0.8188MIN=0.74MAX=0.85N=50150.84=0.0206Cp=1.30Cpk=0.99k=0.23160.81PC%=77.1%PCk%=100.8%170.83OUTOFUPPERSPEC=0.15%OUTOFLOWERSPEC=0.00%180.76KURTOSIS=7.40SKEWNESS=-1.69190.85SPREADRANGE（6）=0.7570.881200.84210.82DISTRIBUTIONDISTRIBUTIONCURVECURVE220.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.7395KINDQTYT111CLASSQTY6450.81X-3s0.757GRADEKIND18GRADEKINDr18.5460.82LS0.72gradewidth0.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-060-1000.70630.7063000.013750.173750530.70390.00015020.71102.1E-050-1000.71100.7110000.0090.1690540.70510.0002030.71586.9E-050-1000.71580.7158000.004250.164250550.70630.00026040.72050.000210.720500010.72050.7205000.00050.15951560.70740.00034050.72530.000620-1000.72530.7253000.005250.154750570.70860.00045060.73000.001740-1000.73000.7300000.010.150580.70980.0006070.73480.004590-1000.73480.7348000.014750.145250590.71100.00078080.73950.011470.739500110.73950.7395010.01950.14050600.71220.00102090.74430.027221-1000.74430.7443100.024250.135750610.71340.001330100.74900.06121-1000.74900.7490100.0290.1310620.71460.001720110.75380.130491-1000.75380.7538100.033750.126250630.71580.002210120.75850.263770.758500110.75850.7585110.03850.12150640.71690.002850130.76330.505481-1000.76330.7633200.043250.116750650.71810.003640140.76800.918381-1000.76800.7680200.0480.1120660.71930.004650150.77281.581871-1000.77280.7728200.052750.107250670.72050.00590160.77752.583180.777500210.77750.7775220.05750.10250680.72170.007470170.78233.999232-1000.78230.7823400.062250.097750690.72290.009420180.78705.869942-1000.78700.7870400.0670.0930700.72410.011830190.79188.168232-1000.79180.7918400.071750.088250710.72530.01480200.796510.7760.7965001110.79650.7965430.07650.08350720.72640.018450210.801313.477911-1000.80130.8013700.081250.078750730.72760.02290220.806015.981811-1000.80600.8060780.0860.0740740.72880.028310230.810817.966511-1000.81080.81081500.090750.069250750.73000.034860240.815519.14870.8155002610.81550.815515160.09550.06450760.73120.042770250.820319.348626-1000.82030.82033100.100250.059750770.73240.052250260.825018.535226-1000.82500.82503100.1050.0550780.73360.063590270.829816.833726-1000.82980.829831100.109750.050250790.73480.077070280.834514.49440.834500910.83450.83454100.11450.04550800.73590.093030290.839311.83199-1000.83930.83934170.119250.040750810.73710.111840300.84409.156879-1000.84400.84404800.1240.0360820.73830.133910310.84886.718549-1000.84880.84884820.128750.031250830.73950.159670320.85354.673470.853500010.85350.85355000.13350.02650840.74070.18960330.85833.082050-1000.85830.85835000.138250.021750850.74190.22420340.86301.926970-1000.86300.86305000.1430.0170860.74310.264010350.86781.142220-1000.86780.86785000.147750.012250870.74430.309570360.87250.641890.872500010.87250.87255000.15250.00750880.74540.361460370.87730.341980-1000.87730.87735000.157250.002750890.74660.420240380.88200.172740-1000.88200.88205000.1620.0021900.74780.486470390.88680.082720-1000.88680.88685000.166750.006750910.74900.560681400.89150.037550.891500010.89150.89155000.17150.01150920.75020.643391410.89630.016160-1000.89630.89635000.176250.016250930.75140