Dear all,

Is there any easy method to monitor SPC in real time. Operator on the machine measures the sample every hour and at the same time i get the readings on my monitor in my office. So that i can monitor the process in real time. this should be possible to monitor all the machines in the company.
Some kind of excel spreadsheet with macro which will register the values operator measures and i get graphic preview of the process

Have a look at this thread in the similar discussion threads box: Making Minitab support real time data acquistion using digital gages interface (http://elsmar.com/Forums/showthread.php?t=12069)

Dear all,

Is there any easy method to monitor SPC in real time. Operator on the machine measures the sample every hour and at the same time i get the readings on my monitor in my office. So that i can monitor the process in real time. this should be possible to monitor all the machines in the company.
Some kind of excel spreadsheet with macro which will register the values operator measures and i get graphic preview of the process

I am not sure this is a good idea in any case. Why do you need real time monitoring of the process? The OPERATOR needs real time monitoring of the process. If you are looking over the operator's shoulder all the time, this is not going to improve either his/her morale or or ownership in the process. Are you going to second guess operators on when to make adjustments?

Geoff Withnell

Real time monitoring will help me keep an eye on the process and make right decisions and the right time.

I am not sure this is a good idea in any case. Why do you need real time monitoring of the process? The OPERATOR needs real time monitoring of the process. If you are looking over the operator's shoulder all the time, this is not going to improve either his/her morale or or ownership in the process. Are you going to second guess operators on when to make adjustments?

Geoff Withnell

I agree, the desire is to have the operator responsible for the output of their process. The operator should be bringing attention to issues of out of control conditions, etc.:cool:

Use minitab is the easiest way. However, some of the company (like mine) are not invest this kind of cause, then general the software by using microsoft excel

Thats what i am looking for... some sort of excel sheet with macro.
Have you got any idea about it?

if you want "real time online" SPC and your company doesn't have a strong software infrastructure, have the operator use a paper chart. You can always have the operators call you when an out of control condition occurs and you can regularly walk out to the production floor to review the charts and chat with the operators: there is NO substitute for being there! You will not solve problems or control processes simply by sitting at your desk reviewing charts.

If you want to have the data in electronic form and/or your operators are not proficient at math and plotting dots on grid paper, I would recommend EXCEL as the best simplest and cheapest start. Simply create the chart with existing data, calculate and SET your control limits. Then have the operators enter the new data as it is acquired. You can create a small macro (you really should learn how to do this - lots of resources on the web) that will insert the required rows/cells for each new data entry and adjust the chart plottting area.

Minitab and JMP will do this although setting the control limits and getting the chart routinely updated with new data is far more complex than with EXCEL, plus most of us have EXCEL while the cost for JMP/Minitab can get pricey for many licenses. It will also not look or feel friendly to the operator for data entry without some sophisticated coding. I would recommend starting simple so you can concentrate on understanding and controlling your processes first, and worry about more sophisticated software later when you have a better idea of your true needs...

Dear Bev D, :bonk:

No need to tell me the basic things:mad:
We are way ahead of what you just wrote in your post.... we use excel spreadsheet at the initial stage to calculate the control borders and then we use automated data registration system ( which i cannot disclose due to company standards) to register every sample measurement.........

:sarcasm:

Dear Bev D, :bonk:

No need to tell me the basic things:mad:
We are way ahead of what you just wrote in your post.... we use excel spreadsheet at the initial stage to calculate the control borders and then we use automated data registration system ( which i cannot disclose due to company standards) to register every sample measurement.........

:sarcasm:Hello Jackichan,

We can get as complex as you like, but Bev's advice went beyond "use excel with macros." My interpretation of your question was that it not only involved what software to use, but the best way to provide supervision using SPC. It appears Bev interpreted your question the same way.

Maybe if you provided more precise detail about your question we can understand your needs better. An alternative would be to peruse the attachments I have located for you (http://elsmar.com/Forums/fileslist.php?mode=allfiles&sortby=filename&pageamt=2&criteria=spc) by clicking on the green Post Attachments Button in the header and searching using key word "spc."

Dear Bev D, :bonk:

No need to tell me the basic things:mad:
We are way ahead of what you just wrote in your post.... we use excel spreadsheet at the initial stage to calculate the control borders and then we use automated data registration system ( which i cannot disclose due to company standards) to register every sample measurement....... People are trying to help others and you. There is no need to be offensive. Please be more polite when you reply in posts.

Thank you.

Marc

When a person helps i appreciate that......but there is also no need to be sarcastic if they don't want to help.

Now you want to continue the issue instead of dropping it and getting on with your question. That's a shame.

As per the TOS anyone with a complaint, such as in this thread, is to use the Report This Post button, not carry on an argument or try to be combative in a post in a thread.

Thread closed.