Collecting SPC Data Electronically? CNC Lathes, CNC Mills and CNC Grinders

C

CMfgT

#1
I work in a job shop with CNC Lathes, CNC Mills and CNC Grinders. We are looking into starting an SPC program. I would like to not have the operators manually make a control chart or graph, I would like it to be electronically made using excel or other database. What are you guys using with success? I envision an operator taking a measurement and either sending it to a excel file on their machine or sending it to a remote computer for a quality person to review. Any ideas would be great. I have looked at Mitutoyo and MicroRidge. Anyone use these? I know Mitutoyo requires their own software and it is not user friendly. The MicroRidge seems to be more flexible.
 
Elsmar Forum Sponsor

reynald

Quite Involved in Discussions
#2
There are many softwares out there that can provide you with such capability.
But if you are particular with the cost you can use a combination ms MS Access and MS Excel.

Set it up like this.

Create a database in MS Access and provide a from in which your operators would input the data.

In the MS Excel, create the chart and let the data be connected to the MS Access via its data connectivity/SQL feature.

Then you can create a excel macro to that will ask the excel to update at certain time frequency.
 

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#3
Sounds like you are doing precision machining. If that is the case, you want software that will allow you to use the correct SPC methodology - the X hi/lo -R chart. You surely do not want to implement the X bar-R, X-MR or X trend-R charting, as it is incorrect for your application (at least lengths and diameters), and I would hate to see you spend money on software that will not work!

As far as a database that supports it, it appears InfinityQS may have that capability. I have been discussing the X hi/lo R charting with them, and they have proposed a technique to implement it within their system with its current capabilities. I hope to verify the technique next week with sample data. If it works, I will be more than happy to share the results. InfinityQS is capable of automated input, wireless and multiplexed interfaces and direct input of data on input screens set up for the operators.
 
Last edited:

bobdoering

Stop X-bar/R Madness!!
Trusted Information Resource
#4
I did a quick run-through of a technique of developing an X hi/lo-R chart using InfinityQS. I plugged in a data set I had, set up the specs and used warning limits rather than the control limit feature. Still works well - providing a pop-up warning and color-coded flag on the data input. It is actually several IX charts, one for Hi values, one for Low values plotted on the same chart using the "Group" feature, then a IX chart of Range values calculated from the Hi and Lo data input. It's a little tricky to set up the first time, but can be input on an operator screen or directly from gaging. Also, you can either put in the hi and lo values, or put in all values measured and the software will calculate it internally. See the attachment for the screen shot.

I have no affiliation with InfinityQS - just darn glad that somebody can do this charting in their software!
 

Attachments

Last edited:

Wes Bucey

Quite Involved in Discussions
#5
I work in a job shop with CNC Lathes, CNC Mills and CNC Grinders. We are looking into starting an SPC program. I would like to not have the operators manually make a control chart or graph, I would like it to be electronically made using excel or other database. What are you guys using with success? I envision an operator taking a measurement and either sending it to a excel file on their machine or sending it to a remote computer for a quality person to review. Any ideas would be great. I have looked at Mitutoyo and MicroRidge. Anyone use these? I know Mitutoyo requires their own software and it is not user friendly. The MicroRidge seems to be more flexible.
I did a quick run-through of a technique of developing an X hi/lo-R chart using InfinityQS. I plugged in a data set I had, set up the specs and used warning limits rather than the control limit feature. Still works well - providing a pop-up warning and color-coded flag on the data input. It is actually several IX charts, one for Hi values, one for Low values plotted on the same chart using the "Group" feature, then a IX chart of Range values calculated from the Hi and Lo data input. It's a little tricky to set up the first time, but can be input on an operator screen or directly from gaging. Also, you can either put in the hi and lo values, or put in all values measured and the software will calculate it internally. See the attachment for the screen shot.

I have no affiliation with InfinityQS - just darn glad that somebody can do this charting in their software!
When it comes to the nitty gritty details of SPC, Bob is the go to guy. I'd defer to him on a choice of software.

As to the entire concept of direct input from machine to computer, this post
lists several posts and threads where I've discussed the system used in my own shops.

Note my experience detailed in those posts is now more than ten years old. We hard wired machines and test instruments to computers. Today, wireless connections are the way to go. Our software was self-created and would be hopelessly out of date today.

Critical to customer-centric operation is to make the data available in real time via internet to customers. This will save acres of trees in printing and shipping reports.
 
