cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
saggi
Level I

Adding Control / spec limits

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!!

2 ACCEPTED SOLUTIONS

Accepted Solutions
louv
Staff (Retired)

Re: Adding Control / spec limits

Th attached Journal may even a better solution.

View solution in original post

louv
Staff (Retired)

Re: Adding Control / spec limits

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

View solution in original post

9 REPLIES 9
louv
Staff (Retired)

Re: Adding Control / spec limits

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 (Retired)

Re: Adding Control / spec limits

Th attached Journal may even a better solution.

louv
Staff (Retired)

Re: Adding Control / spec limits

And one more attached.

saggi
Level I

Re: Adding Control / spec limits

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 (Alumni)

Re: Adding Control / spec limits

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

Dave

-Dave
saggi
Level I

Re: Adding Control / spec limits

HI Dave,

Can you please explain it in detail?

louv
Staff (Retired)

Re: Adding Control / spec limits

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 (Alumni)

Re: Adding Control / spec limits

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

Dave

-Dave
louv
Staff (Retired)

Re: Adding Control / spec limits

Dave,

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

Lou