cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Get the free JMP Student Edition for qualified students and instructors at degree granting institutions.
Choose Language Hide Translation Bar
View Original Published Thread

SPC scripting - Why writing information back into a database is important

Mauro_Gerber
Level IV

Problem description - Process is unstable:

  • Influence of time or unknown variable
  • Process moves slowly towards out of spec
  • An incident shift the process

Overview SPC:

  • SPC is like telling a dog to “stay”. Wherever the process is, it should remain in that place.
  • A stable phase should be defined and notify the operator when the process is out of control limits before it’s out of spec.

Problems with SPC:

  • Process screening platform gives a lot of false positives and is therefore not always useable for prioritizing improvements
  • Default SPC control limits on our data are often too strict:

Mauro_Gerber_0-1670596708136.png

  • When new data are analyzed, the control limits shifts automatically.
  • A change in the process can be overlooked.

Mauro_Gerber_1-1670596754575.png

 

The solution should:

  • Generate, store and update individual control limits.
  • Help in setting limits for multiple variables.

Mauro_Gerber_2-1670596879130.png

 

SPC scripts

  • The Script generates a table with each variable that contains spec limits.
  • It tries to load existing control limits into the table from the DB
  • It adds scripts to store and set the limits.

 

Slides and Demo are available on the attachment.

"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS
1 REPLY 1


Re: SPC scripting - Why writing information back into a database is important

Great demo Mauro, thanks for sharing the script !