SPC八大控制图自动生成表(系统)表格文件下载.xls
《SPC八大控制图自动生成表(系统)表格文件下载.xls》由会员分享,可在线阅读,更多相关《SPC八大控制图自动生成表(系统)表格文件下载.xls(224页珍藏版)》请在冰豆网上搜索。
![SPC八大控制图自动生成表(系统)表格文件下载.xls](https://file1.bdocx.com/fileroot1/2022-10/15/47bb639e-cb3c-413c-8d84-ee9bd40e3455/47bb639e-cb3c-413c-8d84-ee9bd40e34551.gif)
通往初始面板X-R、X-S、中中位位数数图图数数据据登登入入表表规范标准值上限值USL200.000请将数据登入在白色方格内,若显红色则超上差,显蓝色则超下差。
@#@生成X-R图中心限CL150.000下限值LSL100.000子子组组编编号号12345678910111213样样品品编编号号实实际际测测量量值值1101.00102.00103.00104.00105.00106.00107.00108.00109.00300.00111.00112.00113.002131.00132.00133.00134.00135.00136.00137.00138.00139.00140.00141.00142.00143.003161.00162.00163.00164.00165.00166.00167.00168.00169.00170.00171.0050.00173.004101.00102.00103.00104.00105.00106.00107.00108.00250.00110.00111.00112.00113.005131.00132.00133.00134.00135.00136.00137.00138.00139.00140.00141.00142.00143.006161.00162.00163.00164.00165.00166.00167.00168.00169.00170.00171.00172.00173.007161.00162.00163.00164.00165.00166.00167.00168.00169.00170.0050.00172.00173.008101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.009101.00102.00103.00104.00105.00106.00107.00108.00109.00110.00111.00112.00113.00生成控制图数据清零生成X-S图生成中位数图清除输入数据14151617181920212223242526272829114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.0040.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00114.00115.00116.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00144.00145.00146.00147.00148.00149.00150.00151.00152.00153.00154.00155.00156.00157.00158.00159.00174.00300.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00174.00175.00176.00177.00178.00179.00180.00181.00182.00183.00184.00185.00186.00187.00188.00189.00114.00115.0050.00117.00118.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00114.00115.00116.00117.00300.00119.00120.00121.00122.00123.00124.00125.00126.00127.00128.00129.00X-R、X-S、中中位位数数图图数数据据登登入入表表30130.00160.00190.00130.00160.00190.00190.00130.00130.00通往初始面板单单值值和和移移动动全全距距X-MR图图数数据据登登入入表表规规范范标标准准值值生成控制图上上限限值值USL200请将数据登入在白色方格内,若显红色则超上差,显蓝色则超下差。
@#@生成X-MR图(批次在50以内)中中心心限限CL150下下限限值值LSL100批批次次号号123456789101112样样本本测测量量值值112.00151.00312.00321.00123.0012.0012.00321.00123.00155.00131.00412.00批批次次号号262728293031323334353637样样本本测测量量值值112.00151.00312.00321.00112.00151.00312.00321.00123.0012.00412.00132.00批批次次号号515253545556575859606162样样本本测测量量值值112.00151.00312.00321.00123.0012.00144.00412.00132.00111.00121.00114.00批批次次号号767778798081828384858687样样本本测测量量值值112.00151.00312.00321.00123.0012.00112.00151.00312.00321.00123.0012.00数据清零生成X-MR图(批次大于50)清除输入数据13141516171819202122232425121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.0038394041424344454647484950111.00121.00114.00161.00166.00162.00112.00151.00312.00321.00123.0012.0012.0063646566676869707172737475161.00166.00162.00162.00123.00123.00112.00151.00312.00321.00123.0012.0021.00888990919293949596979899100121.00144.00412.00132.00111.00121.00114.00161.00166.00162.00162.00123.00123.00单单值值和和移移动动全全距距X-MR图图数数据据登登入入表表生成控制图通往初始面板P图图、U图图数数据据登登入入表表生成控制图生成P图(子组数在50以内)请将数据登入在白色方格内生成P图(子组数大于50)子子组组编编号号1234567891011子子组组容容量量50607080901009010231232不不良良品品数数量量/缺缺陷陷数数量量12325111224子子组组编编号号2627282930313233343536子子组组容容量量4354244354522634421211不不良良品品数数量量/缺缺陷陷数数量量34124212412子子组组编编号号5152535455565758596061子子组组容容量量3546676589766552623626不不良良品品数数量量/缺缺陷陷数数量量32233217131子子组组编编号号7677787980818283848586子子组组容容量量2423123254432352352353不不良良品品数数量量/缺缺陷陷数数量量33231722344生成U图(子组数在50以内)数据清零清除输入数据生成U图(子组数大于50)12131415161718192021222324252343542324234323431232431232421212341214123738394041424344454647484950353454121132443354443322283953115721552322626364656667686970717273747562345332245322342423432234532122334211315587888990919293949596979899100456464346434544466456463909013721323212755P图图、U图图数数据据登登入入表表生成控制图通往初始面板nP图图、C图图数数据据登登入入表表生成控制图生成nP图(子组数在50以内)固固定定子子组组容容量量150请将数据登入在白色方格内生成nP图(子组数大于50)子子组组编编号号1234567891011不不良良品品数数量量/缺缺陷陷数数量量1215201222151417171720子子组组编编号号2627282930313233343536不不良良品品数数量量/缺缺陷陷数数量量1112131421182021231511子子组组编编号号5152535455565758596061不不良良品品数数量量/缺缺陷陷数数量量13412132121234223子子组组编编号号7677787980818283848586不不良良品品数数量量/缺缺陷陷数数量量45686235636生成C图(子组数在50以内)数据清零清除输入数据生成C图(子组数大于50)1213141516171819202122232425122215201222151414131312121137383940414243444546474849501024415161182967121156263646566676869707172737475211112112976867238788899091929394959697989910042346235324634nP图图、C图图数数据据登登入入表表生成控制图返回X-R、X-S、中中位位数数图图数数据据运运算算表表子组内计算批次号12345678910111213X1149.0001158.0001167.0001176.0001185.0001194.0001203.0001212.0001362.0001420.0001118.0001126.0001257.000X127.667128.667129.667130.667131.667132.667133.667134.667151.333157.778124.222125.111139.667X131.000132.000133.000134.000135.000136.000137.000138.000139.000140.000111.000112.000143.000R60.00060.00060.00060.00060.00060.00060.00060.000141.000190.000121.000122.00060.000S27.83927.83927.83927.83927.83927.83927.83927.83945.21159.32537.32937.57827.839X2152889.00155196.00157521.00159864.00162225.00164604.00167001.00169416.00222468.00252200.00150028.00152172.00181761.00总样本合计X-RX和R的中位数图子组容量n9.0000R=84.167R=总组数Count30.0000R=2525.000R=总样本数N270.0000上限值UCL(X)171.349上限值UCL(X)平均值