Thread starter Similar threads Forum Replies Date
Hami812 Collecting Data for SPC Control Charting Statistical Analysis Tools, Techniques and SPC 7
E Collecting Patient Information and Patient Identifiers - HIPAA Other US Medical Device Regulations 2
S Ensuring Randomness in Collecting Chicken Samples for Microbiological Testing Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
M Electronic Form for Collecting 5S Data Automatically Lean in Manufacturing and Service Industries 9
P Collecting Analysis Reports from all Departments - Clause 8.4 Analysis of Data ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
A Collecting Clinical Data using CE Marked Devices EU Medical Device Regulations 4
S Problem Collecting In-Service Data (AS9100 Clause 7.5.1.4) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
A Audit NC for not collecting/reviewing feedback from Internal Customers ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
J Customer Satisfaction Graph - Method of Collecting Customer Satisfaction Data ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
G Collecting Customer Satisfaction Data - What are some methods? Benchmarking 6
G A twist on collecting Customer Satisfaction Information ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
D Definition Quality Records - 4.16 - Definitions for "identification, collecting, indexing....." Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 3
A SPC procedure / flow chart Statistical Analysis Tools, Techniques and SPC 2
P Informational SPC in Batch Processing Statistical Analysis Tools, Techniques and SPC 3
B Handling lower detection limits for SPC and process performance Statistical Analysis Tools, Techniques and SPC 1
A How to reduce the process SPC monitoring Capability, Accuracy and Stability - Processes, Machines, etc. 3
P SPC for machining processes Capability, Accuracy and Stability - Processes, Machines, etc. 1
earl62 What is the best way to control special characteristics in Control plan? Is it Mandatory to have SPC for IATF 16949? IATF 16949 - Automotive Quality Systems Standard 12
J SPC - Stamping parts - Small batch size Statistical Analysis Tools, Techniques and SPC 6
T Attributes SPC study - Attributive control (Go gage) Statistical Analysis Tools, Techniques and SPC 5
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
G Assignable cause/corrective action list for SPC Software Statistical Analysis Tools, Techniques and SPC 3
H SPC for special characteristics - CSR - Control of SC and CC Statistical Analysis Tools, Techniques and SPC 1
J Determining SPC tolerance Statistical Analysis Tools, Techniques and SPC 21
L SPC - Methods to collect data IATF 16949 - Automotive Quality Systems Standard 7
Marc Steve Prevette's Statistical Process Control (SPC) "Library" Statistical Analysis Tools, Techniques and SPC 0
A SPC for Eddy Current Testing Statistical Analysis Tools, Techniques and SPC 28
S SPC (Statistical Process Control) for Unilateral Tolerance - Questions Statistical Analysis Tools, Techniques and SPC 6
Proud Liberal Informational Use of Classical SPC in Precision Machining Statistical Analysis Tools, Techniques and SPC 9
J Recommendations on Inspection/SPC Software Statistical Analysis Tools, Techniques and SPC 4
Q Real Time Electronic SPC/Control Charting Statistical Analysis Tools, Techniques and SPC 4
Rameshwar25 Other types of Control Charts described in Chapter II of SPC Manual Statistical Analysis Tools, Techniques and SPC 6
A Electric terminal crimping machines - Is SPC appropriate for this process? Manufacturing and Related Processes 4
J Properly understanding SPC - Newbie SPC questions Statistical Analysis Tools, Techniques and SPC 34
bobdoering SPC Charting frequency calculator for X hi/lo chart Imported Legacy Blogs 0
bobdoering Handy training tip for SPC - the Check Engine Light Analogy Statistical Analysis Tools, Techniques and SPC 0
QMMike SPC Software for MAC computers Statistical Analysis Tools, Techniques and SPC 2
Marc SPC based Dashboards - By Steve Prevette (November 2017) Statistical Analysis Tools, Techniques and SPC 1
H SPC Work Instructions (WI) Statistical Analysis Tools, Techniques and SPC 2
S Doubts about SPC taken in Machining - Part has +-0.01 Tolerance Statistical Analysis Tools, Techniques and SPC 5
A Short Term vs. Long Term SPC Study - Where is Cp and Cpk Defined Statistical Analysis Tools, Techniques and SPC 8
E SPC for Dummies - The correct meaning of all the graphs Statistical Analysis Tools, Techniques and SPC 3
Tagin Can/should SPC be applied to Computer Assembly and Software Imaging? Statistical Analysis Tools, Techniques and SPC 8
P Recommendations on SPC Software or Excel SPC add-in(s) Quality Assurance and Compliance Software Tools and Solutions 6
A Not all characteristics follow a Normal Distribution - How do you do SPC Chart Capability, Accuracy and Stability - Processes, Machines, etc. 5
T SPC in Insurance Back Office Operations Service Industry Specific Topics 4
C SPC for Particulate Alert/Action Levels Statistical Analysis Tools, Techniques and SPC 3
E SPC Production - Getting Cpk and Ppk Statistical Analysis Tools, Techniques and SPC 8
M SPC with many data points from one dimension Statistical Analysis Tools, Techniques and SPC 16
Q Mixed data collection (SPC) for different mold cavities Statistical Analysis Tools, Techniques and SPC 2

Similar threads

Top Bottom