Subscribe Bookmark RSS Feed

Adding Control / spec limits

saggi

Community Trekker

Joined:

Jun 28, 2013

Hi,

I know that we can add the control or spec limits in the data table for all the columns. But, it gets hard to add spec limits when we have over 1000 columns....we can easily add spec limits for 5- 10 columns manually but it is impractical to add them for large number of columns.

Does anyone know a faster way to do so?

Basically, we can have another text/ csv file with the limits for each column but how do we merge into our data table and apply those spec limits?

I think it can be done with the use of script but unfortunately, I have no idea of writing scripts.

Can someone help, please.

Thanks!!

9 REPLIES
louv

Staff

Joined:

Jun 23, 2011

You may want to check out the JMP File Exchange.

I found this script there that might enable you to do what you want to do.

http://support.sas.com/demosdownloads/downarea_t4.jsp?productID=108877&jmpflag=N

louv

Staff

Joined:

Jun 23, 2011

Th attached Journal may even a better solution.

louv

Staff

Joined:

Jun 23, 2011

And one more attached.

saggi

Community Trekker

Joined:

Jun 28, 2013

I liked the attachement. But I'm not able to see the content written in the script....I want to see how the code is written...Is this possible?

David_Burnham

Super User

Joined:

Jul 13, 2011

The Capability platform provides a facility for importing specs without needing a custom script

Dave

-Dave
saggi

Community Trekker

Joined:

Jun 28, 2013

HI Dave,

Can you please explain it in detail?

louv

Staff

Joined:

Jun 23, 2011

Open your data table in JMP 10

Go to Analyze>Quality and Process

Launch Capability, Specify your responses in the dialog box, click ok

Add your specifications, click next

The platform will show you a Capability Goal Post plot

Go to red triangle and either save spec limits to a table or save as a column property

3813_Screen Shot 2013-06-28 at 11.13.19 PM.png

I saved them as column properties. Then ran distribution platform and the results show capability

3815_Screen Shot 2013-06-28 at 11.15.24 PM.png

*One caveat this is for two-sided specifications. In JMP 11 there will be one-sided support.

Lou

David_Burnham

Super User

Joined:

Jul 13, 2011

Thanks Lou.  I realise my response was a bit brief!

Dave

-Dave
louv

Staff

Joined:

Jun 23, 2011

Dave,

Brief but right on target (no pun intended). Certainly more friendly solution than scripting.

Lou